DB/Creature: Fix Training Dummy auras

1 files changed, 29 insertions, 0 deletions

diff --git a/sql/updates/world/master/2018_06_27_00_world.sql b/sql/updates/world/master/2018_06_27_00_world.sql
new file mode 100644
index 00000000000..4773a133088
--- /dev/null
+++ b/sql/updates/world/master/2018_06_27_00_world.sql
@@ -0,0 +1,29 @@
+-- 
+DELETE FROM `creature_addon` WHERE `guid` IN (314196, 314193, 314185, 314169, 314147, 314150, 314154, 307660, 307668, 307669, 307675, 307676, 307670, 311815, 311816, 311814, 311818, 311817, 311839, 312152, 312158, 312161, 312164);
+INSERT INTO `creature_addon` (`guid`, `Auras`) VALUES
+-- Stormwind
+(314196, '61574 98892'),
+(314193, '61574 98892'),
+(314185, '61574 98892'),
+(314169, '61574 98892'),
+(314147, '61574 98892'),
+(314150, '61574 98892'),
+(314154, '61574 98892'),
+-- Ironforge
+(307660, '61574 98892'),
+(307668, '61574 98892'),
+(307669, '61574 98892'),
+(307675, '61574 98892'),
+(307676, '61574 98892'),
+(307670, '61574 98892'),
+-- Darnassus
+(311815, '61574 98892'),
+(311816, '61574 98892'),
+(311814, '61574 98892'),
+(311818, '61574 98892'),
+(311817, '61574 98892'),
+(311839, '61574 98892'),
+(312152, '61574 98892'),
+(312158, '61574 98892'),
+(312161, '61574 98892'),
+(312164, '61574 98892');