From 81d720fefe89c2a9a38b9658a44a3b0bf69cee4a Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Fri, 21 Feb 2014 15:58:50 -0500 Subject: [PATCH] Stamping 0864-0867 for MVF, CRA, and TPAC MRs That is, Multi-valued Fields, Composite Record Attibutes, and TPAC Metarecord support. Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{QQQQ.MVF_CRA-upgrade.sql => 0864.MVF_CRA-upgrade.sql} | 2 ++ ..._formats.sql => 0865.schema.convert-MR-holdable_formats.sql} | 2 ++ .../{ZZZZ.schema.unapi-mmr.sql => 0866.schema.unapi-mmr.sql} | 2 ++ ...ta.mmr-holds-formats.sql => 0867.data.mmr-holds-formats.sql} | 2 ++ 5 files changed, 9 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{QQQQ.MVF_CRA-upgrade.sql => 0864.MVF_CRA-upgrade.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.convert-MR-holdable_formats.sql => 0865.schema.convert-MR-holdable_formats.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.unapi-mmr.sql => 0866.schema.unapi-mmr.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZZ.data.mmr-holds-formats.sql => 0867.data.mmr-holds-formats.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index e165f06e21..6900d1bd5b 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0863', :eg_version); -- senator/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0867', :eg_version); -- miker/berick/dbwells CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql rename to Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql index b0d17702eb..4adbde77fe 100644 --- a/Open-ILS/src/sql/Pg/upgrade/QQQQ.MVF_CRA-upgrade.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0864.MVF_CRA-upgrade.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0864', :eg_version); + CREATE EXTENSION intarray; -- while we have this opportunity, and before we start collecting diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.convert-MR-holdable_formats.sql b/Open-ILS/src/sql/Pg/upgrade/0865.schema.convert-MR-holdable_formats.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.convert-MR-holdable_formats.sql rename to Open-ILS/src/sql/Pg/upgrade/0865.schema.convert-MR-holdable_formats.sql index b2e4028dc2..166460f59f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.convert-MR-holdable_formats.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0865.schema.convert-MR-holdable_formats.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0865', :eg_version); + -- First, explode the field into constituent parts WITH format_parts_array AS ( SELECT a.id, diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql b/Open-ILS/src/sql/Pg/upgrade/0866.schema.unapi-mmr.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql rename to Open-ILS/src/sql/Pg/upgrade/0866.schema.unapi-mmr.sql index 20889b1c21..9d707dd29e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.unapi-mmr.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0866.schema.unapi-mmr.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0866', :eg_version); + DROP FUNCTION asset.record_has_holdable_copy (BIGINT); CREATE FUNCTION asset.record_has_holdable_copy ( rid BIGINT, ou INT DEFAULT NULL) RETURNS BOOL AS $f$ BEGIN diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZZ.data.mmr-holds-formats.sql b/Open-ILS/src/sql/Pg/upgrade/0867.data.mmr-holds-formats.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZZ.data.mmr-holds-formats.sql rename to Open-ILS/src/sql/Pg/upgrade/0867.data.mmr-holds-formats.sql index 5c11a875f1..48fa0efc37 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZZ.data.mmr-holds-formats.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0867.data.mmr-holds-formats.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0867', :eg_version); + INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( 'opac.metarecord.holds.format_attr', oils_i18n_gettext( -- 2.43.2