From b3efa877e7d0138340b3231d62ca0196731695ef Mon Sep 17 00:00:00 2001
From: Katrin Fischer <Katrin.Fischer.83@web.de>
Date: Mon, 4 Apr 2011 08:38:02 +0000
Subject: [PATCH] Bug 5839: Add index stocknumber on 952$i

This patch adds a new index for stocknumber on field 952$i.

Note: For testing you have to copy over the changed files
from  kohaclone/etc/zebradb/ to your koha-dev/etc/zebradb folders.
Reindex.

To test:
1) Add 952$i to your frameworks
2) Add an item with 952$i
3) Search for your 952$i value in keyword search
4) Search for stocknumber, using stocknumber:<your 952$i value> or inv:<...

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
---
 C4/Search.pm                                    | 2 ++
 etc/zebradb/biblios/etc/bib1.att                | 1 +
 etc/zebradb/ccl.properties                      | 2 ++
 etc/zebradb/marc_defs/marc21/biblios/record.abs | 2 +-
 4 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/C4/Search.pm b/C4/Search.pm
index b8939b65cb..c69e787341 100644
--- a/C4/Search.pm
+++ b/C4/Search.pm
@@ -993,6 +993,8 @@ sub getIndexes{
                     'reserves',
                     'restricted',
                     'stack',
+                    'stocknumber',
+                    'inv',
                     'uri',
                     'withdrawn',
 
diff --git a/etc/zebradb/biblios/etc/bib1.att b/etc/zebradb/biblios/etc/bib1.att
index 3397664d4c..ed680922bb 100644
--- a/etc/zebradb/biblios/etc/bib1.att
+++ b/etc/zebradb/biblios/etc/bib1.att
@@ -105,6 +105,7 @@ att 1034    ctype
 att 1035    Anywhere
 att 1036    Author-Title-Subject
 att 1045    Record-control-number
+att 1062    stocknumber
 att 1079    Subject-topical
 
 
diff --git a/etc/zebradb/ccl.properties b/etc/zebradb/ccl.properties
index 709410d566..59c270553e 100644
--- a/etc/zebradb/ccl.properties
+++ b/etc/zebradb/ccl.properties
@@ -984,6 +984,8 @@ mc-loc location
 acqsource 1=8015
 coded-location-qualifier 1=8016
 price 1=8017
+stocknumber 1=1062
+inv stocknumber
 stack 1=8018
 issues 1=8019
 renewals 1=8020
diff --git a/etc/zebradb/marc_defs/marc21/biblios/record.abs b/etc/zebradb/marc_defs/marc21/biblios/record.abs
index 06080b55ae..d3f83adfa5 100755
--- a/etc/zebradb/marc_defs/marc21/biblios/record.abs
+++ b/etc/zebradb/marc_defs/marc21/biblios/record.abs
@@ -295,7 +295,7 @@ melm 952$e      acqsource
 melm 952$f      coded-location-qualifier
 melm 952$g      price
 #melm 952$h     
-#melm 952$i     
+melm 952$i      stocknumber
 melm 952$j      stack:n,stack:w
 #melm 952$k     
 melm 952$l      issues:n,issues:w,issues:s
-- 
2.39.5