From ebdd2b423a3d6d57601bc353d9ce6e23747ad5cd Mon Sep 17 00:00:00 2001 From: gmc Date: Tue, 20 Jul 2010 22:36:06 +0000 Subject: [PATCH] set truncation to 1 for all biblios.net Z39.50 attributes Thanks to Anoop Atre for spotting the problem. Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/trunk@16993 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 5 +++-- Open-ILS/src/sql/Pg/upgrade/0345.data.biblios-truncation.sql | 7 +++++++ 3 files changed, 11 insertions(+), 3 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0345.data.biblios-truncation.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6c92fac02..53b3e6816 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,7 +68,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0344'); -- berick +INSERT INTO config.upgrade_log (version) VALUES ('0345'); -- gmc CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, 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 0340144c8..ebdaee392 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -894,8 +894,8 @@ INSERT INTO config.z3950_attr (id, source, name, label, code, format) VALUES (21, 'biblios', 'lccn', oils_i18n_gettext(21, 'LCCN', 'cza', 'label'), 9, 1); INSERT INTO config.z3950_attr (id, source, name, label, code, format) VALUES (22, 'biblios', 'author', oils_i18n_gettext(22, 'Author', 'cza', 'label'), 1003, 6); -INSERT INTO config.z3950_attr (id, source, name, label, code, format, truncation) - VALUES (23, 'biblios', 'title', oils_i18n_gettext(23, 'Title', 'cza', 'label'), 4, 6, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (23, 'biblios', 'title', oils_i18n_gettext(23, 'Title', 'cza', 'label'), 4, 6); INSERT INTO config.z3950_attr (id, source, name, label, code, format) VALUES (24, 'biblios', 'issn', oils_i18n_gettext(24, 'ISSN', 'cza', 'label'), 8, 1); INSERT INTO config.z3950_attr (id, source, name, label, code, format) @@ -905,6 +905,7 @@ INSERT INTO config.z3950_attr (id, source, name, label, code, format) INSERT INTO config.z3950_attr (id, source, name, label, code, format) VALUES (27, 'biblios', 'item_type', oils_i18n_gettext(27, 'Item Type', 'cza', 'label'), 1001, 1); +UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'biblios'; SELECT SETVAL('config.z3950_attr_id_seq'::TEXT, 100); diff --git a/Open-ILS/src/sql/Pg/upgrade/0345.data.biblios-truncation.sql b/Open-ILS/src/sql/Pg/upgrade/0345.data.biblios-truncation.sql new file mode 100644 index 000000000..e1ed5f73d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0345.data.biblios-truncation.sql @@ -0,0 +1,7 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0345'); --gmc + +UPDATE config.z3950_attr SET truncation = 1 WHERE source = 'biblios' AND truncation = 0; + +COMMIT; -- 2.11.0