summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn5902.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/upgrade_svn5902.sql')
-rw-r--r--sql-files/upgrade_svn5902.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn5902.sql b/sql-files/upgrade_svn5902.sql
new file mode 100644
index 000000000..f9783ef00
--- /dev/null
+++ b/sql-files/upgrade_svn5902.sql
@@ -0,0 +1,14 @@
+update `char` set `class`='7' where `class`='13';
+update `char` set `class`='21' where `class`='14';
+update `char` set `class`='4008' where `class`='4014';
+update `char` set `class`='4015' where `class`='4022';
+update `char` set `class`='4030' where `class`='4036';
+update `char` set `class`='4037' where `class`='4044';
+update `char` set `class`='4047' where `class`='4048';
+update `guild_member` set `class`='7' where `class`='13';
+update `guild_member` set `class`='21' where `class`='14';
+update `guild_member` set `class`='4008' where `class`='4014';
+update `guild_member` set `class`='4015' where `class`='4022';
+update `guild_member` set `class`='4030' where `class`='4036';
+update `guild_member` set `class`='4037' where `class`='4044';
+update `guild_member` set `class`='4047' where `class`='4048';