Core/Warden: Warden refactors (PR #25235)

(cherry picked from commit 6116e5b38522ccfb00f6c941c75482e05b4c0799)

2 files changed, 20 insertions, 0 deletions

diff --git a/sql/updates/auth/master/2020_08_11_00_auth.sql b/sql/updates/auth/master/2020_08_11_00_auth.sql
new file mode 100644
index 00000000000..16296ac7c90
--- /dev/null
+++ b/sql/updates/auth/master/2020_08_11_00_auth.sql
@@ -0,0 +1,5 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=705;
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=705;
+DELETE FROM `rbac_account_permissions` WHERE `permissionId`=705;
+DELETE FROM `rbac_default_permissions` WHERE `permissionId`=705;
diff --git a/sql/updates/world/master/2022_01_26_31_world_2020_08_11_00_world_335.sql b/sql/updates/world/master/2022_01_26_31_world_2020_08_11_00_world_335.sql
new file mode 100644
index 00000000000..6e66caa8855
--- /dev/null
+++ b/sql/updates/world/master/2022_01_26_31_world_2020_08_11_00_world_335.sql
@@ -0,0 +1,15 @@
+-- 
+ALTER TABLE `warden_checks`
+    CHANGE COLUMN `data` `oldData` VARCHAR(48),
+    CHANGE COLUMN `result` `oldResult` VARCHAR(24),
+    ADD COLUMN `data` BINARY(24) DEFAULT NULL,
+    ADD COLUMN `result` VARBINARY(12) DEFAULT NULL;
+
+UPDATE `warden_checks` SET `data`=UNHEX(`oldData`) WHERE `type` IN (113,178,191);
+UPDATE `warden_checks` SET `result`=UNHEX(`oldResult`) WHERE `type` IN (152,243);
+
+ALTER TABLE `warden_checks`
+    DROP COLUMN `oldData`,
+    DROP COLUMN `oldResult`;
+
+DELETE FROM `command` WHERE `name`='reload warden_action';