diff options
| author | TDB Release <tdb-release@build.bot> | 2023-11-15 01:03:38 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2023-11-15 01:03:38 +0000 |
| commit | ac053167430748acd8ba0152eb195584973bf974 (patch) | |
| tree | 8f0b0524af0d2eb7d54b23dd1c1aff5fe97a9bbb /sql/updates/auth | |
| parent | a1b898ce41ab6d24665499c08fe9ec1f27a16878 (diff) | |
TDB 1020.23111 - 2023/11/15TDB1020.23111
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2023_10_17_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_10_25_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_01_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_09_00_auth.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_09_01_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_14_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_15_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_11_15_01_auth.sql (renamed from sql/updates/auth/master/2023_10_06_00_auth.sql) | 2 |
8 files changed, 1 insertions, 52 deletions
diff --git a/sql/updates/auth/master/2023_10_17_00_auth.sql b/sql/updates/auth/master/2023_10_17_00_auth.sql deleted file mode 100644 index fab4b5e6fd5..00000000000 --- a/sql/updates/auth/master/2023_10_17_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=51754; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(51754,10,1,7,NULL,NULL,'BED5A861C071AB41FEF6087E0C37BB1A',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=51754 WHERE `gamebuild`=51536; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51754'; diff --git a/sql/updates/auth/master/2023_10_25_00_auth.sql b/sql/updates/auth/master/2023_10_25_00_auth.sql deleted file mode 100644 index 5c959d21545..00000000000 --- a/sql/updates/auth/master/2023_10_25_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=51886; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(51886,10,1,7,NULL,NULL,'09CF8919FD2EABDEAEBC0C810F53B511',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=51886 WHERE `gamebuild`=51754; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51886'; diff --git a/sql/updates/auth/master/2023_11_01_00_auth.sql b/sql/updates/auth/master/2023_11_01_00_auth.sql deleted file mode 100644 index 4d6bf28dade..00000000000 --- a/sql/updates/auth/master/2023_11_01_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=51972; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(51972,10,1,7,NULL,NULL,'444DC7EF3544B6670C18884DADA00428',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=51972 WHERE `gamebuild`=51886; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51972'; diff --git a/sql/updates/auth/master/2023_11_09_00_auth.sql b/sql/updates/auth/master/2023_11_09_00_auth.sql deleted file mode 100644 index ca462a6d2e2..00000000000 --- a/sql/updates/auth/master/2023_11_09_00_auth.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (52038,52068,52095); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(52038,10,2,0,NULL,NULL,'A8EF004ADED8A3AFF5A67D2BB8D95795',NULL,NULL,NULL), -(52068,10,2,0,NULL,NULL,'A44F842BACCC7EE8E2975FAF01F12474',NULL,NULL,NULL), -(52095,10,2,0,NULL,NULL,'BA36382887D16D274EA9149695F0C9C8',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=52095 WHERE `gamebuild`=51972; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52095'; diff --git a/sql/updates/auth/master/2023_11_09_01_auth.sql b/sql/updates/auth/master/2023_11_09_01_auth.sql deleted file mode 100644 index f9dece9af4d..00000000000 --- a/sql/updates/auth/master/2023_11_09_01_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=52106; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(52106,10,2,0,NULL,NULL,'95F43869B7D881212CBC1690B8F393ED',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=52106 WHERE `gamebuild`=52095; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52106'; diff --git a/sql/updates/auth/master/2023_11_14_00_auth.sql b/sql/updates/auth/master/2023_11_14_00_auth.sql deleted file mode 100644 index 3f904970618..00000000000 --- a/sql/updates/auth/master/2023_11_14_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=52129; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(52129,10,2,0,NULL,NULL,'02DD842F2A7162EEB8FD5B9D325606F8',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=52129 WHERE `gamebuild`=52106; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52129'; diff --git a/sql/updates/auth/master/2023_11_15_00_auth.sql b/sql/updates/auth/master/2023_11_15_00_auth.sql deleted file mode 100644 index 2a7db3982e6..00000000000 --- a/sql/updates/auth/master/2023_11_15_00_auth.sql +++ /dev/null @@ -1,7 +0,0 @@ -DELETE FROM `build_info` WHERE `build`=52148; -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES -(52148,10,2,0,NULL,NULL,'8A969717C8CDC6E7FF4C54D5CB00C224',NULL,NULL,NULL); - -UPDATE `realmlist` SET `gamebuild`=52148 WHERE `gamebuild`=52129; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52148'; diff --git a/sql/updates/auth/master/2023_10_06_00_auth.sql b/sql/updates/auth/master/2023_11_15_01_auth.sql index 1f1bdec7024..e3304836cd2 100644 --- a/sql/updates/auth/master/2023_10_06_00_auth.sql +++ b/sql/updates/auth/master/2023_11_15_01_auth.sql @@ -1,3 +1,3 @@ --- TDB 1017.23101 auth +-- TDB 1020.23111 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED'); |
