From 40b5853bd226041d991c0c356db2e6d016bf2410 Mon Sep 17 00:00:00 2001 From: Jane Sandberg Date: Wed, 4 Sep 2019 11:11:43 -0700 Subject: [PATCH] LP1832897 and LP1721036: stamping upgrade scripts Signed-off-by: Jane Sandberg --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../src/sql/Pg/upgrade/1174.schema.asset.copy_tag.url.sql | 8 ++++++++ ...XXX.schema.carousels.sql => 1175.schema.carousels.sql} | 2 +- .../src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql | 8 -------- 4 files changed, 10 insertions(+), 10 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1174.schema.asset.copy_tag.url.sql rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.carousels.sql => 1175.schema.carousels.sql} (97%) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 8afa76e79f..12db6e1c8b 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 ('1173', :eg_version); -- berick/khuckins/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1175', :eg_version); -- gmcharlt/berick/miker/sandbergja CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1174.schema.asset.copy_tag.url.sql b/Open-ILS/src/sql/Pg/upgrade/1174.schema.asset.copy_tag.url.sql new file mode 100644 index 0000000000..700d355c43 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1174.schema.asset.copy_tag.url.sql @@ -0,0 +1,8 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1174', :eg_version); + +ALTER TABLE asset.copy_tag + ADD COLUMN url TEXT; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.carousels.sql b/Open-ILS/src/sql/Pg/upgrade/1175.schema.carousels.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.carousels.sql rename to Open-ILS/src/sql/Pg/upgrade/1175.schema.carousels.sql index 9dd366952e..5ea5acf4ff 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.carousels.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1175.schema.carousels.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1175', :eg_version); CREATE TABLE config.carousel_type ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql deleted file mode 100644 index b7b26ceb09..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.asset.copy_tag.url.sql +++ /dev/null @@ -1,8 +0,0 @@ -BEGIN; - ---INSERT INTO config.upgrade_log (version, applied_to) VALUES ('XXXX', :eg_version); - -ALTER TABLE asset.copy_tag - ADD COLUMN url TEXT; - -COMMIT; -- 2.43.2