TDB 440.24101 - 2024/10/27TDB440.24101

18 files changed, 1 insertions, 188 deletions

diff --git a/sql/updates/auth/cata_classic/2024_06_05_00_auth.sql b/sql/updates/auth/cata_classic/2024_06_05_00_auth.sql
deleted file mode 100644
index 1d026aca147..00000000000
--- a/sql/updates/auth/cata_classic/2024_06_05_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55006;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55006,4,4,0,NULL,NULL,'D13B75D1E7848DFBB61AB5D9FEE51B49',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55006 WHERE `gamebuild`=54901;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55006';
diff --git a/sql/updates/auth/cata_classic/2024_06_13_00_auth.sql b/sql/updates/auth/cata_classic/2024_06_13_00_auth.sql
deleted file mode 100644
index 20cd6b31fcd..00000000000
--- a/sql/updates/auth/cata_classic/2024_06_13_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55056;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55056,4,4,0,NULL,NULL,'209BEEBBBFE6AA3AE491D9D1F1A7C98A',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55056 WHERE `gamebuild`=55006;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55056';
diff --git a/sql/updates/auth/cata_classic/2024_06_17_00_auth.sql b/sql/updates/auth/cata_classic/2024_06_17_00_auth.sql
deleted file mode 100644
index 6a26ef65b6d..00000000000
--- a/sql/updates/auth/cata_classic/2024_06_17_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55141;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55141,4,4,0,NULL,NULL,'102810005F13A3440705DE344DF5633F',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55141 WHERE `gamebuild`=55056;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55141';
diff --git a/sql/updates/auth/cata_classic/2024_06_27_00_auth.sql b/sql/updates/auth/cata_classic/2024_06_27_00_auth.sql
deleted file mode 100644
index 13b2a5fb3b5..00000000000
--- a/sql/updates/auth/cata_classic/2024_06_27_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55262;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55262,4,4,0,NULL,NULL,'EB4B58AF1B3B79DDD9E2477BA1375D42',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55262 WHERE `gamebuild`=55141;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55262';
diff --git a/sql/updates/auth/cata_classic/2024_07_09_00_auth.sql b/sql/updates/auth/cata_classic/2024_07_09_00_auth.sql
deleted file mode 100644
index 330832c7fbb..00000000000
--- a/sql/updates/auth/cata_classic/2024_07_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55460;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55460,4,4,0,NULL,NULL,'E5455F750394046CC9BD2ED0397F7418',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55460 WHERE `gamebuild`=55262;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55460';
diff --git a/sql/updates/auth/cata_classic/2024_07_14_00_auth.sql b/sql/updates/auth/cata_classic/2024_07_14_00_auth.sql
deleted file mode 100644
index 5acad50b2e4..00000000000
--- a/sql/updates/auth/cata_classic/2024_07_14_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55613;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55613,4,4,0,NULL,NULL,'0BA3BFF2E324FE30D15BA8A88CF8738B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55613 WHERE `gamebuild`=55460;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55613';
diff --git a/sql/updates/auth/cata_classic/2024_07_18_00_auth.sql b/sql/updates/auth/cata_classic/2024_07_18_00_auth.sql
deleted file mode 100644
index 2fd14bc281e..00000000000
--- a/sql/updates/auth/cata_classic/2024_07_18_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=55639;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(55639,4,4,0,NULL,NULL,'FFD74533A9D95E1D38C972BA4F351B8D',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=55639 WHERE `gamebuild`=55613;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '55639';
diff --git a/sql/updates/auth/cata_classic/2024_08_09_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_09_00_auth.sql
deleted file mode 100644
index 6a496115e8e..00000000000
--- a/sql/updates/auth/cata_classic/2024_08_09_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=56014;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(56014,4,4,0,NULL,NULL,'89AD7A75E156374D41F0CC70455B2F6B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=56014 WHERE `gamebuild`=55639;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` INT UNSIGNED NOT NULL DEFAULT '56014';
diff --git a/sql/updates/auth/cata_classic/2024_08_18_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_18_00_auth.sql
deleted file mode 100644
index 641e0d3d181..00000000000
--- a/sql/updates/auth/cata_classic/2024_08_18_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `account` ADD `client_build` int unsigned NOT NULL DEFAULT '0' AFTER `muteby`;
diff --git a/sql/updates/auth/cata_classic/2024_08_28_01_auth.sql b/sql/updates/auth/cata_classic/2024_08_28_01_auth.sql
deleted file mode 100644
index 7e547d9cc4a..00000000000
--- a/sql/updates/auth/cata_classic/2024_08_28_01_auth.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-ALTER TABLE `build_info` ADD `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `mac64AuthSeed`;
-
-UPDATE `build_info` SET `macArmAuthSeed`='778F6A5DF79A4EF1B86F651F3B303CE7' WHERE `build`=56196;
-UPDATE `build_info` SET `macArmAuthSeed`='41710C793EF021721F14B06EC1896D3F' WHERE `build`=56288;
-UPDATE `build_info` SET `macArmAuthSeed`='412D3200715AAFDC0522DF031A941F0E' WHERE `build`=56311;
-UPDATE `build_info` SET `macArmAuthSeed`='A83ED19EE659BC95CC322D1E49BDEDBB' WHERE `build`=56313;
diff --git a/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql
deleted file mode 100644
index 2b36c28a3cf..00000000000
--- a/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql
+++ /dev/null
@@ -1,39 +0,0 @@
---
--- Table structure for table `build_auth_key`
---
-DROP TABLE IF EXISTS `build_auth_key`;
-CREATE TABLE `build_auth_key` (
-  `build` int NOT NULL,
-  `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `arch` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `type` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `key` binary(16) NOT NULL,
-  PRIMARY KEY (`build`,`platform`,`arch`,`type`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-
---
--- Table structure for table `build_executable_hash`
---
-DROP TABLE IF EXISTS `build_executable_hash`;
-CREATE TABLE `build_executable_hash` (
-  `build` int NOT NULL,
-  `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
-  `executableHash` binary(20) NOT NULL,
-  PRIMARY KEY (`build`,`platform`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-
-INSERT INTO `build_auth_key` SELECT `build`,'Win','x86','WoW',UNHEX(`winAuthSeed`) FROM `build_info` WHERE LENGTH(`winAuthSeed`)=32;
-INSERT INTO `build_auth_key` SELECT `build`,'Win','x64','WoW',UNHEX(`win64AuthSeed`) FROM `build_info` WHERE LENGTH(`win64AuthSeed`)=32;
-INSERT INTO `build_auth_key` SELECT `build`,'Mac','x64','WoW',UNHEX(`mac64AuthSeed`) FROM `build_info` WHERE LENGTH(`mac64AuthSeed`)=32;
-INSERT INTO `build_auth_key` SELECT `build`,'Mac','A64','WoW',UNHEX(`macArmAuthSeed`) FROM `build_info` WHERE LENGTH(`macArmAuthSeed`)=32;
-
-INSERT INTO `build_executable_hash` SELECT `build`,'Win',UNHEX(`winChecksumSeed`) FROM `build_info` WHERE LENGTH(`winChecksumSeed`)=40;
-INSERT INTO `build_executable_hash` SELECT `build`,'OSX',UNHEX(`macChecksumSeed`) FROM `build_info` WHERE LENGTH(`macChecksumSeed`)=40;
-
-ALTER TABLE `build_info`
-  DROP `winAuthSeed`,
-  DROP `win64AuthSeed`,
-  DROP `mac64AuthSeed`,
-  DROP `macArmAuthSeed`,
-  DROP `winChecksumSeed`,
-  DROP `macChecksumSeed`;
diff --git a/sql/updates/auth/cata_classic/2024_09_04_00_auth.sql b/sql/updates/auth/cata_classic/2024_09_04_00_auth.sql
deleted file mode 100644
index 8cb9b95a1bf..00000000000
--- a/sql/updates/auth/cata_classic/2024_09_04_00_auth.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56420);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56420,4,4,0,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56420 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56420,'Win','x64','WoW',0xA8E98C37F813D988C81256424A024AB0);
-
-UPDATE `realmlist` SET `gamebuild`=56420 WHERE `gamebuild`=56014;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56420';
diff --git a/sql/updates/auth/cata_classic/2024_09_17_00_auth.sql b/sql/updates/auth/cata_classic/2024_09_17_00_auth.sql
deleted file mode 100644
index d72117fae16..00000000000
--- a/sql/updates/auth/cata_classic/2024_09_17_00_auth.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56489);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56489,4,4,0,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56489 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56489,'Win','x64','WoW',0xA3FC116BB68FA279DBB66B4024305D99);
-
-UPDATE `realmlist` SET `gamebuild`=56489 WHERE `gamebuild`=56420;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56489';
diff --git a/sql/updates/auth/cata_classic/2024_09_17_01_auth.sql b/sql/updates/auth/cata_classic/2024_09_17_01_auth.sql
deleted file mode 100644
index 1b0251e0f86..00000000000
--- a/sql/updates/auth/cata_classic/2024_09_17_01_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-DELETE FROM `build_auth_key` WHERE `build`=56489 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56489 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56489 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56489 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56489,'Mac','A64','WoW',0x6A8C974BCAF78D6E2032E3B5776D89FA),
-(56489,'Mac','x64','WoW',0x482A7A1DCE05F878626F1B1D52BFA80B),
-(56489,'Win','A64','WoW',0xC0FA9CBF98C21ED7F062AB8ED5A34B50),
-(56489,'Win','x64','WoW',0xA3FC116BB68FA279DBB66B4024305D99);
diff --git a/sql/updates/auth/cata_classic/2024_09_24_00_auth.sql b/sql/updates/auth/cata_classic/2024_09_24_00_auth.sql
deleted file mode 100644
index 4325e0a64ab..00000000000
--- a/sql/updates/auth/cata_classic/2024_09_24_00_auth.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (56713);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(56713,4,4,0,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=56713 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56713 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56713 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=56713 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(56713,'Mac','A64','WoW',0x52EA30F5FC879526462F8FB65B9797AC),
-(56713,'Mac','x64','WoW',0x0DFE481E53DF3B21DF98B8598E0CA674),
-(56713,'Win','A64','WoW',0x7CD3F3C05BAA6B377202616A1D2C2504),
-(56713,'Win','x64','WoW',0x63D7153C3703C7E7FAB7C92F1BA7822C);
-
-UPDATE `realmlist` SET `gamebuild`=56713 WHERE `gamebuild`=56489;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56713';
diff --git a/sql/updates/auth/cata_classic/2024_09_26_00_auth.sql b/sql/updates/auth/cata_classic/2024_09_26_00_auth.sql
deleted file mode 100644
index a5c75e51c38..00000000000
--- a/sql/updates/auth/cata_classic/2024_09_26_00_auth.sql
+++ /dev/null
@@ -1,20 +0,0 @@
-
-ALTER TABLE `realmlist` MODIFY `population` float NOT NULL DEFAULT '0';
-
-SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; -- views do not have explicit charset/collation options but record whatever the connection settings were as their own (visible in mysqldump)
-
-DROP VIEW IF EXISTS `vw_log_history`;
-DROP VIEW IF EXISTS `vw_rbac`;
-
-CREATE SQL SECURITY INVOKER VIEW `vw_log_history` AS (SELECT FROM_UNIXTIME(MIN(`logs`.`time`)) AS `First Logged` ,FROM_UNIXTIME(MAX(`logs`.`time`)) AS `Last Logged` ,COUNT(*) AS `Occurrences` ,`realmlist`.`name` AS `Realm` ,`logs`.`type` ,`logs`.`level` ,`logs`.`string` FROM `logs` LEFT JOIN realmlist ON `logs`.`realm` = `realmlist`.`id` GROUP BY `logs`.`string`, `logs`.`type`, `logs`.`realm`);
-
-CREATE SQL SECURITY INVOKER VIEW `vw_rbac` AS
-(
-    SELECT `t1`.`linkedId` AS `Permission ID`,
-           `t1`.`id` AS `Permission Group`,
-           IFNULL(`t2`.`secId`, 'linked') AS `Security Level`,
-       `t3`.`name` AS `Permission`
-    FROM `rbac_linked_permissions` `t1`
-    LEFT JOIN `rbac_default_permissions` `t2` ON `t1`.`id` = `t2`.`permissionId`
-    LEFT JOIN `rbac_permissions` `t3` ON `t1`.`linkedId` = `t3`.`id`
-);
diff --git a/sql/updates/auth/cata_classic/2024_10_24_00_auth.sql b/sql/updates/auth/cata_classic/2024_10_24_00_auth.sql
deleted file mode 100644
index 9f01d9192bb..00000000000
--- a/sql/updates/auth/cata_classic/2024_10_24_00_auth.sql
+++ /dev/null
@@ -1,17 +0,0 @@
-DELETE FROM `build_info` WHERE `build` IN (57244);
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
-(57244,4,4,0,NULL);
-
-DELETE FROM `build_auth_key` WHERE `build`=57244 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57244 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57244 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW';
-DELETE FROM `build_auth_key` WHERE `build`=57244 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
-INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
-(57244,'Mac','A64','WoW',0x4DC6904ECDDB8D45209C9A1A1EAFDF34),
-(57244,'Mac','x64','WoW',0x0D662EAB1F2F0EC74F6D11F167F378B6),
-(57244,'Win','A64','WoW',0x9A849BAEEC89BDBF3ADE5FEDDBB27A74),
-(57244,'Win','x64','WoW',0xF972E54BD89E8AD83420C6E3DEFA267F);
-
-UPDATE `realmlist` SET `gamebuild`=57244 WHERE `gamebuild`=56713;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '57244';
diff --git a/sql/updates/auth/cata_classic/2024_06_02_00_auth.sql b/sql/updates/auth/cata_classic/2024_10_27_00_auth.sql
index 4ab884a0eed..c93322e9d13 100644
--- a/sql/updates/auth/cata_classic/2024_06_02_00_auth.sql
+++ b/sql/updates/auth/cata_classic/2024_10_27_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 440.24061 auth
+-- TDB 440.24101 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/4.4.x/auth', 'ARCHIVED');