From 431d6372122256e1f7b8f7e893f32c6b64a42181 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Thu, 25 Feb 2016 19:30:05 -0500 Subject: [PATCH] LP#1527342 Stamping upgrade script decouple checkout history Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ouple_co_history.sql => 0960.schema.decouple_co_history.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.decouple_co_history.sql => 0960.schema.decouple_co_history.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 7f1921638d..12d93f9e4e 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 ('0959', :eg_version); -- csharp/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0960', :eg_version); -- berick/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql b/Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql rename to Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql index 889ab3f416..5fc0fed9f2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.decouple_co_history.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql @@ -4,7 +4,7 @@ BEGIN; -- TODO process to delete history items once the age threshold -- history.circ.retention_age is reached? --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0960', :eg_version); CREATE TABLE action.usr_circ_history ( id BIGSERIAL PRIMARY KEY, -- 2.43.2