From 706c0568a5a7261bbc1839d771bd885a5842a116 Mon Sep 17 00:00:00 2001
From: Xanadu <none@none>
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

