diff options
| author | TDB Release <tdb-release@build.bot> | 2023-06-14 19:37:17 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2023-06-14 19:37:17 +0000 |
| commit | 40d1f7a2e8fa54b3c9432b4432d6df968ec60cc4 (patch) | |
| tree | c6f405d6af8b24fe8b30807e4d4562a8d7ffffb9 /sql/old/3.3.5a/auth | |
| parent | d1c6b9d253faa61246f04058719f7f3c07548165 (diff) | |
TDB 335.23061 - 2023/06/14TDB335.23061
Diffstat (limited to 'sql/old/3.3.5a/auth')
4 files changed, 25 insertions, 0 deletions
diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql new file mode 100644 index 00000000000..2b56c992617 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_01_16_00_auth.sql @@ -0,0 +1,2 @@ +-- TDB 335.23011 auth +UPDATE `updates` SET `state`='ARCHIVED'; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql new file mode 100644 index 00000000000..a1db2d6b2a9 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_00_auth.sql @@ -0,0 +1,19 @@ +ALTER TABLE `account` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_access` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `account_muted` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `autobroadcast` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `build_info` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `ip_banned` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `logs` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `logs_ip_actions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_account_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_default_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_linked_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rbac_permissions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `realmcharacters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `realmlist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `secret_digest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `updates_include` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `uptime` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql new file mode 100644 index 00000000000..c1cca3f8c7d --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_02_05_01_auth.sql @@ -0,0 +1,2 @@ +ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT; +ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT; diff --git a/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql new file mode 100644 index 00000000000..c4b98641686 --- /dev/null +++ b/sql/old/3.3.5a/auth/23011_2023_06_14/2023_05_05_00_auth.sql @@ -0,0 +1,2 @@ +-- +UPDATE `rbac_permissions` SET `name` = 'Command: reload graveyard_zone' WHERE `id` = 645; |