From 647710dbdbd153b7d06ecfcc36ddcf97a933851a Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 4 Sep 2018 13:32:46 -0400 Subject: [PATCH] LP#1776020: stamp database update Signed-off-by: Galen Charlton --- 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