Core/DB: Merge pool_creature, pool_gameobject and pool_pool into a single pool_members table.

(More pooling prep, I really don't want to have any sql update files in that PR if I can help it.)

1 files changed, 23 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_07_16_01_world.sql b/sql/updates/world/3.3.5/2019_07_16_01_world.sql
new file mode 100644
index 00000000000..9bc838f2c6e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_07_16_01_world.sql
@@ -0,0 +1,23 @@
+-- 
+DROP TABLE IF EXISTS `pool_members`;
+CREATE TABLE `pool_members` (
+  `type` smallint(10) unsigned NOT NULL,
+  `spawnId` int(10) unsigned NOT NULL,
+  `poolSpawnId` int(10) unsigned NOT NULL,
+  `chance` double unsigned NOT NULL,
+  `description` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`type`,`spawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO `pool_members` (`type`,`spawnId`,`poolSpawnId`,`chance`,`description`)
+SELECT 0 as `type`, `guid` as `spawnId`, `pool_entry` as `poolSpawnId`, `chance`, `description` FROM `pool_creature`;
+
+INSERT INTO `pool_members` (`type`,`spawnId`,`poolSpawnId`,`chance`,`description`)
+SELECT 1 as `type`, `guid` as `spawnId`, `pool_entry` as `poolSpawnId`, `chance`, `description` FROM `pool_gameobject`;
+
+INSERT INTO `pool_members` (`type`,`spawnId`,`poolSpawnId`,`chance`,`description`)
+SELECT 2 as `type`, `pool_id` as `spawnId`, `mother_pool` as `poolSpawnId`, `chance`, `description` FROM `pool_pool`;
+
+DROP TABLE IF EXISTS `pool_creature`;
+DROP TABLE IF EXISTS `pool_gameobject`;
+DROP TABLE IF EXISTS `pool_pool`;