aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTreeston <treeston.mmoc@gmail.com>2020-08-03 18:53:00 +0200
committerShauren <shauren.trinity@gmail.com>2020-08-03 22:49:31 +0200
commit22bad09c01c6f17eeb420076904fd5e88ad4de36 (patch)
treeb71b16dd00bc68d02f8780da4ecfb3ac8232917c /sql/updates/auth
parenteefbf2892fd58c2cfdf9ac376f419fde979b90ad (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.
(cherry picked from commit 38de6d330711f0439d311a3c493cc82eaf9d09db)
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2020_08_03_01_auth.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2020_08_03_01_auth.sql b/sql/updates/auth/master/2020_08_03_01_auth.sql
new file mode 100644
index 00000000000..f46d259aa4b
--- /dev/null
+++ b/sql/updates/auth/master/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`;