aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
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);