aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorjoschiwald <joschiwald.trinity@gmail.com>2016-09-03 15:31:32 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2016-09-03 15:31:32 +0200
commitad52ee8e2569576b395b20f543c5fe0e41bc31b9 (patch)
tree86424f9f34beebbb7b329518b078c2e342a0965b /sql/updates/auth
parenta92bfb5505e17cc183ec5aa74b01564d566b7677 (diff)
DB/RBAC: fixed some permissions after a92bfb5505e17cc183ec5aa74b01564d566b7677
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/6.x/2016_09_03_01_auth.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/auth/6.x/2016_09_03_01_auth.sql b/sql/updates/auth/6.x/2016_09_03_01_auth.sql
new file mode 100644
index 00000000000..5092f093bfb
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_09_03_01_auth.sql
@@ -0,0 +1,11 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (841,842,843);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(841, 'Command: reload character_template'),
+(842, 'Command: reload quest_greeting'),
+(843, 'Command: debug send playscene');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (841,842,843);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 841),
+(196, 842),
+(192, 843);