From b2928e59fa8334e91dfa1a5951fade5b574b5842 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Tue, 4 Dec 2012 00:02:06 +0100 Subject: Core/Quest: Add support for monthly quests Author: svetilo12 Converted and updated by: Subv --- .../2012_12_03_00_character_character_queststatus_monthly.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/characters/2012_12_03_00_character_character_queststatus_monthly.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2012_12_03_00_character_character_queststatus_monthly.sql b/sql/updates/characters/2012_12_03_00_character_character_queststatus_monthly.sql new file mode 100644 index 00000000000..256bb1f7ad6 --- /dev/null +++ b/sql/updates/characters/2012_12_03_00_character_character_queststatus_monthly.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `character_queststatus_monthly`; + +CREATE TABLE IF NOT EXISTS `character_queststatus_monthly` ( + `guid` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`guid`,`quest`), + KEY `idx_guid` (`guid`) +) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Player System'; -- cgit v1.2.3