From a4016b9767bfd97867cabe4c7db4ed01eec8e983 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

(cherry picked from commit abd8140681c007a110a78ccb97a5677816bb94ba)
---
 sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql b/sql/updates/world/master/2022_01_06_12_world_2020_05_20_02_world.sql
new file mode 100644
index 00000000000..768f9fccd0c
--- /dev/null
+++ b/sql/updates/world/master/2022_01_06_12_world_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