From fc5f7714c978fd7a5b5c4ce77d6a993e10dd6ccf Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Sun, 8 Apr 2012 21:32:25 -0400 Subject: [PATCH] Stamp tpac value maps upgrade script Signed-off-by: Thomas Berezansky --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.tpac_value_maps.sql => 0703.tpac_value_maps.sql} | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.tpac_value_maps.sql => 0703.tpac_value_maps.sql} (51%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index e32fda37c7..c6cdb04e50 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,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 ('0702', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0703', :eg_version); -- tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_value_maps.sql b/Open-ILS/src/sql/Pg/upgrade/0703.tpac_value_maps.sql similarity index 51% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_value_maps.sql rename to Open-ILS/src/sql/Pg/upgrade/0703.tpac_value_maps.sql index 6172f5ebe7..ca10969c55 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_value_maps.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0703.tpac_value_maps.sql @@ -1,4 +1,12 @@ +-- Evergreen DB patch 0703.tpac_value_maps.sql +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0703', :eg_version); + ALTER TABLE config.coded_value_map ADD COLUMN opac_visible BOOL NOT NULL DEFAULT TRUE, ADD COLUMN search_label TEXT, ADD COLUMN is_simple BOOL NOT NULL DEFAULT FALSE; + +COMMIT; -- 2.11.0