From df7c1cb0f117e432da2b0a61df4fad1136300b57 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Wed, 7 Aug 2013 15:40:06 +0200 Subject: [PATCH] Bug 10521: Define i18n function for de-DE/mandatory files Content-Type: text/plain; charset=utf-8 This patch adjusts the de-DE/mandatory files. Test plan: Run German install, including all mandatory files. Check translated strings from several tables touched in Mandatory. --- .../mysql/de-DE/mandatory.i18n/class_sources.sql | 41 + .../class_sources.txt | 0 .../mandatory.i18n/message_transport_types.sql | 10 + .../message_transport_types.txt | 0 .../mysql/de-DE/mandatory.i18n/sample_notices.sql | 404 +++++++++ .../sample_notices.txt | 0 .../sample_notices_message_attributes.sql | 9 + .../sample_notices_message_attributes.txt | 0 .../sample_notices_message_transports.sql | 10 + .../sample_notices_message_transports.txt | 0 .../data/mysql/de-DE/mandatory.i18n/stopwords.sql | 304 +++++++ .../{mandatory => mandatory.i18n}/stopwords.txt | 0 .../mysql/de-DE/mandatory.i18n/subtag_registry.sql | 10 + .../subtag_registry.txt | 2 +- .../system_preferences.sql | 8 +- .../system_preferences.txt | 0 .../data/mysql/de-DE/mandatory.i18n/userflags.sql | 67 ++ .../{mandatory => mandatory.i18n}/userflags.txt | 0 .../mysql/de-DE/mandatory.i18n/userpermissions.sql | 193 +++++ .../userpermissions.txt | 0 .../data/mysql/de-DE/mandatory/class_sources.sql | 36 - .../de-DE/mandatory/message_transport_types.sql | 7 - .../data/mysql/de-DE/mandatory/sample_notices.sql | 122 --- .../sample_notices_message_attributes.sql | 8 - .../sample_notices_message_transports.sql | 17 - installer/data/mysql/de-DE/mandatory/stopwords.sql | 99 --- .../data/mysql/de-DE/mandatory/subtag_registry.sql | 897 -------------------- installer/data/mysql/de-DE/mandatory/userflags.sql | 20 - .../data/mysql/de-DE/mandatory/userpermissions.sql | 63 -- 29 files changed, 1053 insertions(+), 1274 deletions(-) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/class_sources.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/class_sources.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/message_transport_types.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/sample_notices.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/sample_notices.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/sample_notices_message_attributes.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/sample_notices_message_transports.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/stopwords.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/stopwords.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/subtag_registry.txt (97%) rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/system_preferences.sql (96%) rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/system_preferences.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/userflags.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/userflags.txt (100%) create mode 100644 installer/data/mysql/de-DE/mandatory.i18n/userpermissions.sql rename installer/data/mysql/de-DE/{mandatory => mandatory.i18n}/userpermissions.txt (100%) delete mode 100644 installer/data/mysql/de-DE/mandatory/class_sources.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/message_transport_types.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/stopwords.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/subtag_registry.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/userflags.sql delete mode 100644 installer/data/mysql/de-DE/mandatory/userpermissions.sql diff --git a/installer/data/mysql/de-DE/mandatory.i18n/class_sources.sql b/installer/data/mysql/de-DE/mandatory.i18n/class_sources.sql new file mode 100644 index 0000000..a2de140 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/class_sources.sql @@ -0,0 +1,41 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' + +-- Class sorting (filing) rules +-- Statement 1, PK:'dewey', description +WHEN 'Default filing rules for DDC' +THEN 'Standard-Sortierregeln für DDC' +-- Statement 1, PK:'lcc', description +WHEN 'Default filing rules for LCC' +THEN 'Standard-Sortierregeln für LCC' +-- Statement 1, PK:'generic', description +WHEN 'Generic call number filing rules' +THEN 'Generische Sortierregeln für Signaturen' + +-- Classification schemes or sources +-- Statement 2, PK:'ddc', description +WHEN 'Dewey Decimal Classification' +THEN 'Dewey-Decimalklassifikation (DDC)' +-- Statement 2, PK:'lcc', description +WHEN 'Library of Congress Classification' +THEN 'Klassifikation der Library of Congress (LCC)' +-- Statement 2, PK:'udc', description +WHEN 'Universal Decimal Classification' +THEN 'Universelle Dezimalklassifikation (UDC)' +-- Statement 2, PK:'sudocs', description +WHEN 'SuDoc Classification (U.S. GPO)' +THEN 'SuDoc-Klassifikation (U.S. GPO)' +-- Statement 2, PK:'anscr', description +WHEN 'ANSCR (Sound Recordings)' +THEN 'ANSCR (Tonaufnahmen)' +-- Statement 2, PK:'z', description +WHEN 'Other/Generic Classification Scheme' +THEN 'Andere/Generische Klassifikation' + +ELSE d +END; +END // diff --git a/installer/data/mysql/de-DE/mandatory/class_sources.txt b/installer/data/mysql/de-DE/mandatory.i18n/class_sources.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/class_sources.txt rename to installer/data/mysql/de-DE/mandatory.i18n/class_sources.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.sql b/installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.sql new file mode 100644 index 0000000..1adc884 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.sql @@ -0,0 +1,10 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' + +ELSE d +END; +END // \ No newline at end of file diff --git a/installer/data/mysql/de-DE/mandatory/message_transport_types.txt b/installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/message_transport_types.txt rename to installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices.sql b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices.sql new file mode 100644 index 0000000..6f700ee --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices.sql @@ -0,0 +1,404 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' +-- Statement 1, PK:'circulation','ODUE', name +WHEN 'Overdue Notice' +THEN 'Mahnung' +-- Statement 1, PK:'circulation','ODUE', title +WHEN 'Item Overdue' +THEN 'Mahnung' +-- Statement 1, PK:'circulation','ODUE', content +WHEN 'Dear <> <>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\n\nIf you have registered a password with the library, and you have a renewal available, you may renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned.\n\nThe following item(s) is/are currently overdue:\n\n"<>" by <>, <>, Barcode: <> Fine: <>\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\n' +THEN 'Liebe/r <> <>,\n\nNach unseren Unterlagen haben Sie Medien entliehen, die nun überfällig geworden sind. Unsere Bibliothek erhebt keine Mahngebühren, bitte geben Sie die entliehenen Medien schnellstmöglich zurück.\n\n<>\n<>\n<> <>\nTelefon: <>\nFax: <>\nEmail: <>\n\nSie können die überfälligen Medien soweit möglich auch direkt über Ihr Benutzerkonto online verlängern. Wenn ein Medium länger als 30 Tage überfällig ist, wird Ihr Benutzeraccount gesperrt und Sie können keine Medien mehr entleihen.\n\nDie folgenden Medien sind zur Zeit überfällig:\n\n"<>" by <>, <>, Barcode: <> Gebühr: <>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n' +-- Statement 1, PK:'claimacquisition','ACQCLAIM', name +WHEN 'Acquisition Claim' +THEN 'Reklamation (Erwerbung)' +-- Statement 1, PK:'claimacquisition','ACQCLAIM', title +WHEN 'Item Not Received' +THEN 'Titel nicht eingetroffen' +-- Statement 1, PK:'claimacquisition','ACQCLAIM', content +WHEN '<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received.' +THEN '<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> bestellt) (je $<> €) sind nicht eingetroffen.' +-- Statement 1, PK:'serial','RLIST', name +WHEN 'Routing List' +THEN 'Neues Heft zugegangen' +-- Statement 1, PK:'serial','RLIST', title +WHEN 'Serial is now available' +THEN 'Zeitschrift ist jetzt verfügbar' +-- Statement 1, PK:'serial','RLIST', content +WHEN '<> <>,\r\n\r\nThe following issue is now available:\r\n\r\n<>, <> (<>)\r\n\r\nPlease pick it up at your convenience.' +THEN '<> <>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<>, <> (<>)\r\n\r\nBitte holen Sie es sobald möglich ab.' +-- Statement 1, PK:'members','ACCTDETAILS', name +WHEN 'Account Details Template - DEFAULT' +THEN 'Kontoinformationen - Standard' +-- Statement 1, PK:'members','ACCTDETAILS', title +WHEN 'Your new Koha account details.' +THEN 'Ihr neues Benutzerkonto' +-- Statement 1, PK:'members','ACCTDETAILS', content +WHEN 'Hello <> <> <>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser: <>\r\nPassword: <>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin@yoursite.org' +THEN 'Liebe/r <> <> <>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer: <>\r\nPasswort: <>\r\n\r\nWenn Sie Probleme in Hinsicht auf Ihr Benutzerkonto haben, wenden Sie sich bitte an die Bibliothek.\r\n\r\nVielen Dank,\r\nIhr Bibliotheksteam' +-- Statement 1, PK:'circulation','DUE', name +WHEN 'Item Due Reminder' +THEN 'Fälligkeitsbenachrichtigung' +-- Statement 1, PK:'circulation','DUE', title +WHEN 'Item Due Reminder' +THEN 'Fälligkeitsbenachrichtigung' +-- Statement 1, PK:'circulation','DUE', content +WHEN 'Dear <> <>,\r\n\r\nThe following item is now due:\r\n\r\n<>, <> (<>)' +THEN 'Liebe/r <> <>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<>, <> (<>)' +-- Statement 1, PK:'circulation','DUEDGST', name +WHEN 'Item Due Reminder (Digest)' +THEN 'Fälligkeitsbenachrichtigung (Zusammenfassung)' +-- Statement 1, PK:'circulation','DUEDGST', title +WHEN 'Item Due Reminder' +THEN 'Fälligkeitsbenachrichtigung' +-- Statement 1, PK:'circulation','DUEDGST', content +WHEN 'You have <> items due' +THEN 'Sie haben <> überfällige Medien.' +-- Statement 1, PK:'circulation','PREDUE', name +WHEN 'Advance Notice of Item Due' +THEN 'Erinnerungsbenachrichtigung' +-- Statement 1, PK:'circulation','PREDUE', title +WHEN 'Advance Notice of Item Due' +THEN 'Erinnerungsbenachrichtigung' +-- Statement 1, PK:'circulation','PREDUE', content +WHEN 'Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>, <> (<>)' +THEN 'Liebe/r <> <>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<>, <> (<>)' +-- Statement 1, PK:'circulation','PREDUEDGST', name +WHEN 'Advance Notice of Item Due (Digest)' +THEN 'Erinnerungsbenachrichtigung (Zusammenfassung)' +-- Statement 1, PK:'circulation','PREDUEDGST', title +WHEN 'Advance Notice of Item Due' +THEN 'Erinnerungsbenachrichtigung' +-- Statement 1, PK:'circulation','PREDUEDGST', content +WHEN 'You have <> items due soon' +THEN 'Sie haben <> Ausleihen, die bald fällig werden.' +-- Statement 1, PK:'circulation','RENEWAL', name +WHEN 'Item Renewals' +THEN 'Verlängerungsbenachrichtigung' +-- Statement 1, PK:'circulation','RENEWAL', title +WHEN 'Item Renewals' +THEN 'Verlängerungsquittung' +-- Statement 1, PK:'circulation','RENEWAL', content +WHEN 'The following items have been renewed:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.' +THEN 'Liebe/r <> <>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<>\r\n----\r\nVielen Dank,\r\n<>.' +-- Statement 1, PK:'reserves','HOLD', name +WHEN 'Hold Available for Pickup' +THEN 'Vormerkbenachrichtigung' +-- Statement 1, PK:'reserves','HOLD', title +WHEN 'Hold Available for Pickup at <>' +THEN 'Vormerkung abholbereit in <>' +-- Statement 1, PK:'reserves','HOLD', content +WHEN 'Dear <> <>,\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\nLocation: <>\r\n<>\r\n<>\r\n<>\r\n<> <>' +THEN 'Liebe/r <> <>,\r\n\r\nFür Sie liegt seit <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nExemplar: <>\r\nStandort: <>\r\n<>\r\n<>\r\n<>\r\n<> <>' +-- Statement 1, PK:'reserves','HOLD_PRINT', name +WHEN 'Hold Available for Pickup (print notice)' +THEN 'Vormerkbenachrichtigung (Print)' +-- Statement 1, PK:'reserves','HOLD_PRINT', title +WHEN 'Hold Available for Pickup (print notice)' +THEN 'Vormerkbenachrichtigung (Print)' +-- Statement 1, PK:'reserves','HOLD_PRINT', content +WHEN '<>\r\n<>\r\n<>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <> <>\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\n' +THEN '<>\r\n<>\r\n<>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<>\r\n<> <>\r\n<>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <> <>,\r\n\r\nFür Sie liegt seit dem <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nSignatur: <>\r\n' +-- Statement 1, PK:'circulation','CHECKIN', name +WHEN 'Item Check-in (Digest)' +THEN 'Rückgabequittung (Zusammenfassung)' +-- Statement 1, PK:'circulation','CHECKIN', title +WHEN 'Check-ins' +THEN 'Rückgabequittung' +-- Statement 1, PK:'circulation','CHECKIN', content +WHEN 'The following items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.' +THEN 'Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<>\r\n----\r\nVielen Dank.' +-- Statement 1, PK:'circulation','CHECKOUT', name +WHEN 'Item Check-out (Digest)' +THEN 'Ausleihquittung (Zusammenfassung)' +-- Statement 1, PK:'circulation','CHECKOUT', title +WHEN 'Checkouts' +THEN 'Ausleihquittung' +-- Statement 1, PK:'circulation','CHECKOUT', content +WHEN 'The following items have been checked out:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.' +THEN 'Die folgenden Medien wurden entliehen:\r\n----\r\n<>\r\n----\r\nVielen Dank für Ihren Besuch in <>.' +-- Statement 1, PK:'reserves','HOLDPLACED', name +WHEN 'Hold Placed on Item' +THEN 'Neue Vormerkung' +-- Statement 1, PK:'reserves','HOLDPLACED', title +WHEN 'Hold Placed on Item' +THEN 'Neue Vormerkung' +-- Statement 1, PK:'reserves','HOLDPLACED', content +WHEN 'A hold has been placed on the following item : <> (<>) by the user <> <> (<>).' +THEN 'Folgender Titel wurde vorgemerkt: <> (<>) durch den Benutzer <> <> (<>).' +-- Statement 1, PK:'suggestions','ACCEPTED', name +WHEN 'Suggestion accepted' +THEN 'Anschaffungsvorschlag wurde angenommen' +-- Statement 1, PK:'suggestions','ACCEPTED', title +WHEN 'Purchase suggestion accepted' +THEN 'Ihr Anschaffungsvorschlag wurde angenommen' +-- Statement 1, PK:'suggestions','ACCEPTED', content +WHEN 'Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your suggestion today. The item will be ordered as soon as possible. You will be notified by mail when the order is completed, and again when the item arrives at the library.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>' +THEN 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> by <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und wird Ihn sobald wie möglich im Buchhandel bestellen. Sie erhalten Nachricht, sobald die Bestellung abgeschlossen ist und sobald der Titel in der Bibliotek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>' +-- Statement 1, PK:'suggestions','AVAILABLE', name +WHEN 'Suggestion available' +THEN 'Vorgeschlagenes Medium verfügbar' +-- Statement 1, PK:'suggestions','AVAILABLE', title +WHEN 'Suggested purchase available' +THEN 'Das vorgeschlagene Medium ist jetzt verfügbar' +-- Statement 1, PK:'suggestions','AVAILABLE', content +WHEN 'Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>' +THEN 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Bestand der Bibliothek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>' +-- Statement 1, PK:'suggestions','ORDERED', name +WHEN 'Suggestion ordered' +THEN 'Vorgeschlagenes Medium bestellt' +-- Statement 1, PK:'suggestions','ORDERED', title +WHEN 'Suggested item ordered' +THEN 'Das vorgeschlagene Medium wurde im Buchhandel bestellt' +-- Statement 1, PK:'suggestions','ORDERED', content +WHEN 'Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <>\n\nThank you,\n\n<>' +THEN 'Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <> von <>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Buchhandel bestellt wurde. Nach Eintreffen wird er in unseren Bestand eingearbeitet.\n\nSie erhalten Nachricht, sobald das Medium verfügbar ist.\n\nBei Nachfragen erreichen Sie uns unter der Emailadresse <>.\n\nVielen Dank,\n\n<>' +-- Statement 1, PK:'suggestions','REJECTED', name +WHEN 'Suggestion rejected' +THEN 'Anschaffungsvorschlag nicht angenommen' +-- Statement 1, PK:'suggestions','REJECTED', title +WHEN 'Purchase suggestion declined' +THEN 'Ihr Anschaffungsvorschlag wurde nicht angenommen' +-- Statement 1, PK:'suggestions','REJECTED', content +WHEN 'Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>' +THEN '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<>' + + +-- Statement 2, PK:'circulation','ISSUESLIP', name +WHEN 'Issue Slip' +THEN 'Ausleihquittung (Quittungsdruck)' +-- Statement 2, PK:'circulation','ISSUESLIP', title +WHEN 'Issue Slip' +THEN 'Ausleihquittung (Quittungsdruck)' +-- Statement 2, PK:'circulation','ISSUESLIP', content +WHEN '

