TDB 1017.23101 - 2023/10/06TDB1017.23101

15 files changed, 1 insertions, 100 deletions

diff --git a/sql/updates/auth/master/2023_07_14_01_auth.sql b/sql/updates/auth/master/2023_07_14_01_auth.sql
deleted file mode 100644
index 8fa030074b1..00000000000
--- a/sql/updates/auth/master/2023_07_14_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50467;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50467 WHERE `gamebuild`=50438;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50467';
diff --git a/sql/updates/auth/master/2023_07_15_00_auth.sql b/sql/updates/auth/master/2023_07_15_00_auth.sql
deleted file mode 100644
index a397732920f..00000000000
--- a/sql/updates/auth/master/2023_07_15_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50469;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50469 WHERE `gamebuild`=50467;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50469';
diff --git a/sql/updates/auth/master/2023_07_19_00_auth.sql b/sql/updates/auth/master/2023_07_19_00_auth.sql
deleted file mode 100644
index 445c720218f..00000000000
--- a/sql/updates/auth/master/2023_07_19_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50504;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50504 WHERE `gamebuild`=50469;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50504';
diff --git a/sql/updates/auth/master/2023_07_22_00_auth.sql b/sql/updates/auth/master/2023_07_22_00_auth.sql
deleted file mode 100644
index cd88b6e3f2a..00000000000
--- a/sql/updates/auth/master/2023_07_22_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50585;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50585 WHERE `gamebuild`=50504;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50585';
diff --git a/sql/updates/auth/master/2023_07_28_00_auth.sql b/sql/updates/auth/master/2023_07_28_00_auth.sql
deleted file mode 100644
index 42680483bbf..00000000000
--- a/sql/updates/auth/master/2023_07_28_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50622;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50622 WHERE `gamebuild`=50585;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50622';
diff --git a/sql/updates/auth/master/2023_08_03_00_auth.sql b/sql/updates/auth/master/2023_08_03_00_auth.sql
deleted file mode 100644
index 5cba6423175..00000000000
--- a/sql/updates/auth/master/2023_08_03_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50747;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50747,10,1,5,NULL,NULL,'2D3C386A9C45C27304ED3A3C6EB3F7C8',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50747 WHERE `gamebuild`=50622;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50747';
diff --git a/sql/updates/auth/master/2023_08_09_00_auth.sql b/sql/updates/auth/master/2023_08_09_00_auth.sql
deleted file mode 100644
index 8c21a9798a7..00000000000
--- a/sql/updates/auth/master/2023_08_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=50791;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(50791,10,1,5,NULL,NULL,'0BE7D0BB07EF37C25CBC682409091EA0',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=50791 WHERE `gamebuild`=50747;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '50791';
diff --git a/sql/updates/auth/master/2023_08_31_00_auth.sql b/sql/updates/auth/master/2023_08_31_00_auth.sql
deleted file mode 100644
index 51d8ca4746b..00000000000
--- a/sql/updates/auth/master/2023_08_31_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51130;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51130,10,1,5,NULL,NULL,'44CD2C91E4F0655DA387483726CE4035',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51130 WHERE `gamebuild`=50791;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51130';
diff --git a/sql/updates/auth/master/2023_09_07_00_auth.sql b/sql/updates/auth/master/2023_09_07_00_auth.sql
deleted file mode 100644
index 508be5a7ec7..00000000000
--- a/sql/updates/auth/master/2023_09_07_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (51187,51237);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL),
-(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51237 WHERE `gamebuild`=51130;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51237';
diff --git a/sql/updates/auth/master/2023_09_08_00_auth.sql b/sql/updates/auth/master/2023_09_08_00_auth.sql
deleted file mode 100644
index 09ee6025dcd..00000000000
--- a/sql/updates/auth/master/2023_09_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51261;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51261,10,1,7,NULL,NULL,'1BEBB57AE450331E9F8C301AA7876FAB',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51261 WHERE `gamebuild`=51237;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51261';
diff --git a/sql/updates/auth/master/2023_09_13_00_auth.sql b/sql/updates/auth/master/2023_09_13_00_auth.sql
deleted file mode 100644
index b23d68373e1..00000000000
--- a/sql/updates/auth/master/2023_09_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51313;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51313,10,1,7,NULL,NULL,'35419ED0AB16735CF720858F45DC300C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51313 WHERE `gamebuild`=51261;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51313';
diff --git a/sql/updates/auth/master/2023_09_20_00_auth.sql b/sql/updates/auth/master/2023_09_20_00_auth.sql
deleted file mode 100644
index 02fdbe473a9..00000000000
--- a/sql/updates/auth/master/2023_09_20_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51421;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51421,10,1,7,NULL,NULL,'45E24D6F3335269787DF2B2063939002',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51421 WHERE `gamebuild`=51313;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51421';
diff --git a/sql/updates/auth/master/2023_09_23_00_auth.sql b/sql/updates/auth/master/2023_09_23_00_auth.sql
deleted file mode 100644
index d86fdb5d8fa..00000000000
--- a/sql/updates/auth/master/2023_09_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51485;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51485,10,1,7,NULL,NULL,'EC549E1D0A5DD85C03E7A9D93B7DC6D1',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51485 WHERE `gamebuild`=51421;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51485';
diff --git a/sql/updates/auth/master/2023_09_28_00_auth.sql b/sql/updates/auth/master/2023_09_28_00_auth.sql
deleted file mode 100644
index d1c9d6c75d0..00000000000
--- a/sql/updates/auth/master/2023_09_28_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=51536;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51536,10,1,7,NULL,NULL,'570EEA10A8EC169C3FF9621D1B635BB4',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51536 WHERE `gamebuild`=51485;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51536';
diff --git a/sql/updates/auth/master/2023_07_14_00_auth.sql b/sql/updates/auth/master/2023_10_06_00_auth.sql
index 2faf120d26a..1f1bdec7024 100644
--- a/sql/updates/auth/master/2023_07_14_00_auth.sql
+++ b/sql/updates/auth/master/2023_10_06_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1015.23071 auth
+-- TDB 1017.23101 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');