diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/hotfixes/master/2016_10_26_00_hotfixes.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/master/2016_10_26_00_hotfixes.sql b/sql/updates/hotfixes/master/2016_10_26_00_hotfixes.sql new file mode 100644 index 00000000000..c05f6eba2b8 --- /dev/null +++ b/sql/updates/hotfixes/master/2016_10_26_00_hotfixes.sql @@ -0,0 +1,15 @@ +ALTER TABLE `chr_classes` MODIFY `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `SelectScreenFileDataID`; + +ALTER TABLE `creature_model_data` + DROP `FootstepShakeSize`, + DROP `DeathThudShakeSize`; + +ALTER TABLE `item_class` ADD `OldEnumValue` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `Name`; + +ALTER TABLE `lfg_dungeons` ADD `MinItemLevel` float NOT NULL DEFAULT '0' AFTER `PlayerConditionID`; + +ALTER TABLE `spell_x_spell_visual` + CHANGE `Unk620` `Chance` float NOT NULL DEFAULT '0' AFTER `SpellID`, + ADD `UnitConditionID` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `PlayerConditionID`, + CHANGE `Flags` `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `UnitConditionID`, + ADD `Priority` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `DifficultyID`; |