From a0fee439de4c1d5d36a4079778976fe821b3d8d1 Mon Sep 17 00:00:00 2001 From: Vincent-Michael Date: Sat, 2 May 2015 16:03:06 +0200 Subject: SQL: Update auth_database --- sql/updates/auth/2015_05_02_01_auth.sql | 9 +++++++++ sql/updates/world/2015_05_02_05_world.sql | 1 + 2 files changed, 10 insertions(+) create mode 100644 sql/updates/auth/2015_05_02_01_auth.sql create mode 100644 sql/updates/world/2015_05_02_05_world.sql (limited to 'sql/updates') diff --git a/sql/updates/auth/2015_05_02_01_auth.sql b/sql/updates/auth/2015_05_02_01_auth.sql new file mode 100644 index 00000000000..eb6f50ec026 --- /dev/null +++ b/sql/updates/auth/2015_05_02_01_auth.sql @@ -0,0 +1,9 @@ +DELETE FROM `rbac_permissions` WHERE `id`=12; +DELETE FROM `rbac_permissions` WHERE `id`=834; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(834, 'Command: go quest'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=12; +DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=834; +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(198, 834); diff --git a/sql/updates/world/2015_05_02_05_world.sql b/sql/updates/world/2015_05_02_05_world.sql new file mode 100644 index 00000000000..b62b508b988 --- /dev/null +++ b/sql/updates/world/2015_05_02_05_world.sql @@ -0,0 +1 @@ +UPDATE `command` SET `permission`=834 WHERE `name`='go quest'; -- cgit v1.2.3