aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authortreeston <treeston.mmoc@gmail.com>2017-06-12 17:12:02 +0200
committertreeston <treeston.mmoc@gmail.com>2017-06-12 17:12:02 +0200
commit06c5d139f6ad7fedb920e0bafda88be57050a970 (patch)
treedfe308bd95a1611d0e6184b09557b77976cfcba0 /sql/updates/auth
parentac0f76f8c57bba195b773a6a31ade2e8e2318aeb (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.
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2017_06_12_01_auth.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2017_06_12_01_auth.sql b/sql/updates/auth/3.3.5/2017_06_12_01_auth.sql
new file mode 100644
index 00000000000..17c204b56af
--- /dev/null
+++ b/sql/updates/auth/3.3.5/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);