From 24ab54f213a40adb643fe0b30cd0ffa5d6f1b2b7 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Tue, 9 Mar 2010 20:33:59 +0100 Subject: Small update to the group/party system. - Fixes raid assistant privileges, Fixes issue #248 - Proper designation for Main tank and Main assistant roles - Remove 2 redundant columns in DB, namely groups.mainTank and groups.mainAssist. These are now defined by the value of group_member.memberFlags --HG-- branch : trunk --- sql/updates/7515_characters_group_member.sql | 2 ++ sql/updates/7515_characters_groups.sql | 3 +++ 2 files changed, 5 insertions(+) create mode 100644 sql/updates/7515_characters_group_member.sql create mode 100644 sql/updates/7515_characters_groups.sql (limited to 'sql/updates') diff --git a/sql/updates/7515_characters_group_member.sql b/sql/updates/7515_characters_group_member.sql new file mode 100644 index 00000000000..e2ffafb5039 --- /dev/null +++ b/sql/updates/7515_characters_group_member.sql @@ -0,0 +1,2 @@ +ALTER TABLE `group_member` +CHANGE `assistant` `memberFlags` tinyint(2) NOT NULL DEFAULT '0'; diff --git a/sql/updates/7515_characters_groups.sql b/sql/updates/7515_characters_groups.sql new file mode 100644 index 00000000000..cf8f714a739 --- /dev/null +++ b/sql/updates/7515_characters_groups.sql @@ -0,0 +1,3 @@ +ALTER TABLE `groups` +DROP COLUMN `mainTank`, +DROP COLUMN `mainAssistant`; -- cgit v1.2.3