From 85205d8ca5d41e4eca09619ebf46d92e7b925aaa Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Sun, 20 Nov 2022 11:12:09 +0000
Subject: TDB 927.22111 - 2022/11/20

---
 sql/updates/auth/master/2022_08_21_00_auth.sql |  3 ---
 sql/updates/auth/master/2022_09_02_00_auth.sql | 10 ----------
 sql/updates/auth/master/2022_09_08_00_auth.sql |  7 -------
 sql/updates/auth/master/2022_09_23_00_auth.sql |  7 -------
 sql/updates/auth/master/2022_10_03_00_auth.sql |  3 ---
 sql/updates/auth/master/2022_11_20_00_auth.sql |  3 +++
 6 files changed, 3 insertions(+), 30 deletions(-)
 delete mode 100644 sql/updates/auth/master/2022_08_21_00_auth.sql
 delete mode 100644 sql/updates/auth/master/2022_09_02_00_auth.sql
 delete mode 100644 sql/updates/auth/master/2022_09_08_00_auth.sql
 delete mode 100644 sql/updates/auth/master/2022_09_23_00_auth.sql
 delete mode 100644 sql/updates/auth/master/2022_10_03_00_auth.sql
 create mode 100644 sql/updates/auth/master/2022_11_20_00_auth.sql

(limited to 'sql/updates/auth')

diff --git a/sql/updates/auth/master/2022_08_21_00_auth.sql b/sql/updates/auth/master/2022_08_21_00_auth.sql
deleted file mode 100644
index 6be643a1373..00000000000
--- a/sql/updates/auth/master/2022_08_21_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- TDB 927.22082 auth
-UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
-REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');
diff --git a/sql/updates/auth/master/2022_09_02_00_auth.sql b/sql/updates/auth/master/2022_09_02_00_auth.sql
deleted file mode 100644
index ead11623565..00000000000
--- a/sql/updates/auth/master/2022_09_02_00_auth.sql
+++ /dev/null
@@ -1,10 +0,0 @@
--- 
-SET @PERMISSION := 883;
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@PERMISSION;
-DELETE FROM `rbac_permissions` WHERE `id`=@PERMISSION;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(@PERMISSION, 'Command: quest objective complete');
-
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(196, @PERMISSION);
diff --git a/sql/updates/auth/master/2022_09_08_00_auth.sql b/sql/updates/auth/master/2022_09_08_00_auth.sql
deleted file mode 100644
index 1a188d14664..00000000000
--- a/sql/updates/auth/master/2022_09_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=45338;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(45338,9,2,7,NULL,NULL,'5CE2094A41B61EDA9DF56378BC3B1DE0',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=45338 WHERE `gamebuild` IN(45114, 45161);
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45338';
diff --git a/sql/updates/auth/master/2022_09_23_00_auth.sql b/sql/updates/auth/master/2022_09_23_00_auth.sql
deleted file mode 100644
index 2cba9673db4..00000000000
--- a/sql/updates/auth/master/2022_09_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=45745;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(45745,9,2,7,NULL,NULL,'0F6DC90161694D765A595A3AF603166B',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=45745 WHERE `gamebuild`=45338;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '45745';
diff --git a/sql/updates/auth/master/2022_10_03_00_auth.sql b/sql/updates/auth/master/2022_10_03_00_auth.sql
deleted file mode 100644
index ca85f55b3ee..00000000000
--- a/sql/updates/auth/master/2022_10_03_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `rbac_account_permissions` WHERE `permissionId`=416;
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=416;
-DELETE FROM `rbac_permissions` WHERE `id`=416;
diff --git a/sql/updates/auth/master/2022_11_20_00_auth.sql b/sql/updates/auth/master/2022_11_20_00_auth.sql
new file mode 100644
index 00000000000..7f3734af8d8
--- /dev/null
+++ b/sql/updates/auth/master/2022_11_20_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 927.22111 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/9.x/auth', 'ARCHIVED');
-- 
cgit v1.2.3