aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2023-11-15 01:03:38 +0000
committerTDB Release <tdb-release@build.bot>2023-11-15 01:03:38 +0000
commitac053167430748acd8ba0152eb195584973bf974 (patch)
tree8f0b0524af0d2eb7d54b23dd1c1aff5fe97a9bbb /sql/updates/auth
parenta1b898ce41ab6d24665499c08fe9ec1f27a16878 (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.sql7
-rw-r--r--sql/updates/auth/master/2023_10_25_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2023_11_01_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2023_11_09_00_auth.sql9
-rw-r--r--sql/updates/auth/master/2023_11_09_01_auth.sql7
-rw-r--r--sql/updates/auth/master/2023_11_14_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2023_11_15_00_auth.sql7
-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');