TDB 1025.24021 - 2024/02/08TDB1025.24021

19 files changed, 1 insertions, 115 deletions

diff --git a/sql/updates/auth/master/2023_11_16_00_auth.sql b/sql/updates/auth/master/2023_11_16_00_auth.sql
deleted file mode 100644
index 7e3c0dbd361..00000000000
--- a/sql/updates/auth/master/2023_11_16_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52188;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52188,10,2,0,NULL,NULL,'977DF9993E94855DED5E328BA7A2F21F',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52188 WHERE `gamebuild`=52148;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52188';
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/master/2023_11_30_00_auth.sql b/sql/updates/auth/master/2023_11_30_00_auth.sql
deleted file mode 100644
index c7741b60847..00000000000
--- a/sql/updates/auth/master/2023_11_30_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52301;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52301,10,2,0,NULL,NULL,'821AA3BB237B400B82F44970250539AA',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52301 WHERE `gamebuild`=52188;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52301';
diff --git a/sql/updates/auth/master/2023_12_05_00_auth.sql b/sql/updates/auth/master/2023_12_05_00_auth.sql
deleted file mode 100644
index a00863dd431..00000000000
--- a/sql/updates/auth/master/2023_12_05_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52393;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52393,10,2,0,NULL,NULL,'B013ED23B7EF51B29A45594D9BBB0D03',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52393 WHERE `gamebuild`=52301;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52393';
diff --git a/sql/updates/auth/master/2023_12_12_00_auth.sql b/sql/updates/auth/master/2023_12_12_00_auth.sql
deleted file mode 100644
index 14f952e17f6..00000000000
--- a/sql/updates/auth/master/2023_12_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52485;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52485,10,2,0,NULL,NULL,'5805CEB4650730AE489258DD30E34441',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52485 WHERE `gamebuild`=52393;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52485';
diff --git a/sql/updates/auth/master/2023_12_13_00_auth.sql b/sql/updates/auth/master/2023_12_13_00_auth.sql
deleted file mode 100644
index 51dd09a92bb..00000000000
--- a/sql/updates/auth/master/2023_12_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52545;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52545,10,2,0,NULL,NULL,'FB52179A8355A46EDBFBDC8E8E5CDAFD',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52545 WHERE `gamebuild`=52485;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52545';
diff --git a/sql/updates/auth/master/2023_12_19_00_auth.sql b/sql/updates/auth/master/2023_12_19_00_auth.sql
deleted file mode 100644
index fa5299b7558..00000000000
--- a/sql/updates/auth/master/2023_12_19_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52607;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52607,10,2,0,NULL,NULL,'8F002E4AADCAEABB08ABC2880B31AD60',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52607 WHERE `gamebuild` IN(52545, 52485);
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52607';
diff --git a/sql/updates/auth/master/2023_12_21_00_auth.sql b/sql/updates/auth/master/2023_12_21_00_auth.sql
deleted file mode 100644
index 3d0a62820d5..00000000000
--- a/sql/updates/auth/master/2023_12_21_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52649;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52649,10,2,0,NULL,NULL,'D0B779FBECEBC1ED5A85D83F03C8A75B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52649 WHERE `gamebuild`=52607;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52649';
diff --git a/sql/updates/auth/master/2023_12_24_00_auth.sql b/sql/updates/auth/master/2023_12_24_00_auth.sql
deleted file mode 100644
index 6242c21a362..00000000000
--- a/sql/updates/auth/master/2023_12_24_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` IN (795, 796);
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(795,'Command: instance setbossstate'),
-(796,'Command: instance getbossstate');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id`= 192 AND `linkedId` IN (795, 796);
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(192,795),
-(192,796);
diff --git a/sql/updates/auth/master/2023_12_26_00_auth.sql b/sql/updates/auth/master/2023_12_26_00_auth.sql
deleted file mode 100644
index 3c27a8c7ac5..00000000000
--- a/sql/updates/auth/master/2023_12_26_00_auth.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `battlenet_accounts`
-  ADD `srp_version` tinyint(3) NOT NULL DEFAULT '1' AFTER `email`,
-  ADD `salt` binary(32) AFTER `srp_version`,
-  ADD `verifier` blob AFTER `salt`;
diff --git a/sql/updates/auth/master/2024_01_05_00_auth.sql b/sql/updates/auth/master/2024_01_05_00_auth.sql
deleted file mode 100644
index 894218f657c..00000000000
--- a/sql/updates/auth/master/2024_01_05_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `rbac_permissions` SET `name` = 'Command: reload waypoint_path' WHERE `id` = 707;
diff --git a/sql/updates/auth/master/2024_01_10_00_auth.sql b/sql/updates/auth/master/2024_01_10_00_auth.sql
deleted file mode 100644
index 023d30c2395..00000000000
--- a/sql/updates/auth/master/2024_01_10_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=52808;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52808,10,2,0,NULL,NULL,'6276712B6C8AEA21CD5D94D52FEE70EE',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=52808 WHERE `gamebuild`=52649;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '52808';
diff --git a/sql/updates/auth/master/2024_01_21_00_auth.sql b/sql/updates/auth/master/2024_01_21_00_auth.sql
deleted file mode 100644
index d1f5781cd5f..00000000000
--- a/sql/updates/auth/master/2024_01_21_00_auth.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (52902,52968,52983,53007);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(52902,10,2,5,NULL,NULL,'D4F0A24CDF165628538C1C387A326AF3',NULL,NULL,NULL),
-(52968,10,2,5,NULL,NULL,'2D247FD440C44D4F1BF80B075B8720F2',NULL,NULL,NULL),
-(52983,10,2,5,NULL,NULL,'B1E5ADA5FDD06C9AB5E5D8A6983324AC',NULL,NULL,NULL),
-(53007,10,2,5,NULL,NULL,'A21AFB4D381C56AF471D994258C0EEF5',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=53007 WHERE `gamebuild`=52808;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53007';
diff --git a/sql/updates/auth/master/2024_01_23_00_auth.sql b/sql/updates/auth/master/2024_01_23_00_auth.sql
deleted file mode 100644
index 8f36d8cea86..00000000000
--- a/sql/updates/auth/master/2024_01_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=53040;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(53040,10,2,5,NULL,NULL,'2F1283BF7B7F307B70DBBD75CC42D7C3',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=53040 WHERE `gamebuild`=53007;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53040';
diff --git a/sql/updates/auth/master/2024_01_31_00_auth.sql b/sql/updates/auth/master/2024_01_31_00_auth.sql
deleted file mode 100644
index ca927f92fdb..00000000000
--- a/sql/updates/auth/master/2024_01_31_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=53104;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(53104,10,2,5,NULL,NULL,'DBD79EC8DF044B53C78931B985CAB406',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=53104 WHERE `gamebuild`=53040;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53104';
diff --git a/sql/updates/auth/master/2024_02_01_00_auth.sql b/sql/updates/auth/master/2024_02_01_00_auth.sql
deleted file mode 100644
index e90e5a0e27d..00000000000
--- a/sql/updates/auth/master/2024_02_01_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=53162;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(53162,10,2,5,NULL,NULL,'8A67511FBF8984EEE2B630F7CB23376A',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=53162 WHERE `gamebuild`=53104;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53162';
diff --git a/sql/updates/auth/master/2024_02_07_00_auth.sql b/sql/updates/auth/master/2024_02_07_00_auth.sql
deleted file mode 100644
index ee783d6da81..00000000000
--- a/sql/updates/auth/master/2024_02_07_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=53212;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(53212,10,2,5,NULL,NULL,'08761EFF2F9B639364B9A9FBFFFFB949',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=53212 WHERE `gamebuild`=53162;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '53212';
diff --git a/sql/updates/auth/master/2023_11_15_01_auth.sql b/sql/updates/auth/master/2024_02_08_00_auth.sql
index e3304836cd2..faeb8fc07e4 100644
--- a/sql/updates/auth/master/2023_11_15_01_auth.sql
+++ b/sql/updates/auth/master/2024_02_08_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 1020.23111 auth
+-- TDB 1025.24021 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');