TDB 335.24111 - 2024/11/22TDB335.24111

4 files changed, 1 insertions, 66 deletions

diff --git a/sql/updates/auth/3.3.5/2024_08_28_01_auth.sql b/sql/updates/auth/3.3.5/2024_08_28_01_auth.sql
deleted file mode 100644
index 7e547d9cc4a..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2024_08_30_00_auth.sql b/sql/updates/auth/3.3.5/2024_08_30_00_auth.sql
deleted file mode 100644
index 2b36c28a3cf..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2024_09_26_00_auth.sql b/sql/updates/auth/3.3.5/2024_09_26_00_auth.sql
deleted file mode 100644
index a5c75e51c38..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2024_08_17_00_auth.sql b/sql/updates/auth/3.3.5/2024_11_22_00_auth.sql
index 3f3bd0e6e07..75986885739 100644
--- a/sql/updates/auth/3.3.5/2024_08_17_00_auth.sql
+++ b/sql/updates/auth/3.3.5/2024_11_22_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 335.24081 auth
+-- TDB 335.24111 auth
 UPDATE `updates` SET `state`='ARCHIVED';