aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2017-06-12 17:12:02 +0200
committerCarbenium <carbenium@outlook.com>2020-07-16 22:00:29 +0200
commit60fadf8c71d3fda1bbb01d33cecb34f3bd158f16 (patch)
treecaffe33f81e291b6ddbd914c01eb4228d64149bc /sql/updates/auth
parent17a0139b0e121b0d8d0f2a079fcfd49090ea35a4 (diff)
Insert dynamic_spawning RBACs (already reserved in RBAC.h as of 55d8c2b) into auth database to prevent constant base file conflicts on that branch.
(cherry picked from commit 06c5d139f6ad7fedb920e0bafda88be57050a970)
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2017_06_12_01_auth.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2017_06_12_01_auth.sql b/sql/updates/auth/master/2017_06_12_01_auth.sql
new file mode 100644
index 00000000000..17c204b56af
--- /dev/null
+++ b/sql/updates/auth/master/2017_06_12_01_auth.sql
@@ -0,0 +1,12 @@
+--
+DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 856 AND 860;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(856, 'Command: npc spawngroup'),
+(857, 'Command: npc despawngroup'),
+(858, 'Command: gobject spawngroup'),
+(859, 'Command: gobject despawngroup'),
+(860, 'Command: list respawns');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` BETWEEN 856 AND 860;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(197,856),(197,857),(197,858),(197,859),(197,860);