Changed PKs in world_database.sql...which I forgot to do in 8625.

--HG--
branch : trunk

1 files changed, 3 insertions, 3 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 5be96e7bf15..f84a6b76705 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -4211,7 +4211,7 @@ CREATE TABLE `pool_creature` (
   `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `chance` float unsigned NOT NULL DEFAULT '0',
   `description` varchar(255) DEFAULT NULL,
-  PRIMARY KEY (`pool_entry`,`guid`),
+  PRIMARY KEY (`guid`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -4237,7 +4237,7 @@ CREATE TABLE `pool_gameobject` (
   `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `chance` float unsigned NOT NULL DEFAULT '0',
   `description` varchar(255) DEFAULT NULL,
-  PRIMARY KEY (`guid`,`pool_entry`),
+  PRIMARY KEY (`guid`),
   KEY `idx_guid` (`guid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -4263,7 +4263,7 @@ CREATE TABLE `pool_pool` (
   `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `chance` float NOT NULL DEFAULT '0',
   `description` varchar(255) DEFAULT NULL,
-  PRIMARY KEY (`pool_id`,`mother_pool`)
+  PRIMARY KEY (`pool_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 /*!40101 SET character_set_client = @saved_cs_client */;