Core/Quests: Updated Quest System to new Format

All quest requirements are now in quest_objectives table
quest_template table contains _ONLY_ WDB data and must not be modified
Currently supported objectives are MONSTER, GAMEOBJECT, ITEM, TALKTO, CURRENCY, REPUTATION, MONEY, PLAYERKILLS, AREATRIGGER

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/characters/2014_12_28_00_characters.sql b/sql/updates/characters/2014_12_28_00_characters.sql
new file mode 100644
index 00000000000..d6424d676b7
--- /dev/null
+++ b/sql/updates/characters/2014_12_28_00_characters.sql
@@ -0,0 +1,17 @@
+DROP TABLE IF EXISTS `character_queststatus`;
+CREATE TABLE `character_queststatus` (
+  `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `quest` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `timer` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`, `quest`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
+
+DROP TABLE IF EXISTS `character_queststatus_objectives`;
+CREATE TABLE `character_queststatus_objectives` (
+  `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+  `quest` INT(10) UNSIGNED NOT NULL DEFAULT '0',
+  `objective` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+  `data` INT(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`guid`, `quest`, `objective`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';