Corrections to recent sqls

4 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/auth/2013_02_25_00_auth_misc.sql b/sql/updates/auth/2013_02_25_00_auth_misc.sql
index fbbf47f1a23..5531252037a 100644
--- a/sql/updates/auth/2013_02_25_00_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_00_auth_misc.sql
@@ -1,13 +1,17 @@
 -- Add new permission
+DELETE FROM `rbac_permissions` WHERE `id` = 11;
 INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (11, 'Log GM trades');
 
 -- Add new role
+DELETE FROM `rbac_roles` WHERE `id` = 8;
 INSERT INTO `rbac_roles` (`id`, `name`) VALUES (8, 'Log GM trades');
 
 -- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` = 8;
 INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (8, 11);
 
 -- Add it to all GM+ groups
+DELETE FROM `rbac_group_roles` WHERE `roleId` = 8;
 INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
 (2, 8),
 (3, 8),
diff --git a/sql/updates/auth/2013_02_25_01_auth_misc.sql b/sql/updates/auth/2013_02_25_01_auth_misc.sql
index 0cd63bf2062..f5cb6c01d19 100644
--- a/sql/updates/auth/2013_02_25_01_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_01_auth_misc.sql
@@ -1,13 +1,17 @@
 -- Add new permission
+DELETE FROM `rbac_permissions` WHERE `id` = 13;
 INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (13, 'Skip Instance required bosses check');
 
 -- Add new role
+DELETE FROM `rbac_roles` WHERE `id` = 9;
 INSERT INTO `rbac_roles` (`id`, `name`) VALUES (9, 'Skip Instance required bosses check');
 
 -- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` = 9;
 INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (9, 13);
 
 -- Add it to all GM+ groups
+DELETE FROM `rbac_group_roles` WHERE `roleId` = 9;
 INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
 (2, 9),
 (3, 9),
diff --git a/sql/updates/auth/2013_02_25_02_auth_misc.sql b/sql/updates/auth/2013_02_25_02_auth_misc.sql
index 5695d308cf4..11e235c91d9 100644
--- a/sql/updates/auth/2013_02_25_02_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_02_auth_misc.sql
@@ -1,13 +1,17 @@
 -- Add new permission
+DELETE FROM `rbac_permissions` WHERE `id` = 32;
 INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (32, 'Can be assigned tickets with .assign ticket command');
 
 -- Add new role
+DELETE FROM `rbac_roles` WHERE `id` = 10;
 INSERT INTO `rbac_roles` (`id`, `name`) VALUES (10, 'Ticket management');
 
 -- Add the permission to the role
+DELETE FROM `rbac_role_permissions` WHERE `roleId` = 10;
 INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (10, 32);
 
 -- Add it to all GM+ groups
+DELETE FROM `rbac_group_roles` WHERE `roleId` = 10;
 INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
 (2, 10),
 (3, 10),
diff --git a/sql/updates/auth/2013_02_25_03_auth_misc.sql b/sql/updates/auth/2013_02_25_03_auth_misc.sql
index cf843b9769d..ab2c6e0692c 100644
--- a/sql/updates/auth/2013_02_25_03_auth_misc.sql
+++ b/sql/updates/auth/2013_02_25_03_auth_misc.sql
@@ -20,6 +20,7 @@ INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
 (13, 38);
 
 -- Add it to all GM+ groups
+DELETE FROM `rbac_role_permissions` WHERE `roleId` IN (11, 12, 13);
 INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
 (2, 11),
 (3, 11),