TDB 1015.23071 - 2023/07/14TDB1015.23071

17 files changed, 1 insertions, 115 deletions

diff --git a/sql/updates/auth/master/2023_04_05_00_auth.sql b/sql/updates/auth/master/2023_04_05_00_auth.sql
deleted file mode 100644
index b97bfd62eaa..00000000000
--- a/sql/updates/auth/master/2023_04_05_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48892;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48892,10,0,7,NULL,NULL,'AA31BF27458321B03A1A346964DD7B9D',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48892 WHERE `gamebuild`=48865;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48892';
diff --git a/sql/updates/auth/master/2023_04_06_00_auth.sql b/sql/updates/auth/master/2023_04_06_00_auth.sql
deleted file mode 100644
index 54deaa8050e..00000000000
--- a/sql/updates/auth/master/2023_04_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48966;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48966,10,0,7,NULL,NULL,'823142CA131FBB715FF55D4343E55C6D',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48966 WHERE `gamebuild`=48892;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48966';
diff --git a/sql/updates/auth/master/2023_04_12_00_auth.sql b/sql/updates/auth/master/2023_04_12_00_auth.sql
deleted file mode 100644
index e3a8a7ef9d4..00000000000
--- a/sql/updates/auth/master/2023_04_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48999;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48999,10,0,7,NULL,NULL,'79BA6FF0F9672EEF875F64155C8B62D4',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48999 WHERE `gamebuild`=48966;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48999';
diff --git a/sql/updates/auth/master/2023_04_25_00_auth.sql b/sql/updates/auth/master/2023_04_25_00_auth.sql
deleted file mode 100644
index ac8dc2c5616..00000000000
--- a/sql/updates/auth/master/2023_04_25_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49267;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49267,10,0,7,NULL,NULL,'EEE77EA5A216E0731ADBB41AEFB1DF31',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49267 WHERE `gamebuild`=48999;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49267';
diff --git a/sql/updates/auth/master/2023_04_28_00_auth.sql b/sql/updates/auth/master/2023_04_28_00_auth.sql
deleted file mode 100644
index dffe0fd39ec..00000000000
--- a/sql/updates/auth/master/2023_04_28_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49343;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49343 WHERE `gamebuild` IN(49267, 48999);
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49343';
diff --git a/sql/updates/auth/master/2023_05_04_00_auth.sql b/sql/updates/auth/master/2023_05_04_00_auth.sql
deleted file mode 100644
index c081beddc8c..00000000000
--- a/sql/updates/auth/master/2023_05_04_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (49318,49407,49426);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL),
-(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL),
-(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49426 WHERE `gamebuild`=49343;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49426';
diff --git a/sql/updates/auth/master/2023_05_05_00_auth.sql b/sql/updates/auth/master/2023_05_05_00_auth.sql
deleted file mode 100644
index ce6dfa8cd24..00000000000
--- a/sql/updates/auth/master/2023_05_05_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49444;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49444,10,1,0,NULL,NULL,'363B2B05285BDD8857419D2866316D3C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49444 WHERE `gamebuild`=49426;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49444';
diff --git a/sql/updates/auth/master/2023_05_09_00_auth.sql b/sql/updates/auth/master/2023_05_09_00_auth.sql
deleted file mode 100644
index 554479d53c0..00000000000
--- a/sql/updates/auth/master/2023_05_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49474;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49474,10,1,0,NULL,NULL,'44A7D2B352EE3D098A3CB4C2F1065E37',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49474 WHERE `gamebuild`=49444;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49474';
diff --git a/sql/updates/auth/master/2023_05_15_00_auth.sql b/sql/updates/auth/master/2023_05_15_00_auth.sql
deleted file mode 100644
index 2074cea990c..00000000000
--- a/sql/updates/auth/master/2023_05_15_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49570;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49570,10,1,0,NULL,NULL,'B024DE67ACAEB9E8EE6DB38DC53E8281',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49570 WHERE `gamebuild`=49474;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49570';
diff --git a/sql/updates/auth/master/2023_05_23_00_auth.sql b/sql/updates/auth/master/2023_05_23_00_auth.sql
deleted file mode 100644
index 5ac0d9c00d7..00000000000
--- a/sql/updates/auth/master/2023_05_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49679;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49679,10,1,0,NULL,NULL,'9CE59B68D8797EBF00581F41138F4316',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49679 WHERE `gamebuild`=49570;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49679';
diff --git a/sql/updates/auth/master/2023_05_25_00_auth.sql b/sql/updates/auth/master/2023_05_25_00_auth.sql
deleted file mode 100644
index 99c138d9bc2..00000000000
--- a/sql/updates/auth/master/2023_05_25_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49741;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49741,10,1,0,NULL,NULL,'0EF181E2BB0E946CF3B7422ADEB6CD1A',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49741 WHERE `gamebuild`=49679;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49741';
diff --git a/sql/updates/auth/master/2023_05_27_00_auth.sql b/sql/updates/auth/master/2023_05_27_00_auth.sql
deleted file mode 100644
index 04e79d1f55e..00000000000
--- a/sql/updates/auth/master/2023_05_27_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49801;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49801,10,1,0,NULL,NULL,'0832179567B66CA85DBD5678B604C683',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49801 WHERE `gamebuild`=49741;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49801';
diff --git a/sql/updates/auth/master/2023_06_06_00_auth.sql b/sql/updates/auth/master/2023_06_06_00_auth.sql
deleted file mode 100644
index ae4b26ad79a..00000000000
--- a/sql/updates/auth/master/2023_06_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=49890;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(49890,10,1,0,NULL,NULL,'22A5B8A1EB797A64995F705B3DBCB14C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=49890 WHERE `gamebuild`=49801;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49890';
diff --git a/sql/updates/auth/master/2023_06_12_00_auth.sql b/sql/updates/auth/master/2023_06_12_00_auth.sql
deleted file mode 100644
index 4e0d6dd0619..00000000000
--- a/sql/updates/auth/master/2023_06_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50000;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50000,10,1,0,NULL,NULL,'02F06FFA2296FD66384295DBFD5A4C91',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50000 WHERE `gamebuild`=49890;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50000';
diff --git a/sql/updates/auth/master/2023_07_12_00_auth.sql b/sql/updates/auth/master/2023_07_12_00_auth.sql
deleted file mode 100644
index a962847b081..00000000000
--- a/sql/updates/auth/master/2023_07_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50401;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50401,10,1,5,NULL,NULL,'3EEF52D902CCE81D16D0E255F0AA4938',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50401 WHERE `gamebuild`=50000;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50401';
diff --git a/sql/updates/auth/master/2023_07_13_00_auth.sql b/sql/updates/auth/master/2023_07_13_00_auth.sql
deleted file mode 100644
index 7c414422b9c..00000000000
--- a/sql/updates/auth/master/2023_07_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50438;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50438 WHERE `gamebuild`=50401;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50438';
diff --git a/sql/updates/auth/master/2023_04_02_00_auth.sql b/sql/updates/auth/master/2023_07_14_00_auth.sql
index 80ea98771a4..2faf120d26a 100644
--- a/sql/updates/auth/master/2023_04_02_00_auth.sql
+++ b/sql/updates/auth/master/2023_07_14_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1007.23041 auth
+-- TDB 1015.23071 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');