From 45f748301aa6c5f1bca8e942cf88098fe79d9af6 Mon Sep 17 00:00:00 2001 From: Jake Litrell Date: Tue, 23 Feb 2016 20:18:48 -0500 Subject: [PATCH] Adding Electronic to seed values; adding upgrade script. --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 12 ++++++++++++ .../src/sql/Pg/upgrade/XXX.data.electronic-resources.sql | 16 ++++++++++++++++ 2 files changed, 28 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXX.data.electronic-resources.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index ee87ff59f5..b7ce2606ec 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -7047,6 +7047,13 @@ INSERT INTO config.coded_value_map oils_i18n_gettext(633, 'Blu-ray', 'ccvm', 'value'), oils_i18n_gettext(633, 'Blu-ray', 'ccvm', 'search_label')); +-- Electronic search format, not opac_visible +INSERT INTO config.coded_value_map + (id, ctype, code, value, opac_visible, search_label) VALUES +(712, 'search_format', 'electronic', FALSE, + oils_i18n_gettext(712, 'Electronic', 'ccvm', 'value'), + oils_i18n_gettext(712, 'Electronic', 'ccvm', 'search_label')); + -- RDA content type, media type, and carrier type INSERT INTO config.coded_value_map (id, ctype, code, value, concept_uri) VALUES (634, 'content_type', 'two-dimensional moving image', @@ -7444,6 +7451,11 @@ INSERT INTO config.composite_attr_entry_definition INSERT INTO config.composite_attr_entry_definition (coded_value, definition) VALUES (608, '{"_attr":"vr_format","_val":"s"}'); +-- electronic +INSERT INTO config.composite_attr_entry_definition + (coded_value, definition) VALUES +(712, '{"_attr":"item_form","_val":"s"},{"_attr":"item_form","_val":"o"}'); + -- use the definitions from the icon_format as the basis for the MR hold format definitions DO $$ DECLARE format TEXT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX.data.electronic-resources.sql b/Open-ILS/src/sql/Pg/upgrade/XXX.data.electronic-resources.sql new file mode 100644 index 0000000000..580547b362 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXX.data.electronic-resources.sql @@ -0,0 +1,16 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXX', :eg_version); + +INSERT INTO config.coded_value_map + (id, ctype, code, value, opac_visible, search_label) VALUES +(712, 'search_format', 'electronic', FALSE, + oils_i18n_gettext(712, 'Electronic', 'ccvm', 'value'), + oils_i18n_gettext(712, 'Electronic', 'ccvm', 'search_label')); + +INSERT INTO config.composite_attr_entry_definition + (coded_value, definition) VALUES +(712, '{"_attr":"item_form","_val":"s"},{"_attr":"item_form","_val":"o"}'); + + +COMMIT; -- 2.11.0