From 2c2df1e1ad80d219b14de106e9d76d3cac0c5ce5 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Thu, 26 Jun 2014 15:30:26 -0400 Subject: [PATCH] LP#925776 Stamping upgrade script for staff uri visibility Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...taff-uri-visibility.sql => 0882.function.staff-uri-visibility.sql} | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.staff-uri-visibility.sql => 0882.function.staff-uri-visibility.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 231f1bec13..083016c65b 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 ('0881', :eg_version); -- phasefx/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0882', :eg_version); -- miker/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.staff-uri-visibility.sql b/Open-ILS/src/sql/Pg/upgrade/0882.function.staff-uri-visibility.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.staff-uri-visibility.sql rename to Open-ILS/src/sql/Pg/upgrade/0882.function.staff-uri-visibility.sql index 6a5466bdd7..65895e84a0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.staff-uri-visibility.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0882.function.staff-uri-visibility.sql @@ -1,3 +1,6 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0882', :eg_version); CREATE OR REPLACE FUNCTION search.query_parser_fts ( @@ -364,3 +367,4 @@ BEGIN END; $func$ LANGUAGE PLPGSQL; +COMMIT; -- 2.11.0