diff options
| author | Treeston <treeston.mmoc@gmail.com> | 2020-09-06 16:04:10 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-05 13:29:21 +0100 |
| commit | e0e3bae82cfb6c70ba810997104054ab6ca77e99 (patch) | |
| tree | 33c02a81521514ffe392e27dcccd13a49b0fcb69 /sql/updates | |
| parent | 3bf33628fc4833e8682f96c679982200fcbd1674 (diff) | |
Core/Authserver: Removal of sha_pass_hash, compatibility fields, and everything that uses them (PR #25156)
(cherry picked from commit bcdbdd6f23ce65cc0e381e61d2840140dce79311)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2020_09_06_00_auth.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2020_09_06_00_auth.sql b/sql/updates/auth/master/2020_09_06_00_auth.sql new file mode 100644 index 00000000000..d04bdf6f4fe --- /dev/null +++ b/sql/updates/auth/master/2020_09_06_00_auth.sql @@ -0,0 +1,8 @@ +-- +UPDATE `account` SET `salt`=UNHEX(CONCAT(MD5(RAND()),MD5(RAND()))), `verifier`=UNHEX(CONCAT(MD5(RAND()),MD5(RAND()))) WHERE `salt` IS NULL OR `verifier` IS NULL; +ALTER TABLE `account` + DROP COLUMN `s`, + DROP COLUMN `v`, + DROP COLUMN `sha_pass_hash`, + MODIFY COLUMN `salt` BINARY(32) NOT NULL, + MODIFY COLUMN `verifier` BINARY(32) NOT NULL; |