DB: Convert databases to utf8mb4

1 files changed, 30 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2021_12_31_00_auth.sql b/sql/updates/auth/master/2021_12_31_00_auth.sql
new file mode 100644
index 00000000000..d053218702f
--- /dev/null
+++ b/sql/updates/auth/master/2021_12_31_00_auth.sql
@@ -0,0 +1,30 @@
+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_last_played_character 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 battle_pet_declinedname CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battle_pet_slots CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battle_pets CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_account_bans CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_account_heirlooms CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_account_mounts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_account_toys CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_accounts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_item_appearances CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

+ALTER TABLE battlenet_item_favorite_appearances 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;