Attachment 23748 Details for Bug 11260 – Bug 11260: Update German web installer for 3.14

[patch] Bug 11260: Update German web installer for 3.14

Bug-11260-Update-German-web-installer-for-314.patch (text/plain), 27.17 KB, created by Chris Cormack on 2013-12-22 20:20:24 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Chris Cormack

Created: 2013-12-22 20:20:24 UTC

Size: 27.17 KB

patch

obsolete

>From b4454101dde2cf13def33220a68a7e9b608ce901 Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <Katrin.Fischer.83@web.de>
>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 <chrisc@catalyst.net.nz>
>---
> .../data/mysql/de-DE/mandatory/auth_values.sql     |   2 +
> .../data/mysql/de-DE/mandatory/auth_values.txt     |   1 +
> .../data/mysql/de-DE/mandatory/sample_notices.sql  | 100 ++++++++++-----------
> .../data/mysql/de-DE/mandatory/subtag_registry.sql |  40 ++++++++-
> installer/data/mysql/de-DE/mandatory/userflags.sql |   2 +-
> .../data/mysql/de-DE/mandatory/userpermissions.sql |  16 ++--
> .../data/mysql/de-DE/optional/csv_profiles.sql     |   2 +
> .../data/mysql/de-DE/optional/csv_profiles.txt     |   3 +
> .../mysql/de-DE/optional/sample_z3950_servers.sql  |   2 +
> .../data/mysql/en/mandatory/subtag_registry.sql    |  40 ++++++++-
> .../data/mysql/en/mandatory/userpermissions.sql    |   2 +-
> .../mysql/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 0000000..8a728e4
>--- /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 0000000..8d380a9
>--- /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 b16a7fd..0bb581a 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 <<borrowers.firstname>
> ('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegrÃ¼ndung: <<suggestions.reason>>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>');
> 
> INSERT INTO `letter` (module, code, name, title, content, is_html)
>-VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h3><<branches.branchname>></h3>
>-Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>-(<<borrowers.cardnumber>>) <br />
>-
>+VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h2>Ausleihquittung</h2>
>+Bibliothek: <<branches.branchname>> <br/>
>+Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
>+Ausweisnummer: <<borrowers.cardnumber>> <br />
>+<br />
> <<today>><br />
>-
>+<br />
> <h4>Ausleihen</h4>
> <checkedout>
> <p>
> <<biblio.title>> <br />
>+Signatur: <<items.itemcallnumber>><br/>
> Barcode: <<items.barcode>><br />
> FÃ¤llig am: <<issues.date_due>><br />
> </p>
> </checkedout>
>-
>+<br />
> <h4>ÃberfÃ¤llig</h4>
> <overdue>
> <p>
> <<biblio.title>> <br />
>+Signatur: <<items.itemcallnumber>><br/>
> Barcode: <<items.barcode>><br />
> FÃ¤llig am: <<issues.date_due>><br />
> </p>
> </overdue>
>-
>-<hr>
>-
>-<h4 style="text-align: center; font-style:italic;">Neuigkeiten</h4>
> <news>
> <div class="newsitem">
> <h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
> <p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
>-<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">VerÃ¶ffentlicht am <<opac_news.timestamp>></p>
>+<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px"><<opac_news.timestamp>></p>
> <hr />
> </div>
> </news>', 1),
>-('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h3><<branches.branchname>></h3>
>-Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
>-(<<borrowers.cardnumber>>) <br />
>-
>+('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h2>Ausleihquittung</h2>
>+Bibliothek: <<branches.branchname>> <br/>
>+Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
>+Ausweisnummer: <<borrowers.cardnumber>> <br />
>+<br />
> <<today>><br />
>-
>+<br />
> <h4>Heutige Ausleihen</h4>
> <checkedout>
> <p>
> <<biblio.title>> <br />
> Barcode: <<items.barcode>><br />
>+Signatur: <<items.itemcallnumber>><br/>
> FÃ¤llig am: <<issues.date_due>><br />
> </p>
> </checkedout>', 1),
>-('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h5>Datum: <<today>></h5>
>-
>-<h3> Bereitstellung in <<branches.branchname>></h3>
>-
>-<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
>-
>-<ul>
>-    <li><<borrowers.cardnumber>></li>
>-    <li><<borrowers.phone>></li>
>-    <li> <<borrowers.address>><br />
>-         <<borrowers.address2>><br />
>-         <<borrowers.city >>  <<borrowers.zipcode>>
>-    </li>
>-    <li><<borrowers.email>></li>
>-</ul>
>+('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h2>Ausleihquittung</h2>
>+Bibliothek: <<branches.branchname>> <br/>
>+Ausleihe an: <<borrowers.firstname>>  <<borrowers.surname>> <br />
>+Ausweisnummer: <<borrowers.cardnumber>> <br />
>+<br />
>+<<today>><br />
> <br />
>-<h3>VORMERKUNG</h3>
>-<h4><<biblio.title>></h4>
>-<h5><<biblio.author>></h5>
>-<ul>
>-   <li><<items.barcode>></li>
>-   <li><<items.itemcallnumber>></li>
>-   <li><<reserves.waitingdate>></li>
>-</ul>
>-<p>Notiz:
>-<pre><<reserves.reservenotes>></pre>
>+<h4>Ausleihen</h4>
>+<checkedout>
>+<p>
>+<<biblio.title>> <br />
>+Signatur: <<items.itemcallnumber>><br/>
>+Barcode: <<items.barcode>><br />
>+FÃ¤llig am: <<issues.date_due>><br />
> </p>
>+</checkedout>
>+<br />
>+<h4>ÃberfÃ¤llig</h4>
>+<overdue>
>+<p>
>+<<biblio.title>> <br />
>+Signatur: <<items.itemcallnumber>><br/>
>+Barcode: <<items.barcode>><br />
>+FÃ¤llig am: <<issues.date_due>><br />
>+</p>
>+</overdue>
> ', 1),
>-('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h5>Datum: <<today>></h5>
>-
>-<h3>Transport nach <<branches.branchname>></h3>
>-
>+('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h2>TRANSPORT</h2>
>+<h3>Transport nach: <<branches.branchname>></h3>
>+<h3>Datum: <<today>></h3>
>+<br/>
>+<br/>
> <h3>EXEMPLAR</h3>
>-<h4><<biblio.title>></h4>
>-<h5><<biblio.author>></h5>
>-<ul>
>-   <li><<items.barcode>></li>
>-   <li><<items.itemcallnumber>></li>
>-</ul>', 1);
>+<h4><<biblio.author>><<biblio.title>></h4>
>+Barcode: <<items.barcode>><br/>
>+Signatur: <<items.itemcallnumber>><br/>', 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 9663c5c..b91aba9 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&#229;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 e9b7f2d..9399f4a 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 9f5eadd..98e44af 100644
>--- a/installer/data/mysql/de-DE/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/de-DE/mandatory/userpermissions.sql
>@@ -16,7 +16,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'),
>@@ -44,8 +44,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'),
>@@ -54,13 +54,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 0000000..a8ea0b6
>--- /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 0000000..c3fd8d1
>--- /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 472d8eb..0a4eb0c 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 9663c5c..b91aba9 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&#229;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 7874c9e..e1637bf 100644
>--- a/installer/data/mysql/en/mandatory/userpermissions.sql
>+++ b/installer/data/mysql/en/mandatory/userpermissions.sql
>@@ -54,7 +54,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 68e28a0..6c444dc 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');
>-- 
>1.8.3.2

Actions: View | Diff | Splinter Review

Attachments on bug 11260: 22987 | 22988 | 22989 | 23748 | 23749 | 23750 | 23996 | 23997 | 23998