From 57c34286bb2039b5e59aac9d2f394dc26f61bea7 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 14 Jan 2020 13:10:48 -0500 Subject: [PATCH] additions to post-upgrade script --- .../Pg/version-upgrade/pines-post-3.4-upgrade.sql | 25 ++++++++++++++++++++++ 1 file changed, 25 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql index ee884efb7d..3863fdc608 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.4-upgrade.sql @@ -12,6 +12,31 @@ insert into container.carousel_org_unit (carousel, org_unit, seq) select id, own insert into container.biblio_record_entry_bucket (owner, name, btype, pub, owning_lib) select 1, 'PINES-Created Bucket for carousel: ' || id, 'carousel', true, owner from container.carousel; -- link the carousels to their buckets update container.carousel cc set bucket = (select id from container.biblio_record_entry_bucket b where b.owning_lib = cc.owner and b.btype = 'carousel'); +-- add admin perms to GlobalAdmins +insert into permission.grp_perm_map (grp, perm, depth) values ((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_CAROUSEL_TYPE'), 0); +insert into permission.grp_perm_map (grp, perm, depth) values ((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_CAROUSEL'), 0); +insert into permission.grp_perm_map (grp, perm, depth) values ((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'REFRESH_CAROUSEL'), 0); + +-- add booking perms - done on production 2020-01-14 +--insert into permission.grp_perm_map (grp, perm, depth, grantable) values +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_TYPE'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR_MAP'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR_VALUE'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_MAP'), 0, true), +--((select id from permission.grp_tree where name = 'GlobalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_VALUE_MAP'), 0, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR_MAP'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESOURCE_ATTR_VALUE'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_MAP'), 1, true), +--((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_VALUE_MAP'), 1, true), +--((select id from permission.grp_tree where name = 'LibraryManager'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION'), 2, true), +--((select id from permission.grp_tree where name = 'LibraryManager'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_MAP'), 2, true), +--((select id from permission.grp_tree where name = 'LibraryManager'), (select id from permission.perm_list where code = 'ADMIN_BOOKING_RESERVATION_ATTR_VALUE_MAP'), 2, true); -- Add ILL circulation modifier -- 2.11.0