aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7515_characters_group_member.sql2
-rw-r--r--sql/updates/7515_characters_groups.sql3
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`;