1 ALTER TABLE character_db_version CHANGE COLUMN required_9680_01_characters_character_stats required_9686_01_characters_character_queststatus_weekly bit;
3 DROP TABLE IF EXISTS `character_queststatus_weekly`;
4 CREATE TABLE `character_queststatus_weekly` (
5 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
6 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
7 PRIMARY KEY (`guid`,`quest`),
8 KEY `idx_guid` (`guid`)
9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
11 ALTER TABLE `saved_variables`
12 ADD COLUMN `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0' AFTER `NextArenaPointDistributionTime`;