From 6e817c9a114d49d9362585f878a9b9dcc6aea5e8 Mon Sep 17 00:00:00 2001 From: Zeno Tajoli 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. To test it: Start a web installation with italian language. Select Marc21 as biblio format Select all optional .sql files See the warning present into the image. Conclude the installation. Apply the patch. Drop and recreate the mysql db Redone the installation with italian language. Use the same options written above. Now no more the warning. Installation conclude 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 = '

Benvenuto !!

' 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||{200a}{. 200c}{ : 200e}{200d}{ / 200f}{ ; 200g}{. 200h}{. 200i}|\r\n#210|. – |{210a}{ : 210c}{, 210d}|\r\n#215|. – |{215a}{ ; 215d}|\r\n#225|. – |{(225a}{ ; 225v)}|\r\n#010|. – |{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'); -- 2.24.1.windows.2