From 644b37b8c859e1e621dbe494b8df3b6745e3e5e2 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 16 Feb 2017 15:43:21 -0500 Subject: [PATCH] schema update script for 2.10.10 Signed-off-by: Galen Charlton --- .../Pg/version-upgrade/2.10.9-2.10.10-upgrade-db.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.10.9-2.10.10-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.10.9-2.10.10-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.10.9-2.10.10-upgrade-db.sql new file mode 100644 index 0000000000..92ef8b3fc1 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.10.9-2.10.10-upgrade-db.sql @@ -0,0 +1,17 @@ +--Upgrade Script for 2.10.9 to 2.10.10 +\set eg_version '''2.10.10''' +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1018', :eg_version); + +UPDATE config.org_unit_setting_type + SET view_perm = (SELECT id FROM permission.perm_list + WHERE code = 'VIEW_CREDIT_CARD_PROCESSING' LIMIT 1) + WHERE name LIKE 'credit.processor.stripe%' AND view_perm IS NULL; + +UPDATE config.org_unit_setting_type + SET update_perm = (SELECT id FROM permission.perm_list + WHERE code = 'ADMIN_CREDIT_CARD_PROCESSING' LIMIT 1) + WHERE name LIKE 'credit.processor.stripe%' AND update_perm IS NULL; + +COMMIT; -- 2.11.0