aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/auth/6.x/2016_09_03_03_auth.sql11
-rw-r--r--sql/updates/world/6.x/2016_09_03_05_world.sql3
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';