<>

+Checked out to <> <> <> <>
+(<>)
+ +<>
+ +

Checked Out

+ +

+<>
+Barcode: <>
+Date due: <>
+

+ + +

Overdues

+ +

+<>
+Barcode: <>
+Date due: <>
+

+ + +
+ +

News

+ +
+
<>
+

<>

+

Posted on <>

+
+
+' +THEN '

<>

+Ausleihe an: <> <> <>
+(<>)
+ +<>
+ +

Ausleihen

+ +

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

+ + +

Überfällig

+ +

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

+ + +
+ +

Neuigkeiten

+ +
+
<>
+

<>

+

Veröffentlicht am <>

+
+
+' +-- Statement 2, PK:'circulation','ISSUEQSLIP', name +WHEN 'Issue Quick Slip' +THEN 'Kurzquittung' +-- Statement 2, PK:'circulation','ISSUEQSLIP', title +WHEN 'Issue Quick Slip' +THEN 'Kurzquittung' +-- Statement 2, PK:'circulation','ISSUEQSLIP', content +WHEN '

<>

+Checked out to <> <> <> <>
+(<>)
+ +<>
+ +

Checked Out Today

+ +

+<>
+Barcode: <>
+Date due: <>
+

+' +THEN '

<>

+Ausleihe an: <> <> <>
+(<>)
+ +<>
+ +

