From ea1387efde1d58cf13240481c931ad8e528c8d45 Mon Sep 17 00:00:00 2001
From: Serpaa <Serpaa@users.noreply.github.com>
Date: Wed, 27 Dec 2017 19:46:35 +0100
Subject: DB/Creature: Restore deleted pool

Closes #21130
---
 sql/updates/world/3.3.5/2017_12_27_00_world.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 sql/updates/world/3.3.5/2017_12_27_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/3.3.5/2017_12_27_00_world.sql b/sql/updates/world/3.3.5/2017_12_27_00_world.sql
new file mode 100644
index 00000000000..3021baaba55
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_12_27_00_world.sql
@@ -0,0 +1,11 @@
+-- Restore deleted pool
+SET @POOL_1 := 382;
+
+DELETE FROM `pool_template` WHERE `entry`=@POOL_1;
+INSERT INTO `pool_template` VALUES 
+(@POOL_1, 1, "Eye of DarKhan/Wailer Spawn 1");
+
+DELETE FROM `pool_creature` WHERE `guid` IN (82897, 85744);
+INSERT INTO `pool_creature` VALUES 
+(82897, @POOL_1, 0, "Wailer Spawn 1"),
+(85744, @POOL_1, 0, "Eye of DarKhan Spawn 1");
-- 
cgit v1.2.3