From cf9d01a0f3a9ae136854529eb1e52a0a8ffb08bb Mon Sep 17 00:00:00 2001 From: Spp Date: Mon, 2 Sep 2013 10:03:19 +0200 Subject: Normalize sql file names from 722a6c1 --- sql/updates/auth/2013_08_17_00_auth_rbac.sql | 35 ---------------------------- sql/updates/auth/2013_09_01_01_auth_misc.sql | 35 ++++++++++++++++++++++++++++ 2 files changed, 35 insertions(+), 35 deletions(-) delete mode 100644 sql/updates/auth/2013_08_17_00_auth_rbac.sql create mode 100644 sql/updates/auth/2013_09_01_01_auth_misc.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/2013_08_17_00_auth_rbac.sql b/sql/updates/auth/2013_08_17_00_auth_rbac.sql deleted file mode 100644 index 14c219deaf4..00000000000 --- a/sql/updates/auth/2013_08_17_00_auth_rbac.sql +++ /dev/null @@ -1,35 +0,0 @@ -ALTER TABLE `account` - ADD COLUMN `reg_mail` VARCHAR(255) NOT NULL DEFAULT '' AFTER `s`; - -UPDATE `account` SET reg_mail = email; - -DELETE FROM `rbac_permissions` WHERE `id` = 49; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (49, 'Forces to enter the email for confirmation on password change'); - -DELETE FROM `rbac_roles` WHERE `id` = 40; -INSERT INTO `rbac_roles` (`id`, `name`) VALUES (40, 'Forces to enter the email for confirmation on password change'); - -DELETE FROM `rbac_role_permissions` WHERE `roleId` = 40 AND `permissionId` = 49; -INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (40, 49); - -DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` = 40; -INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (1, 40); - -DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` = 40; -INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (2, 40); - -DELETE FROM `rbac_group_roles` WHERE `groupId` = 3 AND `roleId` = 40; -INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (3, 40); - -DELETE FROM `rbac_group_roles` WHERE `groupId` = 4 AND `roleId` = 40; -INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (4, 40); - -DELETE FROM `rbac_permissions` WHERE `id` = 50; -INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (50, 'Allow user to check his own email with .account'); - -DELETE FROM `rbac_roles` WHERE `id` = 41; -INSERT INTO `rbac_roles` (`id`, `name`) VALUES (41, 'Allow user to check his own email with .account'); - -DELETE FROM `rbac_role_permissions` WHERE `roleId` = 41 AND `permissionId` = 50; -INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (41, 50); - diff --git a/sql/updates/auth/2013_09_01_01_auth_misc.sql b/sql/updates/auth/2013_09_01_01_auth_misc.sql new file mode 100644 index 00000000000..14c219deaf4 --- /dev/null +++ b/sql/updates/auth/2013_09_01_01_auth_misc.sql @@ -0,0 +1,35 @@ +ALTER TABLE `account` + ADD COLUMN `reg_mail` VARCHAR(255) NOT NULL DEFAULT '' AFTER `s`; + +UPDATE `account` SET reg_mail = email; + +DELETE FROM `rbac_permissions` WHERE `id` = 49; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (49, 'Forces to enter the email for confirmation on password change'); + +DELETE FROM `rbac_roles` WHERE `id` = 40; +INSERT INTO `rbac_roles` (`id`, `name`) VALUES (40, 'Forces to enter the email for confirmation on password change'); + +DELETE FROM `rbac_role_permissions` WHERE `roleId` = 40 AND `permissionId` = 49; +INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (40, 49); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 1 AND `roleId` = 40; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (1, 40); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 2 AND `roleId` = 40; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (2, 40); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 3 AND `roleId` = 40; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (3, 40); + +DELETE FROM `rbac_group_roles` WHERE `groupId` = 4 AND `roleId` = 40; +INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES (4, 40); + +DELETE FROM `rbac_permissions` WHERE `id` = 50; +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (50, 'Allow user to check his own email with .account'); + +DELETE FROM `rbac_roles` WHERE `id` = 41; +INSERT INTO `rbac_roles` (`id`, `name`) VALUES (41, 'Allow user to check his own email with .account'); + +DELETE FROM `rbac_role_permissions` WHERE `roleId` = 41 AND `permissionId` = 50; +INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES (41, 50); + -- cgit v1.2.3