From e99dd159152dcb8093134f025e29901b17cb98a8 Mon Sep 17 00:00:00 2001
From: Spp <spp@jorge.gr>
Date: Mon, 25 Feb 2013 12:50:50 +0100
Subject: Core/RBAC: Create new permission 'Skip over-speed ping check'

---
 sql/updates/auth/2013_02_25_06_auth_misc.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 sql/updates/auth/2013_02_25_06_auth_misc.sql

(limited to 'sql')

diff --git a/sql/updates/auth/2013_02_25_06_auth_misc.sql b/sql/updates/auth/2013_02_25_06_auth_misc.sql
new file mode 100644
index 00000000000..92eae3d782d
--- /dev/null
+++ b/sql/updates/auth/2013_02_25_06_auth_misc.sql
@@ -0,0 +1,18 @@
+-- Add new permission
+DELETE FROM `rbac_permissions` WHERE `id` = 23;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (23, 'Skip over-speed ping check');
+
+-- Add new role
+DELETE FROM `rbac_roles` WHERE `id` = 17;
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES (17, 'Skip over-speed ping check');
+
+-- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` = 17;
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (17, 23);
+
+-- Add it to all GM+ groups
+DELETE FROM `rbac_group_roles` WHERE `roleId` = 17;
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
+(2, 17),
+(3, 17),
+(4, 17);
-- 
cgit v1.2.3