From 3e78787672867667e17dd0c441935c7642068c58 Mon Sep 17 00:00:00 2001
From: Zeno Tajoli <z.tajoli@cineca.it>
Date: Thu, 12 Nov 2015 12:57:05 +0100
Subject: [PATCH 2/2] [BUG 15178]: Update of Italian web installer .sql files
 for 3.22

- iNot worked on notices.sql becouse there is a bug on it (Bz 15177)
- Some change in Italian default system preference settings.

To test:
- Run the web installer in Italian with all sample files selected
- Confirm no error messages are shown
---
 installer/data/mysql/it-IT/necessari/auth_val.sql  | 20 +++++++++++---------
 .../mysql/it-IT/necessari/sample_creator_data.sql  |  3 ++-
 .../mysql/it-IT/necessari/sample_itemtypes.sql     | 14 +++++++-------
 .../it-IT/necessari/sample_numberpatterns.sql      |  2 +-
 .../mysql/it-IT/necessari/system_preferences.sql   | 22 +++++++---------------
 5 files changed, 28 insertions(+), 33 deletions(-)

diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql
index 4c8cfb5..3d4cb79 100644
--- a/installer/data/mysql/it-IT/necessari/auth_val.sql
+++ b/installer/data/mysql/it-IT/necessari/auth_val.sql
@@ -30,7 +30,9 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','S
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','GEN','Sezione generale');
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','AV','Audiovideo');
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','REF','Strumenti di reference');
-
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','CART','Scaffale smistamento');
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('LOC','PROC','Centro lavorazione');
+  
 -- collection codes for an item
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','FIC','Fiction');
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('CCODE','REF','Strumenti di reference');
@@ -85,7 +87,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'PAT', 'Utenti');
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACQ', 'Acquisizione');
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'ACC', 'Accounts');
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Serials');
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('REPORT_GROUP', 'SER', 'Seriali');
 
 -- SIP2 media types
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '000', 'Other');
@@ -101,15 +103,15 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED
 INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Libro con audiocassette');
 
 -- order cancellation reasons
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided');
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock');
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking');
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'Nessuna ragione fornita');
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Fuori mercato');
+INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'In ristampa');
 
 -- Desired formats for requesting new materials
-INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book');
-INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print');
-INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook');
-INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook');
+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Libro', 'Libro');
+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'A caratteri ingranditi', 'A caratteri ingranditi');
+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'Ebook', 'Ebook');
+INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiolibro', 'Audiolibro');
 INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD');
 
 SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql b/installer/data/mysql/it-IT/necessari/sample_creator_data.sql
