DB/RBAC: fixed some permissions after 779d3b23689aba45a3a29eb1016f53e0710ed789

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