From c1d824deaa65f0a64071e6925ae2238beb0a0912 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Mon, 24 Oct 2011 14:57:52 +0200 Subject: [PATCH] Bug 7079: [SIGNED-OFF] Default values for German system preferences Patch adds updates for system preferences to the sql file in the installer directory: - New: AmazonLocale: DE - borrowerRelationship: Vater|Mutter - BorrowersTitles: Herr|Frau - New: CurrencyFormat: FR - New: dateformat: metric - New: DefaultClassificationSource: z - New: OpacMainUserBlock: translated content - New: OpacNav: translated content - New: OpacNavBottom: translated content - New: OPACSearchForTitleIn: translated content To test: A) Do a full installation with German sample files B) Run the sql file 'system_preferences.sql' against your database Verfy values of system preferences have been changed. Signed-off-by: Magnus Enger Patch applied cleanly. I ran through the webinstaller in German on an empty database, and made sure system_preferences were loaded. No complaints from the database and the systprefs are set to the right values when I check in the staff client. Signed-off-by: Paul Poulain --- .../mysql/de-DE/mandatory/system_preferences.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/installer/data/mysql/de-DE/mandatory/system_preferences.sql b/installer/data/mysql/de-DE/mandatory/system_preferences.sql index d0e08a994b..0e304ed4fb 100644 --- a/installer/data/mysql/de-DE/mandatory/system_preferences.sql +++ b/installer/data/mysql/de-DE/mandatory/system_preferences.sql @@ -16,5 +16,17 @@ -- with Koha; if not, write to the Free Software Foundation, Inc., -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. +UPDATE systempreferences SET value = 'DE' WHERE variable = 'AmazonLocale'; UPDATE systempreferences SET value = 'Vater|Mutter' WHERE variable = 'borrowerRelationship'; UPDATE systempreferences SET value = 'Herr|Frau' WHERE variable = 'BorrowersTitles'; +UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat'; +UPDATE systempreferences SET value = 'metric' WHERE variable = 'dateformat'; +UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassificationSource'; +UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog! (OpacMainUserBlock)' WHERE variable = 'OpacMainUserBlock'; +UPDATE systempreferences SET value = 'Wichtige Links hier...(OpacNav)' WHERE variable = 'OpacNav'; +UPDATE systempreferences SET value = '...oder hier (OpacNavBottom)' WHERE variable = 'OpacNavBottom'; +UPDATE systempreferences SET value = + '
  • Andere Bibliotheken (WorldCat)
    • +
  • Google Scholar
    • +
  • Online-Buchhandel (Bookfinder.com)
    • ' + WHERE variable = 'OPACSearchForTitleIn'; -- 2.39.2