From 30fa94a8d64250e336b4f2b56b2901414fcc6323 Mon Sep 17 00:00:00 2001
From: Thomas Berezansky <tsbere@mvlc.org>
Date: Tue, 18 Oct 2011 10:07:08 -0400
Subject: [PATCH] Stamping upgrade script for LP#847973
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
...ing_json_check.sql => 0641.schema.org_unit_setting_json_check.sql} | 4 ++--
2 files changed, 3 insertions(+), 3 deletions(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.org_unit_setting_json_check.sql => 0641.schema.org_unit_setting_json_check.sql} (56%)
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 946150d02b..acccf52f37 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 ('0640', :eg_version); -- miker/lebbeous/berick
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0641', :eg_version); -- tsbere/phasefx
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_unit_setting_json_check.sql b/Open-ILS/src/sql/Pg/upgrade/0641.schema.org_unit_setting_json_check.sql
similarity index 56%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_unit_setting_json_check.sql
rename to Open-ILS/src/sql/Pg/upgrade/0641.schema.org_unit_setting_json_check.sql
index 0e96020bae..a23e154712 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_unit_setting_json_check.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/0641.schema.org_unit_setting_json_check.sql
@@ -1,10 +1,10 @@
--- Evergreen DB patch XXXX.schema.org_unit_setting_json_check.sql
+-- Evergreen DB patch 0641.schema.org_unit_setting_json_check.sql
--
--
BEGIN;
-- check whether patch can be applied
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
+SELECT evergreen.upgrade_deps_block_check('0641', :eg_version);
ALTER TABLE actor.org_unit_setting ADD CONSTRAINT aous_must_be_json CHECK ( evergreen.is_json(value) );
--
2.11.0