From c41d389b2350bf0a1001de50a8f19c1ecc269822 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 16 Nov 2016 14:55:02 -0500 Subject: [PATCH] LP#1488655: stamp schema upgrade script Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...etarecord_remapping.sql => 1003.schema.fix_metarecord_remapping.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.fix_metarecord_remapping.sql => 1003.schema.fix_metarecord_remapping.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 3dd8317fd4..a9a4de19cc 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 ('1002', :eg_version); -- gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1003', :eg_version); -- gmcharlt/rhamby/csharp CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_metarecord_remapping.sql b/Open-ILS/src/sql/Pg/upgrade/1003.schema.fix_metarecord_remapping.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_metarecord_remapping.sql rename to Open-ILS/src/sql/Pg/upgrade/1003.schema.fix_metarecord_remapping.sql index 62d978154c..cfe7b83219 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_metarecord_remapping.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1003.schema.fix_metarecord_remapping.sql @@ -1,6 +1,6 @@ BEGIN; ---- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1003', :eg_version); -- gmcharlt/rhamby/csharp CREATE OR REPLACE FUNCTION metabib.remap_metarecord_for_bib( bib_id BIGINT, fp TEXT, bib_is_deleted BOOL DEFAULT FALSE, retain_deleted BOOL DEFAULT FALSE ) RETURNS BIGINT AS $func$ DECLARE -- 2.11.0