From 80d6dcd0ae99e34627695ff1b410064e083526b5 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 12 Apr 2021 11:45:28 -0400 Subject: [PATCH] update version-upgrade script for 3.7-rc Signed-off-by: Galen Charlton --- ...-upgrade-db.sql => 3.6.2-3.7-rc-upgrade-db.sql} | 26 +++++++++++++++++++--- 1 file changed, 23 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/version-upgrade/{3.6.2-3.7-beta-upgrade-db.sql => 3.6.2-3.7-rc-upgrade-db.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-beta-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-rc-upgrade-db.sql similarity index 97% rename from Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-beta-upgrade-db.sql rename to Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-rc-upgrade-db.sql index b06b9d870a..86595b1154 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-beta-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.6.2-3.7-rc-upgrade-db.sql @@ -1,7 +1,7 @@ ---Upgrade Script for 3.6.2 to 3.7-beta -\set eg_version '''3.7-beta''' +--Upgrade Script for 3.6.2 to 3.7-rc +\set eg_version '''3.7-rc''' BEGIN; -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.7-beta', :eg_version); +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.7-rc', :eg_version); SELECT evergreen.upgrade_deps_block_check('1247', :eg_version); @@ -1374,6 +1374,26 @@ UPDATE config.metabib_field SET xpath = '//*[@tag=''260'' or @tag=''264''][1]' WHERE id = 52 AND xpath = '//*[@tag=''260'']'; +SELECT evergreen.upgrade_deps_block_check('1259', :eg_version); + +INSERT INTO action_trigger.environment (event_def,path) +SELECT id,'items' from action_trigger.event_definition WHERE name='biblio.record_entry.print.full' +AND NOT EXISTS (SELECT 1 FROM action_trigger.environment WHERE +event_def=(SELECT id FROM action_trigger.event_definition WHERE name ='biblio.record_entry.print.full' AND owner=1 LIMIT 1) +AND path='items'); + +INSERT INTO action_trigger.environment (event_def,path) +SELECT id,'items' from action_trigger.event_definition WHERE name='biblio.record_entry.email.full' +AND NOT EXISTS (SELECT 1 FROM action_trigger.environment WHERE +event_def=(SELECT id FROM action_trigger.event_definition WHERE name ='biblio.record_entry.email.full' AND owner=1 LIMIT 1) +AND path='items'); + +INSERT INTO action_trigger.environment (event_def,path) +SELECT id,'owner' from action_trigger.event_definition WHERE name='biblio.record_entry.email.full' +AND NOT EXISTS (SELECT 1 FROM action_trigger.environment WHERE +event_def=(SELECT id FROM action_trigger.event_definition WHERE name ='biblio.record_entry.email.full' AND owner=1 LIMIT 1) +AND path='owner'); + COMMIT; -- Update auditor tables to catch changes to source tables. -- 2.11.0