diff options
| author | Shauren <none@none> | 2010-09-14 13:56:27 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-09-14 13:56:27 +0200 |
| commit | 102e51d620c9a948db4b685cef53a7ed0698bd4c (patch) | |
| tree | a14aba2f465f26678242da5a610e2d2510a749bd /sql/base/world_database.sql | |
| parent | cdd8f446fa9cd82eeea716934d7aa6d99151d1a8 (diff) | |
Core/Pools: Implemented quest pooling
Core/DBLayer: Added GetNumRows() method to PreparedResultSet
--HG--
branch : trunk
Diffstat (limited to 'sql/base/world_database.sql')
| -rw-r--r-- | sql/base/world_database.sql | 25 |
1 files changed, 25 insertions, 0 deletions
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 @@ -16106,6 +16106,31 @@ LOCK TABLES `pool_pool` WRITE; 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` -- |