aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2016-10-26 01:46:48 +0200
committerShauren <shauren.trinity@gmail.com>2016-10-26 01:46:48 +0200
commita4f2062eb1e163991a758cae875b747f289431ce (patch)
tree2f6a2435ec600131ff250cddd048be58d04fa1b0 /sql/updates
parent505d3e24ccbfe0a5248804974bfb0e3386b41d2f (diff)
Core/DataStores: Updated to 7.1.0.22900
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/hotfixes/master/2016_10_26_00_hotfixes.sql15
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`;