View | Details | Raw Unified | Return to bug 10521
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/mandatory.i18n/class_sources.sql (+41 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
8
-- Class sorting (filing) rules
9
-- Statement 1, PK:'dewey', description
10
WHEN 'Default filing rules for DDC'
11
THEN 'Standard-Sortierregeln für DDC'
12
-- Statement 1, PK:'lcc', description
13
WHEN 'Default filing rules for LCC'
14
THEN 'Standard-Sortierregeln für LCC'
15
-- Statement 1, PK:'generic', description
16
WHEN 'Generic call number filing rules'
17
THEN 'Generische Sortierregeln für Signaturen'
18
19
-- Classification schemes or sources
20
-- Statement 2, PK:'ddc', description
21
WHEN 'Dewey Decimal Classification'
22
THEN 'Dewey-Decimalklassifikation (DDC)'
23
-- Statement 2, PK:'lcc', description
24
WHEN 'Library of Congress Classification'
25
THEN 'Klassifikation der Library of Congress (LCC)'
26
-- Statement 2, PK:'udc', description
27
WHEN 'Universal Decimal Classification'
28
THEN 'Universelle Dezimalklassifikation (UDC)'
29
-- Statement 2, PK:'sudocs', description
30
WHEN 'SuDoc Classification (U.S. GPO)'
31
THEN 'SuDoc-Klassifikation (U.S. GPO)'
32
-- Statement 2, PK:'anscr', description
33
WHEN 'ANSCR (Sound Recordings)'
34
THEN 'ANSCR (Tonaufnahmen)'
35
-- Statement 2, PK:'z', description
36
WHEN 'Other/Generic Classification Scheme'
37
THEN 'Andere/Generische Klassifikation'
38
39
ELSE d
40
END;
41
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/message_transport_types.sql (+10 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
8
ELSE d
9
END;
10
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices.sql (+404 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
-- Statement 1, PK:'circulation','ODUE', name
8
WHEN 'Overdue Notice'
9
THEN 'Mahnung'
10
-- Statement 1, PK:'circulation','ODUE', title
11
WHEN 'Item Overdue'
12
THEN 'Mahnung'
13
-- Statement 1, PK:'circulation','ODUE', content
14
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\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<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nPhone: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\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<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Fine: <<items.fine>></item>\n\nThank-you for your prompt attention to this matter.\n\n<<branches.branchname>> Staff\n'
15
THEN 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\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<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTelefon: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\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<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Gebühr: <<items.fine>></item>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'
16
-- Statement 1, PK:'claimacquisition','ACQCLAIM', name
17
WHEN 'Acquisition Claim'
18
THEN 'Reklamation (Erwerbung)'
19
-- Statement 1, PK:'claimacquisition','ACQCLAIM', title
20
WHEN 'Item Not Received'
21
THEN 'Titel nicht eingetroffen'
22
-- Statement 1, PK:'claimacquisition','ACQCLAIM', content
23
WHEN '<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order>'
24
THEN '<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> bestellt) (je $<<aqorders.listprice>> €) sind nicht eingetroffen.</order>'
25
-- Statement 1, PK:'serial','RLIST', name
26
WHEN 'Routing List'
27
THEN 'Neues Heft zugegangen'
28
-- Statement 1, PK:'serial','RLIST', title
29
WHEN 'Serial is now available'
30
THEN 'Zeitschrift ist jetzt verfügbar'
31
-- Statement 1, PK:'serial','RLIST', content
32
WHEN '<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following issue is now available:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nPlease pick it up at your convenience.'
33
THEN '<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nBitte holen Sie es sobald möglich ab.'
34
-- Statement 1, PK:'members','ACCTDETAILS', name
35
WHEN 'Account Details Template - DEFAULT'
36
THEN 'Kontoinformationen - Standard'
37
-- Statement 1, PK:'members','ACCTDETAILS', title
38
WHEN 'Your new Koha account details.'
39
THEN 'Ihr neues Benutzerkonto'
40
-- Statement 1, PK:'members','ACCTDETAILS', content
41
WHEN 'Hello <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser:  <<borrowers.userid>>\r\nPassword: <<borrowers.password>>\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'
42
THEN 'Liebe/r <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer:  <<borrowers.userid>>\r\nPasswort: <<borrowers.password>>\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'
43
-- Statement 1, PK:'circulation','DUE', name
44
WHEN 'Item Due Reminder'
45
THEN 'Fälligkeitsbenachrichtigung'
46
-- Statement 1, PK:'circulation','DUE', title
47
WHEN 'Item Due Reminder'
48
THEN 'Fälligkeitsbenachrichtigung'
49
-- Statement 1, PK:'circulation','DUE', content
50
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item is now due:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
51
THEN 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
52
-- Statement 1, PK:'circulation','DUEDGST', name
53
WHEN 'Item Due Reminder (Digest)'
54
THEN 'Fälligkeitsbenachrichtigung (Zusammenfassung)'
55
-- Statement 1, PK:'circulation','DUEDGST', title
56
WHEN 'Item Due Reminder'
57
THEN 'Fälligkeitsbenachrichtigung'
58
-- Statement 1, PK:'circulation','DUEDGST', content
59
WHEN 'You have <<count>> items due'
60
THEN 'Sie haben <<count>> überfällige Medien.'
61
-- Statement 1, PK:'circulation','PREDUE', name
62
WHEN 'Advance Notice of Item Due'
63
THEN 'Erinnerungsbenachrichtigung'
64
-- Statement 1, PK:'circulation','PREDUE', title
65
WHEN 'Advance Notice of Item Due'
66
THEN 'Erinnerungsbenachrichtigung'
67
-- Statement 1, PK:'circulation','PREDUE', content
68
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nThe following item will be due soon:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
69
THEN 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'
70
-- Statement 1, PK:'circulation','PREDUEDGST', name
71
WHEN 'Advance Notice of Item Due (Digest)'
72
THEN 'Erinnerungsbenachrichtigung (Zusammenfassung)'
73
-- Statement 1, PK:'circulation','PREDUEDGST', title
74
WHEN 'Advance Notice of Item Due'
75
THEN 'Erinnerungsbenachrichtigung'
76
-- Statement 1, PK:'circulation','PREDUEDGST', content
77
WHEN 'You have <<count>> items due soon'
78
THEN 'Sie haben <<count>> Ausleihen, die bald fällig werden.'
79
-- Statement 1, PK:'circulation','RENEWAL', name
80
WHEN 'Item Renewals'
81
THEN 'Verlängerungsbenachrichtigung'
82
-- Statement 1, PK:'circulation','RENEWAL', title
83
WHEN 'Item Renewals'
84
THEN 'Verlängerungsquittung'
85
-- Statement 1, PK:'circulation','RENEWAL', content
86
WHEN 'The following items have been renewed:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.'
87
THEN 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank,\r\n<<branches.branchname>>.'
88
-- Statement 1, PK:'reserves','HOLD', name
89
WHEN 'Hold Available for Pickup'
90
THEN 'Vormerkbenachrichtigung'
91
-- Statement 1, PK:'reserves','HOLD', title
92
WHEN 'Hold Available for Pickup at <<branches.branchname>>'
93
THEN 'Vormerkung abholbereit in <<branches.branchname>>'
94
-- Statement 1, PK:'reserves','HOLD', content
95
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\nLocation: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'
96
THEN 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nExemplar: <<items.copynumber>>\r\nStandort: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'
97
-- Statement 1, PK:'reserves','HOLD_PRINT', name
98
WHEN 'Hold Available for Pickup (print notice)'
99
THEN 'Vormerkbenachrichtigung (Print)'
100
-- Statement 1, PK:'reserves','HOLD_PRINT', title
101
WHEN 'Hold Available for Pickup (print notice)'
102
THEN 'Vormerkbenachrichtigung (Print)'
103
-- Statement 1, PK:'reserves','HOLD_PRINT', content
104
WHEN '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.city>> <<borrowers.zipcode>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>> <<borrowers.cardnumber>>\r\n\r\nYou have a hold available for pickup as of <<reserves.waitingdate>>:\r\n\r\nTitle: <<biblio.title>>\r\nAuthor: <<biblio.author>>\r\nCopy: <<items.copynumber>>\r\n'
105
THEN '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchzip>> <<branches.branchcity>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.address2>>\r\n<<borrowers.zipcode>> <<borrowers.city>>\r\n<<borrowers.country>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit dem <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nSignatur: <<items.itemcallnumber>>\r\n'
106
-- Statement 1, PK:'circulation','CHECKIN', name
107
WHEN 'Item Check-in (Digest)'
108
THEN 'Rückgabequittung (Zusammenfassung)'
109
-- Statement 1, PK:'circulation','CHECKIN', title
110
WHEN 'Check-ins'
111
THEN 'Rückgabequittung'
112
-- Statement 1, PK:'circulation','CHECKIN', content
113
WHEN 'The following items have been checked in:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you.'
114
THEN 'Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank.'
115
-- Statement 1, PK:'circulation','CHECKOUT', name
116
WHEN 'Item Check-out (Digest)'
117
THEN 'Ausleihquittung (Zusammenfassung)'
118
-- Statement 1, PK:'circulation','CHECKOUT', title
119
WHEN 'Checkouts'
120
THEN 'Ausleihquittung'
121
-- Statement 1, PK:'circulation','CHECKOUT', content
122
WHEN 'The following items have been checked out:\r\n----\r\n<<biblio.title>>\r\n----\r\nThank you for visiting <<branches.branchname>>.'
123
THEN 'Die folgenden Medien wurden entliehen:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank für Ihren Besuch in <<branches.branchname>>.'
124
-- Statement 1, PK:'reserves','HOLDPLACED', name
125
WHEN 'Hold Placed on Item'
126
THEN 'Neue Vormerkung'
127
-- Statement 1, PK:'reserves','HOLDPLACED', title
128
WHEN 'Hold Placed on Item'
129
THEN 'Neue Vormerkung'
130
-- Statement 1, PK:'reserves','HOLDPLACED', content
131
WHEN 'A hold has been placed on the following item : <<biblio.title>> (<<biblio.biblionumber>>) by the user <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'
132
THEN 'Folgender Titel wurde vorgemerkt: <<biblio.title>> (<<biblio.biblionumber>>) durch den Benutzer <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'
133
-- Statement 1, PK:'suggestions','ACCEPTED', name
134
WHEN 'Suggestion accepted'
135
THEN 'Anschaffungsvorschlag wurde angenommen'
136
-- Statement 1, PK:'suggestions','ACCEPTED', title
137
WHEN 'Purchase suggestion accepted'
138
THEN 'Ihr Anschaffungsvorschlag wurde angenommen'
139
-- Statement 1, PK:'suggestions','ACCEPTED', content
140
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\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 <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'
141
THEN 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> by <<suggestions.author>>.\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: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
142
-- Statement 1, PK:'suggestions','AVAILABLE', name
143
WHEN 'Suggestion available'
144
THEN 'Vorgeschlagenes Medium verfügbar'
145
-- Statement 1, PK:'suggestions','AVAILABLE', title
146
WHEN 'Suggested purchase available'
147
THEN 'Das vorgeschlagene Medium ist jetzt verfügbar'
148
-- Statement 1, PK:'suggestions','AVAILABLE', content
149
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\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 <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'
150
THEN 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\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: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
151
-- Statement 1, PK:'suggestions','ORDERED', name
152
WHEN 'Suggestion ordered'
153
THEN 'Vorgeschlagenes Medium bestellt'
154
-- Statement 1, PK:'suggestions','ORDERED', title
155
WHEN 'Suggested item ordered'
156
THEN 'Das vorgeschlagene Medium wurde im Buchhandel bestellt'
157
-- Statement 1, PK:'suggestions','ORDERED', content
158
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\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 <<branches.branchemail>>\n\nThank you,\n\n<<branches.branchname>>'
159
THEN 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <<suggestions.title>> von <<suggestions.author>>.\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 <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
160
-- Statement 1, PK:'suggestions','REJECTED', name
161
WHEN 'Suggestion rejected'
162
THEN 'Anschaffungsvorschlag nicht angenommen'
163
-- Statement 1, PK:'suggestions','REJECTED', title
164
WHEN 'Purchase suggestion declined'
165
THEN 'Ihr Anschaffungsvorschlag wurde nicht angenommen'
166
-- Statement 1, PK:'suggestions','REJECTED', content
167
WHEN 'Dear <<borrowers.firstname>> <<borrowers.surname>>,\n\nYou have suggested that the library acquire <<suggestions.title>> by <<suggestions.author>>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <<suggestions.reason>>\n\nIf you have any questions, please email us at <<branches.branchemail>>.\n\nThank you,\n\n<<branches.branchname>>'
168
THEN 'Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <<suggestions.reason>>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'
169
170
171
-- Statement 2, PK:'circulation','ISSUESLIP', name
172
WHEN 'Issue Slip'
173
THEN 'Ausleihquittung (Quittungsdruck)'
174
-- Statement 2, PK:'circulation','ISSUESLIP', title
175
WHEN 'Issue Slip'
176
THEN 'Ausleihquittung (Quittungsdruck)'
177
-- Statement 2, PK:'circulation','ISSUESLIP', content
178
WHEN '<h3><<branches.branchname>></h3>
179
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
180
(<<borrowers.cardnumber>>) <br />
181
182
<<today>><br />
183
184
<h4>Checked Out</h4>
185
<checkedout>
186
<p>
187
<<biblio.title>> <br />
188
Barcode: <<items.barcode>><br />
189
Date due: <<issues.date_due>><br />
190
</p>
191
</checkedout>
192
193
<h4>Overdues</h4>
194
<overdue>
195
<p>
196
<<biblio.title>> <br />
197
Barcode: <<items.barcode>><br />
198
Date due: <<issues.date_due>><br />
199
</p>
200
</overdue>
201
202
<hr>
203
204
<h4 style="text-align: center; font-style:italic;">News</h4>
205
<news>
206
<div class="newsitem">
207
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
208
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
209
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Posted on <<opac_news.timestamp>></p>
210
<hr />
211
</div>
212
</news>'
213
THEN '<h3><<branches.branchname>></h3>
214
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
215
(<<borrowers.cardnumber>>) <br />
216
217
<<today>><br />
218
219
<h4>Ausleihen</h4>
220
<checkedout>
221
<p>
222
<<biblio.title>> <br />
223
Barcode: <<items.barcode>><br />
224
Fällig am: <<issues.date_due>><br />
225
</p>
226
</checkedout>
227
228
<h4>Überfällig</h4>
229
<overdue>
230
<p>
231
<<biblio.title>> <br />
232
Barcode: <<items.barcode>><br />
233
Fällig am: <<issues.date_due>><br />
234
</p>
235
</overdue>
236
237
<hr>
238
239
<h4 style="text-align: center; font-style:italic;">Neuigkeiten</h4>
240
<news>
241
<div class="newsitem">
242
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
243
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
244
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Veröffentlicht am <<opac_news.timestamp>></p>
245
<hr />
246
</div>
247
</news>'
248
-- Statement 2, PK:'circulation','ISSUEQSLIP', name
249
WHEN 'Issue Quick Slip'
250
THEN 'Kurzquittung'
251
-- Statement 2, PK:'circulation','ISSUEQSLIP', title
252
WHEN 'Issue Quick Slip'
253
THEN 'Kurzquittung'
254
-- Statement 2, PK:'circulation','ISSUEQSLIP', content
255
WHEN '<h3><<branches.branchname>></h3>
256
Checked out to <<borrowers.title>> <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
257
(<<borrowers.cardnumber>>) <br />
258
259
<<today>><br />
260
261
<h4>Checked Out Today</h4>
262
<checkedout>
263
<p>
264
<<biblio.title>> <br />
265
Barcode: <<items.barcode>><br />
266
Date due: <<issues.date_due>><br />
267
</p>
268
</checkedout>'
269
THEN '<h3><<branches.branchname>></h3>
270
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
271
(<<borrowers.cardnumber>>) <br />
272
273
<<today>><br />
274
275
<h4>Heutige Ausleihen</h4>
276
<checkedout>
277
<p>
278
<<biblio.title>> <br />
279
Barcode: <<items.barcode>><br />
280
Fällig am: <<issues.date_due>><br />
281
</p>
282
</checkedout>'
283
-- Statement 2, PK:'circulation','RESERVESLIP', name
284
WHEN 'Reserve Slip'
285
THEN 'Vormerkquittung'
286
-- Statement 2, PK:'circulation','RESERVESLIP', title
287
WHEN 'Reserve Slip'
288
THEN 'Vormerkquittung'
289
-- Statement 2, PK:'circulation','RESERVESLIP', content
290
WHEN '<h5>Date: <<today>></h5>
291
292
<h3> Transfer to/Hold in <<branches.branchname>></h3>
293
294
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
295
296
<ul>
297
    <li><<borrowers.cardnumber>></li>
298
    <li><<borrowers.phone>></li>
299
    <li> <<borrowers.address>><br />
300
         <<borrowers.address2>><br />
301
         <<borrowers.city >>  <<borrowers.zipcode>>
302
    </li>
303
    <li><<borrowers.email>></li>
304
</ul>
305
<br />
306
<h3>ITEM ON HOLD</h3>
307
<h4><<biblio.title>></h4>
308
<h5><<biblio.author>></h5>
309
<ul>
310
   <li><<items.barcode>></li>
311
   <li><<items.itemcallnumber>></li>
312
   <li><<reserves.waitingdate>></li>
313
</ul>
314
<p>Notes:
315
<pre><<reserves.reservenotes>></pre>
316
</p>
317
'
318
THEN '<h5>Datum: <<today>></h5>
319
320
<h3> Bereitstellung in <<branches.branchname>></h3>
321
322
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
323
324
<ul>
325
    <li><<borrowers.cardnumber>></li>
326
    <li><<borrowers.phone>></li>
327
    <li> <<borrowers.address>><br />
328
         <<borrowers.address2>><br />
329
         <<borrowers.city >>  <<borrowers.zipcode>>
330
    </li>
331
    <li><<borrowers.email>></li>
332
</ul>
333
<br />
334
<h3>VORMERKUNG</h3>
335
<h4><<biblio.title>></h4>
336
<h5><<biblio.author>></h5>
337
<ul>
338
   <li><<items.barcode>></li>
339
   <li><<items.itemcallnumber>></li>
340
   <li><<reserves.waitingdate>></li>
341
</ul>
342
<p>Notiz:
343
<pre><<reserves.reservenotes>></pre>
344
</p>
345
'
346
-- Statement 2, PK:'circulation','TRANSFERSLIP', name
347
WHEN 'Transfer Slip'
348
THEN 'Transportquittung'
349
-- Statement 2, PK:'circulation','TRANSFERSLIP', title
350
WHEN 'Transfer Slip'
351
THEN 'Transportquittung'
352
-- Statement 2, PK:'circulation','TRANSFERSLIP', content
353
WHEN '<h5>Date: <<today>></h5>
354
355
<h3>Transfer to <<branches.branchname>></h3>
356
357
<h3>ITEM</h3>
358
<h4><<biblio.title>></h4>
359
<h5><<biblio.author>></h5>
360
<ul>
361
   <li><<items.barcode>></li>
362
   <li><<items.itemcallnumber>></li>
363
</ul>'
364
THEN '<h5>Datum: <<today>></h5>
365
366
<h3>Transport nach <<branches.branchname>></h3>
367
368
<h3>EXEMPLAR</h3>
369
<h4><<biblio.title>></h4>
370
<h5><<biblio.author>></h5>
371
<ul>
372
   <li><<items.barcode>></li>
373
   <li><<items.itemcallnumber>></li>
374
</ul>'
375
376
377
-- Statement 3, PK:'members','OPAC_REG_VERIFY', name
378
WHEN 'Opac Self-Registration Verification Email'
379
THEN 'Bestätigung der Anmeldung zur Bibliotheksnutzung'
380
-- Statement 3, PK:'members','OPAC_REG_VERIFY', title
381
WHEN 'Verify Your Account'
382
THEN 'Verify Your Account'
383
-- Statement 3, PK:'members','OPAC_REG_VERIFY', content
384
WHEN 'Hello!
385
386
Your library account has been created. Please verify your email address by clicking this link to complete the signup process:
387
388
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
389
390
If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.'
391
THEN 'Guten Tag,
392
393
Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken:
394
395
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
396
397
Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachrichtigung ignorieren. Sie wird in Kürze ungültig.
398
399
Vielen Dank,
400
Ihr Bibliotheksteam'
401
402
ELSE d
403
END;
404
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_attributes.sql (+9 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
ELSE d
8
END;
9
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/sample_notices_message_transports.sql (+10 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
8
ELSE d
9
END;
10
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/stopwords.sql (+304 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
-- Statement 1, PK:'a', word
8
WHEN 'a'
9
THEN 'a'
10
-- Statement 1, PK:'about', word
11
WHEN 'about'
12
THEN 'about'
13
-- Statement 1, PK:'also', word
14
WHEN 'also'
15
THEN 'also'
16
-- Statement 1, PK:'an', word
17
WHEN 'an'
18
THEN 'an'
19
-- Statement 1, PK:'and', word
20
WHEN 'and'
21
THEN 'and'
22
-- Statement 1, PK:'another', word
23
WHEN 'another'
24
THEN 'another'
25
-- Statement 1, PK:'any', word
26
WHEN 'any'
27
THEN 'any'
28
-- Statement 1, PK:'are', word
29
WHEN 'are'
30
THEN 'are'
31
-- Statement 1, PK:'as', word
32
WHEN 'as'
33
THEN 'as'
34
-- Statement 1, PK:'at', word
35
WHEN 'at'
36
THEN 'at'
37
-- Statement 1, PK:'back', word
38
WHEN 'back'
39
THEN 'back'
40
-- Statement 1, PK:'be', word
41
WHEN 'be'
42
THEN 'be'
43
-- Statement 1, PK:'because', word
44
WHEN 'because'
45
THEN 'because'
46
-- Statement 1, PK:'been', word
47
WHEN 'been'
48
THEN 'been'
49
-- Statement 1, PK:'being', word
50
WHEN 'being'
51
THEN 'being'
52
-- Statement 1, PK:'but', word
53
WHEN 'but'
54
THEN 'but'
55
-- Statement 1, PK:'by', word
56
WHEN 'by'
57
THEN 'by'
58
-- Statement 1, PK:'can', word
59
WHEN 'can'
60
THEN 'can'
61
-- Statement 1, PK:'could', word
62
WHEN 'could'
63
THEN 'could'
64
-- Statement 1, PK:'did', word
65
WHEN 'did'
66
THEN 'did'
67
-- Statement 1, PK:'do', word
68
WHEN 'do'
69
THEN 'do'
70
-- Statement 1, PK:'each', word
71
WHEN 'each'
72
THEN 'each'
73
-- Statement 1, PK:'end', word
74
WHEN 'end'
75
THEN 'end'
76
-- Statement 1, PK:'even', word
77
WHEN 'even'
78
THEN 'even'
79
-- Statement 1, PK:'for', word
80
WHEN 'for'
81
THEN 'for'
82
-- Statement 1, PK:'from', word
83
WHEN 'from'
84
THEN 'from'
85
-- Statement 1, PK:'get', word
86
WHEN 'get'
87
THEN 'get'
88
-- Statement 1, PK:'go', word
89
WHEN 'go'
90
THEN 'go'
91
-- Statement 1, PK:'had', word
92
WHEN 'had'
93
THEN 'had'
94
-- Statement 1, PK:'have', word
95
WHEN 'have'
96
THEN 'have'
97
-- Statement 1, PK:'he', word
98
WHEN 'he'
99
THEN 'he'
100
-- Statement 1, PK:'her', word
101
WHEN 'her'
102
THEN 'her'
103
-- Statement 1, PK:'here', word
104
WHEN 'here'
105
THEN 'here'
106
-- Statement 1, PK:'his', word
107
WHEN 'his'
108
THEN 'his'
109
-- Statement 1, PK:'how', word
110
WHEN 'how'
111
THEN 'how'
112
-- Statement 1, PK:'i', word
113
WHEN 'i'
114
THEN 'i'
115
-- Statement 1, PK:'if', word
116
WHEN 'if'
117
THEN 'if'
118
-- Statement 1, PK:'in', word
119
WHEN 'in'
120
THEN 'in'
121
-- Statement 1, PK:'into', word
122
WHEN 'into'
123
THEN 'into'
124
-- Statement 1, PK:'is', word
125
WHEN 'is'
126
THEN 'is'
127
-- Statement 1, PK:'it', word
128
WHEN 'it'
129
THEN 'it'
130
-- Statement 1, PK:'just', word
131
WHEN 'just'
132
THEN 'just'
133
-- Statement 1, PK:'may', word
134
WHEN 'may'
135
THEN 'may'
136
-- Statement 1, PK:'me', word
137
WHEN 'me'
138
THEN 'me'
139
-- Statement 1, PK:'might', word
140
WHEN 'might'
141
THEN 'might'
142
-- Statement 1, PK:'much', word
143
WHEN 'much'
144
THEN 'much'
145
-- Statement 1, PK:'must', word
146
WHEN 'must'
147
THEN 'must'
148
-- Statement 1, PK:'my', word
149
WHEN 'my'
150
THEN 'my'
151
-- Statement 1, PK:'no', word
152
WHEN 'no'
153
THEN 'no'
154
-- Statement 1, PK:'not', word
155
WHEN 'not'
156
THEN 'not'
157
-- Statement 1, PK:'of', word
158
WHEN 'of'
159
THEN 'of'
160
-- Statement 1, PK:'off', word
161
WHEN 'off'
162
THEN 'off'
163
-- Statement 1, PK:'on', word
164
WHEN 'on'
165
THEN 'on'
166
-- Statement 1, PK:'only', word
167
WHEN 'only'
168
THEN 'only'
169
-- Statement 1, PK:'or', word
170
WHEN 'or'
171
THEN 'or'
172
-- Statement 1, PK:'other', word
173
WHEN 'other'
174
THEN 'other'
175
-- Statement 1, PK:'our', word
176
WHEN 'our'
177
THEN 'our'
178
-- Statement 1, PK:'out', word
179
WHEN 'out'
180
THEN 'out'
181
-- Statement 1, PK:'should', word
182
WHEN 'should'
183
THEN 'should'
184
-- Statement 1, PK:'so', word
185
WHEN 'so'
186
THEN 'so'
187
-- Statement 1, PK:'some', word
188
WHEN 'some'
189
THEN 'some'
190
-- Statement 1, PK:'still', word
191
WHEN 'still'
192
THEN 'still'
193
-- Statement 1, PK:'such', word
194
WHEN 'such'
195
THEN 'such'
196
-- Statement 1, PK:'than', word
197
WHEN 'than'
198
THEN 'than'
199
-- Statement 1, PK:'that', word
200
WHEN 'that'
201
THEN 'that'
202
-- Statement 1, PK:'the', word
203
WHEN 'the'
204
THEN 'the'
205
-- Statement 1, PK:'their', word
206
WHEN 'their'
207
THEN 'their'
208
-- Statement 1, PK:'them', word
209
WHEN 'them'
210
THEN 'them'
211
-- Statement 1, PK:'then', word
212
WHEN 'then'
213
THEN 'then'
214
-- Statement 1, PK:'there', word
215
WHEN 'there'
216
THEN 'there'
217
-- Statement 1, PK:'these', word
218
WHEN 'these'
219
THEN 'these'
220
-- Statement 1, PK:'they', word
221
WHEN 'they'
222
THEN 'they'
223
-- Statement 1, PK:'this', word
224
WHEN 'this'
225
THEN 'this'
226
-- Statement 1, PK:'those', word
227
WHEN 'those'
228
THEN 'those'
229
-- Statement 1, PK:'to', word
230
WHEN 'to'
231
THEN 'to'
232
-- Statement 1, PK:'too', word
233
WHEN 'too'
234
THEN 'too'
235
-- Statement 1, PK:'try', word
236
WHEN 'try'
237
THEN 'try'
238
-- Statement 1, PK:'two', word
239
WHEN 'two'
240
THEN 'two'
241
-- Statement 1, PK:'under', word
242
WHEN 'under'
243
THEN 'under'
244
-- Statement 1, PK:'up', word
245
WHEN 'up'
246
THEN 'up'
247
-- Statement 1, PK:'us', word
248
WHEN 'us'
249
THEN 'us'
250
-- Statement 1, PK:'was', word
251
WHEN 'was'
252
THEN 'was'
253
-- Statement 1, PK:'we', word
254
WHEN 'we'
255
THEN 'we'
256
-- Statement 1, PK:'were', word
257
WHEN 'were'
258
THEN 'were'
259
-- Statement 1, PK:'what', word
260
WHEN 'what'
261
THEN 'what'
262
-- Statement 1, PK:'when', word
263
WHEN 'when'
264
THEN 'when'
265
-- Statement 1, PK:'where', word
266
WHEN 'where'
267
THEN 'where'
268
-- Statement 1, PK:'which', word
269
WHEN 'which'
270
THEN 'which'
271
-- Statement 1, PK:'while', word
272
WHEN 'while'
273
THEN 'while'
274
-- Statement 1, PK:'who', word
275
WHEN 'who'
276
THEN 'who'
277
-- Statement 1, PK:'why', word
278
WHEN 'why'
279
THEN 'why'
280
-- Statement 1, PK:'will', word
281
WHEN 'will'
282
THEN 'will'
283
-- Statement 1, PK:'with', word
284
WHEN 'with'
285
THEN 'with'
286
-- Statement 1, PK:'within', word
287
WHEN 'within'
288
THEN 'within'
289
-- Statement 1, PK:'without', word
290
WHEN 'without'
291
THEN 'without'
292
-- Statement 1, PK:'would', word
293
WHEN 'would'
294
THEN 'would'
295
-- Statement 1, PK:'you', word
296
WHEN 'you'
297
THEN 'you'
298
-- Statement 1, PK:'your', word
299
WHEN 'your'
300
THEN 'your'
301
302
ELSE d
303
END;
304
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/subtag_registry.sql (+10 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
8
ELSE d
9
END;
10
END //
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt (-1 / +1 lines)
Lines 1-4 Link Here
1
I18N-Unterstützung in Koha
1
I18N-Unterstützung in Koha
2
Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch, 
2
Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch,
3
Standardmappings zwischen Schrift- und Sprachcodes,
3
Standardmappings zwischen Schrift- und Sprachcodes,
4
weitere Spracherweiterungen
4
weitere Spracherweiterungen
(-)a/installer/data/mysql/de-DE/mandatory/system_preferences.sql (-4 / +4 lines)
Lines 7-17 Link Here
7
-- terms of the GNU General Public License as published by the Free Software
7
-- terms of the GNU General Public License as published by the Free Software
8
-- Foundation; either version 2 of the License, or (at your option) any later
8
-- Foundation; either version 2 of the License, or (at your option) any later
9
-- version.
9
-- version.
10
-- 
10
--
11
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
11
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
12
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
12
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
13
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
13
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
14
-- 
14
--
15
-- You should have received a copy of the GNU General Public License along
15
-- You should have received a copy of the GNU General Public License along
16
-- with Koha; if not, write to the Free Software Foundation, Inc.,
16
-- with Koha; if not, write to the Free Software Foundation, Inc.,
17
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
17
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
Lines 25-34 UPDATE systempreferences SET value = 'z' WHERE variable = 'DefaultClassification Link Here
25
UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variable = 'OpacMainUserBlock';
25
UPDATE systempreferences SET value = 'Willkommen im Koha-Katalog!' WHERE variable = 'OpacMainUserBlock';
26
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';
26
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNav';
27
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';
27
UPDATE systempreferences SET value = '' WHERE variable = 'OpacNavBottom';
28
UPDATE systempreferences SET value = 
28
UPDATE systempreferences SET value =
29
    '<li><a href="http://worldcat.org/search?q={TITLE}" target="_blank">Andere Bibliotheken (WorldCat)</a></li>
29
    '<li><a href="http://worldcat.org/search?q={TITLE}" target="_blank">Andere Bibliotheken (WorldCat)</a></li>
30
    <li><a href="http://www.scholar.google.com/scholar?q={TITLE}" target="_blank">Google Scholar</a></li>
30
    <li><a href="http://www.scholar.google.com/scholar?q={TITLE}" target="_blank">Google Scholar</a></li>
31
    <li><a href="http://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr" target="_blank">Online-Buchhandel (Bookfinder.com)</a></li>' 
31
    <li><a href="http://www.bookfinder.com/search/?author={AUTHOR}&amp;title={TITLE}&amp;st=xl&amp;ac=qr" target="_blank">Online-Buchhandel (Bookfinder.com)</a></li>'
32
    WHERE variable = 'OPACSearchForTitleIn';
32
    WHERE variable = 'OPACSearchForTitleIn';
33
UPDATE systempreferences SET value = 'Monday' WHERE variable = 'CalendarFirstDayOfWeek';
33
UPDATE systempreferences SET value = 'Monday' WHERE variable = 'CalendarFirstDayOfWeek';
34
UPDATE systempreferences SET value = '0.07|0.19|0.00' WHERE variable = 'gist';
34
UPDATE systempreferences SET value = '0.07|0.19|0.00' WHERE variable = 'gist';
(-)a/installer/data/mysql/de-DE/mandatory.i18n/userflags.sql (+67 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
-- Statement 1, PK:0,'superlibrarian', flagdesc
8
WHEN 'Access to all librarian functions'
9
THEN 'Zugriff auf alle Funktionen'
10
-- Statement 1, PK:1,'circulate', flagdesc
11
WHEN 'Check out and check in items'
12
THEN 'Medien ausleihen/zurückgeben'
13
-- Statement 1, PK:2,'catalogue', flagdesc
14
WHEN '<b>Required for staff login.</b> Staff access, allows viewing of catalogue in staff client.'
15
THEN 'Katalogsuche verwenden (Dienstoberfläche)'
16
-- Statement 1, PK:3,'parameters', flagdesc
17
WHEN 'Manage Koha system settings (Administration panel)'
18
THEN 'Systemparameter verändern'
19
-- Statement 1, PK:4,'borrowers', flagdesc
20
WHEN 'Add or modify patrons'
21
THEN 'Benutzer anlegen/ändern'
22
-- Statement 1, PK:5,'permissions', flagdesc
23
WHEN 'Set user permissions'
24
THEN 'Berechtigungen für Benutzer vergeben'
25
-- Statement 1, PK:6,'reserveforothers', flagdesc
26
WHEN 'Place and modify holds for patrons'
27
THEN 'Vormerkungen für Benutzer setzen/ändern'
28
-- Statement 1, PK:7,'borrow', flagdesc
29
WHEN 'Borrow books'
30
THEN 'Medien entleihen'
31
-- Statement 1, PK:9,'editcatalogue', flagdesc
32
WHEN 'Edit Catalog (Modify bibliographic/holdings data)'
33
THEN 'Katalogdaten ändern (Titel- und Bestandsdaten ändern)'
34
-- Statement 1, PK:10,'updatecharges', flagdesc
35
WHEN 'Manage patrons fines and fees'
36
THEN 'Gebühren kassieren/ändern'
37
-- Statement 1, PK:11,'acquisition', flagdesc
38
WHEN 'Acquisition and/or suggestion management'
39
THEN 'Erwerbung und Verwaltung von Anschaffungsvorschlägen'
40
-- Statement 1, PK:12,'management', flagdesc
41
WHEN 'Set library management parameters (deprecated)'
42
THEN 'Zugriff auf Administration'
43
-- Statement 1, PK:13,'tools', flagdesc
44
WHEN 'Use all tools (expand for granular tools permissions)'
45
THEN 'Werkzeuge verwenden (Export, Import, Etikettendruck)'
46
-- Statement 1, PK:14,'editauthorities', flagdesc
47
WHEN 'Edit Authorities'
48
THEN 'Normdaten ändern'
49
-- Statement 1, PK:15,'serials', flagdesc
50
WHEN 'Manage serial subscriptions'
51
THEN 'Zugriff auf Abonnementverwaltung/Zeitschriftenmodul'
52
-- Statement 1, PK:16,'reports', flagdesc
53
WHEN 'Allow access to the reports module'
54
THEN 'Zugriff auf Reportmodul'
55
-- Statement 1, PK:17,'staffaccess', flagdesc
56
WHEN 'Allow staff members to modify permissions for other staff members'
57
THEN 'Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben'
58
-- Statement 1, PK:18,'coursereserves', flagdesc
59
WHEN 'Course Reserves'
60
THEN 'Course Reserves'
61
-- Statement 1, PK:19,'plugins', flagdesc
62
WHEN 'Koha plugins'
63
THEN 'Koha Plugins'
64
65
ELSE d
66
END;
67
END //
(-)a/installer/data/mysql/de-DE/mandatory.i18n/userpermissions.sql (+193 lines)
Line 0 Link Here
1
DELIMITER //
2
DROP FUNCTION IF EXISTS i18n//
3
CREATE FUNCTION i18n (d text) RETURNS text DETERMINISTIC
4
BEGIN
5
RETURN CASE d
6
WHEN '' THEN ''
7
-- Statement 1, PK:1,'circulate_remaining_permissions', description
8
WHEN 'Remaining circulation permissions'
9
THEN 'Übrige Ausleihberechtigungen'
10
-- Statement 1, PK:1,'override_renewals', description
11
WHEN 'Override blocked renewals'
12
THEN 'Gesperrte Verlängerungen überschreiben'
13
-- Statement 1, PK:1,'overdues_report', description
14
WHEN 'Execute overdue items report'
15
THEN 'Überfälligkeiten-Report ausführen'
16
-- Statement 1, PK:3,'parameters_remaining_permissions', description
17
WHEN 'Remaining system parameters permissions'
18
THEN 'Übrige Administrationsberechtigungen'
19
-- Statement 1, PK:3,'manage_circ_rules', description
20
WHEN 'manage circulation rules'
21
THEN 'Ausleihkonditionen verwalten'
22
-- Statement 1, PK:6,'place_holds', description
23
WHEN 'Place holds for patrons'
24
THEN 'Vormerkungen für Benutzer setzen'
25
-- Statement 1, PK:6,'modify_holds_priority', description
26
WHEN 'Modify holds priority'
27
THEN 'Vormerkungspriorität verändern'
28
-- Statement 1, PK:9,'edit_catalogue', description
29
WHEN 'Edit catalog (Modify bibliographic/holdings data)'
30
THEN 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'
31
-- Statement 1, PK:9,'fast_cataloging', description
32
WHEN 'Fast cataloging'
33
THEN 'Schnellaufnahmen anlegen'
34
-- Statement 1, PK:9,'edit_items', description
35
WHEN 'Edit Items'
36
THEN 'Exemplare bearbeiten'
37
-- Statement 1, PK:11,'vendors_manage', description
38
WHEN 'Manage vendors'
39
THEN 'Lieferanten verwalten'
40
-- Statement 1, PK:11,'contracts_manage', description
41
WHEN 'Manage contracts'
42
THEN 'Vereinbarungen verwalten'
43
-- Statement 1, PK:11,'period_manage', description
44
WHEN 'Manage periods'
45
THEN 'Etats verwalten'
46
-- Statement 1, PK:11,'budget_manage', description
47
WHEN 'Manage budgets'
48
THEN 'Konten verwalten'
49
-- Statement 1, PK:11,'budget_modify', description
50
WHEN 'Modify budget (can''t create lines, but can modify existing ones)'
51
THEN 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'
52
-- Statement 1, PK:11,'planning_manage', description
53
WHEN 'Manage budget plannings'
54
THEN 'Etatplanung verwalten'
55
-- Statement 1, PK:11,'order_manage', description
56
WHEN 'Manage orders & basket'
57
THEN 'Bestellungen verwalten'
58
-- Statement 1, PK:11,'group_manage', description
59
WHEN 'Manage orders & basketgroups'
60
THEN 'Bestellgruppen vewalten'
61
-- Statement 1, PK:11,'order_receive', description
62
WHEN 'Manage orders & basket'
63
THEN 'Lieferungen verwalten'
64
-- Statement 1, PK:11,'budget_add_del', description
65
WHEN 'Add and delete budgets (but cant modify budgets)'
66
THEN 'Konten hinzufügen/ändern, aber bestehende nicht ändern'
67
-- Statement 1, PK:11,'budget_manage_all', description
68
WHEN 'Manage all budgets'
69
THEN 'Alle Konten verwalten'
70
-- Statement 1, PK:13,'edit_news', description
71
WHEN 'Write news for the OPAC and staff interfaces'
72
THEN 'Nachrichten für OPAC und Dienstoberfläche verfassen'
73
-- Statement 1, PK:13,'label_creator', description
74
WHEN 'Create printable labels and barcodes from catalog and patron data'
75
THEN 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'
76
-- Statement 1, PK:13,'edit_calendar', description
77
WHEN 'Define days when the library is closed'
78
THEN 'Schließtage eintragen'
79
-- Statement 1, PK:13,'moderate_comments', description
80
WHEN 'Moderate patron comments'
81
THEN 'Benutzerkommentare moderieren'
82
-- Statement 1, PK:13,'edit_notices', description
83
WHEN 'Define notices'
84
THEN 'Benachrichtigungen verwalten'
85
-- Statement 1, PK:13,'edit_notice_status_triggers', description
86
WHEN 'Set notice/status triggers for overdue items'
87
THEN 'Mahntrigger für überfällige Medien verwalten'
88
-- Statement 1, PK:13,'edit_quotes', description
89
WHEN 'Edit quotes for quote-of-the-day feature'
90
THEN '"Zitat des Tages" konfigurieren'
91
-- Statement 1, PK:13,'view_system_logs', description
92
WHEN 'Browse the system logs'
93
THEN 'Logs durchsuchen/einsehen'
94
-- Statement 1, PK:13,'inventory', description
95
WHEN 'Perform inventory (stocktaking) of your catalog'
96
THEN 'Inventur durchführen'
97
-- Statement 1, PK:13,'stage_marc_import', description
98
WHEN 'Stage MARC records into the reservoir'
99
THEN 'MARC-Datensätze zwischenspeichern'
100
-- Statement 1, PK:13,'manage_staged_marc', description
101
WHEN 'Managed staged MARC records, including completing and reversing imports'
102
THEN 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'
103
-- Statement 1, PK:13,'export_catalog', description
104
WHEN 'Export bibliographic and holdings data'
105
THEN 'Titel- und Exemplardaten exportieren'
106
-- Statement 1, PK:13,'import_patrons', description
107
WHEN 'Import patron data'
108
THEN 'Benutzerdaten importieren'
109
-- Statement 1, PK:13,'edit_patrons', description
110
WHEN 'Perform batch modification of patrons'
111
THEN 'Stapelbearbeitung von Benutzerdaten durchführen'
112
-- Statement 1, PK:13,'delete_anonymize_patrons', description
113
WHEN 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)'
114
THEN 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'
115
-- Statement 1, PK:13,'batch_upload_patron_images', description
116
WHEN 'Upload patron images in batch or one at a time'
117
THEN 'Benutzerfotos einzeln oder im Stapel hochladen'
118
-- Statement 1, PK:13,'schedule_tasks', description
119
WHEN 'Schedule tasks to run'
120
THEN 'Aufgabenplaner verwenden'
121
-- Statement 1, PK:13,'items_batchmod', description
122
WHEN 'Perform batch modification of items'
123
THEN 'Stapelbearbeitung von Exemplaren durchführen'
124
-- Statement 1, PK:13,'items_batchdel', description
125
WHEN 'Perform batch deletion of items'
126
THEN 'Stapellöschung von Exemplaren durchführen'
127
-- Statement 1, PK:13,'manage_csv_profiles', description
128
WHEN 'Manage CSV export profiles'
129
THEN 'CSV-Profile für Export verwalten'
130
-- Statement 1, PK:13,'moderate_tags', description
131
WHEN 'Moderate patron tags'
132
THEN 'Von Benutzern vergebene Tags moderieren'
133
-- Statement 1, PK:13,'rotating_collections', description
134
WHEN 'Manage rotating collections'
135
THEN 'Wandernde Sammlungen verwalten'
136
-- Statement 1, PK:13,'upload_local_cover_images', description
137
WHEN 'Upload local cover images'
138
THEN 'Eigene Coverbilder hochladen'
139
-- Statement 1, PK:15,'check_expiration', description
140
WHEN 'Check the expiration of a serial'
141
THEN 'Ablauf eines Abonnements prüfen'
142
-- Statement 1, PK:15,'claim_serials', description
143
WHEN 'Claim missing serials'
144
THEN 'Fehlende Hefte reklamieren'
145
-- Statement 1, PK:15,'create_subscription', description
146
WHEN 'Create a new subscription'
147
THEN 'Neues Abonnement anlegen'
148
-- Statement 1, PK:15,'delete_subscription', description
149
WHEN 'Delete an existing subscription'
150
THEN 'Bestehende Abonnements löschen'
151
-- Statement 1, PK:15,'edit_subscription', description
152
WHEN 'Edit an existing subscription'
153
THEN 'Bestehende Abonnements bearbeiten'
154
-- Statement 1, PK:15,'receive_serials', description
155
WHEN 'Serials receiving'
156
THEN 'Zugang von Heften'
157
-- Statement 1, PK:15,'renew_subscription', description
158
WHEN 'Renew a subscription'
159
THEN 'Abonnements verlängern'
160
-- Statement 1, PK:15,'routing', description
161
WHEN 'Routing'
162
THEN 'Umlauflisten verwalten'
163
-- Statement 1, PK:16,'execute_reports', description
164
WHEN 'Execute SQL reports'
165
THEN 'SQL-Reports ausführen'
166
-- Statement 1, PK:16,'create_reports', description
167
WHEN 'Create SQL Reports'
168
THEN 'SQL-Reports erstellen'
169
-- Statement 1, PK:18,'manage_courses', description
170
WHEN 'Add, edit and delete courses'
171
THEN 'Add, edit and delete courses'
172
-- Statement 1, PK:18,'add_reserves', description
173
WHEN 'Add course reserves'
174
THEN 'Add course reserves'
175
-- Statement 1, PK:18,'delete_reserves', description
176
WHEN 'Remove course reserves'
177
THEN 'Remove course reserves'
178
-- Statement 1, PK:19,'manage', description
179
WHEN 'Manage plugins ( install / uninstall )'
180
THEN 'Plugins verwealten (installieren/deinstallieren)'
181
-- Statement 1, PK:19,'tool', description
182
WHEN 'Use tool plugins'
183
THEN 'Werkzeug-Plugins verwenden'
184
-- Statement 1, PK:19,'report', description
185
WHEN 'Use report plugins'
186
THEN 'Report-Plugins verwenden'
187
-- Statement 1, PK:19,'configure', description
188
WHEN 'Configure plugins'
189
THEN 'Plugins konfigurieren'
190
191
ELSE d
192
END;
193
END //
(-)a/installer/data/mysql/de-DE/mandatory/class_sources.sql (-36 lines)
Lines 1-36 Link Here
1
-- 
2
-- Default classification sources and filing rules
3
-- for Koha.
4
--
5
-- Copyright (C) 2007 LiblimeA
6
--
7
-- This file is part of Koha.
8
--
9
-- Koha is free software; you can redistribute it and/or modify it under the
10
-- terms of the GNU General Public License as published by the Free Software
11
-- Foundation; either version 2 of the License, or (at your option) any later
12
-- version.
13
-- 
14
-- Koha is distributed in the hope that it will be useful, but WITHOUT ANY
15
-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
16
-- A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
17
-- 
18
-- You should have received a copy of the GNU General Public License along
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21
22
-- class sorting (filing) rules
23
INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES
24
                               ('dewey', 'Standard-Sortierregeln für DDC', 'Dewey'),
25
                               ('lcc', 'Standard-Sortierregeln für LCC', 'LCC'),
26
                               ('generic', 'Generische Sortierregeln für Signaturen', 'Generic');
27
28
29
-- classification schemes or sources
30
INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES
31
                            ('ddc', 'Dewey-Decimalklassifikation (DDC)', 1, 'dewey'),
32
                            ('lcc', 'Klassifikation der Library of Congress (LCC)', 1, 'lcc'),
33
                            ('udc', 'Universelle Dezimalklassifikation (UDC)', 0, 'generic'),
34
                            ('sudocs', 'SuDoc-Klassifikation (U.S. GPO)', 0, 'generic'),
35
                            ('anscr', 'ANSCR (Tonaufnahmen)', 0, 'generic'),
36
                            ('z', 'Andere/Generische Klassifikation', 0, 'generic');
(-)a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql (-7 lines)
Lines 1-7 Link Here
1
INSERT INTO message_transport_types
2
(message_transport_type)
3
values
4
('email'),
5
('print'),
6
('sms'),
7
('feed');
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices.sql (-122 lines)
Lines 1-122 Link Here
1
INSERT INTO `letter` (module, code, name, title, content) 
2
VALUES ('circulation','ODUE','Mahnung','Mahnung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\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<<branches.branchname>>\n<<branches.branchaddress1>>\n<<branches.branchaddress2>> <<branches.branchaddress3>>\nTelefon: <<branches.branchphone>>\nFax: <<branches.branchfax>>\nEmail: <<branches.branchemail>>\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<item>"<<biblio.title>>" by <<biblio.author>>, <<items.itemcallnumber>>, Barcode: <<items.barcode>> Gebühr: <<items.fine>></item>\n\nVielen Dank für die schnelle Erledigung.\n\n< Ihr Bibliotheksteam\n'),
3
('claimacquisition','ACQCLAIM','Reklamation (Erwerbung)','Titel nicht eingetroffen','<<aqbooksellers.name>>\r\n<<aqbooksellers.address1>>\r\n<<aqbooksellers.address2>>\r\n<<aqbooksellers.address3>>\r\n<<aqbooksellers.address4>>\r\n<<aqbooksellers.phone>>\r\n\r\n<order>Ordernumber <<aqorders.ordernumber>> (<<aqorders.title>>) (<<aqorders.quantity>> bestellt) (je $<<aqorders.listprice>> €) sind nicht eingetroffen.</order>'),
4
('serial','RLIST','Neues Heft zugegangen','Zeitschrift ist jetzt verfügbar','<<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDas folgende Heft ist jetzt verfügbar:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)\r\n\r\nBitte holen Sie es sobald möglich ab.'),
5
('members','ACCTDETAILS','Kontoinformationen - Standard','Ihr neues Benutzerkonto','Liebe/r <<borrowers.title>> <<borrowers.firstname>> <<borrowers.surname>>.\r\n\r\nDie Daten Ihres neuen Benutzerkontos sind:\r\n\r\nBenutzer:  <<borrowers.userid>>\r\nPasswort: <<borrowers.password>>\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'), 
6
('circulation','DUE','Fälligkeitsbenachrichtigung','Fälligkeitsbenachrichtigung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nDie folgenden Medien sind ab heute fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
7
('circulation','DUEDGST','Fälligkeitsbenachrichtigung (Zusammenfassung)','Fälligkeitsbenachrichtigung','Sie haben <<count>> überfällige Medien.'), 
8
('circulation','PREDUE','Erinnerungsbenachrichtigung','Erinnerungsbenachrichtigung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgende Ausleihe wird bald fällig:\r\n\r\n<<biblio.title>>, <<biblio.author>> (<<items.barcode>>)'), 
9
('circulation','PREDUEDGST','Erinnerungsbenachrichtigung (Zusammenfassung)','Erinnerungsbenachrichtigung','Sie haben <<count>> Ausleihen, die bald fällig werden.'),
10
('circulation','RENEWAL','Verlängerungsbenachrichtigung','Verlängerungsquittung','Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFolgede Exemplare wurden verlängert:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank,\r\n<<branches.branchname>>.'),
11
('reserves', 'HOLD', 'Vormerkbenachrichtigung', 'Vormerkung abholbereit in <<branches.branchname>>', 'Liebe/r <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nExemplar: <<items.copynumber>>\r\nStandort: <<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress3>>\r\n<<branches.branchcity>> <<branches.branchzip>>'),
12
('reserves', 'HOLD_PRINT', 'Vormerkbenachrichtigung (Print)', 'Vormerkbenachrichtigung (Print)', '<<branches.branchname>>\r\n<<branches.branchaddress1>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchaddress2>>\r\n<<branches.branchzip>> <<branches.branchcity>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<<borrowers.firstname>> <<borrowers.surname>>\r\n<<borrowers.address>>\r\n<<borrowers.address2>>\r\n<<borrowers.zipcode>> <<borrowers.city>>\r\n<<borrowers.country>>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nLiebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\r\n\r\nFür Sie liegt seit dem <<reserves.waitingdate>> eine Vormerkung zur Abholung bereit:\r\n\r\nTitel: <<biblio.title>>\r\nVerfasser: <<biblio.author>>\r\nSignatur: <<items.itemcallnumber>>\r\n'),
13
('circulation','CHECKIN','Rückgabequittung (Zusammenfassung)','Rückgabequittung','Die folgenden Medien wurden zurückgegeben:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank.'),
14
('circulation','CHECKOUT','Ausleihquittung (Zusammenfassung)','Ausleihquittung','Die folgenden Medien wurden entliehen:\r\n----\r\n<<biblio.title>>\r\n----\r\nVielen Dank für Ihren Besuch in <<branches.branchname>>.'),
15
('reserves', 'HOLDPLACED', 'Neue Vormerkung', 'Neue Vormerkung','Folgender Titel wurde vorgemerkt: <<biblio.title>> (<<biblio.biblionumber>>) durch den Benutzer <<borrowers.firstname>> <<borrowers.surname>> (<<borrowers.cardnumber>>).'),
16
('suggestions','ACCEPTED','Anschaffungsvorschlag wurde angenommen', 'Ihr Anschaffungsvorschlag wurde angenommen','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> by <<suggestions.author>>.\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: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
17
('suggestions','AVAILABLE','Vorgeschlagenes Medium verfügbar', 'Das vorgeschlagene Medium ist jetzt verfügbar','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\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: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
18
('suggestions','ORDERED','Vorgeschlagenes Medium bestellt', 'Das vorgeschlagene Medium wurde im Buchhandel bestellt','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haben der Bibliothek folgendes Medium zur Anschaffung vorgeschlaten: <<suggestions.title>> von <<suggestions.author>>.\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 <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>'),
19
('suggestions','REJECTED','Anschaffungsvorschlag nicht angenommen', 'Ihr Anschaffungsvorschlag wurde nicht angenommen','Liebe(r) <<borrowers.firstname>> <<borrowers.surname>>,\n\nSie haven der Bibliothek folgendes Medium zur Anschaffung vorgeschlagen: <<suggestions.title>> von <<suggestions.author>>.\n\nDie Bibliothek hat diesen Titel heute recherchiert und sich gegen eine Anschaffung entschieden.\n\nBegründung: <<suggestions.reason>>\n\nWenn Sie Fragen haben, richten Sie Ihre Mail bitte an: <<branches.branchemail>>.\n\nVielen Dank,\n\n<<branches.branchname>>');
20
21
INSERT INTO `letter` (module, code, name, title, content, is_html)
22
VALUES ('circulation','ISSUESLIP','Ausleihquittung (Quittungsdruck)','Ausleihquittung (Quittungsdruck)', '<h3><<branches.branchname>></h3>
23
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
24
(<<borrowers.cardnumber>>) <br />
25
26
<<today>><br />
27
28
<h4>Ausleihen</h4>
29
<checkedout>
30
<p>
31
<<biblio.title>> <br />
32
Barcode: <<items.barcode>><br />
33
Fällig am: <<issues.date_due>><br />
34
</p>
35
</checkedout>
36
37
<h4>Überfällig</h4>
38
<overdue>
39
<p>
40
<<biblio.title>> <br />
41
Barcode: <<items.barcode>><br />
42
Fällig am: <<issues.date_due>><br />
43
</p>
44
</overdue>
45
46
<hr>
47
48
<h4 style="text-align: center; font-style:italic;">Neuigkeiten</h4>
49
<news>
50
<div class="newsitem">
51
<h5 style="margin-bottom: 1px; margin-top: 1px"><b><<opac_news.title>></b></h5>
52
<p style="margin-bottom: 1px; margin-top: 1px"><<opac_news.new>></p>
53
<p class="newsfooter" style="font-size: 8pt; font-style:italic; margin-bottom: 1px; margin-top: 1px">Veröffentlicht am <<opac_news.timestamp>></p>
54
<hr />
55
</div>
56
</news>', 1),
57
('circulation','ISSUEQSLIP','Kurzquittung','Kurzquittung', '<h3><<branches.branchname>></h3>
58
Ausleihe an: <<borrowers.firstname>> <<borrowers.initials>> <<borrowers.surname>> <br />
59
(<<borrowers.cardnumber>>) <br />
60
61
<<today>><br />
62
63
<h4>Heutige Ausleihen</h4>
64
<checkedout>
65
<p>
66
<<biblio.title>> <br />
67
Barcode: <<items.barcode>><br />
68
Fällig am: <<issues.date_due>><br />
69
</p>
70
</checkedout>', 1),
71
('circulation','RESERVESLIP','Vormerkquittung','Vormerkquittung', '<h5>Datum: <<today>></h5>
72
73
<h3> Bereitstellung in <<branches.branchname>></h3>
74
75
<h3><<borrowers.surname>>, <<borrowers.firstname>></h3>
76
77
<ul>
78
    <li><<borrowers.cardnumber>></li>
79
    <li><<borrowers.phone>></li>
80
    <li> <<borrowers.address>><br />
81
         <<borrowers.address2>><br />
82
         <<borrowers.city >>  <<borrowers.zipcode>>
83
    </li>
84
    <li><<borrowers.email>></li>
85
</ul>
86
<br />
87
<h3>VORMERKUNG</h3>
88
<h4><<biblio.title>></h4>
89
<h5><<biblio.author>></h5>
90
<ul>
91
   <li><<items.barcode>></li>
92
   <li><<items.itemcallnumber>></li>
93
   <li><<reserves.waitingdate>></li>
94
</ul>
95
<p>Notiz:
96
<pre><<reserves.reservenotes>></pre>
97
</p>
98
', 1),
99
('circulation','TRANSFERSLIP','Transportquittung','Transportquittung', '<h5>Datum: <<today>></h5>
100
101
<h3>Transport nach <<branches.branchname>></h3>
102
103
<h3>EXEMPLAR</h3>
104
<h4><<biblio.title>></h4>
105
<h5><<biblio.author>></h5>
106
<ul>
107
   <li><<items.barcode>></li>
108
   <li><<items.itemcallnumber>></li>
109
</ul>', 1);
110
111
INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`)
112
VALUES (
113
'members',  'OPAC_REG_VERIFY',  '',  'Bestätigung der Anmeldung zur Bibliotheksnutzung',  '1',  'Verify Your Account',  'Guten Tag,
114
115
Ihr Bibliothekskonto wurde angelegt. Bitte bestätigen Sie Ihre Emailadresse, indem Sie auf folgenden Link klicken:
116
117
http://<<OPACBaseURL>>/cgi-bin/koha/opac-registration-verify.pl?token=<<borrower_modifications.verification_token>>
118
119
Wenn Sie keine Kontoanmeldung durchgeführt haben, können Sie diese Benachrichtigung ignorieren. Sie wird in Kürze ungültig.
120
121
Vielen Dank,
122
Ihr Bibliotheksteam');
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices_message_attributes.sql (-8 lines)
Lines 1-8 Link Here
1
insert into `message_attributes`
2
(`message_attribute_id`, message_name, `takes_days`)
3
values
4
(1, 'Item_Due', 0),
5
(2, 'Advance_Notice', 1),
6
(4, 'Hold_Filled', 0),
7
(5, 'Item_Check_in', 0),
8
(6, 'Item_Checkout', 0);
(-)a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql (-17 lines)
Lines 1-17 Link Here
1
insert into `message_transports`
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
17
(6, 'sms',   0, 'circulation', 'CHECKOUT');
(-)a/installer/data/mysql/de-DE/mandatory/stopwords.sql (-99 lines)
Lines 1-99 Link Here
1
INSERT INTO stopwords (word) VALUES
2
('a'),
3
('about'),
4
('also'),
5
('an'),
6
('and'),
7
('another'),
8
('any'),
9
('are'),
10
('as'),
11
('at'),
12
('back'),
13
('be'),
14
('because'),
15
('been'),
16
('being'),
17
('but'),
18
('by'),
19
('can'),
20
('could'),
21
('did'),
22
('do'),
23
('each'),
24
('end'),
25
('even'),
26
('for'),
27
('from'),
28
('get'),
29
('go'),
30
('had'),
31
('have'),
32
('he'),
33
('her'),
34
('here'),
35
('his'),
36
('how'),
37
('i'),
38
('if'),
39
('in'),
40
('into'),
41
('is'),
42
('it'),
43
('just'),
44
('may'),
45
('me'),
46
('might'),
47
('much'),
48
('must'),
49
('my'),
50
('no'),
51
('not'),
52
('of'),
53
('off'),
54
('on'),
55
('only'),
56
('or'),
57
('other'),
58
('our'),
59
('out'),
60
('should'),
61
('so'),
62
('some'),
63
('still'),
64
('such'),
65
('than'),
66
('that'),
67
('the'),
68
('their'),
69
('them'),
70
('then'),
71
('there'),
72
('these'),
73
('they'),
74
('this'),
75
('those'),
76
('to'),
77
('too'),
78
('try'),
79
('two'),
80
('under'),
81
('up'),
82
('us'),
83
('was'),
84
('we'),
85
('were'),
86
('what'),
87
('when'),
88
('where'),
89
('which'),
90
('while'),
91
('who'),
92
('why'),
93
('will'),
94
('with'),
95
('within'),
96
('without'),
97
('would'),
98
('you'),
99
('your');
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql (-897 lines)
Lines 1-897 Link Here
1
-- http://www.w3.org/International/articles/language-tags/
2
3
-- BIDI Stuff, Arabic and Hebrew
4
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
5
VALUES( 'Arab', 'rtl');
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
7
VALUES( 'Hebr', 'rtl');
8
9
-- Default mappings between script and language subcodes
10
INSERT INTO language_script_mapping(language_subtag,script_subtag)
11
VALUES( 'ar', 'Arab');
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
13
VALUES( 'he', 'Hebr');
14
15
-- EXTENSIONS
16
-- Interface (i)
17
-- SELECT * FROM language_subtag_registry WHERE type='i';
18
-- OPAC
19
INSERT INTO language_subtag_registry( subtag, type, description, added)
20
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
21
22
INSERT INTO language_descriptions(subtag, type, lang, description)
23
VALUES( 'opac', 'i', 'en', 'OPAC');
24
25
INSERT INTO language_descriptions(subtag, type, lang, description)
26
VALUES( 'opac', 'i', 'fr', 'OPAC');
27
28
-- Staff Client
29
INSERT INTO language_subtag_registry( subtag, type, description, added)
30
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
31
32
INSERT INTO language_descriptions(subtag, type, lang, description)
33
VALUES( 'intranet', 'i', 'en', 'Staff Client');
34
35
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'fr', '????');
37
38
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'Prog','2005-10-16');
41
42
INSERT INTO language_descriptions(subtag, type, lang, description)
43
VALUES( 'prog', 't', 'en', 'Prog');
44
45
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 't', 'fr', 'Prog');
47
48
-- LANGUAGES
49
50
-- Arabic
51
INSERT INTO language_subtag_registry( subtag, type, description, added)
52
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
53
54
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
55
VALUES( 'ar','ara');
56
57
INSERT INTO language_descriptions(subtag, type, lang, description)
58
VALUES ( 'ar', 'language', 'ar', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
59
60
INSERT INTO language_descriptions(subtag, type, lang, description)
61
VALUES( 'ar', 'language', 'en', 'Arabic');
62
63
INSERT INTO language_descriptions(subtag, type, lang, description)
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES( 'ar', 'language', 'de', 'Arabisch');
68
69
-- Armenian
70
INSERT INTO language_subtag_registry( subtag, type, description, added)
71
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
72
73
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
74
VALUES( 'hy','arm');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES ( 'hy', 'language', 'hy', '&#1344;&#1377;&#1397;&#1381;&#1408;&#1383;&#1398;');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'en', 'Armenian');
81
82
INSERT INTO language_descriptions(subtag, type, lang, description)
83
VALUES( 'hy', 'language', 'fr', 'Armenian');
84
85
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES( 'hy', 'language', 'de', 'Armenisch');
87
88
-- Bulgarian
89
INSERT INTO language_subtag_registry( subtag, type, description, added)
90
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
91
92
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
93
VALUES( 'bg','bul');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES ( 'bg', 'language', 'bg', '&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;');
97
98
INSERT INTO language_descriptions(subtag, type, lang, description)
99
VALUES( 'bg', 'language', 'en', 'Bulgarian');
100
101
INSERT INTO language_descriptions(subtag, type, lang, description)
102
VALUES( 'bg', 'language', 'fr', 'Bulgare');
103
104
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
106
107
-- Chinese
108
INSERT INTO language_subtag_registry( subtag, type, description, added)
109
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
110
111
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
112
VALUES( 'zh','chi');
113
114
INSERT INTO language_descriptions(subtag, type, lang, description)
115
VALUES ( 'zh', 'language', 'zh', '&#20013;&#25991;');
116
117
INSERT INTO language_descriptions(subtag, type, lang, description)
118
VALUES( 'zh', 'language', 'en', 'Chinese');
119
120
INSERT INTO language_descriptions(subtag, type, lang, description)
121
VALUES( 'zh', 'language', 'fr', 'Chinois');
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES( 'zh', 'language', 'de', 'Chinesisch');
125
126
-- Czech
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
128
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
129
130
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
131
VALUES( 'cs','cze');
132
133
INSERT INTO language_descriptions(subtag, type, lang, description)
134
VALUES ( 'cs', 'language', 'cs', '&#x010D;e&#353;tina');
135
136
INSERT INTO language_descriptions(subtag, type, lang, description)
137
VALUES( 'cs', 'language', 'en', 'Czech');
138
139
INSERT INTO language_descriptions(subtag, type, lang, description)
140
VALUES( 'cs', 'language', 'fr', 'Tchèque');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES( 'cs', 'language', 'de', 'Tschechisch');
144
145
-- Danish
146
INSERT INTO language_subtag_registry( subtag, type, description, added)
147
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
148
149
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
150
VALUES( 'da','dan');
151
152
INSERT INTO language_descriptions(subtag, type, lang, description)
153
VALUES ( 'da', 'language', 'da', 'Dansk');
154
155
INSERT INTO language_descriptions(subtag, type, lang, description)
156
VALUES( 'da', 'language', 'en', 'Danish');
157
158
INSERT INTO language_descriptions(subtag, type, lang, description)
159
VALUES( 'da', 'language', 'fr', 'Danois');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'da', 'language', 'de', 'Dänisch');
163
164
-- Dutch, Flemish
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
166
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
167
168
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
169
VALUES( 'nl','dut');
170
171
INSERT INTO language_descriptions(subtag, type, lang, description)
172
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
173
174
INSERT INTO language_descriptions(subtag, type, lang, description)
175
VALUES( 'nl', 'language', 'en', 'Dutch');
176
177
INSERT INTO language_descriptions(subtag, type, lang, description)
178
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES( 'nl', 'language', 'de', 'Niederländisch');
182
183
-- English
184
INSERT INTO language_subtag_registry( subtag, type, description, added)
185
VALUES ( 'en', 'language', 'English','2005-10-16' );
186
187
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
188
VALUES( 'en','eng');
189
190
INSERT INTO language_descriptions(subtag, type, lang, description)
191
VALUES( 'en', 'language', 'en', 'English');
192
193
INSERT INTO language_descriptions(subtag, type, lang, description)
194
VALUES( 'en', 'language', 'fr', 'Anglais');
195
196
INSERT INTO language_descriptions(subtag, type, lang, description)
197
VALUES( 'en', 'language', 'de', 'Englisch');
198
199
-- Finnish
200
INSERT INTO language_subtag_registry( subtag, type, description, added)
201
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
202
203
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
204
VALUES( 'fi','fin');
205
206
INSERT INTO language_descriptions(subtag, type, lang, description)
207
VALUES( 'fi', 'language', 'fi', 'suomi');
208
209
INSERT INTO language_descriptions(subtag, type, lang, description)
210
VALUES( 'fi', 'language', 'en', 'Finnish');
211
212
INSERT INTO language_descriptions(subtag, type, lang, description)
213
VALUES( 'fi', 'language', 'de', 'Finnisch');
214
215
-- French
216
INSERT INTO language_subtag_registry( subtag, type, description, added)
217
VALUES ( 'fr', 'language', 'French','2005-10-16' );
218
219
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
220
VALUES( 'fr','fre');
221
222
INSERT INTO language_descriptions(subtag, type, lang, description)
223
VALUES( 'fr', 'language', 'en', 'French');
224
225
INSERT INTO language_descriptions(subtag, type, lang, description)
226
VALUES( 'fr', 'language', 'fr', 'Fran&ccedil;ais');
227
228
INSERT INTO language_descriptions(subtag, type, lang, description)
229
VALUES( 'fr', 'language', 'de', 'Französisch');
230
231
-- INSERT INTO language_descriptions(subtag, type, lang, description)
232
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'fran&ccedil;ais');
233
234
-- Lao
235
INSERT INTO language_subtag_registry( subtag, type, description, added)
236
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
237
238
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
239
VALUES( 'lo','lao');
240
241
INSERT INTO language_descriptions(subtag, type, lang, description)
242
VALUES( 'lo', 'language', 'lo', '&#3742;&#3762;&#3754;&#3762;&#3749;&#3762;&#3751;');
243
244
INSERT INTO language_descriptions(subtag, type, lang, description)
245
VALUES( 'lo', 'language', 'en', 'Lao');
246
247
INSERT INTO language_descriptions(subtag, type, lang, description)
248
VALUES( 'lo', 'language', 'fr', 'Laotien');
249
250
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'de', 'Laotisch');
252
253
-- German
254
INSERT INTO language_subtag_registry( subtag, type, description, added)
255
VALUES ( 'de', 'language', 'German','2005-10-16' );
256
257
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
258
VALUES( 'de','ger');
259
260
INSERT INTO language_descriptions(subtag, type, lang, description)
261
VALUES( 'de', 'language', 'de', 'Deutsch');
262
263
INSERT INTO language_descriptions(subtag, type, lang, description)
264
VALUES( 'de', 'language', 'en', 'German');
265
266
INSERT INTO language_descriptions(subtag, type, lang, description)
267
VALUES( 'de', 'language', 'fr', 'Allemand');
268
269
-- Greek
270
INSERT INTO language_subtag_registry( subtag, type, description, added)
271
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
272
273
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
274
VALUES( 'el','gre');
275
276
INSERT INTO language_descriptions(subtag, type, lang, description)
277
VALUES( 'el', 'language', 'el', '&#949;&#955;&#955;&#951;&#957;&#953;&#954;&#940;');
278
279
INSERT INTO language_descriptions(subtag, type, lang, description)
280
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
281
282
INSERT INTO language_descriptions(subtag, type, lang, description)
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
287
288
-- Hebrew
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
290
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
291
292
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
293
VALUES( 'he','heb');
294
295
INSERT INTO language_descriptions(subtag, type, lang, description)
296
VALUES( 'he', 'language', 'he', '&#1506;&#1489;&#1512;&#1497;&#1514;');
297
298
INSERT INTO language_descriptions(subtag, type, lang, description)
299
VALUES( 'he', 'language', 'en', 'Hebrew');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'he', 'language', 'fr', 'Hébreu');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'de', 'Hebräisch');
306
307
-- Hindi
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
309
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
310
311
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
312
VALUES( 'hi','hin');
313
314
INSERT INTO language_descriptions(subtag, type, lang, description)
315
VALUES( 'hi', 'language', 'hi', '&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'hi', 'language', 'en', 'Hindi');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'hi', 'language', 'fr', 'Hindi');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'de', 'Hindi');
325
326
-- Hungarian
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'hu','hun');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'hu', 'language', 'hu', 'Magyar');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'hu', 'language', 'en', 'Hungarian');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'hu', 'language', 'fr', 'Hongrois');
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'de', 'Ungarisch');
344
345
-- Indonesian
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
347
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
348
349
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
350
VALUES( 'id','ind');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'id', 'language', 'en', 'Indonesian');
357
358
INSERT INTO language_descriptions(subtag, type, lang, description)
359
VALUES( 'id', 'language', 'fr', 'Indonésien');
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'de', 'Indonesisch');
363
364
-- Italian
365
INSERT INTO language_subtag_registry( subtag, type, description, added)
366
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
367
368
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
369
VALUES( 'it','ita');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'it', 'language', 'it', 'Italiano');
373
374
INSERT INTO language_descriptions(subtag, type, lang, description)
375
VALUES( 'it', 'language', 'en', 'Italian');
376
377
INSERT INTO language_descriptions(subtag, type, lang, description)
378
VALUES( 'it', 'language', 'fr', 'Italien');
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'de', 'Italienisch');
382
383
-- Japanese
384
INSERT INTO language_subtag_registry( subtag, type, description, added)
385
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
386
387
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
388
VALUES( 'ja','jpn');
389
390
INSERT INTO language_descriptions(subtag, type, lang, description)
391
VALUES( 'ja', 'language', 'ja', '&#26085;&#26412;&#35486;');
392
393
INSERT INTO language_descriptions(subtag, type, lang, description)
394
VALUES( 'ja', 'language', 'en', 'Japanese');
395
396
INSERT INTO language_descriptions(subtag, type, lang, description)
397
VALUES( 'ja', 'language', 'fr', 'Japonais');
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'de', 'Japanisch');
401
402
-- Korean
403
INSERT INTO language_subtag_registry( subtag, type, description, added)
404
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
405
406
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
407
VALUES( 'ko','kor');
408
409
INSERT INTO language_descriptions(subtag, type, lang, description)
410
VALUES( 'ko', 'language', 'ko', '&#54620;&#44397;&#50612;');
411
412
INSERT INTO language_descriptions(subtag, type, lang, description)
413
VALUES( 'ko', 'language', 'en', 'Korean');
414
415
INSERT INTO language_descriptions(subtag, type, lang, description)
416
VALUES( 'ko', 'language', 'fr', 'Coréen');
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'de', 'Koreanisch');
420
421
-- Latin
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
423
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
424
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
426
VALUES( 'la','lat');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES( 'la', 'language', 'la', 'Latina');
430
431
INSERT INTO language_descriptions(subtag, type, lang, description)
432
VALUES( 'la', 'language', 'en', 'Latin');
433
434
INSERT INTO language_descriptions(subtag, type, lang, description)
435
VALUES( 'la', 'language', 'fr', 'Latin');
436
437
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'de', 'Latein');
439
440
-- Galician
441
442
INSERT INTO language_subtag_registry( subtag, type, description, added)
443
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
444
445
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
446
VALUES( 'gl','glg');
447
448
INSERT INTO language_descriptions(subtag, type, lang, description)
449
VALUES( 'gl', 'language', 'gl', 'Galego');
450
451
INSERT INTO language_descriptions(subtag, type, lang, description)
452
VALUES( 'gl', 'language', 'en', 'Galician');
453
454
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
457
-- Norwegian (bokmål)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
459
VALUES ( 'nb', 'language', 'Norwegian bokm&#229;l','2005-10-16' );
460
461
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
462
VALUES( 'nb','nor');
463
464
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
465
VALUES( 'nb','nob');
466
467
INSERT INTO language_descriptions(subtag, type, lang, description)
468
VALUES( 'nb', 'language', 'nb', 'Norsk bokm&#229;l');
469
470
INSERT INTO language_descriptions(subtag, type, lang, description)
471
VALUES( 'nb', 'language', 'en', 'Norwegian bokm&#229;l');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES( 'nb', 'language', 'fr', 'Norvégien bokm&#229;l');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;l');
478
479
-- Norwegian (nynorsk)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
481
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
482
483
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
484
VALUES( 'nn','nno');
485
486
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
491
492
INSERT INTO language_descriptions(subtag, type, lang, description)
493
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
494
495
INSERT INTO language_descriptions(subtag, type, lang, description)
496
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
497
498
INSERT INTO language_descriptions(subtag, type, lang, description)
499
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
500
501
-- Persian
502
INSERT INTO language_subtag_registry( subtag, type, description, added)
503
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
504
505
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
506
VALUES( 'fa','per');
507
508
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'fa', 'language', 'fa', '&#1601;&#1575;&#1585;&#1587;&#1609;');
510
511
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'fa', 'language', 'en', 'Persian');
513
514
INSERT INTO language_descriptions(subtag, type, lang, description)
515
VALUES( 'fa', 'language', 'fr', 'Persan');
516
517
INSERT INTO language_descriptions(subtag, type, lang, description)
518
VALUES( 'fa', 'language', 'de', 'Persisch');
519
520
-- Polish
521
INSERT INTO language_subtag_registry( subtag, type, description, added)
522
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
523
524
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
525
VALUES( 'pl','pol');
526
527
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'pl', 'language', 'pl', 'Polski');
529
530
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'pl', 'language', 'en', 'Polish');
532
533
INSERT INTO language_descriptions(subtag, type, lang, description)
534
VALUES( 'pl', 'language', 'fr', 'Polonais');
535
536
INSERT INTO language_descriptions(subtag, type, lang, description)
537
VALUES( 'pl', 'language', 'de', 'Polnisch');
538
539
-- Portuguese
540
INSERT INTO language_subtag_registry( subtag, type, description, added)
541
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
542
543
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
544
VALUES( 'pt','por');
545
546
INSERT INTO language_descriptions(subtag, type, lang, description)
547
VALUES( 'pt', 'language', 'pt', 'Portugu&ecirc;s');
548
549
INSERT INTO language_descriptions(subtag, type, lang, description)
550
VALUES( 'pt', 'language', 'en', 'Portuguese');
551
552
INSERT INTO language_descriptions(subtag, type, lang, description)
553
VALUES( 'pt', 'language', 'fr', 'Portugais');
554
555
INSERT INTO language_descriptions(subtag, type, lang, description)
556
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
557
558
-- Romanian
559
INSERT INTO language_subtag_registry( subtag, type, description, added)
560
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
561
562
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
563
VALUES( 'ro','rum');
564
565
INSERT INTO language_descriptions(subtag, type, lang, description)
566
VALUES( 'ro', 'language', 'ro', 'Rom&acirc;n&#259;');
567
568
INSERT INTO language_descriptions(subtag, type, lang, description)
569
VALUES( 'ro', 'language', 'en', 'Romanian');
570
571
INSERT INTO language_descriptions(subtag, type, lang, description)
572
VALUES( 'ro', 'language', 'fr', 'Roumain');
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'ro', 'language', 'de', 'Rumänisch');
576
577
-- Russian
578
INSERT INTO language_subtag_registry( subtag, type, description, added)
579
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
580
581
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
582
VALUES( 'ru','rus');
583
584
INSERT INTO language_descriptions(subtag, type, lang, description)
585
VALUES( 'ru', 'language', 'ru', '&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'ru', 'language', 'en', 'Russian');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'ru', 'language', 'fr', 'Russe');
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'ru', 'language', 'de', 'Russisch');
595
596
-- Serbian
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'sr','srp');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'sr', 'language', 'sr', '&#1089;&#1088;&#1087;&#1089;&#1082;&#1080;');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'sr', 'language', 'en', 'Serbian');
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'sr', 'language', 'fr', 'Serbe');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'sr', 'language', 'de', 'Serbisch');
614
615
-- Spanish, Castilian
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
617
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
618
619
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
620
VALUES( 'es','spa');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'es', 'language', 'es', 'Espa&ntilde;ol');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'es', 'language', 'en', 'Spanish');
627
628
INSERT INTO language_descriptions(subtag, type, lang, description)
629
VALUES( 'es', 'language', 'fr', 'Espagnol');
630
631
INSERT INTO language_descriptions(subtag, type, lang, description)
632
VALUES( 'es', 'language', 'de', 'Spanisch');
633
634
-- Spanish, Catalan
635
INSERT INTO language_subtag_registry( subtag, type, description, added)
636
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
637
638
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
639
VALUES( 'ca','cat');
640
641
INSERT INTO language_descriptions(subtag, type, lang, description)
642
VALUES( 'ca', 'language', 'es', 'Catalán');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES( 'ca', 'language', 'en', 'Catalan');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'ca', 'language', 'fr', 'Catalan');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'ca', 'language', 'ca', 'Català');
652
653
INSERT INTO language_descriptions(subtag, type, lang, description)
654
VALUES( 'ca', 'language', 'de', 'Katalanisch');
655
656
-- Swedish
657
INSERT INTO language_subtag_registry( subtag, type, description, added)
658
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
659
660
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
661
VALUES( 'sv','swe');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'sv', 'language', 'sv', 'Svenska');
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'sv', 'language', 'en', 'Swedish');   
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES( 'sv', 'language', 'fr', 'Suédois');
671
672
INSERT INTO language_descriptions(subtag, type, lang, description)
673
VALUES( 'sv', 'language', 'de', 'Schwedisch');
674
675
-- Tetum
676
INSERT INTO language_subtag_registry( subtag, type, description, added)
677
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
678
679
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
680
VALUES( 'tet','tet');
681
682
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES( 'tet', 'language', 'tet', 'tetun');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'tet', 'language', 'en', 'Tetum');
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'tet', 'language', 'fr', 'Tétoum');
690
691
INSERT INTO language_descriptions(subtag, type, lang, description)
692
VALUES( 'tet', 'language', 'de', 'Tetum');
693
694
-- Thai
695
INSERT INTO language_subtag_registry( subtag, type, description, added)
696
VALUES ( 'th', 'language', 'Thai','2005-10-16');
697
698
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
699
VALUES( 'th','tha');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'th', 'language', 'th', '&#3616;&#3634;&#3625;&#3634;&#3652;&#3607;&#3618;');
703
704
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES( 'th', 'language', 'en', 'Thai');   
706
707
INSERT INTO language_descriptions(subtag, type, lang, description)
708
VALUES( 'th', 'language', 'fr', 'Thaï');
709
710
INSERT INTO language_descriptions(subtag, type, lang, description)
711
VALUES( 'th', 'language', 'de', 'Thailändisch');
712
713
-- Turkish
714
INSERT INTO language_subtag_registry( subtag, type, description, added)
715
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
716
717
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
718
VALUES( 'tr','tur');
719
720
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES( 'tr', 'language', 'tr', 'T&uuml;rk&ccedil;e');
722
723
INSERT INTO language_descriptions(subtag, type, lang, description)
724
VALUES( 'tr', 'language', 'en', 'Turkish');   
725
726
INSERT INTO language_descriptions(subtag, type, lang, description)
727
VALUES( 'tr', 'language', 'fr', 'Turc');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'tr', 'language', 'de', 'Türkisch');
731
732
-- Ukranian
733
INSERT INTO language_subtag_registry( subtag, type, description, added)
734
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
735
736
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
737
VALUES( 'uk','ukr');
738
739
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES( 'uk', 'language', 'uk', '&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;');
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'uk', 'language', 'en', 'Ukranian');
744
745
INSERT INTO language_descriptions(subtag, type, lang, description)
746
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
747
748
INSERT INTO language_descriptions(subtag, type, lang, description)
749
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
750
751
-- Urdu
752
INSERT INTO language_subtag_registry( subtag, type, description, added)
753
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
754
755
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
756
VALUES( 'ur','urd');
757
758
INSERT INTO language_descriptions(subtag, type, lang, description)
759
VALUES( 'ur', 'language', 'en', 'Urdu');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES( 'ur', 'language', 'ur', '&#1575;&#1585;&#1583;&#1608;');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'ur', 'language', 'fr', 'Ourdou');
766
767
INSERT INTO language_descriptions(subtag, type, lang, description)
768
VALUES( 'ur', 'language', 'de', 'Urdu');
769
770
-- SCRIPTS
771
-- Arabic
772
INSERT INTO language_subtag_registry( subtag, type, description, added)
773
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
774
775
INSERT INTO language_descriptions(subtag, type, lang, description)
776
VALUES ( 'Arab','script', 'Arab', '&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'Arab', 'script','en', 'Arabic');
780
781
INSERT INTO language_descriptions(subtag, type, lang, description)
782
VALUES( 'Arab', 'script','fr', 'Arabic');
783
784
-- Cyrillic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
787
788
INSERT INTO language_descriptions(subtag, type, lang, description)
789
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
790
791
INSERT INTO language_descriptions(subtag, type, lang, description)
792
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
793
794
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
796
797
-- Greek
798
INSERT INTO language_subtag_registry( subtag, type, description, added)
799
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
800
801
INSERT INTO language_descriptions(subtag, type, lang, description)
802
VALUES ( 'Grek', 'script', 'Grek', '????');
803
804
INSERT INTO language_descriptions(subtag, type, lang, description)
805
VALUES( 'Grek', 'script', 'en', 'Greek');
806
807
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Grek', 'script', 'fr', 'Greek');
809
810
-- Han - Simplified
811
INSERT INTO language_subtag_registry( subtag, type, description, added)
812
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
813
814
INSERT INTO language_descriptions(subtag, type, lang, description)
815
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
816
817
INSERT INTO language_descriptions(subtag, type, lang, description)
818
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
819
820
INSERT INTO language_descriptions(subtag, type, lang, description)
821
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
822
823
-- Han - Traditional
824
INSERT INTO language_subtag_registry( subtag, type, description, added)
825
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
826
827
INSERT INTO language_descriptions(subtag, type, lang, description)
828
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
832
833
-- Hebrew
834
INSERT INTO language_subtag_registry( subtag, type, description, added)
835
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
836
837
INSERT INTO language_descriptions(subtag, type, lang, description)
838
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
839
840
INSERT INTO language_descriptions(subtag, type, lang, description)
841
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
842
843
-- Lao
844
INSERT INTO language_subtag_registry( subtag, type, description, added)
845
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
849
850
INSERT INTO language_descriptions(subtag, type, lang, description)
851
VALUES( 'Laoo', 'script', 'en', 'Lao');
852
853
-- REGIONS
854
-- Canada
855
INSERT INTO language_subtag_registry( subtag, type, description, added)
856
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
857
858
INSERT INTO language_descriptions(subtag, type, lang, description)
859
VALUES( 'CA', 'region', 'en', 'Canada');
860
861
-- Denmark
862
INSERT INTO language_subtag_registry( subtag, type, description, added)
863
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
864
865
INSERT INTO language_descriptions(subtag, type, lang, description)
866
VALUES( 'DK', 'region', 'dk', 'Danmark');
867
868
-- France
869
INSERT INTO language_subtag_registry( subtag, type, description, added)
870
VALUES ( 'FR', 'region', 'France','2005-10-16');
871
872
INSERT INTO language_descriptions(subtag, type, lang, description)
873
VALUES ( 'FR', 'region', 'fr', 'France');
874
875
INSERT INTO language_descriptions(subtag, type, lang, description)
876
VALUES( 'FR', 'region', 'en', 'France');
877
878
-- New Zealand
879
INSERT INTO language_subtag_registry( subtag, type, description, added)
880
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
881
882
INSERT INTO language_descriptions(subtag, type, lang, description)
883
VALUES( 'NZ', 'region', 'en', 'New Zealand');
884
885
-- United Kingdom
886
INSERT INTO language_subtag_registry( subtag, type, description, added)
887
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
888
889
INSERT INTO language_descriptions(subtag, type, lang, description)
890
VALUES( 'GB', 'region', 'en', 'United Kingdom');
891
892
-- United States
893
INSERT INTO language_subtag_registry( subtag, type, description, added)
894
VALUES ( 'US', 'region', 'United States','2005-10-16');
895
896
INSERT INTO language_descriptions(subtag, type, lang, description)
897
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/de-DE/mandatory/userflags.sql (-20 lines)
Lines 1-20 Link Here
1
INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES
2
(0,'superlibrarian','Zugriff auf alle Funktionen',0),
3
(1,'circulate','Medien ausleihen/zurückgeben',0),
4
(2,'catalogue','Katalogsuche verwenden (Dienstoberfläche)',0),
5
(3,'parameters','Systemparameter verändern',0),
6
(4,'borrowers','Benutzer anlegen/ändern',0),
7
(5,'permissions','Berechtigungen für Benutzer vergeben',0),
8
(6,'reserveforothers','Vormerkungen für Benutzer setzen/ändern',0),
9
(7,'borrow','Medien entleihen',1),
10
(9,'editcatalogue','Katalogdaten ändern (Titel- und Bestandsdaten ändern)',0),
11
(10,'updatecharges','Gebühren kassieren/ändern',0),
12
(11,'acquisition','Erwerbung und Verwaltung von Anschaffungsvorschlägen',0),
13
(12,'management','Zugriff auf Administration',0),
14
(13,'tools','Werkzeuge verwenden (Export, Import, Etikettendruck)',0),
15
(14,'editauthorities','Normdaten ändern',0),
16
(15,'serials','Zugriff auf Abonnementverwaltung/Zeitschriftenmodul',0),
17
(16,'reports','Zugriff auf Reportmodul',0),
18
(17,'staffaccess','Berechtigungen/Logins für Bibliotheksmitarbeiter vergeben',0),
19
(18,'coursereserves','Course Reserves',0),
20
(19,'plugins', 'Koha Plugins', '0');
(-)a/installer/data/mysql/de-DE/mandatory/userpermissions.sql (-64 lines)
Lines 1-63 Link Here
1
INSERT INTO permissions (module_bit, code, description) VALUES
2
   ( 1, 'circulate_remaining_permissions', 'Übrige Ausleihberechtigungen'),
3
   ( 1, 'override_renewals', 'Gesperrte Verlängerungen überschreiben'),
4
   ( 1, 'overdues_report', 'Überfälligkeiten-Report ausführen'),
5
   ( 3, 'parameters_remaining_permissions', 'Übrige Administrationsberechtigungen'),
6
   ( 3, 'manage_circ_rules', 'Ausleihkonditionen verwalten'),
7
   ( 6, 'place_holds', 'Vormerkungen für Benutzer setzen'),
8
   ( 6, 'modify_holds_priority', 'Vormerkungspriorität verändern'),
9
   ( 9, 'edit_catalogue', 'Katalogdaten bearbeiten (Titel- und Exemplardaten ändern)'),
10
   ( 9, 'fast_cataloging', 'Schnellaufnahmen anlegen'),
11
   ( 9, 'edit_items', 'Exemplare bearbeiten'),
12
   (11, 'vendors_manage', 'Lieferanten verwalten'),
13
   (11, 'contracts_manage', 'Vereinbarungen verwalten'),
14
   (11, 'period_manage', 'Etats verwalten'),
15
   (11, 'budget_manage', 'Konten verwalten'),
16
   (11, 'budget_modify', 'Konten verändern (keine Neuen anlegen, aber Bestehende ändern)'),
17
   (11, 'planning_manage', 'Etatplanung verwalten'),
18
   (11, 'order_manage', 'Bestellungen verwalten'),
19
   (11, 'group_manage', 'Bestellgruppen vewalten'),
20
   (11, 'order_receive', 'Lieferungen verwalten'),
21
   (11, 'budget_add_del', 'Konten hinzufügen/ändern, aber bestehende nicht ändern'),
22
   (11, 'budget_manage_all', 'Alle Konten verwalten'),
23
   (13, 'edit_news', 'Nachrichten für OPAC und Dienstoberfläche verfassen'),
24
   (13, 'label_creator', 'Etiketten und Barcodes aus Katalog- und Benutzerdaten erstellen'),
25
   (13, 'edit_calendar', 'Schließtage eintragen'),
26
   (13, 'moderate_comments', 'Benutzerkommentare moderieren'),
27
   (13, 'edit_notices', 'Benachrichtigungen verwalten'),
28
   (13, 'edit_notice_status_triggers', 'Mahntrigger für überfällige Medien verwalten'),
29
   (13, 'edit_quotes', '"Zitat des Tages" konfigurieren'),
30
   (13, 'view_system_logs', 'Logs durchsuchen/einsehen'),
31
   (13, 'inventory', 'Inventur durchführen'),
32
   (13, 'stage_marc_import', 'MARC-Datensätze zwischenspeichern'),
33
   (13, 'manage_staged_marc', 'MARC-Importe verwalten, auch Übernahme in Katalog und Import rückgängig machen'),
34
   (13, 'export_catalog', 'Titel- und Exemplardaten exportieren'),
35
   (13, 'import_patrons', 'Benutzerdaten importieren'),
36
   (13, 'edit_patrons', 'Stapelbearbeitung von Benutzerdaten durchführen'),
37
   (13, 'delete_anonymize_patrons', 'Inaktive Benutzer löschen und Ausleihhistorie anonymisieren (Benutzerausleihhistorie löschen)'),
38
   (13, 'batch_upload_patron_images', 'Benutzerfotos einzeln oder im Stapel hochladen'),
39
   (13, 'schedule_tasks', 'Aufgabenplaner verwenden'),
40
   (13, 'items_batchmod', 'Stapelbearbeitung von Exemplaren durchführen'),
41
   (13, 'items_batchdel', 'Stapellöschung von Exemplaren durchführen'),
42
   (13, 'manage_csv_profiles', 'CSV-Profile für Export verwalten'),
43
   (13, 'moderate_tags', 'Von Benutzern vergebene Tags moderieren'),
44
   (13, 'rotating_collections', 'Wandernde Sammlungen verwalten'),
45
   (13, 'upload_local_cover_images', 'Eigene Coverbilder hochladen'),
46
   (15, 'check_expiration', 'Ablauf eines Abonnements prüfen'),
47
   (15, 'claim_serials', 'Fehlende Hefte reklamieren'),
48
   (15, 'create_subscription', 'Neues Abonnement anlegen'),
49
   (15, 'delete_subscription', 'Bestehende Abonnements löschen'),
50
   (15, 'edit_subscription', 'Bestehende Abonnements bearbeiten'),
51
   (15, 'receive_serials', 'Zugang von Heften'),
52
   (15, 'renew_subscription', 'Abonnements verlängern'),
53
   (15, 'routing', 'Umlauflisten verwalten'),
54
   (16, 'execute_reports', 'SQL-Reports ausführen'),
55
   (16, 'create_reports', 'SQL-Reports erstellen'),
56
   (18, 'manage_courses', 'Add, edit and delete courses'),
57
   (18, 'add_reserves', 'Add course reserves'),
58
   (18, 'delete_reserves', 'Remove course reserves'),
59
   (19, 'manage', 'Plugins verwealten (installieren/deinstallieren)'),
60
   (19, 'tool', 'Werkzeug-Plugins verwenden'),
61
   (19, 'report', 'Report-Plugins verwenden'),
62
   (19, 'configure', 'Plugins konfigurieren')
63
;
64
- 

Return to bug 10521