From 30ecdad08b55c6fecc45c36921bf3f667d648566 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 19 Dec 2022 14:11:58 -0500 Subject: [PATCH] SQL: add more items to update --- .../src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql index b1c190e40a..e4e0521bbd 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.10-upgrade.sql @@ -40,6 +40,17 @@ insert into config.ui_staff_portal_page_entry (page_col, col_pos, label, image_u -- enable global flag for expired account login update config.global_flag set enabled = true where name = 'auth.block_expired_staff_login'; +-- add ADMIN_STAFF_PORTAL_PAGE perm to appropriate groups +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_STAFF_PORTAL_PAGE'), 0, false), +((select id from permission.grp_tree where name = 'LocalAdmin'), (select id from permission.perm_list where code = 'ADMIN_STAFF_PORTAL_PAGE'), 1, false); + +-- Item stat cats +UPDATE asset.stat_cat SET opac_visible=false WHERE opac_visible=true; + +-- Patron stat cats +UPDATE actor.stat_cat SET opac_visible=false WHERE opac_visible=true; + COMMIT; -- 2.11.0