From bbe64974b02d78fc916f76408a995ac1bf7f6228 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sun, 17 Nov 2013 21:05:45 +0100 Subject: [PATCH] Bug 11260: Update German web installer for 3.14 Mandatory: - adds auth_values.sql and .txt with YES_NO referenced in patron_attributes.sql - updates sample notices with redone slip templates (ISSUESLIP, ISSUEQSLIP, RESERVSLIP, TRANSFERSLIP) - adds German translations to subtag_registry.sql and copies updated file from en to de-DE - adds translation for new course_reserves permission to userflags.sql - adds translations for new permissions in userpermissions.sql - Fixes typo IndependantBranches in English userpermissions.sql Optional: - adds csv_profiles.sql and translation of the serial claims profile - adds z39.50 servers for authorities to sample_z3950_servers.sql To test: - Run web installer in English - check all sample files, make sure they all install without SQL errors - check language list on advanced search displays correctly still - check area/language list on tools > news displays correctly still - check permissions for correct spelling of IndependentBranches - Run web installer in German - repeat checks from above - also check: authorised values, especially existence of YES_NO - all permissions are translated now - slip notices are all there and look right - new z39.50 servers for authorities are available - csv profile for serial claims is available and works as expected ... and anything else you can think of. Signed-off-by: Chris Cormack Signed-off-by: Kyle M Hall Signed-off-by: Galen Charlton --- .../mysql/de-DE/mandatory/auth_values.sql | 2 + .../mysql/de-DE/mandatory/auth_values.txt | 1 + .../mysql/de-DE/mandatory/sample_notices.sql | 100 +++++++++--------- .../mysql/de-DE/mandatory/subtag_registry.sql | 40 ++++++- .../data/mysql/de-DE/mandatory/userflags.sql | 2 +- .../mysql/de-DE/mandatory/userpermissions.sql | 16 +-- .../mysql/de-DE/optional/csv_profiles.sql | 2 + .../mysql/de-DE/optional/csv_profiles.txt | 3 + .../de-DE/optional/sample_z3950_servers.sql | 2 + .../mysql/en/mandatory/subtag_registry.sql | 40 ++++++- .../mysql/en/mandatory/userpermissions.sql | 2 +- .../en/optional/sample_z3950_servers.sql | 10 +- 12 files changed, 152 insertions(+), 68 deletions(-) create mode 100644 installer/data/mysql/de-DE/mandatory/auth_values.sql create mode 100644 installer/data/mysql/de-DE/mandatory/auth_values.txt create mode 100644 installer/data/mysql/de-DE/optional/csv_profiles.sql create mode 100644 installer/data/mysql/de-DE/optional/csv_profiles.txt diff --git a/installer/data/mysql/de-DE/mandatory/auth_values.sql b/installer/data/mysql/de-DE/mandatory/auth_values.sql new file mode 100644 index 0000000000..8a728e46c7 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory/auth_values.sql @@ -0,0 +1,2 @@ +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja'); diff --git a/installer/data/mysql/de-DE/mandatory/auth_values.txt b/installer/data/mysql/de-DE/mandatory/auth_values.txt new file mode 100644 index 0000000000..8d380a9d2c --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory/auth_values.txt @@ -0,0 +1 @@ +Normierte Werte diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql index b16a7fdc15..0bb581a549 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices.sql @@ -19,94 +19,92 @@ VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r < ('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <> <>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>'); INSERT INTO `letter` (module, code, name, title, content, is_html) -VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '

<>

-Ausleihe an: <> <> <>
-(<>)
- +VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '

Ausleihquittung

+Bibliothek: <>
+Ausleihe an: <> <>
+Ausweisnummer: <>
+
<>
- +

Ausleihen

<>
+Signatur: <>
Barcode: <>
Fällig am: <>

 - +

Überfällig

<>
+Signatur: <>
Barcode: <>
Fällig am: <>

 - -
- -

Neuigkeiten

<>

<>

-

Veröffentlicht am <>

+

<>

', 1), -('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '

<>

