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

2 files changed, 5 insertions, 0 deletions

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`;