From 5a7d4c666e4460f99d97f13e9e0fa23852f4752b Mon Sep 17 00:00:00 2001 From: Jared Camins-Esakov Date: Wed, 6 Apr 2011 17:07:06 -0400 Subject: [PATCH] Bug 6103: MARC21 fields missing index for CCL Content-Type: text/plain; charset="UTF-8" Due to misconfigurations in record.abs, author fields other than 100 and most title fields cannot be searched using CCL field prefixes. This patch adds the appropriate indexes on 110, 111, 130, 210, 211, 212, 214, 222, 700, 710, 711, 730, 740, 780, and 785. It also adds a missing Title-later bib1 attribute. NOTE: The files etc/zebradb/marc_defs/marc21/biblios/record.abs and etc/zebradb/biblios/etc/bib1.att were both modified, and will have to be updated on dev installations. The database will need to be reindexed to take advantage of the updated indexes. Signed-off-by: Jared Camins-Esakov --- etc/zebradb/biblios/etc/bib1.att | 1 + etc/zebradb/marc_defs/marc21/biblios/record.abs | 32 +++++++++++----------- 2 files changed, 17 insertions(+), 16 deletions(-) diff --git a/etc/zebradb/biblios/etc/bib1.att b/etc/zebradb/biblios/etc/bib1.att index ed68092..c156fb4 100644 --- a/etc/zebradb/biblios/etc/bib1.att +++ b/etc/zebradb/biblios/etc/bib1.att @@ -107,6 +107,7 @@ att 1036 Author-Title-Subject att 1045 Record-control-number att 1062 stocknumber att 1079 Subject-topical +att 1096 Title-later # Koha Local-Use Biblio Indexes diff --git a/etc/zebradb/marc_defs/marc21/biblios/record.abs b/etc/zebradb/marc_defs/marc21/biblios/record.abs index 6826d4a..5f0ee64 100755 --- a/etc/zebradb/marc_defs/marc21/biblios/record.abs +++ b/etc/zebradb/marc_defs/marc21/biblios/record.abs @@ -89,21 +89,21 @@ melm 086 Number-govt-pub melm 100$9 Cross-Reference:w,Koha-Auth-Number melm 100$a Author,Author:p,Author:s,Editor,Author-personal-bibliography,Author-personal-bibliography:p,Author-personal-bibliography:s -melm 100 Author,Author-title,Author-name-personal,Name,Name-and-title,Personal-name +melm 100 Author,Author:p,Author:s,Author-title,Author-name-personal,Name,Name-and-title,Personal-name melm 110$9 Koha-Auth-Number -melm 110 Author,Author-title,Author-name-corporate,Name,Name-and-title,Corporate-name +melm 110 Author,Author:p,Author:s,Author-title,Author-name-corporate,Name,Name-and-title,Corporate-name melm 111$9 Koha-Auth-Number -melm 111 Author,Author-title,Author-name-corporate,Name,Name-and-title,Conference-name +melm 111 Author,Author:p,Author:s,Author-title,Author-name-corporate,Name,Name-and-title,Conference-name melm 130$n Thematic-number melm 130$r Music-key melm 130$9 Koha-Auth-Number -melm 130 Title,Title-uniform +melm 130 Title,Title:p,Title-uniform -melm 210 Title,Title-abbreviated -melm 211 Title,Title-abbreviated -melm 212 Title,Title-other-variant -melm 214 Title,Title-expanded -melm 222 Title,Title-key +melm 210 Title,Title:p,Title-abbreviated +melm 211 Title,Title:p,Title-abbreviated +melm 212 Title,Title:p,Title-other-variant +melm 214 Title,Title:p,Title-expanded +melm 222 Title,Title:p,Title-key melm 240$r Music-key melm 240$n Thematic-number melm 240 Title:w,Title:p,Title-uniform @@ -202,24 +202,24 @@ melm 700$n Thematic-number melm 700$r Music-key #melm 700$t author,Author-title,Name-and-title,Title,Title-uniform melm 700$t Author-title,Name-and-title,Title,Title-uniform -melm 700 Author,Author-name-corporate,Author-name-personal,Name,Editor,Personal-name +melm 700 Author,Author:p,Author-name-personal,Name,Editor,Personal-name #melm 710$t author,Author-title,Name-and-title,Title,Title-uniform melm 710$t Author-title,Name-and-title,Title,Title-uniform #melm 710$a author,author:p,Name-and-title melm 710$a Name-and-title melm 710$9 Koha-Auth-Number -melm 710 Author,Corporate-name,Name +melm 710 Author,Author:p,Corporate-name,Name melm 711$a Name-and-title #melm 711$t author,Author-title,Title,Title-uniform melm 711$t Author-title,Title,Title-uniform melm 711$9 Koha-Auth-Number #melm 711 author,Author-name-corporate,Name,Conference-name -melm 711 Author-name-corporate,Name,Conference-name +melm 711 Author,Author:p,Author-name-corporate,Name,Conference-name melm 730$n Thematic-number melm 730$r Music-key melm 730$9 Koha-Auth-Number -melm 730 Title,Title-uniform -melm 740 Title,Title-other-variant +melm 730 Title,Title:p,Title-uniform +melm 740 Title,Title:p,Title-other-variant melm 751$a Name-geographic melm 751$9 Koha-Auth-Number melm 751 Name-geographic @@ -234,9 +234,9 @@ melm 776$w Record-control-number melm 777$w Record-control-number melm 780$t Title melm 780$w Record-control-number -melm 780 Title,Title-former,Related-periodical +melm 780 Title,Title:p,Title-former,Related-periodical melm 785$w Record-control-number -melm 785 Related-periodical +melm 785 Title,Title:p,Title-later,Related-periodical melm 787$w Record-control-number melm 800$a Name-and-title -- 1.7.2.3