From b985c79a170c2ea06feffd87444d0a441b1f270d Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 25 May 2017 09:31:27 -0400 Subject: [PATCH] LP#1687971: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../Pg/upgrade/1042.schema.asset.copy_location.url.sql | 8 ++++++++ .../src/sql/Pg/upgrade/XXXX.asset.copy_location.url.sql | 6 ------ 3 files changed, 9 insertions(+), 7 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1042.schema.asset.copy_location.url.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.asset.copy_location.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 f8091f09e3..da3a39d442 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('1041', :eg_version); -- stompro/csharp/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1042', :eg_version); -- mmorgan/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1042.schema.asset.copy_location.url.sql b/Open-ILS/src/sql/Pg/upgrade/1042.schema.asset.copy_location.url.sql new file mode 100644 index 0000000000..7224ecc7d1 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1042.schema.asset.copy_location.url.sql @@ -0,0 +1,8 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1042', :eg_version); -- mmorgan/gmcharlt + +ALTER TABLE asset.copy_location + ADD COLUMN url TEXT; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.asset.copy_location.url.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.asset.copy_location.url.sql deleted file mode 100644 index 6851669ff3..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.asset.copy_location.url.sql +++ /dev/null @@ -1,6 +0,0 @@ -BEGIN; - -ALTER TABLE asset.copy_location - ADD COLUMN url TEXT; - -COMMIT; -- 2.43.2