summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn11895.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn11895.sql')
-rw-r--r--sql-files/upgrade_svn11895.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn11895.sql b/sql-files/upgrade_svn11895.sql
new file mode 100644
index 000000000..e34af527f
--- /dev/null
+++ b/sql-files/upgrade_svn11895.sql
@@ -0,0 +1,12 @@
+ALTER TABLE `guild_expulsion`
+ DROP `acc`,
+ DROP `rsv1`,
+ DROP `rsv2`,
+ DROP `rsv3`;
+
+ALTER TABLE `guild_expulsion`
+ MODIFY `account_id` int(11) unsigned NOT NULL default '0' AFTER `guild_id`;
+
+ALTER TABLE `guild_member`
+ DROP `rsv1`,
+ DROP `rsv2`;