From abd8140681c007a110a78ccb97a5677816bb94ba Mon Sep 17 00:00:00 2001
From: offl <offl@users.noreply.github.com>
Date: Thu, 21 May 2020 01:29:29 +0200
Subject: DB/Loot: Remove loot from creature Water Terror

Closes #24671
---
 sql/updates/world/3.3.5/2020_05_20_02_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2020_05_20_02_world.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/3.3.5/2020_05_20_02_world.sql b/sql/updates/world/3.3.5/2020_05_20_02_world.sql
new file mode 100644
index 00000000000..768f9fccd0c
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_05_20_02_world.sql
@@ -0,0 +1,3 @@
+-- Only one item added due to bad sorting
+DELETE FROM `creature_loot_template` WHERE `entry` = 30633;
+UPDATE `creature_template` SET `lootid` = 0 WHERE `entry` = 30633;
-- 
cgit v1.2.3