Core/Quest: implement Quest Tracker

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;