diff options
| author | ShinDarth <borzifrancesco@gmail.com> | 2015-07-02 00:27:38 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2015-07-02 00:27:38 +0100 |
| commit | 5178395a4f973fdb0b9657e54f06e62a6e2d5111 (patch) | |
| tree | 0ec9773364095c96eaeb78eedabcc3e4feb67d06 /sql | |
| parent | 7c7d258482cb541b9a57fd9ff9b64f01c51cf4cb (diff) | |
DB/World schema backport: split quest_template and quest_template_addon
Closes #14982
Signed-off-by: DDuarte <dnpd.dd@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_07_01_03_world_335.sql | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/sql/updates/world/2015_07_01_03_world_335.sql b/sql/updates/world/2015_07_01_03_world_335.sql new file mode 100644 index 00000000000..4fde11a51aa --- /dev/null +++ b/sql/updates/world/2015_07_01_03_world_335.sql @@ -0,0 +1,48 @@ +-- creating `quest_template_addon` table +DROP TABLE IF EXISTS `quest_template_addon`; +CREATE TABLE IF NOT EXISTS `quest_template_addon` ( -- old names: + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', -- ID + `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', -- MaxLevel + `AllowableClasses` int(10) unsigned NOT NULL DEFAULT '0', -- RequiredClasses + `SourceSpellID` mediumint(8) unsigned NOT NULL DEFAULT '0', -- SourceSpellId + `PrevQuestID` mediumint(8) NOT NULL DEFAULT '0', -- PrevQuestId + `NextQuestID` mediumint(8) NOT NULL DEFAULT '0', -- NextQuestId + `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0', -- ExclusiveGroup + `RewardMailTemplateID` mediumint(8) unsigned NOT NULL DEFAULT '0', -- RewardMailTemplateId + `RewardMailDelay` int(10) unsigned NOT NULL DEFAULT '0', -- RewardMailDelay + `RequiredSkillID` smallint(5) unsigned NOT NULL DEFAULT '0', -- RequiredSkillId + `RequiredSkillPoints` smallint(5) unsigned NOT NULL DEFAULT '0', -- RequiredSkillPoints + `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', -- RequiredMinRepFaction + `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', -- RequiredMaxRepFaction + `RequiredMinRepValue` mediumint(8) NOT NULL DEFAULT '0', -- RequiredMinRepValue + `RequiredMaxRepValue` mediumint(8) NOT NULL DEFAULT '0', -- RequiredMaxRepValue + `ProvidedItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0', -- SourceItemCount + `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', -- SpecialFlags + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + + +-- moving data from `quest_template` to `quest_template_addon` +INSERT INTO `quest_template_addon` +(`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`) +(SELECT `ID`, `MaxLevel`, `RequiredClasses`, `SourceSpellId`, `PrevQuestId`, `NextQuestId`, `ExclusiveGroup`, `RewardMailTemplateId`, `RewardMailDelay`, `RequiredSkillId`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `SourceItemCount`, `SpecialFlags` FROM `quest_template`); + + +-- drop `quest_template` fields +ALTER TABLE `quest_template` +DROP `MaxLevel`, +DROP `RequiredClasses`, +DROP `SourceSpellId`, +DROP `PrevQuestId`, +DROP `NextQuestId`, +DROP `ExclusiveGroup`, +DROP `RewardMailTemplateId`, +DROP `RewardMailDelay`, +DROP `RequiredSkillId`, +DROP `RequiredSkillPoints`, +DROP `RequiredMinRepFaction`, +DROP `RequiredMaxRepFaction`, +DROP `RequiredMinRepValue`, +DROP `RequiredMaxRepValue`, +DROP `SourceItemCount`, +DROP `SpecialFlags`; |