From 842e1b6c9b5030c05dab9149a4feb9904d440462 Mon Sep 17 00:00:00 2001 From: Shauren Date: Fri, 30 Aug 2024 00:52:33 +0200 Subject: Core/Client Builds: Refactor build_info structure to support any client variants (cherry picked from commit e94558d07892a98d78bec3633e0c82e1394b9d66) # Conflicts: # sql/base/auth_database.sql # sql/updates/auth/cata_classic/2024_08_30_00_auth.sql --- .../auth/cata_classic/2024_08_30_00_auth.sql | 39 ++++++++++++++++++++++ 1 file changed, 39 insertions(+) create mode 100644 sql/updates/auth/cata_classic/2024_08_30_00_auth.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql new file mode 100644 index 00000000000..2b36c28a3cf --- /dev/null +++ b/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql @@ -0,0 +1,39 @@ +-- +-- Table structure for table `build_auth_key` +-- +DROP TABLE IF EXISTS `build_auth_key`; +CREATE TABLE `build_auth_key` ( + `build` int NOT NULL, + `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `arch` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `type` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `key` binary(16) NOT NULL, + PRIMARY KEY (`build`,`platform`,`arch`,`type`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `build_executable_hash` +-- +DROP TABLE IF EXISTS `build_executable_hash`; +CREATE TABLE `build_executable_hash` ( + `build` int NOT NULL, + `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `executableHash` binary(20) NOT NULL, + PRIMARY KEY (`build`,`platform`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +INSERT INTO `build_auth_key` SELECT `build`,'Win','x86','WoW',UNHEX(`winAuthSeed`) FROM `build_info` WHERE LENGTH(`winAuthSeed`)=32; +INSERT INTO `build_auth_key` SELECT `build`,'Win','x64','WoW',UNHEX(`win64AuthSeed`) FROM `build_info` WHERE LENGTH(`win64AuthSeed`)=32; +INSERT INTO `build_auth_key` SELECT `build`,'Mac','x64','WoW',UNHEX(`mac64AuthSeed`) FROM `build_info` WHERE LENGTH(`mac64AuthSeed`)=32; +INSERT INTO `build_auth_key` SELECT `build`,'Mac','A64','WoW',UNHEX(`macArmAuthSeed`) FROM `build_info` WHERE LENGTH(`macArmAuthSeed`)=32; + +INSERT INTO `build_executable_hash` SELECT `build`,'Win',UNHEX(`winChecksumSeed`) FROM `build_info` WHERE LENGTH(`winChecksumSeed`)=40; +INSERT INTO `build_executable_hash` SELECT `build`,'OSX',UNHEX(`macChecksumSeed`) FROM `build_info` WHERE LENGTH(`macChecksumSeed`)=40; + +ALTER TABLE `build_info` + DROP `winAuthSeed`, + DROP `win64AuthSeed`, + DROP `mac64AuthSeed`, + DROP `macArmAuthSeed`, + DROP `winChecksumSeed`, + DROP `macChecksumSeed`; -- cgit v1.2.3