diff options
| author | TDB Release <tdb-release@build.bot> | 2024-09-03 00:52:11 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2024-09-03 00:52:11 +0000 |
| commit | c722ff3a68ed5e20a765d8055cb464dfaee55b6f (patch) | |
| tree | f05a2a0075dc908ce26072f007577d14d7a6b50c /sql/updates/auth | |
| parent | 256b5eb097bdd63b11352642a07255493e522e37 (diff) | |
TDB 1102.24091 - 2024/09/03TDB1102.24091
Diffstat (limited to 'sql/updates/auth')
30 files changed, 2 insertions, 242 deletions
diff --git a/sql/updates/auth/master/2024_05_14_00_auth.sql b/sql/updates/auth/master/2024_05_14_00_auth.sql deleted file mode 100644 index 523b4936441..00000000000 --- a/sql/updates/auth/master/2024_05_14_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54673; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54673,10,2,7,NULL,NULL,'AF8B9C8A9C6128498E85228B965A004D',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54673 WHERE `gamebuild`=54630; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54673'; diff --git a/sql/updates/auth/master/2024_05_16_00_auth.sql b/sql/updates/auth/master/2024_05_16_00_auth.sql deleted file mode 100644 index b5af834da50..00000000000 --- a/sql/updates/auth/master/2024_05_16_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54717; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54717,10,2,7,NULL,NULL,'862BBA15158DFF6B56BCF71C1B34D41A',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54717 WHERE `gamebuild`=54673; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54717'; diff --git a/sql/updates/auth/master/2024_05_17_00_auth.sql b/sql/updates/auth/master/2024_05_17_00_auth.sql deleted file mode 100644 index 0371880c8f1..00000000000 --- a/sql/updates/auth/master/2024_05_17_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54736; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54736,10,2,7,NULL,NULL,'FE58F039D91E1C248886A2828127CA2F',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54736 WHERE `gamebuild`=54717; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54736'; diff --git a/sql/updates/auth/master/2024_05_18_00_auth.sql b/sql/updates/auth/master/2024_05_18_00_auth.sql deleted file mode 100644 index 3813e329a32..00000000000 --- a/sql/updates/auth/master/2024_05_18_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54762; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54762,10,2,7,NULL,NULL,'5F7FDA560030255445B713456A286CFA',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54762 WHERE `gamebuild`=54736; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54762'; diff --git a/sql/updates/auth/master/2024_05_25_00_auth.sql b/sql/updates/auth/master/2024_05_25_00_auth.sql deleted file mode 100644 index 3adcd287ac5..00000000000 --- a/sql/updates/auth/master/2024_05_25_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54847; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54847,10,2,7,NULL,NULL,'32FDA0353160EC51EB36195CFACEF2B7',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54847 WHERE `gamebuild`=54762; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54847'; diff --git a/sql/updates/auth/master/2024_05_29_00_auth.sql b/sql/updates/auth/master/2024_05_29_00_auth.sql deleted file mode 100644 index f109a911d08..00000000000 --- a/sql/updates/auth/master/2024_05_29_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54904; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54904,10,2,7,NULL,NULL,'09CBEC3C0DEA28BCA79F1FD9B879B0E3',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54904 WHERE `gamebuild`=54847; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54904'; diff --git a/sql/updates/auth/master/2024_06_05_00_auth.sql b/sql/updates/auth/master/2024_06_05_00_auth.sql deleted file mode 100644 index 8253cf61bf1..00000000000 --- a/sql/updates/auth/master/2024_06_05_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=54988; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(54988,10,2,7,NULL,NULL,'8F2791553226871977B4F9D7F1137311',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=54988 WHERE `gamebuild`=54904; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54988'; diff --git a/sql/updates/auth/master/2024_06_15_00_auth.sql b/sql/updates/auth/master/2024_06_15_00_auth.sql deleted file mode 100644 index b5da79cc175..00000000000 --- a/sql/updates/auth/master/2024_06_15_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=55142; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55142,10,2,7,NULL,NULL,'298B99B5AD67EA3D2AB4B3E07A415305',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55142 WHERE `gamebuild`=54988; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55142'; diff --git a/sql/updates/auth/master/2024_06_17_00_auth.sql b/sql/updates/auth/master/2024_06_17_00_auth.sql deleted file mode 100644 index 3b61aea689e..00000000000 --- a/sql/updates/auth/master/2024_06_17_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=55165; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55165,10,2,7,NULL,NULL,'26D4D1C01434A8A6723DCABC944B6FD0',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55165 WHERE `gamebuild`=55142; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55165'; diff --git a/sql/updates/auth/master/2024_06_26_00_auth.sql b/sql/updates/auth/master/2024_06_26_00_auth.sql deleted file mode 100644 index 8013cb78ded..00000000000 --- a/sql/updates/auth/master/2024_06_26_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=55261; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55261,10,2,7,NULL,NULL,'84E153A3DD1F8249274B91047AAC7AED',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55261 WHERE `gamebuild`=55165; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55261'; diff --git a/sql/updates/auth/master/2024_07_09_00_auth.sql b/sql/updates/auth/master/2024_07_09_00_auth.sql deleted file mode 100644 index dbccdaf9a19..00000000000 --- a/sql/updates/auth/master/2024_07_09_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=55461; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55461,10,2,7,NULL,NULL,'C4522674F854EFECC76C898EC9545099',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55461 WHERE `gamebuild`=55261; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55461'; diff --git a/sql/updates/auth/master/2024_07_16_00_auth.sql b/sql/updates/auth/master/2024_07_16_00_auth.sql deleted file mode 100644 index 909c56952c7..00000000000 --- a/sql/updates/auth/master/2024_07_16_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=55664; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55664,10,2,7,NULL,NULL,'DBCA58486FAAA0FE54EA287A3047E923',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55664 WHERE `gamebuild`=55461; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55664'; diff --git a/sql/updates/auth/master/2024_08_02_00_auth.sql b/sql/updates/auth/master/2024_08_02_00_auth.sql deleted file mode 100644 index dae8b80cfb4..00000000000 --- a/sql/updates/auth/master/2024_08_02_00_auth.sql +++ /dev/null @@ -1,14 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (55666,55792,55793,55818,55824,55846,55933,55939); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55666,11,0,0,NULL,NULL,'F7E5A88E4D3615B652C8B9D76E7F617C',NULL,NULL,NULL), -(55792,11,0,0,NULL,NULL,'C4DECDAA44BC548FF09EF3BB837D2147',NULL,NULL,NULL), -(55793,11,0,0,NULL,NULL,'F9CF3232AD1C38C2028668D5BB64198F',NULL,NULL,NULL), -(55818,11,0,0,NULL,NULL,'903A9B546248F71B16D9D9B06A072C24',NULL,NULL,NULL), -(55824,11,0,0,NULL,NULL,'8A6F13269A2896067A1E88789FB41BA7',NULL,NULL,NULL), -(55846,11,0,0,NULL,NULL,'BB5E1BED705872C226834B95A9E9F8A9',NULL,NULL,NULL), -(55933,11,0,0,NULL,NULL,'C34D42CB351C400D1319D221197CF18D',NULL,NULL,NULL), -(55939,11,0,0,NULL,NULL,'91529F4CE41DE4E54E132660ACDCADC5',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55939 WHERE `gamebuild`=55664; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55939'; diff --git a/sql/updates/auth/master/2024_08_07_00_auth.sql b/sql/updates/auth/master/2024_08_07_00_auth.sql deleted file mode 100644 index 8f80b1172e1..00000000000 --- a/sql/updates/auth/master/2024_08_07_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (55960); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55960,11,0,0,NULL,NULL,'078C056CFC7B371BDE1BAF308E6C19AF',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=55960 WHERE `gamebuild`=55939; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55960'; diff --git a/sql/updates/auth/master/2024_08_09_00_auth.sql b/sql/updates/auth/master/2024_08_09_00_auth.sql deleted file mode 100644 index 3193492d5cd..00000000000 --- a/sql/updates/auth/master/2024_08_09_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56008); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56008,11,0,0,NULL,NULL,'00FCD6BFFCCCBA7A8E71E307EA6EBD0C',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56008 WHERE `gamebuild`=55960; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56008'; diff --git a/sql/updates/auth/master/2024_08_15_00_auth.sql b/sql/updates/auth/master/2024_08_15_00_auth.sql deleted file mode 100644 index 3a50b6b5935..00000000000 --- a/sql/updates/auth/master/2024_08_15_00_auth.sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (55959,56110); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(55959,11,0,2,NULL,NULL,'ED57E0538FD1CE99B171BE34823148A9',NULL,NULL,NULL), -(56110,11,0,2,NULL,NULL,'800BCA228E2FAE37ED160F3C09E21F3A',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56110 WHERE `gamebuild`=56008; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56110'; diff --git a/sql/updates/auth/master/2024_08_17_00_auth.sql b/sql/updates/auth/master/2024_08_17_00_auth.sql deleted file mode 100644 index 1cdc5e0c0b3..00000000000 --- a/sql/updates/auth/master/2024_08_17_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56162); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56162,11,0,2,NULL,NULL,'6F5C93BA436665A94DB67CE5361D4EA8',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56162 WHERE `gamebuild`=56110; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56162'; diff --git a/sql/updates/auth/master/2024_08_18_00_auth.sql b/sql/updates/auth/master/2024_08_18_00_auth.sql deleted file mode 100644 index 641e0d3d181..00000000000 --- a/sql/updates/auth/master/2024_08_18_00_auth.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `account` ADD `client_build` int unsigned NOT NULL DEFAULT '0' AFTER `muteby`; diff --git a/sql/updates/auth/master/2024_08_21_00_auth.sql b/sql/updates/auth/master/2024_08_21_00_auth.sql deleted file mode 100644 index 24b8e1ab712..00000000000 --- a/sql/updates/auth/master/2024_08_21_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56196); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56196,11,0,2,NULL,NULL,'81FC14274BFF0347FFF9C8B1AA6BED9B',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56196 WHERE `gamebuild`=56162; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56196'; diff --git a/sql/updates/auth/master/2024_08_22_00_auth.sql b/sql/updates/auth/master/2024_08_22_00_auth.sql deleted file mode 100644 index 98264daf120..00000000000 --- a/sql/updates/auth/master/2024_08_22_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56263); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56263,11,0,2,NULL,NULL,'EA8472C99236CC617BF518A924014D56',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56263 WHERE `gamebuild`=56196; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56263'; diff --git a/sql/updates/auth/master/2024_08_23_00_auth.sql b/sql/updates/auth/master/2024_08_23_00_auth.sql deleted file mode 100644 index 015d9c1498b..00000000000 --- a/sql/updates/auth/master/2024_08_23_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56288); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56288,11,0,2,NULL,NULL,'03544E35D0480938E5C1238B3A26BDDD',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56288 WHERE `gamebuild`=56263; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56288'; diff --git a/sql/updates/auth/master/2024_08_23_01_auth.sql b/sql/updates/auth/master/2024_08_23_01_auth.sql deleted file mode 100644 index da703936511..00000000000 --- a/sql/updates/auth/master/2024_08_23_01_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE `account` MODIFY `expansion` tinyint unsigned NOT NULL DEFAULT 10; - -UPDATE `account` SET `expansion`=10 WHERE `expansion`=9; diff --git a/sql/updates/auth/master/2024_08_24_00_auth.sql b/sql/updates/auth/master/2024_08_24_00_auth.sql deleted file mode 100644 index b7338a1a6b1..00000000000 --- a/sql/updates/auth/master/2024_08_24_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56311); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56311,11,0,2,NULL,NULL,'AC6415575AEE4D32735FFAD0C57226B2',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56311 WHERE `gamebuild`=56288; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56311'; diff --git a/sql/updates/auth/master/2024_08_28_00_auth.sql b/sql/updates/auth/master/2024_08_28_00_auth.sql deleted file mode 100644 index 5ef652ec2e4..00000000000 --- a/sql/updates/auth/master/2024_08_28_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56313); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(56313,11,0,2,NULL,NULL,'EAF769009A9AD3B1AA0414E1C344074B',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=56313 WHERE `gamebuild`=56311; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56313'; diff --git a/sql/updates/auth/master/2024_08_28_01_auth.sql b/sql/updates/auth/master/2024_08_28_01_auth.sql deleted file mode 100644 index 7e547d9cc4a..00000000000 --- a/sql/updates/auth/master/2024_08_28_01_auth.sql +++ /dev/null @@ -1,6 +0,0 @@ -ALTER TABLE `build_info` ADD `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `mac64AuthSeed`; - -UPDATE `build_info` SET `macArmAuthSeed`='778F6A5DF79A4EF1B86F651F3B303CE7' WHERE `build`=56196; -UPDATE `build_info` SET `macArmAuthSeed`='41710C793EF021721F14B06EC1896D3F' WHERE `build`=56288; -UPDATE `build_info` SET `macArmAuthSeed`='412D3200715AAFDC0522DF031A941F0E' WHERE `build`=56311; -UPDATE `build_info` SET `macArmAuthSeed`='A83ED19EE659BC95CC322D1E49BDEDBB' WHERE `build`=56313; diff --git a/sql/updates/auth/master/2024_08_30_00_auth.sql b/sql/updates/auth/master/2024_08_30_00_auth.sql deleted file mode 100644 index 2b36c28a3cf..00000000000 --- a/sql/updates/auth/master/2024_08_30_00_auth.sql +++ /dev/null @@ -1,39 +0,0 @@ --- --- 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`; diff --git a/sql/updates/auth/master/2024_08_30_01_auth.sql b/sql/updates/auth/master/2024_08_30_01_auth.sql deleted file mode 100644 index 59e78161528..00000000000 --- a/sql/updates/auth/master/2024_08_30_01_auth.sql +++ /dev/null @@ -1,14 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56380,56382); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56380,11,0,2,NULL), -(56382,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56380,'Win','x64','WoW',0xD081784493233E2869933FCC01F1A3C1), -(56380,'Win','x64','WoWC',0x4FB3D72D89F5FF01DD7F4E028494A4E6), -(56382,'Win','x64','WoW',0x67C36A3EF655534C58AD50942192BFDA), -(56382,'Win','x64','WoWC',0xA5BD7A1C33039F58CD45CD5C7EBDF122); diff --git a/sql/updates/auth/master/2024_08_31_00_auth.sql b/sql/updates/auth/master/2024_08_31_00_auth.sql deleted file mode 100644 index 6d44f1b1d2e..00000000000 --- a/sql/updates/auth/master/2024_08_31_00_auth.sql +++ /dev/null @@ -1,13 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56421); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56421,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56421,'Win','x64','WoW',0x3BDFA9AA4B70041F2C8B8CDE3C8DC255), -(56421,'Win','x64','WoWC',0x0DDB8F8738647F3CD8FD585A3A78ED1B); - -UPDATE `realmlist` SET `gamebuild`=56421 WHERE `gamebuild`=56313; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56421'; diff --git a/sql/updates/auth/master/2024_08_31_01_auth.sql b/sql/updates/auth/master/2024_08_31_01_auth.sql deleted file mode 100644 index 40000076bbe..00000000000 --- a/sql/updates/auth/master/2024_08_31_01_auth.sql +++ /dev/null @@ -1,2 +0,0 @@ -DELETE FROM build_auth_key WHERE `build` = 56421 AND `platform` = 'Mac' AND `arch` = 'A64' AND `type`='WoW'; -INSERT INTO build_auth_key VALUES (56421, 'Mac', 'A64', 'WoW', 0x5892FFABAEFDCECB0CFFAAA55D2F9B13); diff --git a/sql/updates/auth/master/2024_05_11_00_auth.sql b/sql/updates/auth/master/2024_09_03_00_auth.sql index 56939041955..f953e7436c4 100644 --- a/sql/updates/auth/master/2024_05_11_00_auth.sql +++ b/sql/updates/auth/master/2024_09_03_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 1027.24051 auth +-- TDB 1102.24091 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED'); +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED'); |
