From 1934d49521b7e10daa8094757d8fe33e28dc15d4 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 17 Nov 2011 14:46:41 -0500 Subject: [PATCH] Stamp upgrade scripts for both unapi update and vandelay-to-bucket Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...et-type.sql => 0652.data.vandelay-queue-bib-bucket-type.sql} | 2 +- ...optional-org.sql => 0653.schema.unapi-indb-optional-org.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.vandelay-queue-bib-bucket-type.sql => 0652.data.vandelay-queue-bib-bucket-type.sql} (82%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.unapi-indb-optional-org.sql => 0653.schema.unapi-indb-optional-org.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 046a08edea..9930af5dfb 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0651', :eg_version); -- berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0653', :eg_version); -- berick/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-queue-bib-bucket-type.sql b/Open-ILS/src/sql/Pg/upgrade/0652.data.vandelay-queue-bib-bucket-type.sql similarity index 82% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-queue-bib-bucket-type.sql rename to Open-ILS/src/sql/Pg/upgrade/0652.data.vandelay-queue-bib-bucket-type.sql index ef2ffd8266..f3beb44e76 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.vandelay-queue-bib-bucket-type.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0652.data.vandelay-queue-bib-bucket-type.sql @@ -3,7 +3,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0652', :eg_version); INSERT INTO container.biblio_record_entry_bucket_type (code, label) VALUES ( 'vandelay_queue', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.unapi-indb-optional-org.sql b/Open-ILS/src/sql/Pg/upgrade/0653.schema.unapi-indb-optional-org.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.unapi-indb-optional-org.sql rename to Open-ILS/src/sql/Pg/upgrade/0653.schema.unapi-indb-optional-org.sql index b9212cb603..beb06f3754 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.unapi-indb-optional-org.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0653.schema.unapi-indb-optional-org.sql @@ -2,7 +2,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0653', :eg_version); CREATE OR REPLACE FUNCTION evergreen.org_top() RETURNS SETOF actor.org_unit AS $$ SELECT * FROM actor.org_unit WHERE parent_ou IS NULL LIMIT 1; $$ LANGUAGE SQL ROWS 1; -- 2.43.2