diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/2014_10_18_00_characters.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/characters/2014_10_18_00_characters.sql b/sql/updates/characters/2014_10_18_00_characters.sql new file mode 100644 index 00000000000..36b2d042374 --- /dev/null +++ b/sql/updates/characters/2014_10_18_00_characters.sql @@ -0,0 +1,12 @@ +DROP TABLE IF EXISTS `quest_tracker`; +CREATE TABLE `quest_tracker` ( + `id` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0', + `character_guid` INT(10) UNSIGNED NOT NULL DEFAULT '0', + `quest_accept_time` DATETIME NOT NULL, + `quest_complete_time` DATETIME DEFAULT NULL, + `quest_abandon_time` DATETIME DEFAULT NULL, + `completed_by_gm` BOOL NOT NULL DEFAULT '0', + `core_hash` VARCHAR(120) NOT NULL DEFAULT '0', + `core_revision` VARCHAR(120) NOT NULL DEFAULT '0' +) +ENGINE=InnoDB; |