From 894694aee327ae0700ea3ef84190497675ec9bff Mon Sep 17 00:00:00 2001
From: Jason Etheridge <jason@EquinoxInitiative.org>
Date: Tue, 27 Nov 2018 00:34:44 -0500
Subject: [PATCH] LP#1714070 Stamping upgrade script
Signed-off-by: Jason Etheridge <jason@EquinoxInitiative.org>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
...{XXXX.schema.patron-guardian.sql => 1139.schema.patron-guardian.sql} | 2 ++
2 files changed, 3 insertions(+), 1 deletion(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.patron-guardian.sql => 1139.schema.patron-guardian.sql} (98%)
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index b50f39d2bd..fa9a8bbe28 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -92,7 +92,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 ('1138', :eg_version); -- rhamby/berick/bshum
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1139', :eg_version); -- berick/kmlussier/phasefx
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-guardian.sql b/Open-ILS/src/sql/Pg/upgrade/1139.schema.patron-guardian.sql
similarity index 98%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-guardian.sql
rename to Open-ILS/src/sql/Pg/upgrade/1139.schema.patron-guardian.sql
index c63e1ceee8..06c12e77a8 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-guardian.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1139.schema.patron-guardian.sql
@@ -1,6 +1,8 @@
BEGIN;
+SELECT evergreen.upgrade_deps_block_check('1139', :eg_version);
+
ALTER TABLE actor.usr ADD COLUMN guardian TEXT;
CREATE INDEX actor_usr_guardian_idx
--
2.11.0