From fa29756c6eb11c65c9dee5cfd201991678fa221f Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 16 Jan 2019 10:53:13 -0500 Subject: [PATCH] add copy alert perms to LocalAdmin and LibraryManager --- .../Pg/version-upgrade/pines-post-3.2-upgrade.sql | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql index af528bb893..ef410369e3 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql @@ -200,6 +200,16 @@ VALUES ( 1 ), ( +(SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), +(SELECT id FROM permission.perm_list WHERE code = 'CREATE_COPY_ALERT'), +1 +), +( +(SELECT id FROM permission.grp_tree WHERE name = 'LibraryManager'), +(SELECT id FROM permission.perm_list WHERE code = 'CREATE_COPY_ALERT'), +1 +), +( (SELECT id FROM permission.grp_tree WHERE name = 'Cat1'), (SELECT id FROM permission.perm_list WHERE code = 'UPDATE_COPY_ALERT'), 1 @@ -210,6 +220,16 @@ VALUES ( 1 ), ( +(SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), +(SELECT id FROM permission.perm_list WHERE code = 'UPDATE_COPY_ALERT'), +1 +), +( +(SELECT id FROM permission.grp_tree WHERE name = 'LibraryManager'), +(SELECT id FROM permission.perm_list WHERE code = 'UPDATE_COPY_ALERT'), +1 +), +( (SELECT id FROM permission.grp_tree WHERE name = 'Cat1'), (SELECT id FROM permission.perm_list WHERE code = 'DELETE_COPY_ALERT'), 1 @@ -220,6 +240,16 @@ VALUES ( 1 ), ( +(SELECT id FROM permission.grp_tree WHERE name = 'LocalAdmin'), +(SELECT id FROM permission.perm_list WHERE code = 'DELETE_COPY_ALERT'), +1 +), +( +(SELECT id FROM permission.grp_tree WHERE name = 'LibraryManager'), +(SELECT id FROM permission.perm_list WHERE code = 'DELETE_COPY_ALERT'), +1 +), +( (SELECT id FROM permission.grp_tree WHERE name = 'GlobalAdmin'), (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_COPY_ALERT_SUPPRESS'), 0 -- 2.11.0