[Koha-patches] [PATCH] Bug 6103: MARC21 fields missing index for CCL

[Frédéric Demians]

From: Jared Camins-Esakov <jcamins at bywatersolutions.com>

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 <jcamins at bywatersolutions.com>
Signed-off-by: Frédéric Demians <f.demians at tamil.fr>
---
 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.4