TDB 343.23121 - 2023/12/20TDB343.23121

11 files changed, 2 insertions, 64 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_21_00_auth.sql b/sql/updates/auth/master/2023_11_21_00_auth.sql
deleted file mode 100644
index 1dc190782d7..00000000000
--- a/sql/updates/auth/master/2023_11_21_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `account` ADD `timezone_offset` smallint NOT NULL DEFAULT '0' AFTER `os`;
diff --git a/sql/updates/auth/master/2023_11_24_00_auth.sql b/sql/updates/auth/master/2023_11_24_00_auth.sql
deleted file mode 100644
index 24ceeb979c7..00000000000
--- a/sql/updates/auth/master/2023_11_24_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- drop .reload waypoint_scripts
-DELETE FROM `rbac_permissions` WHERE `id`=706;
-DELETE FROM `rbac_linked_permissions` WHERE `id`=706 OR `linkedId`=706;
-DELETE FROM `rbac_account_permissions` WHERE `permissionId`=706;
-DELETE FROM `rbac_default_permissions` WHERE `permissionId`=706;
diff --git a/sql/updates/auth/wotlk_classic/2023_11_15_00_auth.sql b/sql/updates/auth/wotlk_classic/2023_11_15_00_auth.sql
deleted file mode 100644
index 3cbe2e9f89c..00000000000
--- a/sql/updates/auth/wotlk_classic/2023_11_15_00_auth.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-DELETE FROM `build_info` WHERE `build`= 51943;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(51943,3,4,3,NULL,NULL,'926D8C2514A3FEBA84F0DEB031AE41CE',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=51943;
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '51943';
diff --git a/sql/updates/auth/wotlk_classic/2023_11_23_00_auth.sql b/sql/updates/auth/wotlk_classic/2023_11_23_00_auth.sql
deleted file mode 100644
index cce0096b20c..00000000000
--- a/sql/updates/auth/wotlk_classic/2023_11_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52237;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52237,3,4,3,NULL,NULL,'3BA993D54FD86EE03E6F81C8FBCE26B7',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52237 WHERE `gamebuild`=51943;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52237';
diff --git a/sql/updates/auth/master/2023_10_06_00_auth.sql b/sql/updates/auth/wotlk_classic/2023_12_20_00_auth.sql
index 1f1bdec7024..6f547c8feb8 100644
--- a/sql/updates/auth/master/2023_10_06_00_auth.sql
+++ b/sql/updates/auth/wotlk_classic/2023_12_20_00_auth.sql
@@ -1,3 +1,4 @@
--- TDB 1017.23101 auth
+-- TDB 343.23121 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/3.4.x/auth', 'ARCHIVED');