From b91c2396d50bab56a672faf31d3f8bcfcbd8e708 Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Tue, 26 Dec 2023 14:55:15 +0100
Subject: 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

(cherry picked from commit 623202d68e862b346b22ac65f9dcbb498d2fa2ac)
---
 sql/base/auth_database.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'sql/base/auth_database.sql')

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;
 
-- 
cgit v1.2.3

