Bugzilla – Attachment 156574 Details for
Bug 34558
Update custom.sql for it-IT webinstaller
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 34558: Update custom.sql for it-IT webinstaller
Bug-34558-Update-customsql-for-it-IT-webinstaller.patch (text/plain), 4.15 KB, created by
David Nind
on 2023-10-05 17:09:16 UTC
(
hide
)
Description:
Bug 34558: Update custom.sql for it-IT webinstaller
Filename:
MIME Type:
Creator:
David Nind
Created:
2023-10-05 17:09:16 UTC
Size:
4.15 KB
patch
obsolete
>From 7bc7839d79128a3ee675577e55077e1241097e17 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 > >Signed-off-by: David Nind <david@davidnind.com> >--- > .../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|. – |{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.30.2
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 34558
:
154507
|
154551
|
156558
|
156574
|
156587