aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/master/2017_12_30_01_auth.sql7
-rw-r--r--sql/updates/world/master/2017_12_30_03_world.sql1
2 files changed, 5 insertions, 3 deletions
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';