diff options
| author | MitchesD <majklprofik@seznam.cz> | 2015-09-10 13:17:13 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-09-10 13:17:13 +0200 |
| commit | 8abbb54ad09f44b96cbc521b72ab5ea95c9276e5 (patch) | |
| tree | b9453e2fb40c1396dd8fe1048178f16d5cf996fe /sql | |
| parent | 6cdfe9dc095bd19ea495c22cb41cd82f1212b6cd (diff) | |
| parent | 33892e0f9da468e8aa3ea173e5baa269235e5070 (diff) | |
Merge pull request #15459 from ShinDarth/quest_template_backport
DB/World schema backport: updated quest_template table
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2015_09_10_00_world_335.sql | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_10_00_world_335.sql b/sql/updates/world/2015_09_10_00_world_335.sql new file mode 100644 index 00000000000..f3fb517d486 --- /dev/null +++ b/sql/updates/world/2015_09_10_00_world_335.sql @@ -0,0 +1,21 @@ +ALTER TABLE `quest_template` + CHANGE COLUMN `LimitTime` `TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `PointOption`, + CHANGE COLUMN `RequiredRaces` `RequiredRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `TimeAllowed`, + CHANGE COLUMN `NextQuestIdChain` `RewardNextQuest` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RequiredFactionValue2`, + CHANGE COLUMN `RewardXPId` `RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardNextQuest`, + CHANGE COLUMN `RewardOrRequiredMoney` `RewardMoney` INT(11) NOT NULL DEFAULT '0' AFTER `RewardXPDifficulty`, + CHANGE COLUMN `RewardMoneyMaxLevel` `RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMoney`, + CHANGE COLUMN `RewardSpell` `RewardDisplaySpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardBonusMoney`, + CHANGE COLUMN `RewardSpellCast` `RewardSpell` INT(11) NOT NULL DEFAULT '0' AFTER `RewardDisplaySpell`, + CHANGE COLUMN `RewardHonorMultiplier` `RewardKillHonor` FLOAT NOT NULL DEFAULT '0' AFTER `RewardHonor`, + CHANGE COLUMN `SourceItemId` `StartItem` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardKillHonor`, + CHANGE COLUMN `RewardTitle` `RewardTitle` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardChoiceItemQuantity6`, + CHANGE COLUMN `RewardTalents` `RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTitle`, + CHANGE COLUMN `RewardArenaPoints` `RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardTalents`; +-- split needed to avoid import errors +ALTER TABLE `quest_template` + CHANGE COLUMN `PointMapId` `POIContinent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardChoiceItemQuantity6`, + CHANGE COLUMN `PointX` `POIx` FLOAT NOT NULL DEFAULT '0' AFTER `POIContinent`, + CHANGE COLUMN `PointY` `POIy` FLOAT NOT NULL DEFAULT '0' AFTER `POIx`, + CHANGE COLUMN `PointOption` `POIPriority` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0' AFTER `POIy`, + CHANGE COLUMN `EndText` `AreaDescription` TEXT NULL AFTER `QuestDescription`; |