aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/3.2.2a_characters_update.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/3.2.2a_characters_update.sql')
-rw-r--r--sql/updates/3.2.2a_characters_update.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/3.2.2a_characters_update.sql b/sql/updates/3.2.2a_characters_update.sql
index c21c0cec188..9c64a873728 100644
--- a/sql/updates/3.2.2a_characters_update.sql
+++ b/sql/updates/3.2.2a_characters_update.sql
@@ -17,6 +17,11 @@ UPDATE characters SET data = CONCAT(TRIM(data),' ');
alter table `groups`
add column `raiddifficulty` int(11) UNSIGNED DEFAULT '0' NOT NULL after `difficulty`;
+ALTER TABLE instance_reset
+ ADD COLUMN difficulty tinyint(1) unsigned NOT NULL default '0' AFTER mapid,
+ DROP PRIMARY KEY,
+ ADD PRIMARY KEY (`mapid`,`difficulty`);
+
ALTER TABLE `bugreport` CHANGE `type` `type` LONGTEXT NOT NULL;
ALTER TABLE `bugreport` CHANGE `content` `content` LONGTEXT NOT NULL;