diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/wotlk_classic/2024_01_09_01_auth_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 aff25c3d7a3..e6d55257edd 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', @@ -2766,7 +2768,8 @@ INSERT INTO `updates` VALUES ('2023_11_23_00_auth.sql','EC3D1289A07E387BF4D2AC94EEBE3A29483EAD3A','ARCHIVED','2023-11-23 02:39:18',0), ('2023_11_24_00_auth.sql','AC1B5136CC97264A21933BD1074D02E88D819488','ARCHIVED','2023-11-24 19:37:38',0), ('2023_12_20_00_auth.sql','D4AB92FEB9FECC1EE35BB9A734B2E95A44C43CD4','ARCHIVED','2023-12-20 21:51:28',0), -('2024_01_09_00_auth_2023_12_24_00_auth.sql', 'F59B3A895750FD83177324B89BFCEBD8A43DD577', 'RELEASED', '2024-01-09 12:02:27', 0); +('2024_01_09_00_auth_2023_12_24_00_auth.sql', 'F59B3A895750FD83177324B89BFCEBD8A43DD577', 'RELEASED', '2024-01-09 12:02:27', 0), +('2024_01_09_01_auth_2023_12_26_00_auth.sql', '5C8716F7F6E2792E15A42BDA8F2D855A7DE95FC5', 'RELEASED', '2024-01-09 12:06:46', 0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/wotlk_classic/2024_01_09_01_auth_2023_12_26_00_auth.sql b/sql/updates/auth/wotlk_classic/2024_01_09_01_auth_2023_12_26_00_auth.sql new file mode 100644 index 00000000000..3c27a8c7ac5 --- /dev/null +++ b/sql/updates/auth/wotlk_classic/2024_01_09_01_auth_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`; |