diff options
| author | Shauren <shauren.trinity@gmail.com> | 2023-12-26 14:55:15 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2023-12-26 14:55:15 +0100 |
| commit | 623202d68e862b346b22ac65f9dcbb498d2fa2ac (patch) | |
| tree | fd882ea858e1668d2f79c1232ea5c0bf50001488 /sql | |
| parent | 4a61675191c91c7d09def0e612f2e11a646845b0 (diff) | |
Core/Bnet: Implemented new SRP6 variants, and migrate old sha_pass_hash in battlenet_accounts to separate salt and verifier columns
* passwords can now be case sensitive and up to 128 characters long
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_12_26_00_auth.sql | 4 |
2 files changed, 9 insertions, 2 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index b1c72397cba..93c547bd4ed 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -419,7 +419,9 @@ DROP TABLE IF EXISTS `battlenet_accounts`; CREATE TABLE `battlenet_accounts` ( `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier', `email` varchar(320) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, - `sha_pass_hash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', + `srp_version` tinyint(3) NOT NULL DEFAULT '1', + `salt` binary(32) NOT NULL, + `verifier` blob NOT NULL, `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '127.0.0.1', `failed_logins` int unsigned NOT NULL DEFAULT '0', @@ -2778,7 +2780,8 @@ INSERT INTO `updates` VALUES ('2023_12_13_00_auth.sql','C3D6AA45BECD5A7F8A420FE0022AAF6A349C5E3F','RELEASED','2023-12-13 06:42:48',0), ('2023_12_19_00_auth.sql','6761E7111F613E57A7D684E18E38FCA3F5CD66A6','RELEASED','2023-12-19 08:54:36',0), ('2023_12_21_00_auth.sql','DB294EF35C00AA92C79786F7A0BFBCE739D4E193','RELEASED','2023-12-21 09:08:30',0), -('2023_12_24_00_auth.sql','F59B3A895750FD83177324B89BFCEBD8A43DD577','RELEASED','2023-12-24 06:24:58',0); +('2023_12_24_00_auth.sql','F59B3A895750FD83177324B89BFCEBD8A43DD577','RELEASED','2023-12-24 06:24:58',0), +('2023_12_26_00_auth.sql','5C8716F7F6E2792E15A42BDA8F2D855A7DE95FC5','RELEASED','2023-12-26 13:38:58',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2023_12_26_00_auth.sql b/sql/updates/auth/master/2023_12_26_00_auth.sql new file mode 100644 index 00000000000..3c27a8c7ac5 --- /dev/null +++ b/sql/updates/auth/master/2023_12_26_00_auth.sql @@ -0,0 +1,4 @@ +ALTER TABLE `battlenet_accounts` + ADD `srp_version` tinyint(3) NOT NULL DEFAULT '1' AFTER `email`, + ADD `salt` binary(32) AFTER `srp_version`, + ADD `verifier` blob AFTER `salt`; |