Core/Maps: Updated map difficulties

1 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/characters/2015_01_10_00_characters.sql b/sql/updates/characters/2015_01_10_00_characters.sql
new file mode 100644
index 00000000000..c0070507b6d
--- /dev/null
+++ b/sql/updates/characters/2015_01_10_00_characters.sql
@@ -0,0 +1,10 @@
+ALTER TABLE `characters`
+  DROP `instance_mode_mask`,
+  ADD `dungeonDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `instance_id`,
+  ADD `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14' AFTER `dungeonDifficulty`,
+  ADD `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3' AFTER `raidDifficulty`;
+
+ALTER TABLE `groups`
+  CHANGE `difficulty` `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '1' AFTER `groupType`,
+  CHANGE `raiddifficulty` `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '14' AFTER `difficulty`,
+  ADD `legacyRaidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '3' AFTER `raidDifficulty`;