From eb63d1516b32eb156e905e30fe4455df8101b538 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Fri, 19 Aug 2022 23:51:29 +0000 Subject: TDB 927.22081 - 2022/08/19 --- sql/updates/auth/master/2022_07_25_00_auth.sql | 3 --- sql/updates/auth/master/2022_08_02_00_auth.sql | 7 ------- sql/updates/auth/master/2022_08_17_00_auth.sql | 7 ------- sql/updates/auth/master/2022_08_19_00_auth.sql | 7 ------- sql/updates/auth/master/2022_08_19_01_auth.sql | 3 +++ 5 files changed, 3 insertions(+), 24 deletions(-) delete mode 100644 sql/updates/auth/master/2022_07_25_00_auth.sql delete mode 100644 sql/updates/auth/master/2022_08_02_00_auth.sql delete mode 100644 sql/updates/auth/master/2022_08_17_00_auth.sql delete mode 100644 sql/updates/auth/master/2022_08_19_00_auth.sql create mode 100644 sql/updates/auth/master/2022_08_19_01_auth.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/master/2022_07_25_00_auth.sql b/sql/updates/auth/master/2022_07_25_00_auth.sql deleted file mode 100644 index db0f935b6ac..00000000000 --- a/sql/updates/auth/master/2022_07_25_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 925.22071 auth -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); diff --git a/sql/updates/auth/master/2022_08_02_00_auth.sql b/sql/updates/auth/master/2022_08_02_00_auth.sql deleted file mode 100644 index 740ce9ae2ee..00000000000 --- a/sql/updates/auth/master/2022_08_02_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=44908; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(44908,9,2,5,NULL,NULL,'BFFAEC40C9BCD591C7C959A9D5A8BA8C',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=44908 WHERE `gamebuild`=44730; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44908'; diff --git a/sql/updates/auth/master/2022_08_17_00_auth.sql b/sql/updates/auth/master/2022_08_17_00_auth.sql deleted file mode 100644 index 6fa99fa9b39..00000000000 --- a/sql/updates/auth/master/2022_08_17_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=45114; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(45114,9,2,7,NULL,NULL,'D7AFE240BD00F06C30D0C2D16E54A8BE',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=45114 WHERE `gamebuild`=44908; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45114'; diff --git a/sql/updates/auth/master/2022_08_19_00_auth.sql b/sql/updates/auth/master/2022_08_19_00_auth.sql deleted file mode 100644 index cfe5d1193ec..00000000000 --- a/sql/updates/auth/master/2022_08_19_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=45161; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(45161,9,2,7,NULL,NULL,'74BD2E787A98B145B063BDA9A98F6CBD',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=45161 WHERE `gamebuild`=45114; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45161'; diff --git a/sql/updates/auth/master/2022_08_19_01_auth.sql b/sql/updates/auth/master/2022_08_19_01_auth.sql new file mode 100644 index 00000000000..a274ed2be36 --- /dev/null +++ b/sql/updates/auth/master/2022_08_19_01_auth.sql @@ -0,0 +1,3 @@ +-- TDB 927.22081 auth +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED'); -- cgit v1.2.3