diff options
| author | TDB Release <tdb-release@build.bot> | 2024-01-21 11:39:53 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2024-01-21 11:39:53 +0000 |
| commit | d16596dc59cb855d62958f2f20d09fad39e419aa (patch) | |
| tree | 62a9ffebec90c1c2aa3daef53e1a0e652911df0d /sql/updates/auth | |
| parent | c715ea698ac52fde3181c02b14e0fc59e6f77f6d (diff) | |
TDB 335.24011 - 2024/01/21TDB335.24011
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/3.3.5/2023_11_21_00_auth.sql | 1 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2024_01_06_00_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2024_01_06_01_auth.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2024_01_06_02_auth.sql | 10 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2024_01_06_03_auth.sql | 3 | ||||
| -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'; |