diff options
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/3.3.5/2020_09_06_00_auth.sql | 8 |
1 files changed, 8 insertions, 0 deletions
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; |