index bb33fc3..654d776 100644
--- a/installer/data/mysql/it-IT/necessari/sample_creator_data.sql
+++ b/installer/data/mysql/it-IT/necessari/sample_creator_data.sql
@@ -3,7 +3,8 @@
 
 LOCK TABLES `creator_layouts` WRITE;
 /*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
-INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES (1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
+INSERT INTO `creator_layouts` (`layout_id`, `barcode_type`, `start_label`, `printing_type`, `layout_name`, `guidebox`, `font`, `font_size`, `units`, `callnum_split`, `text_justify`, `format_string`, `layout_xml`, `creator`) VALUES 
+(1,'CODE39',1,'BIBBAR','Test etic. (BIBBAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
 (2,'CODE39',1,'BAR','Test etic. (BAR)',0,'TR',3,'POINT',0,'L','title, author, isbn, issn, itemtype, barcode, itemcallnumber','<opt></opt>','Labels'),
 (3,'CODE39',1,'BAR','Test tessere',0,'TR',10,'POINT',0,'L','barcode','<opt page_side="F" units="POINT">
   <images name="image_1" Dx="72" Ox="0" Oy="0" Sx="0" Sy="0" Tx="4.5" Ty="63">
diff --git a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql b/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql
index 93fea97..3a931dc 100644
--- a/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql
+++ b/installer/data/mysql/it-IT/necessari/sample_itemtypes.sql
@@ -1,12 +1,12 @@
 SET FOREIGN_KEY_CHECKS=0;
 
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',5,0,'bridge/book.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',5,0,'bridge/kit.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',5,0,'bridge/computer_file.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',5,0,'bridge/map.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',5,1,'bridge/dvd.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',5,0,'bridge/sound.gif','');
-INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',5,0,'bridge/periodical.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('BK', 'Libro',0,0,'bridge/book.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MX', 'Materiale misto',0,0,'bridge/kit.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CF', 'Computer Files',0,0,'bridge/computer_file.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MP', 'Mappe',0,0,'bridge/map.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('VM', 'Audiovisivi',0,1,'bridge/dvd.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('MU', 'Musica',0,0,'bridge/sound.gif','');
+INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('CR', 'Periodici',0,0,'bridge/periodical.gif','');
 INSERT INTO `itemtypes` (`itemtype`,`description`,`rentalcharge`,`notforloan`,`imageurl`,`summary`) VALUES ('REF', 'Reference',0,1,'','');
 
 SET FOREIGN_KEY_CHECKS=1;
diff --git a/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql b/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql
index bc50195..2cd35ce 100644
--- a/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql
+++ b/installer/data/mysql/it-IT/necessari/sample_numberpatterns.sql
@@ -9,7 +9,7 @@ VALUES
     NULL, NULL, NULL, NULL, NULL, NULL,
     NULL, NULL, NULL, NULL, NULL, NULL),
 
-    ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Number {Y}, Issue {Z}',
+    ('Volume, Number, Issue', 2, 'Volume Numero Copia 1', 'Vol.{X}, Num. {Y}, Fasc. {Z}',
     'Volume', 1, 48, 99999, 1, NULL,
     'Number', 1, 4, 12, 1, NULL,
     'Issue', 1, 1, 4, 1, NULL),
diff --git a/installer/data/mysql/it-IT/necessari/system_preferences.sql b/installer/data/mysql/it-IT/necessari/system_preferences.sql
index 94a00b9..ee2329d 100644
--- a/installer/data/mysql/it-IT/necessari/system_preferences.sql
+++ b/installer/data/mysql/it-IT/necessari/system_preferences.sql
@@ -20,48 +20,40 @@ UPDATE systempreferences SET value = 'cataloguing' WHERE variable = 'AcqCreateIt
 UPDATE systempreferences SET value = '1' WHERE variable = 'AllowRenewalLimitOverride';
 UPDATE systempreferences SET value = 'annual' WHERE variable = 'autoBarcode';
 UPDATE systempreferences SET value = 'email' WHERE variable = 'AutoEmailPrimaryAddress';
-UPDATE systempreferences SET value = '1' WHERE variable = 'BiblioAddsAuthorities';
-UPDATE systempreferences SET value = 'city|surname|cardnumber' WHERE variable = 'BorrowerMandatoryField';
+UPDATE systempreferences SET value = '0' WHERE variable = 'BiblioAddsAuthorities';
+UPDATE systempreferences SET value = 'surname|cardnumber' WHERE variable = 'BorrowerMandatoryField';
 UPDATE systempreferences SET value = '0' WHERE variable = 'BorrowersLog';
 UPDATE systempreferences SET value = 'Sig|Sig.ra|Sig.na' WHERE variable = 'BorrowersTitles';
 UPDATE systempreferences SET value = '0' WHERE variable = 'CataloguingLog';
 UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurrencyFormat';
 UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat';
-UPDATE systempreferences SET value = 'relevance' WHERE variable = 'defaultSortField';
+UPDATE systempreferences SET value = 'title' WHERE variable = 'defaultSortField';
 UPDATE systempreferences SET value = 'asc' WHERE variable = 'defaultSortOrder';
 UPDATE systempreferences SET value = '0' WHERE variable = 'FinesLog';
-UPDATE systempreferences SET value = '1' WHERE variable = 'FRBRizeEditions';
 UPDATE systempreferences SET value = '1' WHERE variable = 'GoogleJackets';
 UPDATE systempreferences SET value = '0' WHERE variable = 'IssueLog';
 UPDATE systempreferences SET value = 'whitespace' WHERE variable = 'itemBarcodeInputFilter';
 UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
-UPDATE systempreferences SET value = 'koha@cilea.it' WHERE variable = 'KohaAdminEmailAddress';
+UPDATE systempreferences SET value = 'koha@xxx.it' WHERE variable = 'KohaAdminEmailAddress';
 UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'language';
 UPDATE systempreferences SET value = '0' WHERE variable = 'LetterLog';
-UPDATE systempreferences SET value = '0' WHERE variable = 'MARCOrgCode';
-UPDATE systempreferences SET value = '2' WHERE variable = 'maxreserves';
+UPDATE systempreferences SET value = ''  WHERE variable = 'MARCOrgCode';
+UPDATE systempreferences SET value = '5' WHERE variable = 'maxreserves';
 UPDATE systempreferences SET value = '0' WHERE variable = 'OpacAuthorities';
-UPDATE systempreferences SET value = 'relevance' WHERE variable = 'OPACdefaultSortField';
+UPDATE systempreferences SET value = 'title' WHERE variable = 'OPACdefaultSortField';
 UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';
-UPDATE systempreferences SET value = '1' WHERE variable = 'OPACFRBRizeEditions';
 UPDATE systempreferences SET value = 'en,it-IT' WHERE variable = 'opaclanguages';
 UPDATE systempreferences SET value = '1' WHERE variable = 'opaclanguagesdisplay';
 UPDATE systempreferences SET value = '<h3>Benvenuto !!</h3>' WHERE variable = 'OpacMainUserBlock';
 UPDATE systempreferences SET value = 'Links importanti qui.' WHERE variable = 'OpacNav';
 UPDATE systempreferences SET value = '0' WHERE variable = 'OPACShelfBrowser';
-UPDATE systempreferences SET value = '1' WHERE variable = 'OpacTopissue';
 UPDATE systempreferences SET value = '1' WHERE variable = 'OPACURLOpenInNewWindow';
-UPDATE systempreferences SET value = 'jpg' WHERE variable = 'patronimages';
 UPDATE systempreferences SET value = '0' WHERE variable = 'QueryFuzzy';
 UPDATE systempreferences SET value = '0' WHERE variable = 'QueryStemming';
 UPDATE systempreferences SET value = '0' WHERE variable = 'QueryWeightFields';
-UPDATE systempreferences SET value = '0' WHERE variable = 'ReservesNeedReturns';
-UPDATE systempreferences SET value = '1' WHERE variable = 'ReturnBeforeExpiry';
 UPDATE systempreferences SET value = '1' WHERE variable = 'TagsModeration';
-UPDATE systempreferences SET value = '1' WHERE variable = 'ThingISBN';
 UPDATE systempreferences SET value = '30600' WHERE variable = 'timeout';
 UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
-UPDATE systempreferences SET value = '1' WHERE variable = 'XISBN';
 
 UPDATE systempreferences SET value = '#200|<span style=\"font-weight:bold\">|{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|</span>\r\n#210|. &ndash; |{210a}{ : 210c}{, 210d}|\r\n#215|. &ndash; |{215a}{ ; 215d}|\r\n#225|. &ndash; |{(225a}{ ; 225v)}|\r\n#010|. &ndash; |{ISBN 010a}|' WHERE variable = 'ISBD';
 
-- 
2.1.4