From bcdbdd6f23ce65cc0e381e61d2840140dce79311 Mon Sep 17 00:00:00 2001 From: Treeston Date: Sun, 6 Sep 2020 16:04:10 +0200 Subject: Core/Authserver: Removal of sha_pass_hash, compatibility fields, and everything that uses them (PR #25156) --- sql/updates/auth/3.3.5/2020_09_06_00_auth.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/auth/3.3.5/2020_09_06_00_auth.sql (limited to 'sql/updates/auth') 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; -- cgit v1.2.3