From d34020da7f34943e9cc84482ce19f829154334bd Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 9 Oct 2016 16:54:11 +0200 Subject: Core/DataStores: Fixed loading signed db2 fields --- .../hotfixes/6.x/2016_10_09_00_hotfixes.sql | 25 ++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 sql/updates/hotfixes/6.x/2016_10_09_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/6.x/2016_10_09_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_10_09_00_hotfixes.sql new file mode 100644 index 00000000000..b594584b34d --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_10_09_00_hotfixes.sql @@ -0,0 +1,25 @@ +ALTER TABLE `artifact_power` MODIFY `RelicType` int(11) NOT NULL DEFAULT '0' AFTER `ID`; +ALTER TABLE `criteria_tree` MODIFY `OrderIndex` int(11) NOT NULL DEFAULT '0' AFTER `Operator`; +ALTER TABLE `dungeon_encounter` MODIFY `OrderIndex` int(11) NOT NULL DEFAULT '0' AFTER `Flags`; +ALTER TABLE `emotes` MODIFY `ClassMask` int(11) NOT NULL DEFAULT '0' AFTER `EmoteSoundID`; +ALTER TABLE `emotes` MODIFY `RaceMask` int(11) NOT NULL DEFAULT '0' AFTER `ClassMask`; +ALTER TABLE `garr_building` MODIFY `BuildDuration` int(11) NOT NULL DEFAULT '0' AFTER `GarrTypeID`; +ALTER TABLE `garr_building` MODIFY `BonusAmount` int(11) NOT NULL DEFAULT '0' AFTER `CostCurrencyAmount`; +ALTER TABLE `item_search_name` MODIFY `AllowableClass` int(11) NOT NULL DEFAULT '0' AFTER `RequiredLevel`; +ALTER TABLE `player_condition` MODIFY `ClassMask` int(11) NOT NULL DEFAULT '0' AFTER `PowerTypeValue`; +ALTER TABLE `player_condition` MODIFY `Unknown7001` int(11) NOT NULL DEFAULT '0' AFTER `MaxAvgItemLevel`; +ALTER TABLE `player_condition` MODIFY `Unknown7002` int(11) NOT NULL DEFAULT '0' AFTER `Unknown7001`; +ALTER TABLE `skill_line_ability` MODIFY `ClassMask` int(11) NOT NULL DEFAULT '0' AFTER `NumSkillUps`; +ALTER TABLE `spell_category` CHANGE `Unk703` `ChargeCategoryType` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `MaxCharges`; +ALTER TABLE `spell_effect` MODIFY `EffectBasePoints` int(11) NOT NULL DEFAULT '0' AFTER `EffectAuraPeriod`; +ALTER TABLE `spell_effect` MODIFY `EffectDieSides` int(11) NOT NULL DEFAULT '0' AFTER `EffectChainTargets`; +ALTER TABLE `spell_power` MODIFY `ManaCostPerLevel` int(11) NOT NULL DEFAULT '0' AFTER `ID`; +ALTER TABLE `spell_power` MODIFY `ManaCostPerSecond` int(11) NOT NULL DEFAULT '0' AFTER `ManaCostPerLevel`; +ALTER TABLE `summon_properties` MODIFY `Type` int(11) NOT NULL DEFAULT '0' AFTER `Faction`; +ALTER TABLE `tact_key` CHANGE `Id` `ID` int(10) UNSIGNED NOT NULL DEFAULT '0' FIRST ; +ALTER TABLE `world_map_overlay` MODIFY `OffsetX` int(11) NOT NULL DEFAULT '0' AFTER `AreaID4`; +ALTER TABLE `world_map_overlay` MODIFY `OffsetY` int(11) NOT NULL DEFAULT '0' AFTER `OffsetX`; +ALTER TABLE `world_map_overlay` MODIFY `HitRectTop` int(11) NOT NULL DEFAULT '0' AFTER `OffsetY`; +ALTER TABLE `world_map_overlay` MODIFY `HitRectLeft` int(11) NOT NULL DEFAULT '0' AFTER `HitRectTop`; +ALTER TABLE `world_map_overlay` MODIFY `HitRectBottom` int(11) NOT NULL DEFAULT '0' AFTER `HitRectLeft`; +ALTER TABLE `world_map_overlay` MODIFY `HitRectRight` int(11) NOT NULL DEFAULT '0' AFTER `HitRectBottom`; -- cgit v1.2.3