Core/RBAC: Create new permissions 'Notify if a command was not found' and 'Enables lower security than target check'

2 files changed, 29 insertions, 2 deletions

diff --git a/sql/updates/auth/2013_02_25_08_auth_misc.sql b/sql/updates/auth/2013_02_25_08_auth_misc.sql
index 35b12b1eddb..244b1848d0c 100644
--- a/sql/updates/auth/2013_02_25_08_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_08_auth_misc.sql
@@ -1,10 +1,10 @@
 -- Add new permission
 DELETE FROM `rbac_permissions` WHERE `id` = 27;
-INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (27, 'Send mail to other faction');
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (27, 'Two side mail interaction');
 
 -- Add new role
 DELETE FROM `rbac_roles` WHERE `id` = 19;
-INSERT INTO `rbac_roles` (`id`, `name`) VALUES (19, 'Send mail to other faction');
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES (19, 'Two side mail interaction');
 
 -- Add the permission to the role
 DELETE FROM `rbac_role_permissions` WHERE `roleId` = 19;
diff --git a/sql/updates/auth/2013_02_25_09_auth_misc.sql b/sql/updates/auth/2013_02_25_09_auth_misc.sql
new file mode 100644
index 00000000000..f2affe05b70
--- /dev/null
+++ b/sql/updates/auth/2013_02_25_09_auth_misc.sql
@@ -0,0 +1,27 @@
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id` IN (33, 47);
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(33, 'Notify if a command was not found'),
+(47, 'Enables lower security than target check');
+
+-- Add new role
+DELETE FROM `rbac_roles` WHERE `id` IN (20, 21);
+INSERT INTO `rbac_roles` (`id`, `name`) VALUES
+(20, 'Notify if a command was not found'),
+(21, 'Enables lower security than target check');
+
+-- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (20, 21);
+INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
+(20, 33),
+(21, 47);
+
+-- Add it to all GM+ groups
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (20, 21);
+INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
+(2, 20),
+(3, 20),
+(4, 20),
+(2, 21),
+(3, 21),
+(4, 21);