aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql23
-rw-r--r--sql/base/world_database.sql25
2 files changed, 48 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 094cf5c4009..0ca70b84dec 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1993,6 +1993,29 @@ LOCK TABLES `petition_sign` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `pool_quest_save`
+--
+
+DROP TABLE IF EXISTS `pool_quest_save`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pool_quest_save` (
+ `pool_id` int(10) unsigned NOT NULL DEFAULT '0',
+ `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`pool_id`,`quest_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `pool_quest_save`
+--
+
+LOCK TABLES `pool_quest_save` WRITE;
+/*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `worldstates`
--
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`
--