From d11b9a6992b9e46cc880f4c8b085479009acfaab Mon Sep 17 00:00:00 2001 From: funjoker Date: Tue, 18 Jun 2019 19:33:29 +0200 Subject: Core/DataStores: Fix field order for some DB2s (#23439) --- sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/hotfixes/master/2019_06_18_00_hotfixes.sql (limited to 'sql') 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`; -- cgit v1.2.3