Attachment 44797 Details for Bug 15178 – Update italian web istall sql files

[patch] Update italian web istall sql files

BUG-15178-Update-of-Italian-web-installer-.sql-files.patch (text/plain), 14.68 KB, created by Zeno Tajoli on 2015-11-12 12:18:47 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Zeno Tajoli

Created: 2015-11-12 12:18:47 UTC

Size: 14.68 KB

patch

obsolete

>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
>

Actions: View | Diff | Splinter Review

Attachments on bug 15178: 44797 | 44803 | 44827