From 102e51d620c9a948db4b685cef53a7ed0698bd4c Mon Sep 17 00:00:00 2001 From: Shauren Date: Tue, 14 Sep 2010 13:56:27 +0200 Subject: Core/Pools: Implemented quest pooling Core/DBLayer: Added GetNumRows() method to PreparedResultSet --HG-- branch : trunk --- sql/base/world_database.sql | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'sql/base/world_database.sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 052e400092a..825caf16d46 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -16105,6 +16105,31 @@ LOCK TABLES `pool_pool` WRITE; /*!40000 ALTER TABLE `pool_pool` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `pool_quest` +-- + +DROP TABLE IF EXISTS `pool_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_quest` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`entry`), + KEY `idx_guid` (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `pool_quest` +-- + +LOCK TABLES `pool_quest` WRITE; +/*!40000 ALTER TABLE `pool_quest` DISABLE KEYS */; +/*!40000 ALTER TABLE `pool_quest` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `pool_template` -- -- cgit v1.2.3