-Ausleihe an: <> <> <>
-(<>)
- +('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '

Ausleihquittung

+Bibliothek: <>
+Ausleihe an: <> <>
+Ausweisnummer: <>
+
<>
- +

Heutige Ausleihen

<>
Barcode: <>
+Signatur: <>
Fällig am: <>

', 1), -('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '
Datum: <>
- -

Bereitstellung in <>

- -

<>, <>

- -
    -
  • <>
    • -
  • <>
    • -
  • <>
    - <>
    - <> <> -
    • -
  • <>
    • -
+('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '

Ausleihquittung

+Bibliothek: <>
+Ausleihe an: <> <>
+Ausweisnummer: <>
+
+<>

-

VORMERKUNG

-

<>

-
<>
-
    -
  • <>
    • -
  • <>
    • -
  • <>
    • -
-

Notiz: -

<>
+

Ausleihen

+ +

+<>
+Signatur: <>
+Barcode: <>
+Fällig am: <>

+ +
+

Überfällig

+ +

+<>
+Signatur: <>
+Barcode: <>
+Fällig am: <>
+

+ ', 1), -('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '
Datum: <>
- -

Transport nach <>

- +('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '

TRANSPORT

+

Transport nach: <>

+

Datum: <>

+
+

EXEMPLAR

-

<>

-
<>
-
    -
  • <>
    • -
  • <>
    • -
', 1); +

<><>

+Barcode: <>
+Signatur: <>
', 1); INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) VALUES ( diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql index 9663c5cd3e..b91aba97b3 100644 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ VALUES( 'opac', 'i', 'en', 'OPAC'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'opac', 'i', 'fr', 'OPAC'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'opac', 'i', 'de', 'OPAC'); + -- Staff Client INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); @@ -35,6 +38,9 @@ VALUES( 'intranet', 'i', 'en', 'Staff Client'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'intranet', 'i', 'fr', '????'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche'); + -- Theme (t) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'prog', 't', 'Prog','2005-10-16'); @@ -45,6 +51,9 @@ VALUES( 'prog', 't', 'en', 'Prog'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'prog', 't', 'fr', 'Prog'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'prog', 't', 'de', 'Prog'); + -- LANGUAGES -- Arabic @@ -283,7 +292,7 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)'); +VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]'); -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) @@ -454,6 +463,10 @@ VALUES( 'gl', 'language', 'en', 'Galician'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'gl', 'language', 'fr', 'Galicien'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'gl', 'language', 'de', 'Galicisch'); + + -- Norwegian (bokmÃ¥l) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); @@ -781,6 +794,9 @@ VALUES( 'Arab', 'script','en', 'Arabic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Arab', 'script','fr', 'Arabic'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Arab', 'script', 'de', 'Arabisch'); + -- Cyrillic INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); @@ -794,6 +810,10 @@ VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch'); + + -- Greek INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); @@ -807,6 +827,10 @@ VALUES( 'Grek', 'script', 'en', 'Greek'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Grek', 'script', 'fr', 'Greek'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Grek', 'script', 'de', 'Griechisch'); + + -- Han - Simplified INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); @@ -820,6 +844,10 @@ VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)'); + + -- Han - Traditional INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); @@ -830,6 +858,9 @@ VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)'); + -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); @@ -840,6 +871,9 @@ VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hebr', 'script', 'en', 'Hebrew'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hebr', 'script', 'de', 'Hebräisch'); + -- Lao INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); @@ -850,6 +884,10 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Laoo', 'script', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/de-DE/mandatory/userflags.sql b/installer/data/mysql/de-DE/mandatory/userflags.sql index e9b7f2d843..9399f4a27d 100644 --- a/installer/data/mysql/de-DE/mandatory/userflags.sql +++ b/installer/data/mysql/de-DE/mandatory/userflags.sql @@ -15,5 +15,5 @@ INSERT INTO `userflags` VALUES(14,'editauthorities','Normdaten ändern',0); INSERT INTO `userflags` VALUES(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0); INSERT INTO `userflags` VALUES(16,'reports','Zugriff auf Reportmodul',0); INSERT INTO `userflags` VALUES(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0); -INSERT INTO `userflags` VALUES(18,'coursereserves','Course Reserves',0); +INSERT INTO `userflags` VALUES(18,'coursereserves','Semesteraparate',0); INSERT INTO `userflags` VALUES(19,'plugins', 'Koha Plugins', '0'); diff --git a/installer/data/mysql/de-DE/mandatory/userpermissions.sql b/installer/data/mysql/de-DE/mandatory/userpermissions.sql index e85d053bdf..9c754ee2e7 100644 --- a/installer/data/mysql/de-DE/mandatory/userpermissions.sql +++ b/installer/data/mysql/de-DE/mandatory/userpermissions.sql @@ -18,7 +18,7 @@ INSERT INTO permissions (module_bit, code, description) VALUES (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'), (11, 'planning_manage', 'Etatplanung verwalten'), (11, 'order_manage', 'Bestellungen verwalten'), - (11, 'order_manage_all', 'Manage all orders and baskets, regardless of restrictions on them'), + (11, 'order_manage_all', 'Bestellungen aller Bibliotheken, unabhängig von Berechtigungen, verwalten'), (11, 'group_manage', 'Bestellgruppen vewalten'), (11, 'order_receive', 'Lieferungen verwalten'), (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'), @@ -46,8 +46,8 @@ INSERT INTO permissions (module_bit, code, description) VALUES (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'), (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'), (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'), - (13, 'manage_patron_lists', 'Add, edit and delete patron lists and their contents'), - (13, 'marc_modification_templates', 'Manage marc modification templates'), + (13, 'manage_patron_lists', 'Benutzerlisten anlegen, bearbeiten und löschen'), + (13, 'marc_modification_templates', 'Templates für MARC-Modifikationen verwalten'), (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'), (15, 'claim_serials', 'Fehlende Hefte reklamieren'), (15, 'create_subscription', 'Neues Abonnement anlegen'), @@ -56,13 +56,13 @@ INSERT INTO permissions (module_bit, code, description) VALUES (15, 'receive_serials', 'Zugang von Heften'), (15, 'renew_subscription', 'Abonnements verlängern'), (15, 'routing', 'Umlauflisten verwalten'), - (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependantBranches is used)'), + (15, 'superserials', 'Abonnements aller Bibliotheken verwalten (nur relevant wenn IndependentBranches verwendet wird)'), (16, 'execute_reports', 'SQL-Reports ausführen'), (16, 'create_reports', 'SQL-Reports erstellen'), - (18, 'manage_courses', 'Add, edit and delete courses'), - (18, 'add_reserves', 'Add course reserves'), - (18, 'delete_reserves', 'Remove course reserves'), - (19, 'manage', 'Plugins verwealten (installieren/deinstallieren)'), + (18, 'manage_courses', 'Semesterapparate anlegen, bearbenten und löschen'), + (18, 'add_reserves', 'Semesterapparate anlegen'), + (18, 'delete_reserves', 'Semesterapparate löschen'), + (19, 'manage', 'Plugins verwalten (installieren/deinstallieren)'), (19, 'tool', 'Werkzeug-Plugins verwenden'), (19, 'report', 'Report-Plugins verwenden'), (19, 'configure', 'Plugins konfigurieren') diff --git a/installer/data/mysql/de-DE/optional/csv_profiles.sql b/installer/data/mysql/de-DE/optional/csv_profiles.sql new file mode 100644 index 0000000000..a8ea0b67bc --- /dev/null +++ b/installer/data/mysql/de-DE/optional/csv_profiles.sql @@ -0,0 +1,2 @@ +INSERT IGNORE INTO export_format( profile, description, content, csv_separator, type ) +VALUES ( "Zeitschriftenreklamationen", "Standardprofil für den Export von Heftinformationen für Zeitschriftenreklamationen", "LIEFERANT=aqbooksellers.name|TITEL=subscription.title|HEFTNUMMER=serial.serialseq|SEIT=serial.planneddate", ",", "sql" ); diff --git a/installer/data/mysql/de-DE/optional/csv_profiles.txt b/installer/data/mysql/de-DE/optional/csv_profiles.txt new file mode 100644 index 0000000000..c3fd8d175b --- /dev/null +++ b/installer/data/mysql/de-DE/optional/csv_profiles.txt @@ -0,0 +1,3 @@ +CSV-Profile + +CSV-Profiles, einschließlich einem für den Export von Zeitschriftenreklamationen. diff --git a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql index 472d8eb0b1..0a4eb0c23a 100644 --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql @@ -1,5 +1,7 @@ INSERT INTO `z3950servers` (`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), +('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), +('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), ('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), ('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql index 9663c5cd3e..b91aba97b3 100755 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -25,6 +25,9 @@ VALUES( 'opac', 'i', 'en', 'OPAC'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'opac', 'i', 'fr', 'OPAC'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'opac', 'i', 'de', 'OPAC'); + -- Staff Client INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); @@ -35,6 +38,9 @@ VALUES( 'intranet', 'i', 'en', 'Staff Client'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'intranet', 'i', 'fr', '????'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche'); + -- Theme (t) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'prog', 't', 'Prog','2005-10-16'); @@ -45,6 +51,9 @@ VALUES( 'prog', 't', 'en', 'Prog'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'prog', 't', 'fr', 'Prog'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'prog', 't', 'de', 'Prog'); + -- LANGUAGES -- Arabic @@ -283,7 +292,7 @@ INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)'); +VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]'); -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) @@ -454,6 +463,10 @@ VALUES( 'gl', 'language', 'en', 'Galician'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'gl', 'language', 'fr', 'Galicien'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'gl', 'language', 'de', 'Galicisch'); + + -- Norwegian (bokmÃ¥l) INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); @@ -781,6 +794,9 @@ VALUES( 'Arab', 'script','en', 'Arabic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Arab', 'script','fr', 'Arabic'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Arab', 'script', 'de', 'Arabisch'); + -- Cyrillic INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); @@ -794,6 +810,10 @@ VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch'); + + -- Greek INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); @@ -807,6 +827,10 @@ VALUES( 'Grek', 'script', 'en', 'Greek'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Grek', 'script', 'fr', 'Greek'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Grek', 'script', 'de', 'Griechisch'); + + -- Han - Simplified INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); @@ -820,6 +844,10 @@ VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)'); + + -- Han - Traditional INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); @@ -830,6 +858,9 @@ VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)'); + -- Hebrew INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); @@ -840,6 +871,9 @@ VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Hebr', 'script', 'en', 'Hebrew'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hebr', 'script', 'de', 'Hebräisch'); + -- Lao INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); @@ -850,6 +884,10 @@ VALUES ( 'Laoo', 'script', 'lo', 'Lao'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'Laoo', 'script', 'en', 'Lao'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Laoo', 'script', 'en', 'Laotisch'); + + -- REGIONS -- Canada INSERT INTO language_subtag_registry( subtag, type, description, added) diff --git a/installer/data/mysql/en/mandatory/userpermissions.sql b/installer/data/mysql/en/mandatory/userpermissions.sql index 2f42224227..eb1275c483 100644 --- a/installer/data/mysql/en/mandatory/userpermissions.sql +++ b/installer/data/mysql/en/mandatory/userpermissions.sql @@ -56,7 +56,7 @@ INSERT INTO permissions (module_bit, code, description) VALUES (15, 'receive_serials', 'Serials receiving'), (15, 'renew_subscription', 'Renew a subscription'), (15, 'routing', 'Routing'), - (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependantBranches is used)'), + (15, 'superserials', 'Manage subscriptions from any branch (only applies when IndependentBranches is used)'), (16, 'execute_reports', 'Execute SQL reports'), (16, 'create_reports', 'Create SQL Reports'), (18, 'manage_courses', 'Add, edit and delete courses'), diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql index 68e28a04f7..6c444dc5b4 100644 --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -1,7 +1,7 @@ -INSERT INTO z3950servers -(host, port, db, userid, password, name, checked, rank, syntax, encoding,recordtype) VALUES -('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'), +INSERT INTO `z3950servers` +(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES +('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'), ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), +('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); -- 2.39.5