From 44e2a7fbc655818182917e0fb2f381d9c258ffdc Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Tue, 29 Dec 2015 17:34:33 +0100
Subject: DB/Creature: Remove unneeded SAI for Water Terror and move the aura
 to creature addon

Closes #16107

(cherry picked from commit 335ec729bd0b6829f9f5bf98f63f3acc738b2a58)
---
 sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql

(limited to 'sql')

diff --git a/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql b/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql
new file mode 100644
index 00000000000..22a1ee3edcf
--- /dev/null
+++ b/sql/updates/world/2016_01_17_08_world_2015_12_29_04.sql
@@ -0,0 +1,4 @@
+-- 
+UPDATE `creature_template` SET `AIName`='' WHERE `entry`=30645;
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 30645  AND `source_type` = 0;
+UPDATE `creature_template_addon` SET `auras`=57664 WHERE `entry`=30645;
-- 
cgit v1.2.3