From 647710dbdbd153b7d06ecfcc36ddcf97a933851a Mon Sep 17 00:00:00 2001
From: Galen Charlton <gmc@equinoxinitiative.org>
Date: Tue, 4 Sep 2018 13:32:46 -0400
Subject: [PATCH] LP#1776020: stamp database update
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
....schema.patron-alt-name.sql => 1122.schema.patron-alt-name.sql} | 7 ++-----
2 files changed, 3 insertions(+), 6 deletions(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.patron-alt-name.sql => 1122.schema.patron-alt-name.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 d975d9a31d..43c190361c 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 ('1121', :eg_version); -- khuckins/berick/kmlussier
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1122', :eg_version); -- berick/kmlussier/gmcharlt
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-alt-name.sql b/Open-ILS/src/sql/Pg/upgrade/1122.schema.patron-alt-name.sql
similarity index 99%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-alt-name.sql
rename to Open-ILS/src/sql/Pg/upgrade/1122.schema.patron-alt-name.sql
index 9fb27264ed..0d2eca71b5 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron-alt-name.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1122.schema.patron-alt-name.sql
@@ -1,10 +1,7 @@
-
-/**
-update patron merge
-*/
-
BEGIN;
+SELECT evergreen.upgrade_deps_block_check('1122', :eg_version);
+
ALTER TABLE actor.usr
ADD COLUMN pref_prefix TEXT,
ADD COLUMN pref_first_given_name TEXT,
--
2.11.0