From 623202d68e862b346b22ac65f9dcbb498d2fa2ac Mon Sep 17 00:00:00 2001 From: Shauren 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 --- sql/updates/auth/master/2023_12_26_00_auth.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 sql/updates/auth/master/2023_12_26_00_auth.sql (limited to 'sql/updates/auth/master') 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`; -- cgit v1.2.3