From d16596dc59cb855d62958f2f20d09fad39e419aa Mon Sep 17 00:00:00 2001 From: TDB Release Date: Sun, 21 Jan 2024 11:39:53 +0000 Subject: TDB 335.24011 - 2024/01/21 --- sql/old/3.3.5a/auth/23061_2024_01_21/2023_06_14_00_auth.sql | 2 ++ sql/old/3.3.5a/auth/23061_2024_01_21/2023_11_21_00_auth.sql | 1 + sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_00_auth.sql | 7 +++++++ sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_01_auth.sql | 7 +++++++ sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_02_auth.sql | 10 ++++++++++ sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_03_auth.sql | 3 +++ 6 files changed, 30 insertions(+) create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2023_06_14_00_auth.sql create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2023_11_21_00_auth.sql create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_00_auth.sql create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_01_auth.sql create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_02_auth.sql create mode 100644 sql/old/3.3.5a/auth/23061_2024_01_21/2024_01_06_03_auth.sql (limited to 'sql/old/3.3.5a/auth') 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); -- cgit v1.2.3