aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTreeston <treeston.mmoc@gmail.com>2020-08-03 18:53:00 +0200
committerTreeston <treeston.mmoc@gmail.com>2020-08-03 18:53:00 +0200
commit38de6d330711f0439d311a3c493cc82eaf9d09db (patch)
treec12698240211f2085a896b5749439b2c9a4c5d58 /sql/updates
parent65e3b3cf0dd6a73cf376e6815cca808322b9881e (diff)
Core/DB: Split `accounts`.`session_key` into `session_key_auth` (3.3.5) and `session_key_bnet` (master), so the branches will no longer break each other's realm switching.
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/3.3.5/2020_08_03_01_auth.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2020_08_03_01_auth.sql b/sql/updates/auth/3.3.5/2020_08_03_01_auth.sql
new file mode 100644
index 00000000000..f46d259aa4b
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2020_08_03_01_auth.sql
@@ -0,0 +1,5 @@
+--
+ALTER TABLE `account`
+ DROP COLUMN `session_key`,
+ ADD COLUMN `session_key_auth` BINARY(40) DEFAULT NULL AFTER `verifier`,
+ ADD COLUMN `session_key_bnet` VARBINARY(64) DEFAULT NULL AFTER `session_key_auth`;