Core/Quests: Do not rely on StorageIndex for quest objectives

Also fixed unsigned columns in quest_template

1 files changed, 12 insertions, 12 deletions

diff --git a/sql/updates/world/2014_12_28_05_world.sql b/sql/updates/world/2014_12_28_05_world.sql
index ef671e03196..e3e7f680de1 100644
--- a/sql/updates/world/2014_12_28_05_world.sql
+++ b/sql/updates/world/2014_12_28_05_world.sql
@@ -2,7 +2,7 @@ ALTER TABLE `quest_template` CHANGE `Id` `ID` INT(10) UNSIGNED NOT NULL DEFAULT
 ALTER TABLE `quest_template` CHANGE `Method` `QuestType` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2';
 ALTER TABLE `quest_template` CHANGE `Level` `QuestLevel` INT(11) NOT NULL DEFAULT '-1';
 ALTER TABLE `quest_template` ADD COLUMN `QuestPackageID` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `QuestLevel`;
-ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel`  INT(10) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` CHANGE `MinLevel` `MinLevel`  INT(11) NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` DROP COLUMN `MaxLevel`;
 ALTER TABLE `quest_template` CHANGE `ZoneOrSort` `QuestSortID` SMALLINT(6) NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` CHANGE `Type` `QuestInfoID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0';
@@ -26,7 +26,7 @@ ALTER TABLE `quest_template` DROP COLUMN `ExclusiveGroup`;
 ALTER TABLE `quest_template` CHANGE `NextQuestIdChain` `RewardNextQuest` INT(10) UNSIGNED NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` CHANGE `RewardXPId` `RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` ADD COLUMN `Float10` float NOT NULL DEFAULT '1' AFTER `RewardXPDifficulty`;
-ALTER TABLE `quest_template` CHANGE `RewardOrRequiredMoney` `RewardMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `quest_template` CHANGE `RewardOrRequiredMoney` `RewardMoney` INT(11) NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` ADD COLUMN `RewardMoneyDifficulty` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardMoney`;
 ALTER TABLE `quest_template` ADD COLUMN `Float13` float NOT NULL DEFAULT '1' AFTER `RewardMoneyDifficulty`;
 ALTER TABLE `quest_template` CHANGE `RewardMoneyMaxLevel` `RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0';
@@ -77,20 +77,20 @@ ALTER TABLE `quest_template` ADD COLUMN `RewardChoiceItemDisplayID5` INT(10) UNS
 ALTER TABLE `quest_template` CHANGE `RewardChoiceItemCount6` `RewardChoiceItemQuantity6` INT(10) UNSIGNED NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` ADD COLUMN `RewardChoiceItemDisplayID6` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardChoiceItemQuantity6`;
 ALTER TABLE `quest_template` CHANGE `RewardFactionId1` `RewardFactionID1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `PortraitTurnIn`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionValueId1` `RewardFactionValue1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionID1`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionvalueIdOverride1` `RewardFactionOverride1` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionValue1`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueId1` `RewardFactionValue1` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionID1`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride1` `RewardFactionOverride1` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionValue1`;
 ALTER TABLE `quest_template` CHANGE `RewardFactionId2` `RewardFactionID2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionOverride1`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionValueId2` `RewardFactionValue2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionID2`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionvalueIdOverride2` `RewardFactionOverride2` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionValue2`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueId2` `RewardFactionValue2` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionID2`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride2` `RewardFactionOverride2` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionValue2`;
 ALTER TABLE `quest_template` CHANGE `RewardFactionId3` `RewardFactionID3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionOverride2`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionValueId3` `RewardFactionValue3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionID3`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionvalueIdOverride3` `RewardFactionOverride3` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionValue3`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueId3` `RewardFactionValue3` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionID3`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride3` `RewardFactionOverride3` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionValue3`;
 ALTER TABLE `quest_template` CHANGE `RewardFactionId4` `RewardFactionID4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionOverride3`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionValueId4` `RewardFactionValue4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionID4`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionvalueIdOverride4` `RewardFactionOverride4` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionValue4`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueId4` `RewardFactionValue4` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionID4`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride4` `RewardFactionOverride4` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionValue4`;
 ALTER TABLE `quest_template` CHANGE `RewardFactionId5` `RewardFactionID5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionOverride4`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionValueId5` `RewardFactionValue5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionID5`;
-ALTER TABLE `quest_template` CHANGE `RewardFactionvalueIdOverride5` `RewardFactionOverride5` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionValue5`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueId5` `RewardFactionValue5` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionID5`;
+ALTER TABLE `quest_template` CHANGE `RewardFactionValueIdOverride5` `RewardFactionOverride5` INT(11) NOT NULL DEFAULT '0' AFTER `RewardFactionValue5`;
 ALTER TABLE `quest_template` CHANGE `RewardReputationMask` `RewardFactionFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `RewardFactionOverride5`;
 ALTER TABLE `quest_template` CHANGE `PointMapId` `POIContinent` INT(10) UNSIGNED NOT NULL DEFAULT '0';
 ALTER TABLE `quest_template` CHANGE `PointX` `POIx` float NOT NULL DEFAULT '0';