aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorVincent-Michael <vincent_michael@gmx.de>2016-07-30 16:56:41 +0200
committerVincent-Michael <vincent_michael@gmx.de>2016-07-30 16:56:41 +0200
commitc25c747b36ccf1ce44bb40b3fdc8422325a07372 (patch)
treecee9c14b504daf2926c9900a296612fdab912225 /sql
parent41aac793572c52e374824691c01681ece644c067 (diff)
Misc/RBAC: Sync with 3.3.5
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/auth/6.x/2016_07_30_00_auth.sql14
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/auth/6.x/2016_07_30_00_auth.sql b/sql/updates/auth/6.x/2016_07_30_00_auth.sql
new file mode 100644
index 00000000000..5b81f14f1b5
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_07_30_00_auth.sql
@@ -0,0 +1,14 @@
+DELETE FROM `rbac_permissions` WHERE `id` IN (662,664,692);
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (662,664,692);
+
+DELETE FROM `rbac_permissions` WHERE `id` IN (837,838,839);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(837, 'Command: reload character_template'),
+(838, 'Command: reload quest_greeting'),
+(839, 'Command: debug send playscene');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (837,838,839);
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 837),
+(196, 838),
+(192, 839);