Schema Changes: 3.6.2

INSERT INTO config.workstation_setting_type (name, grp, datatype, fm_class, label)
VALUES (
    'eg.orgselect.catalog.holdings', 'gui', 'link', 'aou',
    oils_i18n_gettext(
        'eg.orgselect.catalog.holdings',
        'Default org unit for catalog holdings tab',
        'cwst', 'label'
    )
);

-- In some cases, asset.copy_tag_copy_map might have an inh_fkey()
-- trigger that fires on delete when it's not supposed to. This
-- update drops all inh_fkey triggers on that table and recreates
-- the known good version.
DROP TRIGGER IF EXISTS inherit_asset_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;
DROP TRIGGER IF EXISTS inherit_copy_tag_copy_map_copy_fkey ON asset.copy_tag_copy_map;

CREATE CONSTRAINT TRIGGER inherit_asset_copy_tag_copy_map_copy_fkey
        AFTER UPDATE OR INSERT ON asset.copy_tag_copy_map
        DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE evergreen.asset_copy_tag_copy_map_copy_inh_fkey();

INSERT INTO config.global_flag (name, value, enabled, label)
VALUES (
    'auth.block_expired_staff_login',
    NULL,
    FALSE,
    oils_i18n_gettext(
        'auth.block_expired_staff_login',
        'Block the ability of expired user with the STAFF_LOGIN permission to log into Evergreen.',
        'cgf', 'label'
    )
);

CREATE OR REPLACE VIEW money.open_with_balance_usr_summary AS
    SELECT
        usr,
        sum(total_paid) AS total_paid,
        sum(total_owed) AS total_owed,
        sum(balance_owed) AS balance_owed
    FROM money.materialized_billable_xact_summary
    WHERE xact_finish IS NULL AND balance_owed <> 0.0
    GROUP BY usr;