From e806fc8a02dbde324dd9654b0165a7cac5ae7086 Mon Sep 17 00:00:00 2001 From: ShinDarth Date: Sat, 18 Oct 2014 13:05:47 +0200 Subject: Core/Quest: implement Quest Tracker --- sql/updates/characters/2014_10_18_00_characters.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/characters/2014_10_18_00_characters.sql (limited to 'sql/updates') 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; -- cgit v1.2.3