From f93b9f4d5b8778993ceefc1b9163a2ec8bc28313 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 11 Mar 2013 17:45:23 -0400 Subject: [PATCH 1/1] Stamping upgrade for "exclude_invisible_acn" unapi holdings filter Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ible_acn.sql => 0769.schema.unapi_exclude_invisible_acn.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXX.schema.unapi_exclude_invisible_acn.sql => 0769.schema.unapi_exclude_invisible_acn.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 9ad2ba51f7..9acacb1604 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('0768', :eg_version); -- berick/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0769', :eg_version); -- berick/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX.schema.unapi_exclude_invisible_acn.sql b/Open-ILS/src/sql/Pg/upgrade/0769.schema.unapi_exclude_invisible_acn.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXX.schema.unapi_exclude_invisible_acn.sql rename to Open-ILS/src/sql/Pg/upgrade/0769.schema.unapi_exclude_invisible_acn.sql index cae52166c0..7bef743f4f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXX.schema.unapi_exclude_invisible_acn.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0769.schema.unapi_exclude_invisible_acn.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0769', :eg_version); + DROP FUNCTION IF EXISTS evergreen.ranked_volumes(BIGINT, INT, INT, HSTORE, HSTORE, INT); -- 2.43.2