From d16596dc59cb855d62958f2f20d09fad39e419aa Mon Sep 17 00:00:00 2001
From: TDB Release <tdb-release@build.bot>
Date: Sun, 21 Jan 2024 11:39:53 +0000
Subject: TDB 335.24011 - 2024/01/21

---
 sql/updates/auth/3.3.5/2023_06_14_00_auth.sql |  2 --
 sql/updates/auth/3.3.5/2023_11_21_00_auth.sql |  1 -
 sql/updates/auth/3.3.5/2024_01_06_00_auth.sql |  7 -------
 sql/updates/auth/3.3.5/2024_01_06_01_auth.sql |  7 -------
 sql/updates/auth/3.3.5/2024_01_06_02_auth.sql | 10 ----------
 sql/updates/auth/3.3.5/2024_01_06_03_auth.sql |  3 ---
 sql/updates/auth/3.3.5/2024_01_21_00_auth.sql |  2 ++
 7 files changed, 2 insertions(+), 30 deletions(-)
 delete mode 100644 sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
 delete mode 100644 sql/updates/auth/3.3.5/2023_11_21_00_auth.sql
 delete mode 100644 sql/updates/auth/3.3.5/2024_01_06_00_auth.sql
 delete mode 100644 sql/updates/auth/3.3.5/2024_01_06_01_auth.sql
 delete mode 100644 sql/updates/auth/3.3.5/2024_01_06_02_auth.sql
 delete mode 100644 sql/updates/auth/3.3.5/2024_01_06_03_auth.sql
 create mode 100644 sql/updates/auth/3.3.5/2024_01_21_00_auth.sql

(limited to 'sql/updates/auth')

diff --git a/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql b/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
deleted file mode 100644
index 90ead8908c8..00000000000
--- a/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- TDB 335.23061 auth
-UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/auth/3.3.5/2023_11_21_00_auth.sql b/sql/updates/auth/3.3.5/2023_11_21_00_auth.sql
deleted file mode 100644
index 1dc190782d7..00000000000
--- a/sql/updates/auth/3.3.5/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/3.3.5/2024_01_06_00_auth.sql b/sql/updates/auth/3.3.5/2024_01_06_00_auth.sql
deleted file mode 100644
index 188513853c0..00000000000
--- a/sql/updates/auth/3.3.5/2024_01_06_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-DELETE FROM `rbac_permissions` WHERE `id` = 52;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (52, "No battleground deserter debuff");
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 52;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(193, 52);
diff --git a/sql/updates/auth/3.3.5/2024_01_06_01_auth.sql b/sql/updates/auth/3.3.5/2024_01_06_01_auth.sql
deleted file mode 100644
index f09d9139e4a..00000000000
--- a/sql/updates/auth/3.3.5/2024_01_06_01_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
---
-DELETE FROM `rbac_permissions` WHERE `id` = 53;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (53, "Can be AFK on the battleground");
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 53;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(193, 53);
diff --git a/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql b/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql
deleted file mode 100644
index 2e3b0616aa3..00000000000
--- a/sql/updates/auth/3.3.5/2024_01_06_02_auth.sql
+++ /dev/null
@@ -1,10 +0,0 @@
---
-DELETE FROM `rbac_permissions` WHERE `id` IN (884, 885);
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
-(884, "Command: bg start"),
-(885, "Command: bg stop");
-
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (884, 885);
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
-(197, 884),
-(197, 885);
diff --git a/sql/updates/auth/3.3.5/2024_01_06_03_auth.sql b/sql/updates/auth/3.3.5/2024_01_06_03_auth.sql
deleted file mode 100644
index 93e6ffad0c8..00000000000
--- a/sql/updates/auth/3.3.5/2024_01_06_03_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
---
-DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 7;
-INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 7);
diff --git a/sql/updates/auth/3.3.5/2024_01_21_00_auth.sql b/sql/updates/auth/3.3.5/2024_01_21_00_auth.sql
new file mode 100644
index 00000000000..3f9344918bf
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2024_01_21_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.24011 auth
+UPDATE `updates` SET `state`='ARCHIVED';
-- 
cgit v1.2.3