From 94f48dee43aeeb1e2a74517181ce34b8e7e53ef8 Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Thu, 26 Jan 2012 11:35:53 -0500 Subject: [PATCH] Don't index "All Subjects" (the subject|complete field) for browse/suggest It's redundant. Credit Miker. Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 4 ++-- Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib_autosuggest.sql | 3 ++- 2 files changed, 4 insertions(+), 3 deletions(-) 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 55d189981f..ef53fbf673 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -143,8 +143,8 @@ INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, -- ( id, field_class, name, xpath ) VALUES ( 'subject', 'genre', 'mods32', $$//mods32:mods/mods32:genre$$ ); INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, browse_field ) VALUES (15, 'keyword', 'keyword', oils_i18n_gettext(15, 'General Keywords', 'cmf', 'label'), 'mods32', $$//mods32:mods/*[not(local-name()='originInfo')]$$, FALSE ); -- /* to fool vim */; -INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath ) VALUES - (16, 'subject', 'complete', oils_i18n_gettext(16, 'All Subjects', 'cmf', 'label'), 'mods32', $$//mods32:mods/mods32:subject$$ ); +INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, browse_field ) VALUES + (16, 'subject', 'complete', oils_i18n_gettext(16, 'All Subjects', 'cmf', 'label'), 'mods32', $$//mods32:mods/mods32:subject$$, FALSE ); INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath ) VALUES (17, 'identifier', 'accession', oils_i18n_gettext(17, 'Accession Number', 'cmf', 'label'), 'marcxml', $$//marc:controlfield[@tag='001']$$ ); diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib_autosuggest.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib_autosuggest.sql index 5099f1d7cf..896cca265f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib_autosuggest.sql +++ b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.bib_autosuggest.sql @@ -36,7 +36,8 @@ ALTER TABLE config.metabib_field ADD COLUMN restrict BOOLEAN DEFAULT FALSE NOT N -- one good exception to default true: UPDATE config.metabib_field SET browse_field = FALSE - WHERE field_class = 'keyword' AND name = 'keyword'; + WHERE (field_class = 'keyword' AND name = 'keyword') OR + (field_class = 'subject' AND name = 'complete'); -- AFTER UPDATE OR INSERT trigger for biblio.record_entry -- We're only touching it here to add a DELETE statement to the IF NEW.deleted -- 2.11.0