diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 12 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2020_09_06_00_auth.sql | 8 |
2 files changed, 13 insertions, 7 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 62dd06db112..06ae7646c24 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(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `username` varchar(32) 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) NOT NULL DEFAULT '', - `v` varchar(64) NOT NULL DEFAULT 'dummy value, use `verifier` instead', - `s` varchar(64) NOT NULL DEFAULT 'dummy value, use `salt` instead', `totp_secret` varbinary(128) DEFAULT NULL, `email` varchar(255) NOT NULL DEFAULT '', `reg_mail` varchar(255) NOT NULL DEFAULT '', @@ -1972,8 +1969,9 @@ INSERT INTO `updates` VALUES ('2020_08_03_00_auth.sql','492CA77C0FAEEEF3E0492121B3A92689373ECFA3','ARCHIVED','2020-08-03 00:00:00',0), ('2020_08_03_01_auth.sql','EC1063396CA20A2303D83238470D41EF4439EC72','ARCHIVED','2020-08-03 00:00:01',0), ('2020_08_11_00_auth.sql','14C99177E43003D83A4D6F2227722F15FC15A1D0','ARCHIVED','2020-08-11 00:00:00',0), -('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 09:34:44',0), -('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 16:27:26',0); +('2020_08_15_00_auth.sql','A49F4A776E1583B1FF63DFE99BC0E0DD97A74674','ARCHIVED','2020-08-15 00:00:00',0), +('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','RELEASED','2020-08-22 00:00:00',0), +('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','RELEASED','2020-09-06 00:00:00',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/3.3.5/2020_09_06_00_auth.sql b/sql/updates/auth/3.3.5/2020_09_06_00_auth.sql new file mode 100644 index 00000000000..d04bdf6f4fe --- /dev/null +++ b/sql/updates/auth/3.3.5/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; |