Fixed pool system I broke in 52fac32a0b35, added a check for child pools and rearranged primary keys to prevent inclusion of single creature/GO spawn in multiple pools.

--HG--
branch : trunk

3 files changed, 3 insertions, 0 deletions

diff --git a/sql/updates/8625_world_pool_creature.sql b/sql/updates/8625_world_pool_creature.sql
new file mode 100644
index 00000000000..ade35efe138
--- /dev/null
+++ b/sql/updates/8625_world_pool_creature.sql
@@ -0,0 +1 @@
+ALTER TABLE `pool_creature` DROP PRIMARY KEY, ADD PRIMARY KEY (`guid`);
diff --git a/sql/updates/8625_world_pool_gameobject.sql b/sql/updates/8625_world_pool_gameobject.sql
new file mode 100644
index 00000000000..720fbb76a0c
--- /dev/null
+++ b/sql/updates/8625_world_pool_gameobject.sql
@@ -0,0 +1 @@
+ALTER TABLE `pool_gameobject` DROP PRIMARY KEY, ADD PRIMARY KEY (`guid`);
diff --git a/sql/updates/8625_world_pool_pool.sql b/sql/updates/8625_world_pool_pool.sql
new file mode 100644
index 00000000000..1c8b9f3db8e
--- /dev/null
+++ b/sql/updates/8625_world_pool_pool.sql
@@ -0,0 +1 @@
+ALTER TABLE `pool_pool` DROP PRIMARY KEY, ADD PRIMARY KEY (`pool_id`);