From 48a1138206441465b524d8fa2ec0f329efd15767 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 6 Mar 2013 20:56:32 -0500 Subject: [PATCH] adding coded value map entries/changes --- .../Pg/version-upgrade/pines-post-upgrade-data.sql | 27 ++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-data.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-data.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-data.sql new file mode 100644 index 0000000000..8f7bc85592 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-data.sql @@ -0,0 +1,27 @@ +-- config.coded value maps changes +BEGIN; +-- remove opac visibility for unused types +UPDATE config.coded_value_map SET opac_visible = FALSE WHERE ctype = 'audience' AND code IN (' ', 'a', 'b', 'c', 'd', 'f', 'g'); +UPDATE config.coded_value_map SET opac_visible = FALSE WHERE ctype = 'item_form' AND code IN ('a', 'b','c', 'r', 's'); +UPDATE config.coded_value_map SET opac_visible = FALSE WHERE ctype = 'item_type' AND code IN ('a', 'c', 'd', 'e', 'f', 'k', 'o', 'p', 'r', 't'); +UPDATE config.coded_value_map SET opac_visible = FALSE WHERE ctype = 'lit_form' AND code IN ('0', '1', 'c', 'd', 'e', 'f', 'h', 'i', 'j', 'm', 'p', 's', 'u'); +UPDATE config.coded_value_map SET opac_visible = FALSE WHERE ctype = 'vr_format' AND code IN ('a', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'm', 'o', 'p', 'q', 'u', 'z'); + +-- set most commonly-used languages as "simple" selectors +UPDATE config.coded_value_map SET is_simple = TRUE WHERE ctype = 'item_lang' AND code IN ('chi', 'eng', 'fre', 'ger', 'hin', 'ita', 'jpn', 'kor', 'lat', 'por', 'rus', 'spa'); + +-- add user-friendly search labels for certain types + +-- add new types +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_type', 'a,t', 'Books'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_type', 'e,f', 'Maps'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_type', 'o,p', 'Kits'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_type', 'c,d', 'Scores/Sheet Music'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_type', 'k,r', 'Other Formats'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'lit_form', '0,c,d,e,h,i,m,p,s,u', 'Nonfiction'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'lit_form', '1,f,j,u', 'Fiction'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'vr_format', 'a,c,d,e,f,g,h,i,j,k,m,o,p,q,u,z', 'Other Formats'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_form', 'a,b,c', 'Microform'; +INSERT INTO config.coded_value_map (ctype, code, value) VALUES 'item_form', 's,q,o', 'Electronic Resources'; + +COMMIT; -- 2.11.0