From 1934d49521b7e10daa8094757d8fe33e28dc15d4 Mon Sep 17 00:00:00 2001
From: Mike Rylander <mrylander@gmail.com>
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 <mrylander@gmail.com>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
...bib-bucket-type.sql => 0652.data.vandelay-queue-bib-bucket-type.sql} | 2 +-
...pi-indb-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.11.0