diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9920_characters_pool_quest_save.sql | 6 | ||||
| -rw-r--r-- | sql/updates/9920_world_pool_quest.sql | 8 |
2 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/9920_characters_pool_quest_save.sql b/sql/updates/9920_characters_pool_quest_save.sql new file mode 100644 index 00000000000..ca1bfdafd16 --- /dev/null +++ b/sql/updates/9920_characters_pool_quest_save.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `pool_quest_save`; +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; diff --git a/sql/updates/9920_world_pool_quest.sql b/sql/updates/9920_world_pool_quest.sql new file mode 100644 index 00000000000..b8a326b38d3 --- /dev/null +++ b/sql/updates/9920_world_pool_quest.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `pool_quest`; +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; |