From fe3eb2e69d79fb4a7493cc245abbef525c180176 Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Wed, 15 Apr 2020 20:06:45 -0300
Subject: [PATCH] Bug 24973: add locale-sysprefs.yml to localized dirs

This patch put a copy of en/locale-sysprefs.yml on
each localized installation directory.

Each file complements general sysprefs.sql file
to enable a normal install.

To test:
1) Apply the patch

2) Do a clean install for any of current localized
dirs: de-DE,es-ES,fr-CA,fr-FR,it-IT,nb-NO,pl-PL,ru-RU
and uk-UA

3) Check systempreferecences table content
No changes expected.
---
 .../data/mysql/de-DE/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/es-ES/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/fr-CA/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/fr-FR/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/it-IT/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/nb-NO/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/pl-PL/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/ru-RU/locale_sysprefs.yml      | 122 ++++++++++++++++++
 .../data/mysql/uk-UA/locale_sysprefs.yml      | 122 ++++++++++++++++++
 9 files changed, 1098 insertions(+)
 create mode 100644 installer/data/mysql/de-DE/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/es-ES/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/fr-CA/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/fr-FR/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/it-IT/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/nb-NO/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/pl-PL/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/ru-RU/locale_sysprefs.yml
 create mode 100644 installer/data/mysql/uk-UA/locale_sysprefs.yml

diff --git a/installer/data/mysql/de-DE/locale_sysprefs.yml b/installer/data/mysql/de-DE/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/de-DE/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/es-ES/locale_sysprefs.yml b/installer/data/mysql/es-ES/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/es-ES/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/fr-CA/locale_sysprefs.yml b/installer/data/mysql/fr-CA/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/fr-CA/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/fr-FR/locale_sysprefs.yml b/installer/data/mysql/fr-FR/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/fr-FR/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/it-IT/locale_sysprefs.yml b/installer/data/mysql/it-IT/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/it-IT/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/nb-NO/locale_sysprefs.yml b/installer/data/mysql/nb-NO/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/nb-NO/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/pl-PL/locale_sysprefs.yml b/installer/data/mysql/pl-PL/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/pl-PL/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/ru-RU/locale_sysprefs.yml b/installer/data/mysql/ru-RU/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/ru-RU/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
diff --git a/installer/data/mysql/uk-UA/locale_sysprefs.yml b/installer/data/mysql/uk-UA/locale_sysprefs.yml
new file mode 100644
index 0000000000..7376f2bba1
--- /dev/null
+++ b/installer/data/mysql/uk-UA/locale_sysprefs.yml
@@ -0,0 +1,122 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
+#
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+# Localized Koha system preferences
+
+tables:
+  - systempreferences:
+      translatable: [ value ]
+      multiline: [ ]
+      comments: [ variable, options, explanation ]
+      rows:
+        - variable: AddressFormat
+          value: "us"
+          options: "us|de|fr"
+          explanation: "Choose format to display postal addresses"
+          type: Choice
+
+        - variable: AmazonLocale
+          value: "US"
+          options: "US|CA|DE|FR|IN|JP|UK"
+          explanation: "Use to set the Locale of your Amazon.com Web Services"
+          type: Choice
+
+        - variable: borrowerRelationship
+          value: "father|mother"
+          options: ""
+          explanation: "Define valid relationships between a guarantor & a guarantee (separated by | or ,)"
+          type: free
+
+        - variable: BorrowersTitles
+          value: "Mr|Mrs|Miss|Ms"
+          options: ""
+          explanation: "Define appropriate Titles for patrons"
+          type: free
+
+        - variable: CalendarFirstDayOfWeek
+          value: 0
+          options: "0|1|2|3|4|5|6"
+          explanation: "Select the first day of week to use in the calendar."
+          type: Choice
+
+        - variable: CurrencyFormat
+          value: "US"
+          options: "US|FR|CH"
+          explanation: "Determines the display format of currencies. eg: '360000' is displayed as '360 000,00'  in 'FR' or '360,000.00' in 'US'."
+          type: Choice
+
+        - variable: dateformat
+          value: "us"
+          options: "metric|us|iso|dmydot"
+          explanation: "Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy-mm-dd, dmydot dd.mm.yyyy)"
+          type: Choice
+
+        - variable: DefaultClassificationSource
+          value: "ddc"
+          options: ""
+          explanation: "Default classification scheme used by the collection. E.g., Dewey, LCC, etc."
+          type: ClassSources
+
+        - variable: gist
+          value: 0
+          options: ""
+          explanation: "Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST"
+          type: Integer
+
+        - variable: opaclanguagesdisplay
+          value: 0
+          options: ""
+          explanation: "If ON, enables display of Change Language feature on OPAC"
+          type: YesNo
+
+        - variable: OpacMainUserBlock
+          value: "Welcome to Koha...<hr>"
+          options: "70|10"
+          explanation: "A user-defined block of HTML  in the main content area of the opac main page"
+          type: Textarea
+
+        - variable: OpacNav
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OpacNavBottom
+          value: "Important links here."
+          options: "70|10"
+          explanation: "Use HTML tags to add navigational links to the left-hand navigational bar in OPAC"
+          type: Textarea
+
+        - variable: OPACSearchForTitleIn
+          value: "<li><a href=\"https://worldcat.org/search?q={TITLE}\" target=\"_blank\">Other Libraries (WorldCat)</a></li><li><a href=\"https://scholar.google.com/scholar?q={TITLE}\" target=\"_blank\">Other Databases (Google Scholar)</a></li><li><a href=\"https://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr\" target=\"_blank\">Online Stores (Bookfinder.com)</a></li><li><a href=\"https://openlibrary.org/search?author=({AUTHOR})&title=({TITLE})\" target=\"_blank\">Open Library (openlibrary.org)</a></li>"
+          options: "70|10"
+          explanation: "Enter the HTML that will appear in the 'Search for this title in' box on the detail page in the OPAC.  Enter {TITLE}, {AUTHOR}, or {ISBN} in place of their respective variables in the URL. Leave blank to disable 'More Searches' menu."
+          type: Textarea
+
+        - variable: RoutingListNote
+          value: "To change this note edit <a href=\"/cgi-bin/koha/admin/preferences.pl?op=search&searchfield=RoutingListNote#jumped\">RoutingListNote</a> system preference."
+          options: "70|10"
+          explanation: "Define a note to be shown on all routing lists"
+          type: Textarea
+
+        - variable: UniqueItemFields
+          value: "barcode"
+          options: ""
+          explanation: "Pipe-separated list of fields that should be unique (used in acquisition module for item creation). Fields must be valid SQL column names of items table"
+          type: Free
-- 
2.17.1