From 3f021262cf49b5a532c9f698d0f6aeead5aef0d5 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 11 Sep 2014 15:04:26 +0200 Subject: [PATCH] Bug 12872: Db revision for ZebraExclude pref Content-Type: text/plain; charset=utf-8 Test plan: Run install or upgrade. Check insertion of pref into database. Check editing the value via interface. Signed-off-by: Paola Rossi --- installer/data/mysql/sysprefs.sql | 4 ++-- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ .../prog/en/modules/admin/preferences/admin.pref | 7 +++++++ 3 files changed, 19 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/sysprefs.sql b/installer/data/mysql/sysprefs.sql index e881086..4072373 100644 --- a/installer/data/mysql/sysprefs.sql +++ b/installer/data/mysql/sysprefs.sql @@ -455,5 +455,5 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('XSLTResultsDisplay','default','','Enable XSL stylesheet control over results page display on intranet','Free'), ('yuipath','local','local|http://yui.yahooapis.com/2.5.1/build','Insert the path to YUI libraries, choose local if you use koha offline','Choice'), ('z3950AuthorAuthFields','701,702,700',NULL,'Define the MARC biblio fields for Personal Name Authorities to fill biblio.author','free'), -('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo') -; +('z3950NormalizeAuthor','0','','If ON, Personal Name Authorities will replace authors in biblio.author','YesNo'), +('ZebraExclude','',NULL,'Define some fields to exclude from Zebra indexing','Textarea'); diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 5064c40..8c42e97 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8891,6 +8891,16 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } + +$DBversion = "3.17.00.XXX"; +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + INSERT IGNORE INTO systempreferences (variable,value,options,explanation,type) VALUES('ZebraExclude','', NULL,'Define some fields to exclude from Zebra indexing', 'Textarea') + }); + print "Upgrade to $DBversion done (Bug 12872 - Adding syspref ZebraExclude)\n"; + SetVersion($DBversion); +} + =head1 FUNCTIONS =head2 TableExists($table) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref index e7d12fb..a17616f 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/admin/preferences/admin.pref @@ -149,3 +149,10 @@ Administration: university: "university" - will be shown on the Hea Koha community website. - Note that this value has no effect if the UsageStats system preference is set to "Don't share" + Search Engine: + - + - Exclude the following fields from Zebra indexing. + - pref: ZebraExclude + default: '' + type: textarea + - You can include fields, subfields, field groups (see online help). When you change its value, you should probably reindex. -- 1.7.7.6