From 706c0568a5a7261bbc1839d771bd885a5842a116 Mon Sep 17 00:00:00 2001 From: Xanadu Date: Fri, 18 Jun 2010 22:38:18 +0200 Subject: Changed PKs in world_database.sql...which I forgot to do in 8625. --HG-- branch : trunk --- sql/base/world_database.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sql/base/world_database.sql') 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 */; -- cgit v1.2.3