From 922158c02a8953816c96c6af535e92118ccd94f5 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 31 Oct 2016 13:21:20 -0400 Subject: [PATCH] PINES already has 0977 applied, so comment it out. --- Open-ILS/src/sql/Pg/version-upgrade/2.10.1-2.10.2-upgrade-db.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.10.1-2.10.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.10.1-2.10.2-upgrade-db.sql index 535b1a8466..1c285a2967 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.10.1-2.10.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.10.1-2.10.2-upgrade-db.sql @@ -13,10 +13,12 @@ CREATE TRIGGER action_usr_circ_history_target_copy_trig AFTER INSERT OR UPDATE ON action.usr_circ_history FOR EACH ROW EXECUTE PROCEDURE evergreen.fake_fkey_tgr('target_copy'); -SELECT evergreen.upgrade_deps_block_check('0977', :eg_version); -- Callender/Dyrcona/gmcharlt +-- PINES already has 0977 -ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique"; -CREATE UNIQUE INDEX record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE; +-- SELECT evergreen.upgrade_deps_block_check('0977', :eg_version); -- Callender/Dyrcona/gmcharlt +-- +-- ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique"; +-- CREATE UNIQUE INDEX record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE; SELECT evergreen.upgrade_deps_block_check('0978', :eg_version); -- 2.11.0