1 --Upgrade Script for 3.6.1 to 3.6.2
2 \set eg_version '''3.6.2'''
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.6.2', :eg_version);
6 SELECT evergreen.upgrade_deps_block_check('1243', :eg_version);
8 INSERT INTO config.workstation_setting_type (name, grp, datatype, fm_class, label)
10 'eg.orgselect.catalog.holdings', 'gui', 'link', 'aou',
12 'eg.orgselect.catalog.holdings',
13 'Default org unit for catalog holdings tab',
21 SELECT evergreen.upgrade_deps_block_check('1244', :eg_version);
23 -- In some cases, asset.copy_tag_copy_map might have an inh_fkey()
24 -- trigger that fires on delete when it's not supposed to. This
25 -- update drops all inh_fkey triggers on that table and recreates
26 -- the known good version.
27 DROP TRIGGER IF EXISTS inherit_asset_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
28 DROP TRIGGER IF EXISTS inherit_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
30 CREATE CONSTRAINT TRIGGER inherit_asset_copy_tag_copy_map_copy_fkey
31 AFTER UPDATE OR INSERT ON asset.copy_tag_copy_map
32 DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.asset_copy_tag_copy_map_copy_inh_fkey();
35 SELECT evergreen.upgrade_deps_block_check('1245', :eg_version);
37 INSERT INTO config.global_flag (name, value, enabled, label)
39 'auth.block_expired_staff_login',
43 'auth.block_expired_staff_login',
44 'Block the ability of expired user with the STAFF_LOGIN permission to log into Evergreen.',
50 SELECT evergreen.upgrade_deps_block_check('1246', :eg_version);
52 CREATE OR REPLACE VIEW money.open_with_balance_usr_summary AS
55 sum(total_paid) AS total_paid,
56 sum(total_owed) AS total_owed,
57 sum(balance_owed) AS balance_owed
58 FROM money.materialized_billable_xact_summary
59 WHERE xact_finish IS NULL AND balance_owed <> 0.0
64 -- Update auditor tables to catch changes to source tables.
65 -- Can be removed/skipped if there were no schema changes.
66 SELECT auditor.update_auditors();