Heutige Ausleihen

+ +

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

+' +-- Statement 2, PK:'circulation','RESERVESLIP', name +WHEN 'Reserve Slip' +THEN 'Vormerkquittung' +-- Statement 2, PK:'circulation','RESERVESLIP', title +WHEN 'Reserve Slip' +THEN 'Vormerkquittung' +-- Statement 2, PK:'circulation','RESERVESLIP', content +WHEN '
Date: <>
+ +

Transfer to/Hold in <>

+ +

<>, <>

+ +
    +
  • <>
    • +
  • <>
    • +
  • <>
    + <>
    + <> <> +
    • +
  • <>
    • +
+
+

ITEM ON HOLD

+

<>

+
<>
+
    +
  • <>
    • +
  • <>
    • +
  • <>
    • +
+

Notes: +

<>
+

+' +THEN '
Datum: <>
+ +

Bereitstellung in <>

+ +

<>, <>

+ +
    +
  • <>
    • +
  • <>
    • +
  • <>
    + <>
    + <> <> +
    • +
  • <>
    • +
+
+

VORMERKUNG

+

<>

+
<>
+
    +
  • <>
    • +
  • <>
    • +
  • <>
    • +
+

Notiz: +

<>
+

+' +-- Statement 2, PK:'circulation','TRANSFERSLIP', name +WHEN 'Transfer Slip' +THEN 'Transportquittung' +-- Statement 2, PK:'circulation','TRANSFERSLIP', title +WHEN 'Transfer Slip' +THEN 'Transportquittung' +-- Statement 2, PK:'circulation','TRANSFERSLIP', content +WHEN '
Date: <>
+ +

Transfer to <>

+ +

ITEM

+

<>

+
<>
+
    +
  • <>
    • +
  • <>
    • +
' +THEN '
Datum: <>
+ +

Transport nach <>

+ +

EXEMPLAR

+

<>

+
<>
+
    +
  • <>
    • +
  • <>
    • +
