aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2023-12-26 14:55:15 +0100
committerfunjoker <funjoker109@gmail.com>2024-01-09 12:07:15 +0100
commitb91c2396d50bab56a672faf31d3f8bcfcbd8e708 (patch)
tree6ca75f888dfcbbbe6e5071151b4955fce9d0b71d /sql/updates
parentc431c77d8923d216901287a2d372494242bc7a51 (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 (cherry picked from commit 623202d68e862b346b22ac65f9dcbb498d2fa2ac)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/wotlk_classic/2024_01_09_01_auth_2023_12_26_00_auth.sql4
1 files changed, 4 insertions, 0 deletions
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`;