aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/8116_characters_groups.sql
diff options
context:
space:
mode:
authorTrazom62 <none@none>2010-05-05 12:40:52 +0200
committerTrazom62 <none@none>2010-05-05 12:40:52 +0200
commiteee3ebe6d6e55a18f690704bc28db3a58f0efb12 (patch)
tree655a60eee075bce42c85ecc876472dc9e446a77c /sql/updates/8116_characters_groups.sql
parent3199e7b8dbae8eb6025a612073fed230566ba9c6 (diff)
Fix raid groups load from DB and save to DB.
Fixes issue #299. - In table GROUPS, since rev 7841, isRaid is used to store the groupType. The DB was not updated. this is now fixed. - Fix isRaid set to 1 when group converted to raid (shall be the groupType). - Fix isRaidGroup check as groupType is now a set of flags. - Fix dungeon/raid check when difficulty change. --HG-- branch : trunk
Diffstat (limited to 'sql/updates/8116_characters_groups.sql')
-rw-r--r--sql/updates/8116_characters_groups.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/8116_characters_groups.sql b/sql/updates/8116_characters_groups.sql
new file mode 100644
index 00000000000..a75bb274ffb
--- /dev/null
+++ b/sql/updates/8116_characters_groups.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `groups` CHANGE `isRaid` `groupType` MEDIUMINT(8) UNSIGNED NOT NULL;
+UPDATE `groups` SET `groupType`=2 where `groupType`=1;