From bb2ddadae99de1bd253886b4dcd394cb15997b64 Mon Sep 17 00:00:00 2001
From: n0n4m3 <none@none>
Date: Fri, 18 Dec 2009 07:06:53 +0100
Subject: Added missing sql updates

--HG--
branch : trunk
---
 sql/updates/3.2.2a_characters_update.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'sql/updates/3.2.2a_characters_update.sql')

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;
 
-- 
cgit v1.2.3

