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/old/3.3.5a/auth | |
| parent | c715ea698ac52fde3181c02b14e0fc59e6f77f6d (diff) | |
TDB 335.24011 - 2024/01/21TDB335.24011
Diffstat (limited to 'sql/old/3.3.5a/auth')
6 files changed, 30 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/23061_2024_01_21/2023_06_14_00_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2023_06_14_00_auth.sql new file mode 100644 index 00000000000..90ead8908c8 --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2023_06_14_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.23061 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/auth/23061_2024_01_21/2023_11_21_00_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2023_11_21_00_auth.sql new file mode 100644 index 00000000000..1dc190782d7 --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2023_11_21_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `account` ADD `timezone_offset` smallint NOT NULL DEFAULT '0' AFTER `os`; diff --git a/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_00_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_00_auth.sql new file mode 100644 index 00000000000..188513853c0 --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_00_auth.sql @@ -0,0 +1,7 @@ +-- +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/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_01_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_01_auth.sql new file mode 100644 index 00000000000..f09d9139e4a --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_01_auth.sql @@ -0,0 +1,7 @@ +-- +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/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_02_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_02_auth.sql new file mode 100644 index 00000000000..2e3b0616aa3 --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_02_auth.sql @@ -0,0 +1,10 @@ +-- +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/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_03_auth.sql b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_03_auth.sql new file mode 100644 index 00000000000..93e6ffad0c8 --- /dev/null +++ b/sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_03_auth.sql @@ -0,0 +1,3 @@ +-- +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 7; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (192, 7); |