aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2023_11_21_00_auth.sql1
-rw-r--r--sql/updates/auth/3.3.5/2024_01_06_00_auth.sql7
-rw-r--r--sql/updates/auth/3.3.5/2024_01_06_01_auth.sql7
-rw-r--r--sql/updates/auth/3.3.5/2024_01_06_02_auth.sql10
-rw-r--r--sql/updates/auth/3.3.5/2024_01_06_03_auth.sql3
-rw-r--r--sql/updates/auth/3.3.5/2024_01_21_00_auth.sql (renamed from sql/updates/auth/3.3.5/2023_06_14_00_auth.sql)2
6 files changed, 1 insertions, 29 deletions
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/2023_06_14_00_auth.sql b/sql/updates/auth/3.3.5/2024_01_21_00_auth.sql
index 90ead8908c8..3f9344918bf 100644
--- a/sql/updates/auth/3.3.5/2023_06_14_00_auth.sql
+++ b/sql/updates/auth/3.3.5/2024_01_21_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 335.23061 auth
+-- TDB 335.24011 auth
UPDATE `updates` SET `state`='ARCHIVED';