From 9e643427e702a085c8af6d18ce8dfca104d9ff81 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 3 Dec 2010 21:35:39 +0000 Subject: [PATCH] Moving bits around and protecting against a pre-existing subject|complete index definition that some sites have git-svn-id: svn://svn.open-ils.org/ILS/trunk@18920 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index b4a31ed133..8beae96586 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -15020,7 +15020,6 @@ INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('eg.subject' INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('dc.subject','subject'); INSERT INTO config.metabib_search_alias (alias,field_class,field) VALUES ('bib.subjectplace','subject',11); INSERT INTO config.metabib_search_alias (alias,field_class,field) VALUES ('bib.subjectname','subject',12); -INSERT INTO config.metabib_search_alias (alias,field_class,field) VALUES ('bib.subjectoccupation','subject',16); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('se','series'); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('eg.series','series'); @@ -15503,8 +15502,9 @@ CREATE INDEX scecm_owning_copy_idx ON asset.stat_cat_entry_copy_map(owning_copy) INSERT INTO config.metabib_class ( name, label ) VALUES ( 'identifier', oils_i18n_gettext('identifier', 'Identifier', 'cmc', 'name') ); -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//text()$$ ); +INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath ) + SELECT 16, 'subject', 'complete', oils_i18n_gettext(16, 'All Subjects', 'cmf', 'label'), 'mods32', $$//mods32:mods/mods32:subject//text()$$ + WHERE NOT EXISTS (select id from config.metabib_field where field_class = 'subject' and name = 'complete'); -- in case it's already there INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, facet_field ) VALUES (17, 'identifier', 'accession', oils_i18n_gettext(17, 'Accession Number', 'cmf', 'label'), 'marcxml', $$//marcxml:datafield[tag="001"]/text()$$, TRUE ); @@ -15530,6 +15530,7 @@ SELECT SETVAL('config.metabib_field_id_seq'::TEXT, (SELECT MAX(id) FROM config.m DELETE FROM config.metabib_search_alias WHERE alias = 'dc.identifier'; +INSERT INTO config.metabib_search_alias (alias,field_class,field) VALUES ('bib.subjectoccupation','subject',16); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('id','identifier'); INSERT INTO config.metabib_search_alias (alias,field_class) VALUES ('dc.identifier','identifier'); INSERT INTO config.metabib_search_alias (alias,field_class,field) VALUES ('eg.isbn','identifier', 18); -- 2.43.2