From a6c23267ab95f36d836f447055226a4bb3147a0e Mon Sep 17 00:00:00 2001
From: Katrin Fischer <Katrin.Fischer.83@web.de>
Date: Wed, 30 Mar 2011 08:32:08 +0200
Subject: [PATCH 2/2] Bug 5839: Add index stocknumber on 952$i
Content-Type: text/plain; charset="utf-8"

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:<...
---
 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 deletions(-)

diff --git a/C4/Search.pm b/C4/Search.pm
index 21c61fb..94f4942 100644
--- a/C4/Search.pm
+++ b/C4/Search.pm
@@ -992,6 +992,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 3397664..ed68092 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 709410d..59c2705 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 85eaedd..4326133 100755
--- a/etc/zebradb/marc_defs/marc21/biblios/record.abs
+++ b/etc/zebradb/marc_defs/marc21/biblios/record.abs
@@ -294,7 +294,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
-- 
1.7.1