aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql
new file mode 100644
index 00000000000..4d76e75fbf3
--- /dev/null
+++ b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_07.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `char_sections` CHANGE `Id` `ID` int(10) unsigned NOT NULL DEFAULT 0 FIRST;
+
+ALTER TABLE `chr_races`
+ CHANGE `Unk` `Unk1` int(10) unsigned NOT NULL DEFAULT 0 AFTER `HighResFemaleDisplayID`,
+ ADD `Unk2` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Unk1`,
+ ADD `Unk3` int(10) unsigned NOT NULL DEFAULT 0 AFTER `Unk2`;
+
+ALTER TABLE `spell_scaling`
+ CHANGE `MinScalingLevel` `MinScalingLevel` int(10) unsigned NOT NULL DEFAULT 0 AFTER `ScalingClass`,
+ CHANGE `MaxScalingLevel` `MaxScalingLevel` int(10) unsigned NOT NULL DEFAULT 0 AFTER `MinScalingLevel`;