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