diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/6.x/2016_10_09_00_hotfixes.sql | 25 |
1 files changed, 25 insertions, 0 deletions
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`; |