TDB 925.22071 - 2022/07/25TDB925.22071

21 files changed, 1 insertions, 132 deletions

diff --git a/sql/updates/auth/master/2021_06_20_00_auth.sql b/sql/updates/auth/master/2021_06_20_00_auth.sql
deleted file mode 100644
index 4b8209a2123..00000000000
--- a/sql/updates/auth/master/2021_06_20_00_auth.sql
+++ /dev/null
@@ -1,13 +0,0 @@
---
-DROP VIEW IF EXISTS `vw_rbac`;
-
-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/master/2022_03_08_00_auth.sql b/sql/updates/auth/master/2022_03_08_00_auth.sql
deleted file mode 100644
index 54849d2f464..00000000000
--- a/sql/updates/auth/master/2022_03_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42614;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42614,9,2,0,NULL,NULL,'772BE726FEEF42124255D2EA7973CA18',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42614 WHERE `gamebuild`=42560;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42614';
diff --git a/sql/updates/auth/master/2022_03_12_00_auth.sql b/sql/updates/auth/master/2022_03_12_00_auth.sql
deleted file mode 100644
index c0e465337ce..00000000000
--- a/sql/updates/auth/master/2022_03_12_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42698;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42698,9,2,0,NULL,NULL,'B4497B1CD11FC974C5FB09548AC27269',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42698 WHERE `gamebuild`=42614;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42698';
diff --git a/sql/updates/auth/master/2022_03_22_00_auth.sql b/sql/updates/auth/master/2022_03_22_00_auth.sql
deleted file mode 100644
index 5870b2bd34f..00000000000
--- a/sql/updates/auth/master/2022_03_22_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42825;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42825,9,2,0,NULL,NULL,'A14DA228C6A6AFF1DDBA51218939E557',NULL,NULL,NULL);
diff --git a/sql/updates/auth/master/2022_03_25_00_auth.sql b/sql/updates/auth/master/2022_03_25_00_auth.sql
deleted file mode 100644
index 04901f48598..00000000000
--- a/sql/updates/auth/master/2022_03_25_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42852;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42852,9,2,0,NULL,NULL,'DE9F9F0C3CC8FD54D3AFF99CEFFCE129',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42852 WHERE `gamebuild`=42698;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42852';
diff --git a/sql/updates/auth/master/2022_03_30_00_auth.sql b/sql/updates/auth/master/2022_03_30_00_auth.sql
deleted file mode 100644
index a2544835afe..00000000000
--- a/sql/updates/auth/master/2022_03_30_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42937;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42937,9,2,0,NULL,NULL,'F5FC75E70874752C92846B3333920E63',NULL,NULL,NULL);
diff --git a/sql/updates/auth/master/2022_03_30_01_auth.sql b/sql/updates/auth/master/2022_03_30_01_auth.sql
deleted file mode 100644
index 13f621bc1c7..00000000000
--- a/sql/updates/auth/master/2022_03_30_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=42979;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(42979,9,2,0,NULL,NULL,'E1DD38AE6450FC4D2AE4609233C59E54',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=42979 WHERE `gamebuild`=42852;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '42979';
diff --git a/sql/updates/auth/master/2022_04_08_00_auth.sql b/sql/updates/auth/master/2022_04_08_00_auth.sql
deleted file mode 100644
index 4e030da1f9d..00000000000
--- a/sql/updates/auth/master/2022_04_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=43114;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(43114,9,2,0,NULL,NULL,'F75C9380CCB24A48A24EEE52C1594A7E',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=43114 WHERE `gamebuild`=42979;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '43114';
diff --git a/sql/updates/auth/master/2022_04_14_00_auth.sql b/sql/updates/auth/master/2022_04_14_00_auth.sql
deleted file mode 100644
index 3dbbab652da..00000000000
--- a/sql/updates/auth/master/2022_04_14_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=43206;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(43206,9,2,0,NULL,NULL,'DDE806532C7704FFB75F256DC5F1F3D9',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=43206 WHERE `gamebuild`=43114;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '43206';
diff --git a/sql/updates/auth/master/2022_04_22_00_auth.sql b/sql/updates/auth/master/2022_04_22_00_auth.sql
deleted file mode 100644
index a2297cc1b54..00000000000
--- a/sql/updates/auth/master/2022_04_22_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=43340;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(43340,9,2,0,NULL,NULL,'70E46D2D888E84DF9316EA849B068CF4',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=43340 WHERE `gamebuild`=43206;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '43340';
diff --git a/sql/updates/auth/master/2022_05_03_00_auth.sql b/sql/updates/auth/master/2022_05_03_00_auth.sql
deleted file mode 100644
index 2f8bed9bda7..00000000000
--- a/sql/updates/auth/master/2022_05_03_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=43345;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(43345,9,2,0,NULL,NULL,'D911ABFCDA030DEE8CAF4EE3F60DEE13',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=43345 WHERE `gamebuild`=43340;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '43345';
diff --git a/sql/updates/auth/master/2022_06_01_00_auth.sql b/sql/updates/auth/master/2022_06_01_00_auth.sql
deleted file mode 100644
index f3e4856444c..00000000000
--- a/sql/updates/auth/master/2022_06_01_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=43971;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(43971,9,2,5,NULL,NULL,'681CF99E61FB0005A5C7D31D0AAD1ED9',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=43971 WHERE `gamebuild`=43345;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '43971';
diff --git a/sql/updates/auth/master/2022_06_06_00_auth.sql b/sql/updates/auth/master/2022_06_06_00_auth.sql
deleted file mode 100644
index d97c172b41a..00000000000
--- a/sql/updates/auth/master/2022_06_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44015;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(44015,9,2,5,NULL,NULL,'FCF0BDA7C98BFEF92AE6D8C39A217ABD',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=44015 WHERE `gamebuild`=43971;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44015';
diff --git a/sql/updates/auth/master/2022_06_07_00_auth.sql b/sql/updates/auth/master/2022_06_07_00_auth.sql
deleted file mode 100644
index af1bbb6f8d5..00000000000
--- a/sql/updates/auth/master/2022_06_07_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44061;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(44061,9,2,5,NULL,NULL,'FD2B5C0B3293FE0E9CAA6EB0B7788119',NULL,NULL,NULL);
diff --git a/sql/updates/auth/master/2022_06_08_00_auth.sql b/sql/updates/auth/master/2022_06_08_00_auth.sql
deleted file mode 100644
index 9b73d477963..00000000000
--- a/sql/updates/auth/master/2022_06_08_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=44061 WHERE `gamebuild`=44015;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44061';
diff --git a/sql/updates/auth/master/2022_06_09_00_auth.sql b/sql/updates/auth/master/2022_06_09_00_auth.sql
deleted file mode 100644
index da9ddd605af..00000000000
--- a/sql/updates/auth/master/2022_06_09_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP TABLE IF EXISTS `battlenet_account_transmog_illusions`;
-CREATE TABLE `battlenet_account_transmog_illusions` (
-  `battlenetAccountId` int unsigned NOT NULL,
-  `blobIndex` smallint unsigned NOT NULL,
-  `illusionMask` int unsigned NOT NULL DEFAULT '0',
-  PRIMARY KEY (`battlenetAccountId`,`blobIndex`),
-  CONSTRAINT `battlenet_account_transmog_illusions_ibfk_1` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
diff --git a/sql/updates/auth/master/2022_06_15_00_auth.sql b/sql/updates/auth/master/2022_06_15_00_auth.sql
deleted file mode 100644
index 562344d94a0..00000000000
--- a/sql/updates/auth/master/2022_06_15_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44127;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(44127,9,2,5,NULL,NULL,'787887CEC9FCC9B516481F60E4FC34A8',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=44127 WHERE `gamebuild`=44061;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44127';
diff --git a/sql/updates/auth/master/2022_06_18_00_auth.sql b/sql/updates/auth/master/2022_06_18_00_auth.sql
deleted file mode 100644
index 158400d2c2c..00000000000
--- a/sql/updates/auth/master/2022_06_18_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44232;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(44232,9,2,5,NULL,NULL,'81F0A71DF7E9873BB3750022D64D33CF',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=44232 WHERE `gamebuild`=44127;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44232';
diff --git a/sql/updates/auth/master/2022_06_27_00_auth.sql b/sql/updates/auth/master/2022_06_27_00_auth.sql
deleted file mode 100644
index 21fad708c44..00000000000
--- a/sql/updates/auth/master/2022_06_27_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44325;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(44325,9,2,5,NULL,NULL,'138A7D524D268A7F9934C3D148E8F01B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=44325 WHERE `gamebuild`=44232;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44325';
diff --git a/sql/updates/auth/master/2022_07_23_00_auth.sql b/sql/updates/auth/master/2022_07_23_00_auth.sql
deleted file mode 100644
index 050506800d7..00000000000
--- a/sql/updates/auth/master/2022_07_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=44730;

-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES

-(44730,9,2,5,NULL,NULL,'FC0B18C47BB4C79F4300CA0FF3E5CAC7',NULL,NULL,NULL);

-

-UPDATE `realmlist` SET `gamebuild`=44730 WHERE `gamebuild`=44325;

-

-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '44730';

diff --git a/sql/updates/auth/master/2022_03_06_00_auth.sql b/sql/updates/auth/master/2022_07_25_00_auth.sql
index b97fcd92e54..db0f935b6ac 100644
--- a/sql/updates/auth/master/2022_03_06_00_auth.sql
+++ b/sql/updates/auth/master/2022_07_25_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 920.22031 auth
+-- TDB 925.22071 auth
 UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
 REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');