From 0bcfb0d95e7bec14e7a65304cd19ccd34e2580cd 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. 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: SELECT value FROM systempreferences where variable = 'BorrowersTitles' You see: 'Sig|Sig.ra|Dott.|Dott.ssa' 12 - Refactor is OK Signed-off-by: David Nind Signed-off-by: Katrin Fischer Signed-off-by: Tomas Cohen Arazi (cherry picked from commit 070af9aaf38e36c2c69d825ac43d28e288d62f04) Signed-off-by: Fridolin Somers --- .../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.39.5