Core/DataStores: Fix field order for some DB2s (#23439)

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql b/sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql
new file mode 100644
index 00000000000..d9cfa8cd02b
--- /dev/null
+++ b/sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `animation_data` MODIFY COLUMN `BehaviorID` smallint(5) unsigned NOT NULL DEFAULT 0 AFTER `ID`;
+ALTER TABLE `animation_data` MODIFY COLUMN `BehaviorTier` tinyint(3) unsigned NOT NULL DEFAULT 0 AFTER `BehaviorID`;
+ALTER TABLE `animation_data` MODIFY COLUMN `Fallback` int(11) NOT NULL DEFAULT 0 AFTER `BehaviorTier`;
+
+ALTER TABLE `spell_item_enchantment` MODIFY COLUMN `TransmogPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0 AFTER `EffectScalingPoints3`;