TDB 1007.23041 - 2023/04/02TDB1007.23041

11 files changed, 1 insertions, 71 deletions

diff --git a/sql/updates/auth/master/2023_02_07_00_auth.sql b/sql/updates/auth/master/2023_02_07_00_auth.sql
deleted file mode 100644
index 20f7b37a77a..00000000000
--- a/sql/updates/auth/master/2023_02_07_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=47967;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(47967,10,0,5,NULL,NULL,'CFE225D0089E224D9E7541D3B5C26478',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=47967 WHERE `gamebuild`=47936;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '47967';
diff --git a/sql/updates/auth/master/2023_02_09_00_auth.sql b/sql/updates/auth/master/2023_02_09_00_auth.sql
deleted file mode 100644
index 662d52994f9..00000000000
--- a/sql/updates/auth/master/2023_02_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48001;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48001,10,0,5,NULL,NULL,'4B0260A37BD95B615E71048469E6D5BB',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48001 WHERE `gamebuild`=47967;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48001';
diff --git a/sql/updates/auth/master/2023_02_14_00_auth.sql b/sql/updates/auth/master/2023_02_14_00_auth.sql
deleted file mode 100644
index 1f3790c5ed2..00000000000
--- a/sql/updates/auth/master/2023_02_14_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48069;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48069,10,0,5,NULL,NULL,'558CDF958FA082E95849779C7C6945E5',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48069 WHERE `gamebuild`=48001;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48069';
diff --git a/sql/updates/auth/master/2023_02_28_00_auth.sql b/sql/updates/auth/master/2023_02_28_00_auth.sql
deleted file mode 100644
index 9532089409e..00000000000
--- a/sql/updates/auth/master/2023_02_28_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48317;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48317,10,0,5,NULL,NULL,'C096E37B45B43244E9C79916604DD4AF',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48317 WHERE `gamebuild`=48069;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48317';
diff --git a/sql/updates/auth/master/2023_03_08_00_auth.sql b/sql/updates/auth/master/2023_03_08_00_auth.sql
deleted file mode 100644
index ead0db461d7..00000000000
--- a/sql/updates/auth/master/2023_03_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48397;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48397,10,0,5,NULL,NULL,'64BA8779EAA97E6C57982B6B1A5B32E7',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48397 WHERE `gamebuild`=48317;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48397';
diff --git a/sql/updates/auth/master/2023_03_11_00_auth.sql b/sql/updates/auth/master/2023_03_11_00_auth.sql
deleted file mode 100644
index 7fcacc3a624..00000000000
--- a/sql/updates/auth/master/2023_03_11_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48526;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48526,10,0,5,NULL,NULL,'D5B7D3303A2A741E6913EE1AEB0BCB65',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48526 WHERE `gamebuild`=48397;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48526';
diff --git a/sql/updates/auth/master/2023_03_22_00_auth.sql b/sql/updates/auth/master/2023_03_22_00_auth.sql
deleted file mode 100644
index 46edc6b85f7..00000000000
--- a/sql/updates/auth/master/2023_03_22_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48676;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48676,10,0,7,NULL,NULL,'E059FB74DFF6438CC20C7F28900F64CA',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48676 WHERE `gamebuild`=48526;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48676';
diff --git a/sql/updates/auth/master/2023_03_27_00_auth.sql b/sql/updates/auth/master/2023_03_27_00_auth.sql
deleted file mode 100644
index b99fc3ba934..00000000000
--- a/sql/updates/auth/master/2023_03_27_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48749;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48749,10,0,7,NULL,NULL,'92DBCCA0E33DFB8A17A2B6A39246B288',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48749 WHERE `gamebuild`=48676;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48749';
diff --git a/sql/updates/auth/master/2023_03_31_00_auth.sql b/sql/updates/auth/master/2023_03_31_00_auth.sql
deleted file mode 100644
index 90be152981e..00000000000
--- a/sql/updates/auth/master/2023_03_31_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48838;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48838,10,0,7,NULL,NULL,'9E6F4E1E46EF228D2DE90F7BC48AAA96',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48838 WHERE `gamebuild`=48749;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48838';
diff --git a/sql/updates/auth/master/2023_03_31_01_auth.sql b/sql/updates/auth/master/2023_03_31_01_auth.sql
deleted file mode 100644
index 51ecd118aae..00000000000
--- a/sql/updates/auth/master/2023_03_31_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=48865;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(48865,10,0,7,NULL,NULL,'4B774ABE7B34D6702571B4279A4B6A13',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=48865 WHERE `gamebuild`=48838;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '48865';
diff --git a/sql/updates/auth/master/2023_02_03_00_auth.sql b/sql/updates/auth/master/2023_04_02_00_auth.sql
index be4f170bd17..80ea98771a4 100644
--- a/sql/updates/auth/master/2023_02_03_00_auth.sql
+++ b/sql/updates/auth/master/2023_04_02_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1005.23021 auth
+-- TDB 1007.23041 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');