' + + +-- Statement 3, PK:'members','OPAC_REG_VERIFY', name +WHEN 'Opac Self-Registration Verification Email' +THEN 'Bestätigung der Anmeldung zur Bibliotheksnutzung' +-- Statement 3, PK:'members','OPAC_REG_VERIFY', title +WHEN 'Verify Your Account' +THEN 'Verify Your Account' +-- Statement 3, PK:'members','OPAC_REG_VERIFY', content +WHEN 'Hello! + +Your library account has been created. Please verify your email address by clicking this link to complete the signup process: + +http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<> + +If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.' +THEN 'Guten Tag, + +Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken: + +http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<> + +Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachrichtigung ignorieren. Sie wird in Kürze ungültig. + +Vielen Dank, +Ihr Bibliotheksteam' + +ELSE d +END; +END // diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.txt b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/sample_notices.txt rename to installer/data/mysql/de-DE/mandatory.i18n/sample_notices.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.sql b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.sql new file mode 100644 index 0000000..e95a919 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.sql @@ -0,0 +1,9 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' +ELSE d +END; +END // \ No newline at end of file diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.txt rename to installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.sql new file mode 100644 index 0000000..1adc884 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.sql @@ -0,0 +1,10 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' + +ELSE d +END; +END // \ No newline at end of file diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt b/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.txt rename to installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/stopwords.sql b/installer/data/mysql/de-DE/mandatory.i18n/stopwords.sql new file mode 100644 index 0000000..77a382b --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/stopwords.sql @@ -0,0 +1,304 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' +-- Statement 1, PK:'a', word +WHEN 'a' +THEN 'a' +-- Statement 1, PK:'about', word +WHEN 'about' +THEN 'about' +-- Statement 1, PK:'also', word +WHEN 'also' +THEN 'also' +-- Statement 1, PK:'an', word +WHEN 'an' +THEN 'an' +-- Statement 1, PK:'and', word +WHEN 'and' +THEN 'and' +-- Statement 1, PK:'another', word +WHEN 'another' +THEN 'another' +-- Statement 1, PK:'any', word +WHEN 'any' +THEN 'any' +-- Statement 1, PK:'are', word +WHEN 'are' +THEN 'are' +-- Statement 1, PK:'as', word +WHEN 'as' +THEN 'as' +-- Statement 1, PK:'at', word +WHEN 'at' +THEN 'at' +-- Statement 1, PK:'back', word +WHEN 'back' +THEN 'back' +-- Statement 1, PK:'be', word +WHEN 'be' +THEN 'be' +-- Statement 1, PK:'because', word +WHEN 'because' +THEN 'because' +-- Statement 1, PK:'been', word +WHEN 'been' +THEN 'been' +-- Statement 1, PK:'being', word +WHEN 'being' +THEN 'being' +-- Statement 1, PK:'but', word +WHEN 'but' +THEN 'but' +-- Statement 1, PK:'by', word +WHEN 'by' +THEN 'by' +-- Statement 1, PK:'can', word +WHEN 'can' +THEN 'can' +-- Statement 1, PK:'could', word +WHEN 'could' +THEN 'could' +-- Statement 1, PK:'did', word +WHEN 'did' +THEN 'did' +-- Statement 1, PK:'do', word +WHEN 'do' +THEN 'do' +-- Statement 1, PK:'each', word +WHEN 'each' +THEN 'each' +-- Statement 1, PK:'end', word +WHEN 'end' +THEN 'end' +-- Statement 1, PK:'even', word +WHEN 'even' +THEN 'even' +-- Statement 1, PK:'for', word +WHEN 'for' +THEN 'for' +-- Statement 1, PK:'from', word +WHEN 'from' +THEN 'from' +-- Statement 1, PK:'get', word +WHEN 'get' +THEN 'get' +-- Statement 1, PK:'go', word +WHEN 'go' +THEN 'go' +-- Statement 1, PK:'had', word +WHEN 'had' +THEN 'had' +-- Statement 1, PK:'have', word +WHEN 'have' +THEN 'have' +-- Statement 1, PK:'he', word +WHEN 'he' +THEN 'he' +-- Statement 1, PK:'her', word +WHEN 'her' +THEN 'her' +-- Statement 1, PK:'here', word +WHEN 'here' +THEN 'here' +-- Statement 1, PK:'his', word +WHEN 'his' +THEN 'his' +-- Statement 1, PK:'how', word +WHEN 'how' +THEN 'how' +-- Statement 1, PK:'i', word +WHEN 'i' +THEN 'i' +-- Statement 1, PK:'if', word +WHEN 'if' +THEN 'if' +-- Statement 1, PK:'in', word +WHEN 'in' +THEN 'in' +-- Statement 1, PK:'into', word +WHEN 'into' +THEN 'into' +-- Statement 1, PK:'is', word +WHEN 'is' +THEN 'is' +-- Statement 1, PK:'it', word +WHEN 'it' +THEN 'it' +-- Statement 1, PK:'just', word +WHEN 'just' +THEN 'just' +-- Statement 1, PK:'may', word +WHEN 'may' +THEN 'may' +-- Statement 1, PK:'me', word +WHEN 'me' +THEN 'me' +-- Statement 1, PK:'might', word +WHEN 'might' +THEN 'might' +-- Statement 1, PK:'much', word +WHEN 'much' +THEN 'much' +-- Statement 1, PK:'must', word +WHEN 'must' +THEN 'must' +-- Statement 1, PK:'my', word +WHEN 'my' +THEN 'my' +-- Statement 1, PK:'no', word +WHEN 'no' +THEN 'no' +-- Statement 1, PK:'not', word +WHEN 'not' +THEN 'not' +-- Statement 1, PK:'of', word +WHEN 'of' +THEN 'of' +-- Statement 1, PK:'off', word +WHEN 'off' +THEN 'off' +-- Statement 1, PK:'on', word +WHEN 'on' +THEN 'on' +-- Statement 1, PK:'only', word +WHEN 'only' +THEN 'only' +-- Statement 1, PK:'or', word +WHEN 'or' +THEN 'or' +-- Statement 1, PK:'other', word +WHEN 'other' +THEN 'other' +-- Statement 1, PK:'our', word +WHEN 'our' +THEN 'our' +-- Statement 1, PK:'out', word +WHEN 'out' +THEN 'out' +-- Statement 1, PK:'should', word +WHEN 'should' +THEN 'should' +-- Statement 1, PK:'so', word +WHEN 'so' +THEN 'so' +-- Statement 1, PK:'some', word +WHEN 'some' +THEN 'some' +-- Statement 1, PK:'still', word +WHEN 'still' +THEN 'still' +-- Statement 1, PK:'such', word +WHEN 'such' +THEN 'such' +-- Statement 1, PK:'than', word +WHEN 'than' +THEN 'than' +-- Statement 1, PK:'that', word +WHEN 'that' +THEN 'that' +-- Statement 1, PK:'the', word +WHEN 'the' +THEN 'the' +-- Statement 1, PK:'their', word +WHEN 'their' +THEN 'their' +-- Statement 1, PK:'them', word +WHEN 'them' +THEN 'them' +-- Statement 1, PK:'then', word +WHEN 'then' +THEN 'then' +-- Statement 1, PK:'there', word +WHEN 'there' +THEN 'there' +-- Statement 1, PK:'these', word +WHEN 'these' +THEN 'these' +-- Statement 1, PK:'they', word +WHEN 'they' +THEN 'they' +-- Statement 1, PK:'this', word +WHEN 'this' +THEN 'this' +-- Statement 1, PK:'those', word +WHEN 'those' +THEN 'those' +-- Statement 1, PK:'to', word +WHEN 'to' +THEN 'to' +-- Statement 1, PK:'too', word +WHEN 'too' +THEN 'too' +-- Statement 1, PK:'try', word +WHEN 'try' +THEN 'try' +-- Statement 1, PK:'two', word +WHEN 'two' +THEN 'two' +-- Statement 1, PK:'under', word +WHEN 'under' +THEN 'under' +-- Statement 1, PK:'up', word +WHEN 'up' +THEN 'up' +-- Statement 1, PK:'us', word +WHEN 'us' +THEN 'us' +-- Statement 1, PK:'was', word +WHEN 'was' +THEN 'was' +-- Statement 1, PK:'we', word +WHEN 'we' +THEN 'we' +-- Statement 1, PK:'were', word +WHEN 'were' +THEN 'were' +-- Statement 1, PK:'what', word +WHEN 'what' +THEN 'what' +-- Statement 1, PK:'when', word +WHEN 'when' +THEN 'when' +-- Statement 1, PK:'where', word +WHEN 'where' +THEN 'where' +-- Statement 1, PK:'which', word +WHEN 'which' +THEN 'which' +-- Statement 1, PK:'while', word +WHEN 'while' +THEN 'while' +-- Statement 1, PK:'who', word +WHEN 'who' +THEN 'who' +-- Statement 1, PK:'why', word +WHEN 'why' +THEN 'why' +-- Statement 1, PK:'will', word +WHEN 'will' +THEN 'will' +-- Statement 1, PK:'with', word +WHEN 'with' +THEN 'with' +-- Statement 1, PK:'within', word +WHEN 'within' +THEN 'within' +-- Statement 1, PK:'without', word +WHEN 'without' +THEN 'without' +-- Statement 1, PK:'would', word +WHEN 'would' +THEN 'would' +-- Statement 1, PK:'you', word +WHEN 'you' +THEN 'you' +-- Statement 1, PK:'your', word +WHEN 'your' +THEN 'your' + +ELSE d +END; +END // diff --git a/installer/data/mysql/de-DE/mandatory/stopwords.txt b/installer/data/mysql/de-DE/mandatory.i18n/stopwords.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/stopwords.txt rename to installer/data/mysql/de-DE/mandatory.i18n/stopwords.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.sql new file mode 100644 index 0000000..10d36f0 --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.sql @@ -0,0 +1,10 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' + +ELSE d +END; +END // diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt b/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.txt similarity index 97% rename from installer/data/mysql/de-DE/mandatory/subtag_registry.txt rename to installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.txt index e28a15c..87ab54b 100644 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt +++ b/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.txt @@ -1,4 +1,4 @@ I18N-Unterstützung in Koha -Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch, +Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch, Standardmappings zwischen Schrift- und Sprachcodes, weitere Spracherweiterungen diff --git a/installer/data/mysql/de-DE/mandatory/system_preferences.sql b/installer/data/mysql/de-DE/mandatory.i18n/system_preferences.sql similarity index 96% rename from installer/data/mysql/de-DE/mandatory/system_preferences.sql rename to installer/data/mysql/de-DE/mandatory.i18n/system_preferences.sql index 7691139..2920950 100644 --- a/installer/data/mysql/de-DE/mandatory/system_preferences.sql +++ b/installer/data/mysql/de-DE/mandatory.i18n/system_preferences.sql @@ -7,11 +7,11 @@ -- terms of the GNU General Public License as published by the Free Software -- Foundation; either version 2 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, write to the Free Software Foundation, Inc., -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. @@ -25,10 +25,10 @@ UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassification UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variable = 'OpacMainUserBlock'; UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav'; UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom'; -UPDATE systempreferences SET value = +UPDATE systempreferences SET value = '
  • Andere Bibliotheken (WorldCat)
  • Google Scholar
    • -
  • Online-Buchhandel (Bookfinder.com)
    • ' +
  • Online-Buchhandel (Bookfinder.com)
    • ' WHERE variable = 'OPACSearchForTitleIn'; UPDATE systempreferences SET value = 'Monday' WHERE variable = 'CalendarFirstDayOfWeek'; UPDATE systempreferences SET value = '0.07|0.19|0.00' WHERE variable = 'gist'; diff --git a/installer/data/mysql/de-DE/mandatory/system_preferences.txt b/installer/data/mysql/de-DE/mandatory.i18n/system_preferences.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/system_preferences.txt rename to installer/data/mysql/de-DE/mandatory.i18n/system_preferences.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/userflags.sql b/installer/data/mysql/de-DE/mandatory.i18n/userflags.sql new file mode 100644 index 0000000..8ef23ed --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/userflags.sql @@ -0,0 +1,67 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' +-- Statement 1, PK:0,'superlibrarian', flagdesc +WHEN 'Access to all librarian functions' +THEN 'Zugriff auf alle Funktionen' +-- Statement 1, PK:1,'circulate', flagdesc +WHEN 'Check out and check in items' +THEN 'Medien ausleihen/zurückgeben' +-- Statement 1, PK:2,'catalogue', flagdesc +WHEN 'Required for staff login. Staff access, allows viewing of catalogue in staff client.' +THEN 'Katalogsuche verwenden (Dienstoberfläche)' +-- Statement 1, PK:3,'parameters', flagdesc +WHEN 'Manage Koha system settings (Administration panel)' +THEN 'Systemparameter verändern' +-- Statement 1, PK:4,'borrowers', flagdesc +WHEN 'Add or modify patrons' +THEN 'Benutzer anlegen/ändern' +-- Statement 1, PK:5,'permissions', flagdesc +WHEN 'Set user permissions' +THEN 'Berechtigungen für Benutzer vergeben' +-- Statement 1, PK:6,'reserveforothers', flagdesc +WHEN 'Place and modify holds for patrons' +THEN 'Vormerkungen für Benutzer setzen/ändern' +-- Statement 1, PK:7,'borrow', flagdesc +WHEN 'Borrow books' +THEN 'Medien entleihen' +-- Statement 1, PK:9,'editcatalogue', flagdesc +WHEN 'Edit Catalog (Modify bibliographic/holdings data)' +THEN 'Katalogdaten ändern (Titel- und Bestandsdaten ändern)' +-- Statement 1, PK:10,'updatecharges', flagdesc +WHEN 'Manage patrons fines and fees' +THEN 'Gebühren kassieren/ändern' +-- Statement 1, PK:11,'acquisition', flagdesc +WHEN 'Acquisition and/or suggestion management' +THEN 'Erwerbung und Verwaltung von Anschaffungsvorschlägen' +-- Statement 1, PK:12,'management', flagdesc +WHEN 'Set library management parameters (deprecated)' +THEN 'Zugriff auf Administration' +-- Statement 1, PK:13,'tools', flagdesc +WHEN 'Use all tools (expand for granular tools permissions)' +THEN 'Werkzeuge verwenden (Export, Import, Etikettendruck)' +-- Statement 1, PK:14,'editauthorities', flagdesc +WHEN 'Edit Authorities' +THEN 'Normdaten ändern' +-- Statement 1, PK:15,'serials', flagdesc +WHEN 'Manage serial subscriptions' +THEN 'Zugriff auf Abonnementverwaltung/Zeitschriftenmodul' +-- Statement 1, PK:16,'reports', flagdesc +WHEN 'Allow access to the reports module' +THEN 'Zugriff auf Reportmodul' +-- Statement 1, PK:17,'staffaccess', flagdesc +WHEN 'Allow staff members to modify permissions for other staff members' +THEN 'Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben' +-- Statement 1, PK:18,'coursereserves', flagdesc +WHEN 'Course Reserves' +THEN 'Course Reserves' +-- Statement 1, PK:19,'plugins', flagdesc +WHEN 'Koha plugins' +THEN 'Koha Plugins' + +ELSE d +END; +END // diff --git a/installer/data/mysql/de-DE/mandatory/userflags.txt b/installer/data/mysql/de-DE/mandatory.i18n/userflags.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/userflags.txt rename to installer/data/mysql/de-DE/mandatory.i18n/userflags.txt diff --git a/installer/data/mysql/de-DE/mandatory.i18n/userpermissions.sql b/installer/data/mysql/de-DE/mandatory.i18n/userpermissions.sql new file mode 100644 index 0000000..0602bdf --- /dev/null +++ b/installer/data/mysql/de-DE/mandatory.i18n/userpermissions.sql @@ -0,0 +1,193 @@ +DELIMITER // +DROP FUNCTION IF EXISTS i18n// +CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC +BEGIN +RETURN CASE d +WHEN '' THEN '' +-- Statement 1, PK:1,'circulate_remaining_permissions', description +WHEN 'Remaining circulation permissions' +THEN 'Übrige Ausleihberechtigungen' +-- Statement 1, PK:1,'override_renewals', description +WHEN 'Override blocked renewals' +THEN 'Gesperrte Verlängerungen überschreiben' +-- Statement 1, PK:1,'overdues_report', description +WHEN 'Execute overdue items report' +THEN 'Überfälligkeiten-Report ausführen' +-- Statement 1, PK:3,'parameters_remaining_permissions', description +WHEN 'Remaining system parameters permissions' +THEN 'Übrige Administrationsberechtigungen' +-- Statement 1, PK:3,'manage_circ_rules', description +WHEN 'manage circulation rules' +THEN 'Ausleihkonditionen verwalten' +-- Statement 1, PK:6,'place_holds', description +WHEN 'Place holds for patrons' +THEN 'Vormerkungen für Benutzer setzen' +-- Statement 1, PK:6,'modify_holds_priority', description +WHEN 'Modify holds priority' +THEN 'Vormerkungspriorität verändern' +-- Statement 1, PK:9,'edit_catalogue', description +WHEN 'Edit catalog (Modify bibliographic/holdings data)' +THEN 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)' +-- Statement 1, PK:9,'fast_cataloging', description +WHEN 'Fast cataloging' +THEN 'Schnellaufnahmen anlegen' +-- Statement 1, PK:9,'edit_items', description +WHEN 'Edit Items' +THEN 'Exemplare bearbeiten' +-- Statement 1, PK:11,'vendors_manage', description +WHEN 'Manage vendors' +THEN 'Lieferanten verwalten' +-- Statement 1, PK:11,'contracts_manage', description +WHEN 'Manage contracts' +THEN 'Vereinbarungen verwalten' +-- Statement 1, PK:11,'period_manage', description +WHEN 'Manage periods' +THEN 'Etats verwalten' +-- Statement 1, PK:11,'budget_manage', description +WHEN 'Manage budgets' +THEN 'Konten verwalten' +-- Statement 1, PK:11,'budget_modify', description +WHEN 'Modify budget (can''t create lines, but can modify existing ones)' +THEN 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)' +-- Statement 1, PK:11,'planning_manage', description +WHEN 'Manage budget plannings' +THEN 'Etatplanung verwalten' +-- Statement 1, PK:11,'order_manage', description +WHEN 'Manage orders & basket' +THEN 'Bestellungen verwalten' +-- Statement 1, PK:11,'group_manage', description +WHEN 'Manage orders & basketgroups' +THEN 'Bestellgruppen vewalten' +-- Statement 1, PK:11,'order_receive', description +WHEN 'Manage orders & basket' +THEN 'Lieferungen verwalten' +-- Statement 1, PK:11,'budget_add_del', description +WHEN 'Add and delete budgets (but cant modify budgets)' +THEN 'Konten hinzufügen/ändern, aber bestehende nicht ändern' +-- Statement 1, PK:11,'budget_manage_all', description +WHEN 'Manage all budgets' +THEN 'Alle Konten verwalten' +-- Statement 1, PK:13,'edit_news', description +WHEN 'Write news for the OPAC and staff interfaces' +THEN 'Nachrichten für OPAC und Dienstoberfläche verfassen' +-- Statement 1, PK:13,'label_creator', description +WHEN 'Create printable labels and barcodes from catalog and patron data' +THEN 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen' +-- Statement 1, PK:13,'edit_calendar', description +WHEN 'Define days when the library is closed' +THEN 'Schließtage eintragen' +-- Statement 1, PK:13,'moderate_comments', description +WHEN 'Moderate patron comments' +THEN 'Benutzerkommentare moderieren' +-- Statement 1, PK:13,'edit_notices', description +WHEN 'Define notices' +THEN 'Benachrichtigungen verwalten' +-- Statement 1, PK:13,'edit_notice_status_triggers', description +WHEN 'Set notice/status triggers for overdue items' +THEN 'Mahntrigger für überfällige Medien verwalten' +-- Statement 1, PK:13,'edit_quotes', description +WHEN 'Edit quotes for quote-of-the-day feature' +THEN '"Zitat des Tages" konfigurieren' +-- Statement 1, PK:13,'view_system_logs', description +WHEN 'Browse the system logs' +THEN 'Logs durchsuchen/einsehen' +-- Statement 1, PK:13,'inventory', description +WHEN 'Perform inventory (stocktaking) of your catalog' +THEN 'Inventur durchführen' +-- Statement 1, PK:13,'stage_marc_import', description +WHEN 'Stage MARC records into the reservoir' +THEN 'MARC-Datensätze zwischenspeichern' +-- Statement 1, PK:13,'manage_staged_marc', description +WHEN 'Managed staged MARC records, including completing and reversing imports' +THEN 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen' +-- Statement 1, PK:13,'export_catalog', description +WHEN 'Export bibliographic and holdings data' +THEN 'Titel- und Exemplardaten exportieren' +-- Statement 1, PK:13,'import_patrons', description +WHEN 'Import patron data' +THEN 'Benutzerdaten importieren' +-- Statement 1, PK:13,'edit_patrons', description +WHEN 'Perform batch modification of patrons' +THEN 'Stapelbearbeitung von Benutzerdaten durchführen' +-- Statement 1, PK:13,'delete_anonymize_patrons', description +WHEN 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)' +THEN 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)' +-- Statement 1, PK:13,'batch_upload_patron_images', description +WHEN 'Upload patron images in batch or one at a time' +THEN 'Benutzerfotos einzeln oder im Stapel hochladen' +-- Statement 1, PK:13,'schedule_tasks', description +WHEN 'Schedule tasks to run' +THEN 'Aufgabenplaner verwenden' +-- Statement 1, PK:13,'items_batchmod', description +WHEN 'Perform batch modification of items' +THEN 'Stapelbearbeitung von Exemplaren durchführen' +-- Statement 1, PK:13,'items_batchdel', description +WHEN 'Perform batch deletion of items' +THEN 'Stapellöschung von Exemplaren durchführen' +-- Statement 1, PK:13,'manage_csv_profiles', description +WHEN 'Manage CSV export profiles' +THEN 'CSV-Profile für Export verwalten' +-- Statement 1, PK:13,'moderate_tags', description +WHEN 'Moderate patron tags' +THEN 'Von Benutzern vergebene Tags moderieren' +-- Statement 1, PK:13,'rotating_collections', description +WHEN 'Manage rotating collections' +THEN 'Wandernde Sammlungen verwalten' +-- Statement 1, PK:13,'upload_local_cover_images', description +WHEN 'Upload local cover images' +THEN 'Eigene Coverbilder hochladen' +-- Statement 1, PK:15,'check_expiration', description +WHEN 'Check the expiration of a serial' +THEN 'Ablauf eines Abonnements prüfen' +-- Statement 1, PK:15,'claim_serials', description +WHEN 'Claim missing serials' +THEN 'Fehlende Hefte reklamieren' +-- Statement 1, PK:15,'create_subscription', description +WHEN 'Create a new subscription' +THEN 'Neues Abonnement anlegen' +-- Statement 1, PK:15,'delete_subscription', description +WHEN 'Delete an existing subscription' +THEN 'Bestehende Abonnements löschen' +-- Statement 1, PK:15,'edit_subscription', description +WHEN 'Edit an existing subscription' +THEN 'Bestehende Abonnements bearbeiten' +-- Statement 1, PK:15,'receive_serials', description +WHEN 'Serials receiving' +THEN 'Zugang von Heften' +-- Statement 1, PK:15,'renew_subscription', description +WHEN 'Renew a subscription' +THEN 'Abonnements verlängern' +-- Statement 1, PK:15,'routing', description +WHEN 'Routing' +THEN 'Umlauflisten verwalten' +-- Statement 1, PK:16,'execute_reports', description +WHEN 'Execute SQL reports' +THEN 'SQL-Reports ausführen' +-- Statement 1, PK:16,'create_reports', description +WHEN 'Create SQL Reports' +THEN 'SQL-Reports erstellen' +-- Statement 1, PK:18,'manage_courses', description +WHEN 'Add, edit and delete courses' +THEN 'Add, edit and delete courses' +-- Statement 1, PK:18,'add_reserves', description +WHEN 'Add course reserves' +THEN 'Add course reserves' +-- Statement 1, PK:18,'delete_reserves', description +WHEN 'Remove course reserves' +THEN 'Remove course reserves' +-- Statement 1, PK:19,'manage', description +WHEN 'Manage plugins ( install / uninstall )' +THEN 'Plugins verwealten (installieren/deinstallieren)' +-- Statement 1, PK:19,'tool', description +WHEN 'Use tool plugins' +THEN 'Werkzeug-Plugins verwenden' +-- Statement 1, PK:19,'report', description +WHEN 'Use report plugins' +THEN 'Report-Plugins verwenden' +-- Statement 1, PK:19,'configure', description +WHEN 'Configure plugins' +THEN 'Plugins konfigurieren' + +ELSE d +END; +END // \ No newline at end of file diff --git a/installer/data/mysql/de-DE/mandatory/userpermissions.txt b/installer/data/mysql/de-DE/mandatory.i18n/userpermissions.txt similarity index 100% rename from installer/data/mysql/de-DE/mandatory/userpermissions.txt rename to installer/data/mysql/de-DE/mandatory.i18n/userpermissions.txt diff --git a/installer/data/mysql/de-DE/mandatory/class_sources.sql b/installer/data/mysql/de-DE/mandatory/class_sources.sql deleted file mode 100644 index 3b0174b..0000000 --- a/installer/data/mysql/de-DE/mandatory/class_sources.sql +++ /dev/null @@ -1,36 +0,0 @@ --- --- Default classification sources and filing rules --- for Koha. --- --- Copyright (C) 2007 LiblimeA --- --- 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 2 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, write to the Free Software Foundation, Inc., --- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. - --- class sorting (filing) rules -INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES - ('dewey', 'Standard-Sortierregeln für DDC', 'Dewey'), - ('lcc', 'Standard-Sortierregeln für LCC', 'LCC'), - ('generic', 'Generische Sortierregeln für Signaturen', 'Generic'); - - --- classification schemes or sources -INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES - ('ddc', 'Dewey-Decimalklassifikation (DDC)', 1, 'dewey'), - ('lcc', 'Klassifikation der Library of Congress (LCC)', 1, 'lcc'), - ('udc', 'Universelle Dezimalklassifikation (UDC)', 0, 'generic'), - ('sudocs', 'SuDoc-Klassifikation (U.S. GPO)', 0, 'generic'), - ('anscr', 'ANSCR (Tonaufnahmen)', 0, 'generic'), - ('z', 'Andere/Generische Klassifikation', 0, 'generic'); diff --git a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql b/installer/data/mysql/de-DE/mandatory/message_transport_types.sql deleted file mode 100644 index bbcb64c..0000000 --- a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql +++ /dev/null @@ -1,7 +0,0 @@ -INSERT INTO message_transport_types -(message_transport_type) -values -('email'), -('print'), -('sms'), -('feed'); diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices.sql b/installer/data/mysql/de-DE/mandatory/sample_notices.sql deleted file mode 100644 index e32224c..0000000 --- a/installer/data/mysql/de-DE/mandatory/sample_notices.sql +++ /dev/null @@ -1,122 +0,0 @@ -INSERT INTO `letter` (module, code, name, title, content) -VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <> <>,\n\nNach unseren Unterlagen haben Sie Medien entliehen, die nun überfällig geworden sind. Unsere Bibliothek erhebt keine Mahngebühren, bitte geben Sie die entliehenen Medien schnellstmöglich zurück.\n\n<>\n<>\n<> <>\nTelefon: <>\nFax: <>\nEmail: <>\n\nSie können die überfälligen Medien soweit möglich auch direkt über Ihr Benutzerkonto online verlängern. Wenn ein Medium länger als 30 Tage überfällig ist, wird Ihr Benutzeraccount gesperrt und Sie können keine Medien mehr entleihen.\n\nDie folgenden Medien sind zur Zeit überfällig:\n\n"<>" by <>, <>, Barcode: <> Gebühr: <>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'), -('claimacquisition','ACQCLAIM','Reklamation (Erwerbung)','Titel nicht eingetroffen','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> bestellt) (je $<> €) sind nicht eingetroffen.'), -('serial','RLIST','Neues Heft zugegangen','Zeitschrift ist jetzt verfügbar','<> <>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<>, <> (<>)\r\n\r\nBitte holen Sie es sobald möglich ab.'), -('members','ACCTDETAILS','Kontoinformationen - Standard','Ihr neues Benutzerkonto','Liebe/r <> <> <>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer: <>\r\nPasswort: <>\r\n\r\nWenn Sie Probleme in Hinsicht auf Ihr Benutzerkonto haben, wenden Sie sich bitte an die Bibliothek.\r\n\r\nVielen Dank,\r\nIhr Bibliotheksteam'), -('circulation','DUE','Fälligkeitsbenachrichtigung','Fälligkeitsbenachrichtigung','Liebe/r <> <>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<>, <> (<>)'), -('circulation','DUEDGST','Fälligkeitsbenachrichtigung (Zusammenfassung)','Fälligkeitsbenachrichtigung','Sie haben <> überfällige Medien.'), -('circulation','PREDUE','Erinnerungsbenachrichtigung','Erinnerungsbenachrichtigung','Liebe/r <> <>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<>, <> (<>)'), -('circulation','PREDUEDGST','Erinnerungsbenachrichtigung (Zusammenfassung)','Erinnerungsbenachrichtigung','Sie haben <> Ausleihen, die bald fällig werden.'), -('circulation','RENEWAL','Verlängerungsbenachrichtigung','Verlängerungsquittung','Liebe/r <> <>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<>\r\n----\r\nVielen Dank,\r\n<>.'), -('reserves', 'HOLD', 'Vormerkbenachrichtigung', 'Vormerkung abholbereit in <>', 'Liebe/r <> <>,\r\n\r\nFür Sie liegt seit <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nExemplar: <>\r\nStandort: <>\r\n<>\r\n<>\r\n<>\r\n<> <>'), -('reserves', 'HOLD_PRINT', 'Vormerkbenachrichtigung (Print)', 'Vormerkbenachrichtigung (Print)', '<>\r\n<>\r\n<>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<>\r\n<> <>\r\n<>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <> <>,\r\n\r\nFür Sie liegt seit dem <> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <>\r\nVerfasser: <>\r\nSignatur: <>\r\n'), -('circulation','CHECKIN','Rückgabequittung (Zusammenfassung)','Rückgabequittung','Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<>\r\n----\r\nVielen Dank.'), -('circulation','CHECKOUT','Ausleihquittung (Zusammenfassung)','Ausleihquittung','Die folgenden Medien wurden entliehen:\r\n----\r\n<>\r\n----\r\nVielen Dank für Ihren Besuch in <>.'), -('reserves', 'HOLDPLACED', 'Neue Vormerkung', 'Neue Vormerkung','Folgender Titel wurde vorgemerkt: <> (<>) durch den Benutzer <> <> (<>).'), -('suggestions','ACCEPTED','Anschaffungsvorschlag wurde angenommen', 'Ihr Anschaffungsvorschlag wurde angenommen','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> by <>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und wird Ihn sobald wie möglich im Buchhandel bestellen. Sie erhalten Nachricht, sobald die Bestellung abgeschlossen ist und sobald der Titel in der Bibliotek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>'), -('suggestions','AVAILABLE','Vorgeschlagenes Medium verfügbar', 'Das vorgeschlagene Medium ist jetzt verfügbar','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <> von <>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Bestand der Bibliothek verfügbar ist.\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <>.\n\nVielen Dank,\n\n<>'), -('suggestions','ORDERED','Vorgeschlagenes Medium bestellt', 'Das vorgeschlagene Medium wurde im Buchhandel bestellt','Liebe(r) <> <>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <> von <>.\n\nWir freuen uns Ihnen mitteilen zu können, dass dieser Titel jetzt im Buchhandel bestellt wurde. Nach Eintreffen wird er in unseren Bestand eingearbeitet.\n\nSie erhalten Nachricht, sobald das Medium verfügbar ist.\n\nBei Nachfragen erreichen Sie uns unter der Emailadresse <>.\n\nVielen Dank,\n\n<>'), -('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: <> <> <>
    -(<>)
    - -<>
    - -

    Ausleihen

    - -

    -<>
    -Barcode: <>
    -Fällig am: <>
    -

    -     - -

    Überfällig

    - -

    -<>
    -Barcode: <>
    -Fällig am: <>
    -

    -     - -
    - -

    Neuigkeiten

    - -
    -
    <>
    -

    <>

    -

    Veröffentlicht am <>

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

    <>

    -Ausleihe an: <> <> <>
    -(<>)
    - -<>
    - -

    Heutige Ausleihen

    - -

    -<>
    -Barcode: <>
    -Fällig am: <>
    -

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

    Bereitstellung in <>

    - -

    <>, <>

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

    VORMERKUNG

    -

    <>

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

    Notiz: -

    <>
    -

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

    Transport nach <>

    - -

    EXEMPLAR

    -

    <>

    -
    <>
    -
      -
    • <>
      • -
    • <>
      • -
    ', 1); - -INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) -VALUES ( -'members', 'OPAC_REG_VERIFY', '', 'Bestätigung der Anmeldung zur Bibliotheksnutzung', '1', 'Verify Your Account', 'Guten Tag, - -Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken: - -http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<> - -Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachrichtigung ignorieren. Sie wird in Kürze ungültig. - -Vielen Dank, -Ihr Bibliotheksteam'); diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql deleted file mode 100644 index b078106..0000000 --- a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql +++ /dev/null @@ -1,8 +0,0 @@ -insert into `message_attributes` -(`message_attribute_id`, message_name, `takes_days`) -values -(1, 'Item_Due', 0), -(2, 'Advance_Notice', 1), -(4, 'Hold_Filled', 0), -(5, 'Item_Check_in', 0), -(6, 'Item_Checkout', 0); \ No newline at end of file diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql deleted file mode 100644 index ae68378..0000000 --- a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql +++ /dev/null @@ -1,17 +0,0 @@ -insert into `message_transports` -(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) -values -(1, 'email', 0, 'circulation', 'DUE'), -(1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), -(1, 'sms', 0, 'circulation', 'DUE'), -(1, 'sms', 1, 'circulation', 'DUEDGST'), -(2, 'sms', 0, 'circulation', 'PREDUE'), -(2, 'sms', 1, 'circulation', 'PREDUEDGST'), -(4, 'sms', 0, 'reserves', 'HOLD'), -(5, 'email', 0, 'circulation', 'CHECKIN'), -(5, 'sms', 0, 'circulation', 'CHECKIN'), -(6, 'email', 0, 'circulation', 'CHECKOUT'), -(6, 'sms', 0, 'circulation', 'CHECKOUT'); diff --git a/installer/data/mysql/de-DE/mandatory/stopwords.sql b/installer/data/mysql/de-DE/mandatory/stopwords.sql deleted file mode 100644 index 6c140b1..0000000 --- a/installer/data/mysql/de-DE/mandatory/stopwords.sql +++ /dev/null @@ -1,99 +0,0 @@ -INSERT INTO stopwords (word) VALUES -('a'), -('about'), -('also'), -('an'), -('and'), -('another'), -('any'), -('are'), -('as'), -('at'), -('back'), -('be'), -('because'), -('been'), -('being'), -('but'), -('by'), -('can'), -('could'), -('did'), -('do'), -('each'), -('end'), -('even'), -('for'), -('from'), -('get'), -('go'), -('had'), -('have'), -('he'), -('her'), -('here'), -('his'), -('how'), -('i'), -('if'), -('in'), -('into'), -('is'), -('it'), -('just'), -('may'), -('me'), -('might'), -('much'), -('must'), -('my'), -('no'), -('not'), -('of'), -('off'), -('on'), -('only'), -('or'), -('other'), -('our'), -('out'), -('should'), -('so'), -('some'), -('still'), -('such'), -('than'), -('that'), -('the'), -('their'), -('them'), -('then'), -('there'), -('these'), -('they'), -('this'), -('those'), -('to'), -('too'), -('try'), -('two'), -('under'), -('up'), -('us'), -('was'), -('we'), -('were'), -('what'), -('when'), -('where'), -('which'), -('while'), -('who'), -('why'), -('will'), -('with'), -('within'), -('without'), -('would'), -('you'), -('your'); diff --git a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql b/installer/data/mysql/de-DE/mandatory/subtag_registry.sql deleted file mode 100644 index 9663c5c..0000000 --- a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql +++ /dev/null @@ -1,897 +0,0 @@ --- http://www.w3.org/International/articles/language-tags/ - --- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); - --- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); - --- EXTENSIONS --- Interface (i) --- SELECT * FROM language_subtag_registry WHERE type='i'; --- OPAC -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'opac', 'i', 'OPAC','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'en', 'OPAC'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', 'OPAC'); - --- Staff Client -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'en', 'Staff Client'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); - --- Theme (t) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'prog', 't', 'Prog','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'en', 'Prog'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); - --- LANGUAGES - --- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ar', 'language', 'Arabic','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ar','ara'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'de', 'Arabisch'); - --- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'de', 'Armenisch'); - --- Bulgarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'bg','bul'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'de', 'Bulgarisch'); - --- Chinese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'zh','chi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'zh', 'language', 'zh', '中文'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'en', 'Chinese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'fr', 'Chinois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'de', 'Chinesisch'); - --- Czech -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'cs', 'language', 'Czech','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'cs','cze'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'de', 'Tschechisch'); - --- Danish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'da', 'language', 'Danish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'da','dan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'da', 'language', 'da', 'Dansk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'en', 'Danish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'de', 'Dänisch'); - --- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'de', 'Niederländisch'); - --- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'en', 'language', 'English','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'en','eng'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'de', 'Englisch'); - --- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'de', 'Finnisch'); - --- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'de', 'Französisch'); - --- INSERT INTO language_descriptions(subtag, type, lang, description) --- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'fr', 'Laotien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'de', 'Laotisch'); - --- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'fr', 'Allemand'); - --- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'el','gre'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'el', 'ελληνικά'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); - -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)'); - --- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'he','heb'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'de', 'Hebräisch'); - --- Hindi -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hi', 'language', 'Hindi','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hi','hin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'de', 'Hindi'); - --- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'de', 'Ungarisch'); - --- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'de', 'Indonesisch'); - --- Italian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'it', 'language', 'Italian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ita'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'de', 'Italienisch'); - --- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'de', 'Japanisch'); - --- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'de', 'Koreanisch'); - --- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'de', 'Latein'); - --- Galician - -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'fr', 'Galicien'); - --- Norwegian (bokmål) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nor'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål'); - --- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk'); - --- Persian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fa', 'language', 'Persian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fa','per'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'de', 'Persisch'); - --- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'de', 'Polnisch'); - --- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'de', 'Portugiesisch'); - --- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'de', 'Rumänisch'); - --- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'de', 'Russisch'); - --- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sr','srp'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'fr', 'Serbe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'de', 'Serbisch'); - --- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'de', 'Spanisch'); - --- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ca','cat'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'es', 'Catalán'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'en', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); - --- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sv','swe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'sv', 'Svenska'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'en', 'Swedish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'de', 'Schwedisch'); - --- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tet','tet'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'fr', 'Tétoum'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'de', 'Tetum'); - --- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'th','tha'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'th', 'ภาษาไทย'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'en', 'Thai'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'de', 'Thailändisch'); - --- Turkish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tr','tur'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'tr', 'Türkçe'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'en', 'Turkish'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'fr', 'Turc'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'de', 'Türkisch'); - --- Ukranian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'uk','ukr'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'uk', 'Українська'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'en', 'Ukranian'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'fr', 'Ukrainien'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'de', 'Ukrainisch'); - --- Urdu -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); - -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ur','urd'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'en', 'Urdu'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'ur', 'اردو'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'fr', 'Ourdou'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'de', 'Urdu'); - --- SCRIPTS --- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Arab','script', 'Arab', 'العربية'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','en', 'Arabic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','fr', 'Arabic'); - --- Cyrillic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Cyrl', 'script', 'Cyrl', '????'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); - --- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Grek', 'script', 'Grek', '????'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'en', 'Greek'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'fr', 'Greek'); - --- Han - Simplified -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); - --- Han - Traditional -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); - --- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); - --- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Laoo', 'script', 'lo', 'Lao'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); - --- REGIONS --- Canada -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'CA', 'region', 'Canada','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'CA', 'region', 'en', 'Canada'); - --- Denmark -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'DK', 'region', 'Denmark','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'DK', 'region', 'dk', 'Danmark'); - --- France -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'FR', 'region', 'France','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'FR', 'region', 'fr', 'France'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); - --- New Zealand -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'NZ', 'region', 'en', 'New Zealand'); - --- United Kingdom -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'GB', 'region', 'en', 'United Kingdom'); - --- United States -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'US', 'region', 'United States','2005-10-16'); - -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'US', 'region', 'en', 'United States'); diff --git a/installer/data/mysql/de-DE/mandatory/userflags.sql b/installer/data/mysql/de-DE/mandatory/userflags.sql deleted file mode 100644 index f2a0619..0000000 --- a/installer/data/mysql/de-DE/mandatory/userflags.sql +++ /dev/null @@ -1,20 +0,0 @@ -INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES -(0,'superlibrarian','Zugriff auf alle Funktionen',0), -(1,'circulate','Medien ausleihen/zurückgeben',0), -(2,'catalogue','Katalogsuche verwenden (Dienstoberfläche)',0), -(3,'parameters','Systemparameter verändern',0), -(4,'borrowers','Benutzer anlegen/ändern',0), -(5,'permissions','Berechtigungen für Benutzer vergeben',0), -(6,'reserveforothers','Vormerkungen für Benutzer setzen/ändern',0), -(7,'borrow','Medien entleihen',1), -(9,'editcatalogue','Katalogdaten ändern (Titel- und Bestandsdaten ändern)',0), -(10,'updatecharges','Gebühren kassieren/ändern',0), -(11,'acquisition','Erwerbung und Verwaltung von Anschaffungsvorschlägen',0), -(12,'management','Zugriff auf Administration',0), -(13,'tools','Werkzeuge verwenden (Export, Import, Etikettendruck)',0), -(14,'editauthorities','Normdaten ändern',0), -(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0), -(16,'reports','Zugriff auf Reportmodul',0), -(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0), -(18,'coursereserves','Course Reserves',0), -(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 deleted file mode 100644 index eb2d48a..0000000 --- a/installer/data/mysql/de-DE/mandatory/userpermissions.sql +++ /dev/null @@ -1,63 +0,0 @@ -INSERT INTO permissions (module_bit, code, description) VALUES - ( 1, 'circulate_remaining_permissions', 'Übrige Ausleihberechtigungen'), - ( 1, 'override_renewals', 'Gesperrte Verlängerungen überschreiben'), - ( 1, 'overdues_report', 'Überfälligkeiten-Report ausführen'), - ( 3, 'parameters_remaining_permissions', 'Übrige Administrationsberechtigungen'), - ( 3, 'manage_circ_rules', 'Ausleihkonditionen verwalten'), - ( 6, 'place_holds', 'Vormerkungen für Benutzer setzen'), - ( 6, 'modify_holds_priority', 'Vormerkungspriorität verändern'), - ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'), - ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'), - ( 9, 'edit_items', 'Exemplare bearbeiten'), - (11, 'vendors_manage', 'Lieferanten verwalten'), - (11, 'contracts_manage', 'Vereinbarungen verwalten'), - (11, 'period_manage', 'Etats verwalten'), - (11, 'budget_manage', 'Konten verwalten'), - (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'), - (11, 'planning_manage', 'Etatplanung verwalten'), - (11, 'order_manage', 'Bestellungen verwalten'), - (11, 'group_manage', 'Bestellgruppen vewalten'), - (11, 'order_receive', 'Lieferungen verwalten'), - (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'), - (11, 'budget_manage_all', 'Alle Konten verwalten'), - (13, 'edit_news', 'Nachrichten für OPAC und Dienstoberfläche verfassen'), - (13, 'label_creator', 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'), - (13, 'edit_calendar', 'Schließtage eintragen'), - (13, 'moderate_comments', 'Benutzerkommentare moderieren'), - (13, 'edit_notices', 'Benachrichtigungen verwalten'), - (13, 'edit_notice_status_triggers', 'Mahntrigger für überfällige Medien verwalten'), - (13, 'edit_quotes', '"Zitat des Tages" konfigurieren'), - (13, 'view_system_logs', 'Logs durchsuchen/einsehen'), - (13, 'inventory', 'Inventur durchführen'), - (13, 'stage_marc_import', 'MARC-Datensätze zwischenspeichern'), - (13, 'manage_staged_marc', 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'), - (13, 'export_catalog', 'Titel- und Exemplardaten exportieren'), - (13, 'import_patrons', 'Benutzerdaten importieren'), - (13, 'edit_patrons', 'Stapelbearbeitung von Benutzerdaten durchführen'), - (13, 'delete_anonymize_patrons', 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'), - (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'), - (13, 'schedule_tasks', 'Aufgabenplaner verwenden'), - (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'), - (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'), - (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'), - (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'), - (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'), - (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'), - (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'), - (15, 'claim_serials', 'Fehlende Hefte reklamieren'), - (15, 'create_subscription', 'Neues Abonnement anlegen'), - (15, 'delete_subscription', 'Bestehende Abonnements löschen'), - (15, 'edit_subscription', 'Bestehende Abonnements bearbeiten'), - (15, 'receive_serials', 'Zugang von Heften'), - (15, 'renew_subscription', 'Abonnements verlängern'), - (15, 'routing', 'Umlauflisten verwalten'), - (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)'), - (19, 'tool', 'Werkzeug-Plugins verwenden'), - (19, 'report', 'Report-Plugins verwenden'), - (19, 'configure', 'Plugins konfigurieren') -; -- 1.7.7.6