DB/RBAC: fixed some permissions after a92bfb5505e17cc183ec5aa74b01564d566b7677

2 files changed, 14 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);
diff --git a/sql/updates/world/6.x/2016_09_03_03_world.sql b/sql/updates/world/6.x/2016_09_03_03_world.sql
new file mode 100644
index 00000000000..23a8e224718
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_03_03_world.sql
@@ -0,0 +1,3 @@
+UPDATE `command` SET `permission`=841 WHERE `name`='reload character_template';
+UPDATE `command` SET `permission`=842 WHERE `name`='reload quest_greeting';
+UPDATE `command` SET `permission`=843 WHERE `name`='debug send playscene';