From 472bdf0dc614f136be11e244a7672a5ca9a70aba Mon Sep 17 00:00:00 2001 From: Galen Charlton <gmc@equinoxinitiative.org> Date: Fri, 6 Sep 2019 11:20:45 -0400 Subject: [PATCH] LP#1816475: stamp DB updates Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org> --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...{XXXX.schema.add_note_bresv.sql => 1176.schema.add_note_bresv.sql} | 2 ++ ...king-sticky-settings.sql => 1177.data.booking-sticky-settings.sql} | 4 +++- 3 files changed, 6 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.add_note_bresv.sql => 1176.schema.add_note_bresv.sql} (53%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.booking-sticky-settings.sql => 1177.data.booking-sticky-settings.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 12db6e1c8b..0d567843ab 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 ('1175', :eg_version); -- gmcharlt/berick/miker/sandbergja +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1177', :eg_version); -- sandberja/cburns/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add_note_bresv.sql b/Open-ILS/src/sql/Pg/upgrade/1176.schema.add_note_bresv.sql similarity index 53% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add_note_bresv.sql rename to Open-ILS/src/sql/Pg/upgrade/1176.schema.add_note_bresv.sql index 4742f1d9a4..a6e84ed09b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.add_note_bresv.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1176.schema.add_note_bresv.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1176', :eg_version); + ALTER TABLE booking.reservation ADD COLUMN note TEXT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.booking-sticky-settings.sql b/Open-ILS/src/sql/Pg/upgrade/1177.data.booking-sticky-settings.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.booking-sticky-settings.sql rename to Open-ILS/src/sql/Pg/upgrade/1177.data.booking-sticky-settings.sql index 8da02ed13b..55622d3dff 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.booking-sticky-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1177.data.booking-sticky-settings.sql @@ -1,5 +1,7 @@ BEGIN; ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1177', :eg_version); + INSERT INTO config.workstation_setting_type (name, grp, datatype, label) VALUES ( 'eg.grid.booking.manage', 'gui', 'object', -- 2.11.0