From 97c7e32a42d4041b4d74e1d6bf951ed2f6161661 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Sun, 31 Dec 2017 00:10:25 +0100 Subject: SQL: Fixed typo --- sql/updates/auth/master/2017_12_30_01_auth.sql | 7 ++++--- sql/updates/world/master/2017_12_30_03_world.sql | 1 + 2 files changed, 5 insertions(+), 3 deletions(-) create mode 100644 sql/updates/world/master/2017_12_30_03_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/master/2017_12_30_01_auth.sql b/sql/updates/auth/master/2017_12_30_01_auth.sql index d9e1e32f103..b1c9a297968 100644 --- a/sql/updates/auth/master/2017_12_30_01_auth.sql +++ b/sql/updates/auth/master/2017_12_30_01_auth.sql @@ -2,9 +2,10 @@ DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=867; DELETE FROM `rbac_permissions` WHERE `id`=867; -- +DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=868; DELETE FROM `rbac_permissions` WHERE `id`=868; INSERT INTO `rbac_permissions` (`id`, `name`) VALUES -(867, 'Command: modify power'); +(868, 'Command: modify power'); -DELETE FROM `rbac_linked_permissions` WHERE `id`=198 AND `linkedId`=868; -INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (198, 867); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(198, 868); diff --git a/sql/updates/world/master/2017_12_30_03_world.sql b/sql/updates/world/master/2017_12_30_03_world.sql new file mode 100644 index 00000000000..1d7be946705 --- /dev/null +++ b/sql/updates/world/master/2017_12_30_03_world.sql @@ -0,0 +1 @@ +UPDATE `command` SET `permission`=868 WHERE `name`='modify power'; -- cgit v1.2.3