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/base | |
| 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/base')
| -rw-r--r-- | sql/base/auth_database.sql | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 098319b982c..d0388e6907b 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -25,13 +25,10 @@ DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `salt` binary(32) DEFAULT NULL, - `verifier` binary(32) DEFAULT NULL, + `salt` binary(32) NOT NULL, + `verifier` binary(32) NOT NULL, `session_key_auth` binary(40) DEFAULT NULL, `session_key_bnet` varbinary(64) DEFAULT NULL, - `sha_pass_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', - `v` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `verifier` instead', - `s` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dummy value, use `salt` instead', `totp_secret` varbinary(128) DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `reg_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', @@ -2487,6 +2484,7 @@ INSERT INTO `updates` VALUES ('2020_08_11_00_auth.sql','14C99177E43003D83A4D6F2227722F15FC15A1D0','ARCHIVED','2020-08-11 00:00:00',0), ('2020_08_14_00_auth.sql','DFB9B07A7846FC0E124EE4CC099E49FE5742FB66','ARCHIVED','2020-08-14 21:41:24',0), ('2020_08_26_00_auth.sql','D5EF787DECB41D898379588F101A0453B46F04D9','ARCHIVED','2020-08-26 21:00:34',0), +('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','ARCHIVED','2020-09-06 00:00:00',0), ('2020_09_25_00_auth.sql','3CCA78EF89223724BA6784A4F3783DED30416637','ARCHIVED','2020-09-25 19:52:40',0), ('2020_10_20_00_auth.sql','1835C5EFD5816DEF914F27E867C8C8D5E08B3F68','ARCHIVED','2020-10-20 21:36:49',0), ('2020_12_06_00_auth.sql','FA254400D3D7D53E9C350EABFEABFF4EC3AD40DA','ARCHIVED','2020-12-06 20:25:10',0), |