diff options
| author | n0n4m3 <none@none> | 2009-12-18 07:06:53 +0100 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2009-12-18 07:06:53 +0100 |
| commit | bb2ddadae99de1bd253886b4dcd394cb15997b64 (patch) | |
| tree | c906e93c2ca43d1f31fa9cc0249b9489a52aa8a8 /sql/updates/3.2.2a_characters_update.sql | |
| parent | 304f59f2bb18439addc3da1471fae8d6dacbb8b2 (diff) | |
Added missing sql updates
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/3.2.2a_characters_update.sql')
| -rw-r--r-- | sql/updates/3.2.2a_characters_update.sql | 5 |
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; |