aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorfunjoker <torti-esser@web.de>2019-06-18 19:33:29 +0200
committerShauren <shauren.trinity@gmail.com>2019-06-18 19:33:29 +0200
commitd11b9a6992b9e46cc880f4c8b085479009acfaab (patch)
tree6671f66f462d468c071cd88fbc8299bbc8dd9f27 /sql/updates
parent357e0ec394af33b9764ff9ac6eb9b8f7c16dce97 (diff)
Core/DataStores: Fix field order for some DB2s (#23439)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql5
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`;