From 28d4e8e9c53c0295e815b1c8ec695b7a6ae7318d Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Sat, 17 Nov 2018 07:59:57 -0500 Subject: [PATCH] adding new post-upgrade script --- Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql 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 new file mode 100644 index 0000000000..fad7c59a6b --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql @@ -0,0 +1,10 @@ +BEGIN; +INSERT INTO permission.grp_perm_map (grp, perm, depth) +VALUES ( + (SELECT id FROM permission.grp_tree WHERE name = 'Staff'), -- name may vary + (SELECT id FROM permission.perm_list WHERE code = 'APPLY_WORKSTATION_SETTING'), + 0 -- or 1, 2, etc. +); + + +COMMIT; -- 2.11.0