From 6e817c9a114d49d9362585f878a9b9dcc6aea5e8 Mon Sep 17 00:00:00 2001
From: Zeno Tajoli <ztajoli@gmail.com>
Date: Thu, 17 Aug 2023 14:04:12 +0200
Subject: [PATCH] Bug 34558: Update custom.sql for it-IT webinstaller

It is an update of this file, here there are the specific customization for
italian users. There are simple changes on defaults values.

To test it:
1 - Start a web installation with italian language.
2 - Select Marc21 as biblio format
3 - Select all optional .sql files
4 - Conclude the installation.
5 - Go to MySQL command line and do:
    SELET value FROM systempreferences where variable = 'BorrowersTitles'
    You see: 'Sig|Sig.ra|Sig.na'
6 - Apply the patch.
7 - Drop and recreate the mysql db
8 - Redone the installation with italian language.
9 - Use the same options written above.
10 - Conclude the installation.
11 - Go to MySQL command line and do:
    SELET value FROM systempreferences where variable = 'BorrowersTitles'
    You see: 'Sig|Sig.ra|Dott.|Dott.ssa'
12 - Refactor is OK
---
 .../data/mysql/localization/it-IT/custom.sql  | 23 +------------------
 1 file changed, 1 insertion(+), 22 deletions(-)

diff --git a/installer/data/mysql/localization/it-IT/custom.sql b/installer/data/mysql/localization/it-IT/custom.sql
index 7fa65cfe54..68dfabc28d 100644
--- a/installer/data/mysql/localization/it-IT/custom.sql
+++ b/installer/data/mysql/localization/it-IT/custom.sql
@@ -28,7 +28,7 @@ UPDATE systempreferences SET value = 'email' WHERE variable = 'EmailFieldPrimary
 UPDATE systempreferences SET value = '1' 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 = 'Sig|Sig.ra|Dott.|Dott.ssa' 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';
@@ -49,8 +49,6 @@ UPDATE systempreferences SET value = 'title' WHERE variable = 'OPACdefaultSortFi
 UPDATE systempreferences SET value = 'asc' WHERE variable = 'OPACdefaultSortOrder';
 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 = 'OPACURLOpenInNewWindow';
 UPDATE systempreferences SET value = '0' WHERE variable = 'QueryFuzzy';
@@ -60,22 +58,3 @@ UPDATE systempreferences SET value = '1' WHERE variable = 'TagsModeration';
 UPDATE systempreferences SET value = '30600' WHERE variable = 'timeout';
 UPDATE systempreferences SET value = '1' WHERE variable = 'UseICUStyleQuotes';
 UPDATE systempreferences SET value = 'URLLinkText' WHERE variable = 'URLLinkText';
-
-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';
-
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES
-('COUNTRY', 'IT', 'Italia'),
-('COUNTRY', 'US', 'Stati Uniti'),
-('COUNTRY', 'GB', 'Regno Unito - UK '),
-('COUNTRY', 'DE', 'Germania'),
-('COUNTRY', 'FR', 'Francia'),
-('COUNTRY', 'VA', 'Vaticano'),
-('COUNTRY', 'CN', 'Cina'),
-('COUNTRY', 'IN', 'India');
-
-INSERT INTO authorised_values (category, authorised_value, lib) VALUES
-('LANG', 'ita', 'italiano'),
-('LANG', 'eng', 'inglese'),
-('LANG', 'ger', 'tedesco'),
-('LANG', 'fre', 'francese'),
-('LANG', 'lat', 'latino');
--