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

1 files changed, 4 insertions, 0 deletions

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`;