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

(-)a/C4/Installer.pm (+3 lines)
Lines 298-303 sub load_sql_in_order { Link Here
298
    $request->execute;
298
    $request->execute;
299
    my ($systempreference) = $request->fetchrow;
299
    my ($systempreference) = $request->fetchrow;
300
    $systempreference = '' unless defined $systempreference; # avoid warning
300
    $systempreference = '' unless defined $systempreference; # avoid warning
301
    # Make sure subtag_registry.sql is loaded second
302
    my $subtag_registry = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/mandatory/subtag_registry.sql";
303
    unshift(@fnames, $subtag_registry);
301
    # Make sure the global sysprefs.sql file is loaded first
304
    # Make sure the global sysprefs.sql file is loaded first
302
    my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql";
305
    my $globalsysprefs = C4::Context->config('intranetdir') . "/installer/data/$self->{dbms}/sysprefs.sql";
303
    unshift(@fnames, $globalsysprefs);
306
    unshift(@fnames, $globalsysprefs);
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.sql (-954 lines)
Lines 1-954 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
INSERT INTO language_descriptions(subtag, type, lang, description)
29
VALUES( 'opac', 'i', 'de', 'OPAC');
30
31
-- Staff Client
32
INSERT INTO language_subtag_registry( subtag, type, description, added)
33
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
34
35
INSERT INTO language_descriptions(subtag, type, lang, description)
36
VALUES( 'intranet', 'i', 'en', 'Staff Client');
37
38
INSERT INTO language_descriptions(subtag, type, lang, description)
39
VALUES( 'intranet', 'i', 'fr', '????');
40
41
INSERT INTO language_descriptions(subtag, type, lang, description)
42
VALUES( 'intranet', 'i', 'de', 'Dienstoberfläche');
43
44
-- Theme (t)
45
INSERT INTO language_subtag_registry( subtag, type, description, added)
46
VALUES ( 'prog', 't', 'Prog','2005-10-16');
47
48
INSERT INTO language_descriptions(subtag, type, lang, description)
49
VALUES( 'prog', 't', 'en', 'Prog');
50
51
INSERT INTO language_descriptions(subtag, type, lang, description)
52
VALUES( 'prog', 't', 'fr', 'Prog');
53
54
INSERT INTO language_descriptions(subtag, type, lang, description)
55
VALUES( 'prog', 't', 'de', 'Prog');
56
57
-- LANGUAGES
58
59
-- Arabic
60
INSERT INTO language_subtag_registry( subtag, type, description, added)
61
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
62
63
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
64
VALUES( 'ar','ara');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES ( 'ar', 'language', 'ar', 'العربية');
68
69
INSERT INTO language_descriptions(subtag, type, lang, description)
70
VALUES( 'ar', 'language', 'en', 'Arabic');
71
72
INSERT INTO language_descriptions(subtag, type, lang, description)
73
VALUES( 'ar', 'language', 'fr', 'Arabe');
74
75
INSERT INTO language_descriptions(subtag, type, lang, description)
76
VALUES( 'ar', 'language', 'de', 'Arabisch');
77
78
-- Armenian
79
INSERT INTO language_subtag_registry( subtag, type, description, added)
80
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
81
82
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
83
VALUES( 'hy','arm');
84
85
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES ( 'hy', 'language', 'hy', 'Հայերեն');
87
88
INSERT INTO language_descriptions(subtag, type, lang, description)
89
VALUES( 'hy', 'language', 'en', 'Armenian');
90
91
INSERT INTO language_descriptions(subtag, type, lang, description)
92
VALUES( 'hy', 'language', 'fr', 'Armenian');
93
94
INSERT INTO language_descriptions(subtag, type, lang, description)
95
VALUES( 'hy', 'language', 'de', 'Armenisch');
96
97
-- Bulgarian
98
INSERT INTO language_subtag_registry( subtag, type, description, added)
99
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
100
101
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
102
VALUES( 'bg','bul');
103
104
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES ( 'bg', 'language', 'bg', 'Български');
106
107
INSERT INTO language_descriptions(subtag, type, lang, description)
108
VALUES( 'bg', 'language', 'en', 'Bulgarian');
109
110
INSERT INTO language_descriptions(subtag, type, lang, description)
111
VALUES( 'bg', 'language', 'fr', 'Bulgare');
112
113
INSERT INTO language_descriptions(subtag, type, lang, description)
114
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
115
116
-- Chinese
117
INSERT INTO language_subtag_registry( subtag, type, description, added)
118
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
119
120
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
121
VALUES( 'zh','chi');
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES ( 'zh', 'language', 'zh', '中文');
125
126
INSERT INTO language_descriptions(subtag, type, lang, description)
127
VALUES( 'zh', 'language', 'en', 'Chinese');
128
129
INSERT INTO language_descriptions(subtag, type, lang, description)
130
VALUES( 'zh', 'language', 'fr', 'Chinois');
131
132
INSERT INTO language_descriptions(subtag, type, lang, description)
133
VALUES( 'zh', 'language', 'de', 'Chinesisch');
134
135
-- Czech
136
INSERT INTO language_subtag_registry( subtag, type, description, added)
137
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
138
139
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
140
VALUES( 'cs','cze');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES ( 'cs', 'language', 'cs', 'čeština');
144
145
INSERT INTO language_descriptions(subtag, type, lang, description)
146
VALUES( 'cs', 'language', 'en', 'Czech');
147
148
INSERT INTO language_descriptions(subtag, type, lang, description)
149
VALUES( 'cs', 'language', 'fr', 'Tchèque');
150
151
INSERT INTO language_descriptions(subtag, type, lang, description)
152
VALUES( 'cs', 'language', 'de', 'Tschechisch');
153
154
-- Danish
155
INSERT INTO language_subtag_registry( subtag, type, description, added)
156
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
157
158
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
159
VALUES( 'da','dan');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES ( 'da', 'language', 'da', 'Dansk');
163
164
INSERT INTO language_descriptions(subtag, type, lang, description)
165
VALUES( 'da', 'language', 'en', 'Danish');
166
167
INSERT INTO language_descriptions(subtag, type, lang, description)
168
VALUES( 'da', 'language', 'fr', 'Danois');
169
170
INSERT INTO language_descriptions(subtag, type, lang, description)
171
VALUES( 'da', 'language', 'de', 'Dänisch');
172
173
-- Dutch, Flemish
174
INSERT INTO language_subtag_registry( subtag, type, description, added)
175
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
176
177
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
178
VALUES( 'nl','dut');
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
182
183
INSERT INTO language_descriptions(subtag, type, lang, description)
184
VALUES( 'nl', 'language', 'en', 'Dutch');
185
186
INSERT INTO language_descriptions(subtag, type, lang, description)
187
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
188
189
INSERT INTO language_descriptions(subtag, type, lang, description)
190
VALUES( 'nl', 'language', 'de', 'Niederländisch');
191
192
-- English
193
INSERT INTO language_subtag_registry( subtag, type, description, added)
194
VALUES ( 'en', 'language', 'English','2005-10-16' );
195
196
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
197
VALUES( 'en','eng');
198
199
INSERT INTO language_descriptions(subtag, type, lang, description)
200
VALUES( 'en', 'language', 'en', 'English');
201
202
INSERT INTO language_descriptions(subtag, type, lang, description)
203
VALUES( 'en', 'language', 'fr', 'Anglais');
204
205
INSERT INTO language_descriptions(subtag, type, lang, description)
206
VALUES( 'en', 'language', 'de', 'Englisch');
207
208
-- Finnish
209
INSERT INTO language_subtag_registry( subtag, type, description, added)
210
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
211
212
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
213
VALUES( 'fi','fin');
214
215
INSERT INTO language_descriptions(subtag, type, lang, description)
216
VALUES( 'fi', 'language', 'fi', 'suomi');
217
218
INSERT INTO language_descriptions(subtag, type, lang, description)
219
VALUES( 'fi', 'language', 'en', 'Finnish');
220
221
INSERT INTO language_descriptions(subtag, type, lang, description)
222
VALUES( 'fi', 'language', 'de', 'Finnisch');
223
224
-- French
225
INSERT INTO language_subtag_registry( subtag, type, description, added)
226
VALUES ( 'fr', 'language', 'French','2005-10-16' );
227
228
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
229
VALUES( 'fr','fre');
230
231
INSERT INTO language_descriptions(subtag, type, lang, description)
232
VALUES( 'fr', 'language', 'en', 'French');
233
234
INSERT INTO language_descriptions(subtag, type, lang, description)
235
VALUES( 'fr', 'language', 'fr', 'Français');
236
237
INSERT INTO language_descriptions(subtag, type, lang, description)
238
VALUES( 'fr', 'language', 'de', 'Französisch');
239
240
-- INSERT INTO language_descriptions(subtag, type, lang, description)
241
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
242
243
-- Lao
244
INSERT INTO language_subtag_registry( subtag, type, description, added)
245
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
246
247
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
248
VALUES( 'lo','lao');
249
250
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
252
253
INSERT INTO language_descriptions(subtag, type, lang, description)
254
VALUES( 'lo', 'language', 'en', 'Lao');
255
256
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'lo', 'language', 'fr', 'Laotien');
258
259
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'lo', 'language', 'de', 'Laotisch');
261
262
-- German
263
INSERT INTO language_subtag_registry( subtag, type, description, added)
264
VALUES ( 'de', 'language', 'German','2005-10-16' );
265
266
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
267
VALUES( 'de','ger');
268
269
INSERT INTO language_descriptions(subtag, type, lang, description)
270
VALUES( 'de', 'language', 'de', 'Deutsch');
271
272
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'de', 'language', 'en', 'German');
274
275
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'de', 'language', 'fr', 'Allemand');
277
278
-- Greek
279
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
281
282
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
283
VALUES( 'el','gre');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'el', 'ελληνικά');
287
288
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
290
291
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
293
294
INSERT INTO language_descriptions(subtag, type, lang, description)
295
VALUES( 'el', 'language', 'de', 'Griechisch (Moern [1453- ]');
296
297
-- Hebrew
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
299
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
300
301
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
302
VALUES( 'he','heb');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'he', 'עברית');
306
307
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'he', 'language', 'en', 'Hebrew');
309
310
INSERT INTO language_descriptions(subtag, type, lang, description)
311
VALUES( 'he', 'language', 'fr', 'Hébreu');
312
313
INSERT INTO language_descriptions(subtag, type, lang, description)
314
VALUES( 'he', 'language', 'de', 'Hebräisch');
315
316
-- Hindi
317
INSERT INTO language_subtag_registry( subtag, type, description, added)
318
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
319
320
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
321
VALUES( 'hi','hin');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
325
326
INSERT INTO language_descriptions(subtag, type, lang, description)
327
VALUES( 'hi', 'language', 'en', 'Hindi');
328
329
INSERT INTO language_descriptions(subtag, type, lang, description)
330
VALUES( 'hi', 'language', 'fr', 'Hindi');
331
332
INSERT INTO language_descriptions(subtag, type, lang, description)
333
VALUES( 'hi', 'language', 'de', 'Hindi');
334
335
-- Hungarian
336
INSERT INTO language_subtag_registry( subtag, type, description, added)
337
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
338
339
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
340
VALUES( 'hu','hun');
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'hu', 'Magyar');
344
345
INSERT INTO language_descriptions(subtag, type, lang, description)
346
VALUES( 'hu', 'language', 'en', 'Hungarian');
347
348
INSERT INTO language_descriptions(subtag, type, lang, description)
349
VALUES( 'hu', 'language', 'fr', 'Hongrois');
350
351
INSERT INTO language_descriptions(subtag, type, lang, description)
352
VALUES( 'hu', 'language', 'de', 'Ungarisch');
353
354
-- Indonesian
355
INSERT INTO language_subtag_registry( subtag, type, description, added)
356
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
357
358
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
359
VALUES( 'id','ind');
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
363
364
INSERT INTO language_descriptions(subtag, type, lang, description)
365
VALUES( 'id', 'language', 'en', 'Indonesian');
366
367
INSERT INTO language_descriptions(subtag, type, lang, description)
368
VALUES( 'id', 'language', 'fr', 'Indonésien');
369
370
INSERT INTO language_descriptions(subtag, type, lang, description)
371
VALUES( 'id', 'language', 'de', 'Indonesisch');
372
373
-- Italian
374
INSERT INTO language_subtag_registry( subtag, type, description, added)
375
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
376
377
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
378
VALUES( 'it','ita');
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'it', 'Italiano');
382
383
INSERT INTO language_descriptions(subtag, type, lang, description)
384
VALUES( 'it', 'language', 'en', 'Italian');
385
386
INSERT INTO language_descriptions(subtag, type, lang, description)
387
VALUES( 'it', 'language', 'fr', 'Italien');
388
389
INSERT INTO language_descriptions(subtag, type, lang, description)
390
VALUES( 'it', 'language', 'de', 'Italienisch');
391
392
-- Japanese
393
INSERT INTO language_subtag_registry( subtag, type, description, added)
394
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
395
396
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
397
VALUES( 'ja','jpn');
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'ja', '日本語');
401
402
INSERT INTO language_descriptions(subtag, type, lang, description)
403
VALUES( 'ja', 'language', 'en', 'Japanese');
404
405
INSERT INTO language_descriptions(subtag, type, lang, description)
406
VALUES( 'ja', 'language', 'fr', 'Japonais');
407
408
INSERT INTO language_descriptions(subtag, type, lang, description)
409
VALUES( 'ja', 'language', 'de', 'Japanisch');
410
411
-- Korean
412
INSERT INTO language_subtag_registry( subtag, type, description, added)
413
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
414
415
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
416
VALUES( 'ko','kor');
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'ko', '한국어');
420
421
INSERT INTO language_descriptions(subtag, type, lang, description)
422
VALUES( 'ko', 'language', 'en', 'Korean');
423
424
INSERT INTO language_descriptions(subtag, type, lang, description)
425
VALUES( 'ko', 'language', 'fr', 'Coréen');
426
427
INSERT INTO language_descriptions(subtag, type, lang, description)
428
VALUES( 'ko', 'language', 'de', 'Koreanisch');
429
430
-- Latin
431
INSERT INTO language_subtag_registry( subtag, type, description, added)
432
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
433
434
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
435
VALUES( 'la','lat');
436
437
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'la', 'Latina');
439
440
INSERT INTO language_descriptions(subtag, type, lang, description)
441
VALUES( 'la', 'language', 'en', 'Latin');
442
443
INSERT INTO language_descriptions(subtag, type, lang, description)
444
VALUES( 'la', 'language', 'fr', 'Latin');
445
446
INSERT INTO language_descriptions(subtag, type, lang, description)
447
VALUES( 'la', 'language', 'de', 'Latein');
448
449
-- Galician
450
451
INSERT INTO language_subtag_registry( subtag, type, description, added)
452
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
453
454
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
455
VALUES( 'gl','glg');
456
457
INSERT INTO language_descriptions(subtag, type, lang, description)
458
VALUES( 'gl', 'language', 'gl', 'Galego');
459
460
INSERT INTO language_descriptions(subtag, type, lang, description)
461
VALUES( 'gl', 'language', 'en', 'Galician');
462
463
INSERT INTO language_descriptions(subtag, type, lang, description)
464
VALUES( 'gl', 'language', 'fr', 'Galicien');
465
466
INSERT INTO language_descriptions(subtag, type, lang, description)
467
VALUES( 'gl', 'language', 'de', 'Galicisch');
468
469
470
-- Norwegian (bokmål)
471
INSERT INTO language_subtag_registry( subtag, type, description, added)
472
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
473
474
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
475
VALUES( 'nb','nor');
476
477
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
478
VALUES( 'nb','nob');
479
480
INSERT INTO language_descriptions(subtag, type, lang, description)
481
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
482
483
INSERT INTO language_descriptions(subtag, type, lang, description)
484
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
485
486
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål');
491
492
-- Norwegian (nynorsk)
493
INSERT INTO language_subtag_registry( subtag, type, description, added)
494
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
495
496
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
497
VALUES( 'nn','nno');
498
499
INSERT INTO language_descriptions(subtag, type, lang, description)
500
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
501
502
INSERT INTO language_descriptions(subtag, type, lang, description)
503
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
504
505
INSERT INTO language_descriptions(subtag, type, lang, description)
506
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
507
508
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
510
511
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
513
514
-- Persian
515
INSERT INTO language_subtag_registry( subtag, type, description, added)
516
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
517
518
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
519
VALUES( 'fa','per');
520
521
INSERT INTO language_descriptions(subtag, type, lang, description)
522
VALUES( 'fa', 'language', 'fa', 'فارسى');
523
524
INSERT INTO language_descriptions(subtag, type, lang, description)
525
VALUES( 'fa', 'language', 'en', 'Persian');
526
527
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'fa', 'language', 'fr', 'Persan');
529
530
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'fa', 'language', 'de', 'Persisch');
532
533
-- Polish
534
INSERT INTO language_subtag_registry( subtag, type, description, added)
535
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
536
537
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
538
VALUES( 'pl','pol');
539
540
INSERT INTO language_descriptions(subtag, type, lang, description)
541
VALUES( 'pl', 'language', 'pl', 'Polski');
542
543
INSERT INTO language_descriptions(subtag, type, lang, description)
544
VALUES( 'pl', 'language', 'en', 'Polish');
545
546
INSERT INTO language_descriptions(subtag, type, lang, description)
547
VALUES( 'pl', 'language', 'fr', 'Polonais');
548
549
INSERT INTO language_descriptions(subtag, type, lang, description)
550
VALUES( 'pl', 'language', 'de', 'Polnisch');
551
552
-- Portuguese
553
INSERT INTO language_subtag_registry( subtag, type, description, added)
554
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
555
556
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
557
VALUES( 'pt','por');
558
559
INSERT INTO language_descriptions(subtag, type, lang, description)
560
VALUES( 'pt', 'language', 'pt', 'Português');
561
562
INSERT INTO language_descriptions(subtag, type, lang, description)
563
VALUES( 'pt', 'language', 'en', 'Portuguese');
564
565
INSERT INTO language_descriptions(subtag, type, lang, description)
566
VALUES( 'pt', 'language', 'fr', 'Portugais');
567
568
INSERT INTO language_descriptions(subtag, type, lang, description)
569
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
570
571
-- Romanian
572
INSERT INTO language_subtag_registry( subtag, type, description, added)
573
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
574
575
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
576
VALUES( 'ro','rum');
577
578
INSERT INTO language_descriptions(subtag, type, lang, description)
579
VALUES( 'ro', 'language', 'ro', 'Română');
580
581
INSERT INTO language_descriptions(subtag, type, lang, description)
582
VALUES( 'ro', 'language', 'en', 'Romanian');
583
584
INSERT INTO language_descriptions(subtag, type, lang, description)
585
VALUES( 'ro', 'language', 'fr', 'Roumain');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'ro', 'language', 'de', 'Rumänisch');
589
590
-- Russian
591
INSERT INTO language_subtag_registry( subtag, type, description, added)
592
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
593
594
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
595
VALUES( 'ru','rus');
596
597
INSERT INTO language_descriptions(subtag, type, lang, description)
598
VALUES( 'ru', 'language', 'ru', 'Русский');
599
600
INSERT INTO language_descriptions(subtag, type, lang, description)
601
VALUES( 'ru', 'language', 'en', 'Russian');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'ru', 'language', 'fr', 'Russe');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'ru', 'language', 'de', 'Russisch');
608
609
-- Serbian
610
INSERT INTO language_subtag_registry( subtag, type, description, added)
611
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
612
613
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
614
VALUES( 'sr','srp');
615
616
INSERT INTO language_descriptions(subtag, type, lang, description)
617
VALUES( 'sr', 'language', 'sr', 'српски');
618
619
INSERT INTO language_descriptions(subtag, type, lang, description)
620
VALUES( 'sr', 'language', 'en', 'Serbian');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'sr', 'language', 'fr', 'Serbe');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'sr', 'language', 'de', 'Serbisch');
627
628
-- Spanish, Castilian
629
INSERT INTO language_subtag_registry( subtag, type, description, added)
630
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
631
632
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
633
VALUES( 'es','spa');
634
635
INSERT INTO language_descriptions(subtag, type, lang, description)
636
VALUES( 'es', 'language', 'es', 'Español');
637
638
INSERT INTO language_descriptions(subtag, type, lang, description)
639
VALUES( 'es', 'language', 'en', 'Spanish');
640
641
INSERT INTO language_descriptions(subtag, type, lang, description)
642
VALUES( 'es', 'language', 'fr', 'Espagnol');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES( 'es', 'language', 'de', 'Spanisch');
646
647
-- Spanish, Catalan
648
INSERT INTO language_subtag_registry( subtag, type, description, added)
649
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
650
651
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
652
VALUES( 'ca','cat');
653
654
INSERT INTO language_descriptions(subtag, type, lang, description)
655
VALUES( 'ca', 'language', 'es', 'Catalán');
656
657
INSERT INTO language_descriptions(subtag, type, lang, description)
658
VALUES( 'ca', 'language', 'en', 'Catalan');
659
660
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES( 'ca', 'language', 'fr', 'Catalan');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'ca', 'language', 'ca', 'Català');
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'ca', 'language', 'de', 'Katalanisch');
668
669
-- Swedish
670
INSERT INTO language_subtag_registry( subtag, type, description, added)
671
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
672
673
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
674
VALUES( 'sv','swe');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES( 'sv', 'language', 'sv', 'Svenska');
678
679
INSERT INTO language_descriptions(subtag, type, lang, description)
680
VALUES( 'sv', 'language', 'en', 'Swedish');   
681
682
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES( 'sv', 'language', 'fr', 'Suédois');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'sv', 'language', 'de', 'Schwedisch');
687
688
-- Tetum
689
INSERT INTO language_subtag_registry( subtag, type, description, added)
690
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
691
692
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
693
VALUES( 'tet','tet');
694
695
INSERT INTO language_descriptions(subtag, type, lang, description)
696
VALUES( 'tet', 'language', 'tet', 'tetun');
697
698
INSERT INTO language_descriptions(subtag, type, lang, description)
699
VALUES( 'tet', 'language', 'en', 'Tetum');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'tet', 'language', 'fr', 'Tétoum');
703
704
INSERT INTO language_descriptions(subtag, type, lang, description)
705
VALUES( 'tet', 'language', 'de', 'Tetum');
706
707
-- Thai
708
INSERT INTO language_subtag_registry( subtag, type, description, added)
709
VALUES ( 'th', 'language', 'Thai','2005-10-16');
710
711
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
712
VALUES( 'th','tha');
713
714
INSERT INTO language_descriptions(subtag, type, lang, description)
715
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
716
717
INSERT INTO language_descriptions(subtag, type, lang, description)
718
VALUES( 'th', 'language', 'en', 'Thai');   
719
720
INSERT INTO language_descriptions(subtag, type, lang, description)
721
VALUES( 'th', 'language', 'fr', 'Thaï');
722
723
INSERT INTO language_descriptions(subtag, type, lang, description)
724
VALUES( 'th', 'language', 'de', 'Thailändisch');
725
726
-- Turkish
727
INSERT INTO language_subtag_registry( subtag, type, description, added)
728
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
729
730
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
731
VALUES( 'tr','tur');
732
733
INSERT INTO language_descriptions(subtag, type, lang, description)
734
VALUES( 'tr', 'language', 'tr', 'Türkçe');
735
736
INSERT INTO language_descriptions(subtag, type, lang, description)
737
VALUES( 'tr', 'language', 'en', 'Turkish');   
738
739
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES( 'tr', 'language', 'fr', 'Turc');
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'tr', 'language', 'de', 'Türkisch');
744
745
-- Ukranian
746
INSERT INTO language_subtag_registry( subtag, type, description, added)
747
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
748
749
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
750
VALUES( 'uk','ukr');
751
752
INSERT INTO language_descriptions(subtag, type, lang, description)
753
VALUES( 'uk', 'language', 'uk', 'Українська');
754
755
INSERT INTO language_descriptions(subtag, type, lang, description)
756
VALUES( 'uk', 'language', 'en', 'Ukranian');
757
758
INSERT INTO language_descriptions(subtag, type, lang, description)
759
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
763
764
-- Urdu
765
INSERT INTO language_subtag_registry( subtag, type, description, added)
766
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
767
768
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
769
VALUES( 'ur','urd');
770
771
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'ur', 'language', 'en', 'Urdu');
773
774
INSERT INTO language_descriptions(subtag, type, lang, description)
775
VALUES( 'ur', 'language', 'ur', 'اردو');
776
777
INSERT INTO language_descriptions(subtag, type, lang, description)
778
VALUES( 'ur', 'language', 'fr', 'Ourdou');
779
780
INSERT INTO language_descriptions(subtag, type, lang, description)
781
VALUES( 'ur', 'language', 'de', 'Urdu');
782
783
-- SCRIPTS
784
-- Arabic
785
INSERT INTO language_subtag_registry( subtag, type, description, added)
786
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
787
788
INSERT INTO language_descriptions(subtag, type, lang, description)
789
VALUES ( 'Arab','script', 'Arab', 'العربية');
790
791
INSERT INTO language_descriptions(subtag, type, lang, description)
792
VALUES( 'Arab', 'script','en', 'Arabic');
793
794
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES( 'Arab', 'script','fr', 'Arabic');
796
797
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'Arab', 'script', 'de', 'Arabisch');
799
800
-- Cyrillic
801
INSERT INTO language_subtag_registry( subtag, type, description, added)
802
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
803
804
INSERT INTO language_descriptions(subtag, type, lang, description)
805
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
806
807
INSERT INTO language_descriptions(subtag, type, lang, description)
808
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
809
810
INSERT INTO language_descriptions(subtag, type, lang, description)
811
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
812
813
INSERT INTO language_descriptions(subtag, type, lang, description)
814
VALUES( 'Cyrl', 'script', 'de', 'Kyrillisch');
815
816
817
-- Greek
818
INSERT INTO language_subtag_registry( subtag, type, description, added)
819
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
820
821
INSERT INTO language_descriptions(subtag, type, lang, description)
822
VALUES ( 'Grek', 'script', 'Grek', '????');
823
824
INSERT INTO language_descriptions(subtag, type, lang, description)
825
VALUES( 'Grek', 'script', 'en', 'Greek');
826
827
INSERT INTO language_descriptions(subtag, type, lang, description)
828
VALUES( 'Grek', 'script', 'fr', 'Greek');
829
830
INSERT INTO language_descriptions(subtag, type, lang, description)
831
VALUES( 'Grek', 'script', 'de', 'Griechisch');
832
833
834
-- Han - Simplified
835
INSERT INTO language_subtag_registry( subtag, type, description, added)
836
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
837
838
INSERT INTO language_descriptions(subtag, type, lang, description)
839
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
840
841
INSERT INTO language_descriptions(subtag, type, lang, description)
842
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
843
844
INSERT INTO language_descriptions(subtag, type, lang, description)
845
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
846
847
INSERT INTO language_descriptions(subtag, type, lang, description)
848
VALUES( 'Hans', 'script', 'de', 'Han (Vereinfachte Variante)');
849
850
851
-- Han - Traditional
852
INSERT INTO language_subtag_registry( subtag, type, description, added)
853
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
854
855
INSERT INTO language_descriptions(subtag, type, lang, description)
856
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
857
858
INSERT INTO language_descriptions(subtag, type, lang, description)
859
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
860
861
INSERT INTO language_descriptions(subtag, type, lang, description)
862
VALUES( 'Hant', 'script', 'de', 'Han (Traditionelle Variante)');
863
864
-- Hebrew
865
INSERT INTO language_subtag_registry( subtag, type, description, added)
866
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
867
868
INSERT INTO language_descriptions(subtag, type, lang, description)
869
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
870
871
INSERT INTO language_descriptions(subtag, type, lang, description)
872
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
873
874
INSERT INTO language_descriptions(subtag, type, lang, description)
875
VALUES( 'Hebr', 'script', 'de', 'Hebräisch');
876
877
-- Lao
878
INSERT INTO language_subtag_registry( subtag, type, description, added)
879
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
880
881
INSERT INTO language_descriptions(subtag, type, lang, description)
882
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
883
884
INSERT INTO language_descriptions(subtag, type, lang, description)
885
VALUES( 'Laoo', 'script', 'en', 'Lao');
886
887
INSERT INTO language_descriptions(subtag, type, lang, description)
888
VALUES( 'Laoo', 'script', 'de', 'Laotisch');
889
890
-- Croatian
891
INSERT INTO language_subtag_registry( subtag, type, description, added)
892
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
893
894
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
895
VALUES( 'hr','hrv');
896
897
INSERT INTO language_descriptions(subtag, type, lang, description)
898
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
899
900
INSERT INTO language_descriptions(subtag, type, lang, description)
901
VALUES( 'hr', 'language', 'en', 'Croatian');
902
903
INSERT INTO language_descriptions(subtag, type, lang, description)
904
VALUES( 'hr', 'language', 'fr', 'Croate');
905
906
INSERT INTO language_descriptions(subtag, type, lang, description)
907
VALUES( 'hr', 'language', 'de', 'Kroatisch');
908
909
910
-- REGIONS
911
-- Canada
912
INSERT INTO language_subtag_registry( subtag, type, description, added)
913
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
914
915
INSERT INTO language_descriptions(subtag, type, lang, description)
916
VALUES( 'CA', 'region', 'en', 'Canada');
917
918
-- Denmark
919
INSERT INTO language_subtag_registry( subtag, type, description, added)
920
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
921
922
INSERT INTO language_descriptions(subtag, type, lang, description)
923
VALUES( 'DK', 'region', 'dk', 'Danmark');
924
925
-- France
926
INSERT INTO language_subtag_registry( subtag, type, description, added)
927
VALUES ( 'FR', 'region', 'France','2005-10-16');
928
929
INSERT INTO language_descriptions(subtag, type, lang, description)
930
VALUES ( 'FR', 'region', 'fr', 'France');
931
932
INSERT INTO language_descriptions(subtag, type, lang, description)
933
VALUES( 'FR', 'region', 'en', 'France');
934
935
-- New Zealand
936
INSERT INTO language_subtag_registry( subtag, type, description, added)
937
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
938
939
INSERT INTO language_descriptions(subtag, type, lang, description)
940
VALUES( 'NZ', 'region', 'en', 'New Zealand');
941
942
-- United Kingdom
943
INSERT INTO language_subtag_registry( subtag, type, description, added)
944
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
945
946
INSERT INTO language_descriptions(subtag, type, lang, description)
947
VALUES( 'GB', 'region', 'en', 'United Kingdom');
948
949
-- United States
950
INSERT INTO language_subtag_registry( subtag, type, description, added)
951
VALUES ( 'US', 'region', 'United States','2005-10-16');
952
953
INSERT INTO language_descriptions(subtag, type, lang, description)
954
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/de-DE/mandatory/subtag_registry.txt (-4 lines)
Lines 1-4 Link Here
1
I18N-Unterstützung in Koha
2
Erweiterung für bidirektionale Schriften, Arabisch und Hebräisch, 
3
Standardmappings zwischen Schrift- und Sprachcodes,
4
weitere Spracherweiterungen
(-)a/installer/data/mysql/es-ES/mandatory/subtag_registry.sql (-798 lines)
Lines 1-798 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', 'العربية');
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
-- Armenian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'hy','arm');
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES( 'hy', 'language', 'en', 'Armenian');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'fr', 'Armenian');
81
82
-- Bulgarian
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
85
86
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
87
VALUES( 'bg','bul');
88
89
INSERT INTO language_descriptions(subtag, type, lang, description)
90
VALUES ( 'bg', 'language', 'bg', 'Български');
91
92
INSERT INTO language_descriptions(subtag, type, lang, description)
93
VALUES( 'bg', 'language', 'en', 'Bulgarian');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'bg', 'language', 'fr', 'Bulgare');
97
98
-- Chinese
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
101
102
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
103
VALUES( 'zh','chi');
104
105
INSERT INTO language_descriptions(subtag, type, lang, description)
106
VALUES ( 'zh', 'language', 'zh', '中文');
107
108
INSERT INTO language_descriptions(subtag, type, lang, description)
109
VALUES( 'zh', 'language', 'en', 'Chinese');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'zh', 'language', 'fr', 'Chinois');
113
114
-- Czech
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
117
118
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
119
VALUES( 'cs','cze');
120
121
INSERT INTO language_descriptions(subtag, type, lang, description)
122
VALUES ( 'cs', 'language', 'cs', 'čeština');
123
124
INSERT INTO language_descriptions(subtag, type, lang, description)
125
VALUES( 'cs', 'language', 'en', 'Czech');
126
127
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'cs', 'language', 'fr', 'Tchèque');
129
130
-- Danish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
133
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
135
VALUES( 'da','dan');
136
137
INSERT INTO language_descriptions(subtag, type, lang, description)
138
VALUES ( 'da', 'language', 'da', 'Dansk');
139
140
INSERT INTO language_descriptions(subtag, type, lang, description)
141
VALUES( 'da', 'language', 'en', 'Danish');
142
143
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'da', 'language', 'fr', 'Danois');
145
146
-- Dutch, Flemish
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
149
150
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
151
VALUES( 'nl','dut');
152
153
INSERT INTO language_descriptions(subtag, type, lang, description)
154
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES( 'nl', 'language', 'en', 'Dutch');
158
159
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
161
162
-- English
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES( 'en','eng');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'en', 'language', 'en', 'English');
171
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
174
175
-- Finnish
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
178
179
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
180
VALUES( 'fi','fin');
181
182
INSERT INTO language_descriptions(subtag, type, lang, description)
183
VALUES( 'fi', 'language', 'fi', 'suomi');
184
185
INSERT INTO language_descriptions(subtag, type, lang, description)
186
VALUES( 'fi', 'language', 'en', 'Finnish');
187
188
-- French
189
INSERT INTO language_subtag_registry( subtag, type, description, added)
190
VALUES ( 'fr', 'language', 'French','2005-10-16' );
191
192
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
193
VALUES( 'fr','fre');
194
195
INSERT INTO language_descriptions(subtag, type, lang, description)
196
VALUES( 'fr', 'language', 'en', 'French');
197
198
INSERT INTO language_descriptions(subtag, type, lang, description)
199
VALUES( 'fr', 'language', 'fr', 'Français');
200
201
-- INSERT INTO language_descriptions(subtag, type, lang, description)
202
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
203
204
-- Lao
205
INSERT INTO language_subtag_registry( subtag, type, description, added)
206
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
207
208
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
209
VALUES( 'lo','lao');
210
211
INSERT INTO language_descriptions(subtag, type, lang, description)
212
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
213
214
INSERT INTO language_descriptions(subtag, type, lang, description)
215
VALUES( 'lo', 'language', 'en', 'Lao');
216
217
-- German
218
INSERT INTO language_subtag_registry( subtag, type, description, added)
219
VALUES ( 'de', 'language', 'German','2005-10-16' );
220
221
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
222
VALUES( 'de','ger');
223
224
INSERT INTO language_descriptions(subtag, type, lang, description)
225
VALUES( 'de', 'language', 'de', 'Deutsch');
226
227
INSERT INTO language_descriptions(subtag, type, lang, description)
228
VALUES( 'de', 'language', 'en', 'German');
229
230
INSERT INTO language_descriptions(subtag, type, lang, description)
231
VALUES( 'de', 'language', 'fr', 'Allemand');
232
233
-- Greek
234
INSERT INTO language_subtag_registry( subtag, type, description, added)
235
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
236
237
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
238
VALUES( 'el','gre');
239
240
INSERT INTO language_descriptions(subtag, type, lang, description)
241
VALUES( 'el', 'language', 'el', 'ελληνικά');
242
243
INSERT INTO language_descriptions(subtag, type, lang, description)
244
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
245
246
INSERT INTO language_descriptions(subtag, type, lang, description)
247
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
248
249
-- Hebrew
250
INSERT INTO language_subtag_registry( subtag, type, description, added)
251
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
252
253
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
254
VALUES( 'he','heb');
255
256
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'he', 'language', 'he', 'עברית');
258
259
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'he', 'language', 'en', 'Hebrew');
261
262
INSERT INTO language_descriptions(subtag, type, lang, description)
263
VALUES( 'he', 'language', 'fr', 'Hébreu');
264
265
-- Hindi
266
INSERT INTO language_subtag_registry( subtag, type, description, added)
267
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
268
269
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
270
VALUES( 'hi','hin');
271
272
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
274
275
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'hi', 'language', 'en', 'Hindi');
277
278
INSERT INTO language_descriptions(subtag, type, lang, description)
279
VALUES( 'hi', 'language', 'fr', 'Hindi');
280
281
-- Hungarian
282
INSERT INTO language_subtag_registry( subtag, type, description, added)
283
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
284
285
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
286
VALUES( 'hu','hun');
287
288
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'hu', 'language', 'hu', 'Magyar');
290
291
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'hu', 'language', 'en', 'Hungarian');
293
294
INSERT INTO language_descriptions(subtag, type, lang, description)
295
VALUES( 'hu', 'language', 'fr', 'Hongrois');
296
297
-- Indonesian
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
299
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
300
301
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
302
VALUES( 'id','ind');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
306
307
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'id', 'language', 'en', 'Indonesian');
309
310
INSERT INTO language_descriptions(subtag, type, lang, description)
311
VALUES( 'id', 'language', 'fr', 'Indonésien');
312
313
-- Italian
314
INSERT INTO language_subtag_registry( subtag, type, description, added)
315
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
316
317
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
318
VALUES( 'it','ita');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'it', 'language', 'it', 'Italiano');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'it', 'language', 'en', 'Italian');
325
326
INSERT INTO language_descriptions(subtag, type, lang, description)
327
VALUES( 'it', 'language', 'fr', 'Italien');
328
329
-- Japanese
330
INSERT INTO language_subtag_registry( subtag, type, description, added)
331
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
332
333
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
334
VALUES( 'ja','jpn');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'ja', 'language', 'ja', '日本語');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'ja', 'language', 'en', 'Japanese');
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'ja', 'language', 'fr', 'Japonais');
344
345
-- Korean
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
347
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
348
349
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
350
VALUES( 'ko','kor');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'ko', 'language', 'ko', '한국어');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'ko', 'language', 'en', 'Korean');
357
358
INSERT INTO language_descriptions(subtag, type, lang, description)
359
VALUES( 'ko', 'language', 'fr', 'Coréen');
360
361
-- Latin
362
INSERT INTO language_subtag_registry( subtag, type, description, added)
363
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
364
365
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
366
VALUES( 'la','lat');
367
368
INSERT INTO language_descriptions(subtag, type, lang, description)
369
VALUES( 'la', 'language', 'la', 'Latina');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'la', 'language', 'en', 'Latin');
373
374
INSERT INTO language_descriptions(subtag, type, lang, description)
375
VALUES( 'la', 'language', 'fr', 'Latin');
376
377
-- Galician
378
379
INSERT INTO language_subtag_registry( subtag, type, description, added)
380
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
381
382
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
383
VALUES( 'gl','glg');
384
385
INSERT INTO language_descriptions(subtag, type, lang, description)
386
VALUES( 'gl', 'language', 'gl', 'Galego');
387
388
INSERT INTO language_descriptions(subtag, type, lang, description)
389
VALUES( 'gl', 'language', 'en', 'Galician');
390
391
-- Norwegian (bokmål)
392
INSERT INTO language_subtag_registry( subtag, type, description, added)
393
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
394
395
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
396
VALUES( 'nb','nor');
397
398
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
399
VALUES( 'nb','nob');
400
401
INSERT INTO language_descriptions(subtag, type, lang, description)
402
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
403
404
INSERT INTO language_descriptions(subtag, type, lang, description)
405
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
406
407
INSERT INTO language_descriptions(subtag, type, lang, description)
408
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
409
410
-- Norwegian (nynorsk)
411
INSERT INTO language_subtag_registry( subtag, type, description, added)
412
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
413
414
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
415
VALUES( 'nn','nno');
416
417
INSERT INTO language_descriptions(subtag, type, lang, description)
418
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
419
420
INSERT INTO language_descriptions(subtag, type, lang, description)
421
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
422
423
INSERT INTO language_descriptions(subtag, type, lang, description)
424
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
425
426
INSERT INTO language_descriptions(subtag, type, lang, description)
427
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
428
429
-- Persian
430
INSERT INTO language_subtag_registry( subtag, type, description, added)
431
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
432
433
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
434
VALUES( 'fa','per');
435
436
INSERT INTO language_descriptions(subtag, type, lang, description)
437
VALUES( 'fa', 'language', 'fa', 'فارسى');
438
439
INSERT INTO language_descriptions(subtag, type, lang, description)
440
VALUES( 'fa', 'language', 'en', 'Persian');
441
442
INSERT INTO language_descriptions(subtag, type, lang, description)
443
VALUES( 'fa', 'language', 'fr', 'Persan');
444
445
-- Polish
446
INSERT INTO language_subtag_registry( subtag, type, description, added)
447
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
448
449
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
450
VALUES( 'pl','pol');
451
452
INSERT INTO language_descriptions(subtag, type, lang, description)
453
VALUES( 'pl', 'language', 'pl', 'Polski');
454
455
INSERT INTO language_descriptions(subtag, type, lang, description)
456
VALUES( 'pl', 'language', 'en', 'Polish');
457
458
INSERT INTO language_descriptions(subtag, type, lang, description)
459
VALUES( 'pl', 'language', 'fr', 'Polonais');
460
461
-- Portuguese
462
INSERT INTO language_subtag_registry( subtag, type, description, added)
463
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
464
465
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
466
VALUES( 'pt','por');
467
468
INSERT INTO language_descriptions(subtag, type, lang, description)
469
VALUES( 'pt', 'language', 'pt', 'Português');
470
471
INSERT INTO language_descriptions(subtag, type, lang, description)
472
VALUES( 'pt', 'language', 'en', 'Portuguese');
473
474
INSERT INTO language_descriptions(subtag, type, lang, description)
475
VALUES( 'pt', 'language', 'fr', 'Portugais');
476
477
-- Romanian
478
INSERT INTO language_subtag_registry( subtag, type, description, added)
479
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
480
481
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
482
VALUES( 'ro','rum');
483
484
INSERT INTO language_descriptions(subtag, type, lang, description)
485
VALUES( 'ro', 'language', 'ro', 'Română');
486
487
INSERT INTO language_descriptions(subtag, type, lang, description)
488
VALUES( 'ro', 'language', 'en', 'Romanian');
489
490
INSERT INTO language_descriptions(subtag, type, lang, description)
491
VALUES( 'ro', 'language', 'fr', 'Roumain');
492
493
-- Russian
494
INSERT INTO language_subtag_registry( subtag, type, description, added)
495
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
496
497
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
498
VALUES( 'ru','rus');
499
500
INSERT INTO language_descriptions(subtag, type, lang, description)
501
VALUES( 'ru', 'language', 'ru', 'Русский');
502
503
INSERT INTO language_descriptions(subtag, type, lang, description)
504
VALUES( 'ru', 'language', 'en', 'Russian');
505
506
INSERT INTO language_descriptions(subtag, type, lang, description)
507
VALUES( 'ru', 'language', 'fr', 'Russe');
508
509
-- Serbian
510
INSERT INTO language_subtag_registry( subtag, type, description, added)
511
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
512
513
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
514
VALUES( 'sr','srp');
515
516
INSERT INTO language_descriptions(subtag, type, lang, description)
517
VALUES( 'sr', 'language', 'sr', 'српски');
518
519
INSERT INTO language_descriptions(subtag, type, lang, description)
520
VALUES( 'sr', 'language', 'en', 'Serbian');
521
522
-- Spanish, Castilian
523
INSERT INTO language_subtag_registry( subtag, type, description, added)
524
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
525
526
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
527
VALUES( 'es','spa');
528
529
INSERT INTO language_descriptions(subtag, type, lang, description)
530
VALUES( 'es', 'language', 'es', 'Español');
531
532
INSERT INTO language_descriptions(subtag, type, lang, description)
533
VALUES( 'es', 'language', 'en', 'Spanish');
534
535
INSERT INTO language_descriptions(subtag, type, lang, description)
536
VALUES( 'es', 'language', 'fr', 'Espagnol');
537
538
-- Spanish, Catalan
539
INSERT INTO language_subtag_registry( subtag, type, description, added)
540
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
541
542
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
543
VALUES( 'ca','cat');
544
545
INSERT INTO language_descriptions(subtag, type, lang, description)
546
VALUES( 'ca', 'language', 'es', 'Catalán');
547
548
INSERT INTO language_descriptions(subtag, type, lang, description)
549
VALUES( 'ca', 'language', 'en', 'Catalan');
550
551
INSERT INTO language_descriptions(subtag, type, lang, description)
552
VALUES( 'ca', 'language', 'fr', 'Catalan');
553
554
INSERT INTO language_descriptions(subtag, type, lang, description)
555
VALUES( 'ca', 'language', 'ca', 'Català');
556
557
INSERT INTO language_descriptions(subtag, type, lang, description)
558
VALUES( 'ca', 'language', 'de', 'Katalanisch');
559
560
-- Swedish
561
INSERT INTO language_subtag_registry( subtag, type, description, added)
562
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
563
564
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
565
VALUES( 'sv','swe');
566
567
INSERT INTO language_descriptions(subtag, type, lang, description)
568
VALUES( 'sv', 'language', 'sv', 'Svenska');
569
570
INSERT INTO language_descriptions(subtag, type, lang, description)
571
VALUES( 'sv', 'language', 'en', 'Swedish');   
572
573
INSERT INTO language_descriptions(subtag, type, lang, description)
574
VALUES( 'sv', 'language', 'fr', 'Suédois');
575
576
-- Tetum
577
INSERT INTO language_subtag_registry( subtag, type, description, added)
578
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
579
580
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
581
VALUES( 'tet','tet');
582
583
INSERT INTO language_descriptions(subtag, type, lang, description)
584
VALUES( 'tet', 'language', 'tet', 'tetun');
585
586
INSERT INTO language_descriptions(subtag, type, lang, description)
587
VALUES( 'tet', 'language', 'en', 'Tetum');
588
589
-- Thai
590
INSERT INTO language_subtag_registry( subtag, type, description, added)
591
VALUES ( 'th', 'language', 'Thai','2005-10-16');
592
593
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
594
VALUES( 'th','tha');
595
596
INSERT INTO language_descriptions(subtag, type, lang, description)
597
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
598
599
INSERT INTO language_descriptions(subtag, type, lang, description)
600
VALUES( 'th', 'language', 'en', 'Thai');   
601
602
INSERT INTO language_descriptions(subtag, type, lang, description)
603
VALUES( 'th', 'language', 'fr', 'Thaï');
604
605
-- Turkish
606
INSERT INTO language_subtag_registry( subtag, type, description, added)
607
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
608
609
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
610
VALUES( 'tr','tur');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'tr', 'language', 'tr', 'Türkçe');
614
615
INSERT INTO language_descriptions(subtag, type, lang, description)
616
VALUES( 'tr', 'language', 'en', 'Turkish');   
617
618
INSERT INTO language_descriptions(subtag, type, lang, description)
619
VALUES( 'tr', 'language', 'fr', 'Turc');
620
621
622
-- Ukranian
623
INSERT INTO language_subtag_registry( subtag, type, description, added)
624
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
625
626
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
627
VALUES( 'uk','ukr');
628
629
INSERT INTO language_descriptions(subtag, type, lang, description)
630
VALUES( 'uk', 'language', 'uk', 'Українська');
631
632
INSERT INTO language_descriptions(subtag, type, lang, description)
633
VALUES( 'uk', 'language', 'en', 'Ukranian');
634
635
INSERT INTO language_descriptions(subtag, type, lang, description)
636
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
637
638
-- Urdu
639
INSERT INTO language_subtag_registry( subtag, type, description, added)
640
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
641
642
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
643
VALUES( 'ur','urd');
644
645
INSERT INTO language_descriptions(subtag, type, lang, description)
646
VALUES( 'ur', 'language', 'en', 'Urdu');
647
648
INSERT INTO language_descriptions(subtag, type, lang, description)
649
VALUES( 'ur', 'language', 'ur', 'اردو');
650
651
-- SCRIPTS
652
-- Arabic
653
INSERT INTO language_subtag_registry( subtag, type, description, added)
654
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
655
656
INSERT INTO language_descriptions(subtag, type, lang, description)
657
VALUES ( 'Arab','script', 'Arab', 'العربية');
658
659
INSERT INTO language_descriptions(subtag, type, lang, description)
660
VALUES( 'Arab', 'script','en', 'Arabic');
661
662
INSERT INTO language_descriptions(subtag, type, lang, description)
663
VALUES( 'Arab', 'script','fr', 'Arabic');
664
665
-- Cyrillic
666
INSERT INTO language_subtag_registry( subtag, type, description, added)
667
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
671
672
INSERT INTO language_descriptions(subtag, type, lang, description)
673
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
674
675
INSERT INTO language_descriptions(subtag, type, lang, description)
676
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
677
678
-- Greek
679
INSERT INTO language_subtag_registry( subtag, type, description, added)
680
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
681
682
INSERT INTO language_descriptions(subtag, type, lang, description)
683
VALUES ( 'Grek', 'script', 'Grek', '????');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES( 'Grek', 'script', 'en', 'Greek');
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'Grek', 'script', 'fr', 'Greek');
690
691
-- Han - Simplified
692
INSERT INTO language_subtag_registry( subtag, type, description, added)
693
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
694
695
INSERT INTO language_descriptions(subtag, type, lang, description)
696
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
697
698
INSERT INTO language_descriptions(subtag, type, lang, description)
699
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
703
704
-- Han - Traditional
705
INSERT INTO language_subtag_registry( subtag, type, description, added)
706
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
707
708
INSERT INTO language_descriptions(subtag, type, lang, description)
709
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
710
711
INSERT INTO language_descriptions(subtag, type, lang, description)
712
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
713
714
-- Hebrew
715
INSERT INTO language_subtag_registry( subtag, type, description, added)
716
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
717
718
INSERT INTO language_descriptions(subtag, type, lang, description)
719
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
720
721
INSERT INTO language_descriptions(subtag, type, lang, description)
722
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
723
724
-- Lao
725
INSERT INTO language_subtag_registry( subtag, type, description, added)
726
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
727
728
INSERT INTO language_descriptions(subtag, type, lang, description)
729
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
730
731
INSERT INTO language_descriptions(subtag, type, lang, description)
732
VALUES( 'Laoo', 'script', 'en', 'Lao');
733
734
-- Croatian
735
INSERT INTO language_subtag_registry( subtag, type, description, added)
736
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
737
738
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
739
VALUES( 'hr','hrv');
740
741
INSERT INTO language_descriptions(subtag, type, lang, description)
742
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
743
744
INSERT INTO language_descriptions(subtag, type, lang, description)
745
VALUES( 'hr', 'language', 'en', 'Croatian');
746
747
INSERT INTO language_descriptions(subtag, type, lang, description)
748
VALUES( 'hr', 'language', 'fr', 'Croate');
749
750
INSERT INTO language_descriptions(subtag, type, lang, description)
751
VALUES( 'hr', 'language', 'de', 'Kroatisch');
752
753
754
-- REGIONS
755
-- Canada
756
INSERT INTO language_subtag_registry( subtag, type, description, added)
757
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
758
759
INSERT INTO language_descriptions(subtag, type, lang, description)
760
VALUES( 'CA', 'region', 'en', 'Canada');
761
762
-- Denmark
763
INSERT INTO language_subtag_registry( subtag, type, description, added)
764
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
765
766
INSERT INTO language_descriptions(subtag, type, lang, description)
767
VALUES( 'DK', 'region', 'dk', 'Danmark');
768
769
-- France
770
INSERT INTO language_subtag_registry( subtag, type, description, added)
771
VALUES ( 'FR', 'region', 'France','2005-10-16');
772
773
INSERT INTO language_descriptions(subtag, type, lang, description)
774
VALUES ( 'FR', 'region', 'fr', 'France');
775
776
INSERT INTO language_descriptions(subtag, type, lang, description)
777
VALUES( 'FR', 'region', 'en', 'France');
778
779
-- New Zealand
780
INSERT INTO language_subtag_registry( subtag, type, description, added)
781
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
782
783
INSERT INTO language_descriptions(subtag, type, lang, description)
784
VALUES( 'NZ', 'region', 'en', 'New Zealand');
785
786
-- United Kingdom
787
INSERT INTO language_subtag_registry( subtag, type, description, added)
788
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
789
790
INSERT INTO language_descriptions(subtag, type, lang, description)
791
VALUES( 'GB', 'region', 'en', 'United Kingdom');
792
793
-- United States
794
INSERT INTO language_subtag_registry( subtag, type, description, added)
795
VALUES ( 'US', 'region', 'United States','2005-10-16');
796
797
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/es-ES/mandatory/subtag_registry.txt (-5 lines)
Lines 1-5 Link Here
1
Soporte I18N
2
3
BIDI Stuff, Arabic and Hebrew
4
Mapeos predeterminados entre subcódigos de script e idiomas
5
Extensión de idiomas
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.sql (-685 lines)
Lines 1-685 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', 'Français');
37
38
-- Theme (t)
39
INSERT INTO language_subtag_registry( subtag, type, description, added)
40
VALUES ( 'prog', 't', 'United Kingdom','2005-10-16');
41
42
INSERT INTO language_descriptions(subtag, type, lang, description)
43
VALUES( 'prog', 'i', 'en', 'Prog');
44
45
INSERT INTO language_descriptions(subtag, type, lang, description)
46
VALUES( 'prog', 'i', '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', 'العربية');
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
-- Bulgarian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'bg','bul');
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'bg', 'language', 'bg', 'Български');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES( 'bg', 'language', 'en', 'Bulgarian');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'bg', 'language', 'fr', 'Bulgare');
81
82
-- Chinese
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
85
86
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
87
VALUES( 'zh','chi');
88
89
INSERT INTO language_descriptions(subtag, type, lang, description)
90
VALUES ( 'zh', 'language', 'zh', '中文');
91
92
INSERT INTO language_descriptions(subtag, type, lang, description)
93
VALUES( 'zh', 'language', 'en', 'Chinese');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'zh', 'language', 'fr', 'Chinois');
97
98
-- Czech
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
101
102
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
103
VALUES( 'cs','cze');
104
105
INSERT INTO language_descriptions(subtag, type, lang, description)
106
VALUES ( 'cs', 'language', 'cs', 'čeština');
107
108
INSERT INTO language_descriptions(subtag, type, lang, description)
109
VALUES( 'cs', 'language', 'en', 'Czech');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'cs', 'language', 'fr', 'Tchèque');
113
114
-- Danish
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
117
118
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
119
VALUES( 'da','dan');
120
121
INSERT INTO language_descriptions(subtag, type, lang, description)
122
VALUES ( 'da', 'language', 'da', 'Dansk');
123
124
INSERT INTO language_descriptions(subtag, type, lang, description)
125
VALUES( 'da', 'language', 'en', 'Danish');
126
127
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'da', 'language', 'fr', 'Danois');
129
130
-- Dutch, Flemish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
133
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
135
VALUES( 'nl','dut');
136
137
INSERT INTO language_descriptions(subtag, type, lang, description)
138
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
139
140
INSERT INTO language_descriptions(subtag, type, lang, description)
141
VALUES( 'nl', 'language', 'en', 'Dutch');
142
143
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
145
146
-- English
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'en', 'language', 'English','2005-10-16' );
149
150
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
151
VALUES( 'en','en');
152
153
INSERT INTO language_descriptions(subtag, type, lang, description)
154
VALUES( 'en', 'language', 'en', 'English');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES( 'en', 'language', 'fr', 'Anglais');
158
159
-- French
160
INSERT INTO language_subtag_registry( subtag, type, description, added)
161
VALUES ( 'fr', 'language', 'French','2005-10-16' );
162
163
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
164
VALUES( 'fr','fr');
165
166
INSERT INTO language_descriptions(subtag, type, lang, description)
167
VALUES( 'fr', 'language', 'en', 'French');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'fr', 'language', 'fr', 'Français');
171
172
-- INSERT INTO language_descriptions(subtag, type, lang, description)
173
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
174
175
-- German
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'de', 'language', 'German','2005-10-16' );
178
179
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
180
VALUES( 'de','ger');
181
182
INSERT INTO language_descriptions(subtag, type, lang, description)
183
VALUES( 'de', 'language', 'de', 'Deutsch');
184
185
INSERT INTO language_descriptions(subtag, type, lang, description)
186
VALUES( 'de', 'language', 'en', 'German');
187
188
INSERT INTO language_descriptions(subtag, type, lang, description)
189
VALUES( 'de', 'language', 'fr', 'Allemand');
190
191
-- Greek
192
INSERT INTO language_subtag_registry( subtag, type, description, added)
193
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
194
195
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
196
VALUES( 'el','gre');
197
198
INSERT INTO language_descriptions(subtag, type, lang, description)
199
VALUES( 'el', 'language', 'el', 'ελληνικά');
200
201
INSERT INTO language_descriptions(subtag, type, lang, description)
202
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
203
204
INSERT INTO language_descriptions(subtag, type, lang, description)
205
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
206
207
-- Hebrew
208
INSERT INTO language_subtag_registry( subtag, type, description, added)
209
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
210
211
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
212
VALUES( 'he','heb');
213
214
INSERT INTO language_descriptions(subtag, type, lang, description)
215
VALUES( 'he', 'language', 'he', 'עברית');
216
217
INSERT INTO language_descriptions(subtag, type, lang, description)
218
VALUES( 'he', 'language', 'en', 'Hebrew');
219
220
INSERT INTO language_descriptions(subtag, type, lang, description)
221
VALUES( 'he', 'language', 'fr', 'Hébreu');
222
223
-- Hindi
224
INSERT INTO language_subtag_registry( subtag, type, description, added)
225
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
226
227
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
228
VALUES( 'hi','hin');
229
230
INSERT INTO language_descriptions(subtag, type, lang, description)
231
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
232
233
INSERT INTO language_descriptions(subtag, type, lang, description)
234
VALUES( 'hi', 'language', 'en', 'Hindi');
235
236
INSERT INTO language_descriptions(subtag, type, lang, description)
237
VALUES( 'hi', 'language', 'fr', 'Hindi');
238
239
-- Hungarian
240
INSERT INTO language_subtag_registry( subtag, type, description, added)
241
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
242
243
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
244
VALUES( 'hu','hun');
245
246
INSERT INTO language_descriptions(subtag, type, lang, description)
247
VALUES( 'hu', 'language', 'hu', 'Magyar');
248
249
INSERT INTO language_descriptions(subtag, type, lang, description)
250
VALUES( 'hu', 'language', 'en', 'Hungarian');
251
252
INSERT INTO language_descriptions(subtag, type, lang, description)
253
VALUES( 'hu', 'language', 'fr', 'Hongrois');
254
255
-- Indonesian
256
INSERT INTO language_subtag_registry( subtag, type, description, added)
257
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
258
259
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
260
VALUES( 'id','ind');
261
262
INSERT INTO language_descriptions(subtag, type, lang, description)
263
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
264
265
INSERT INTO language_descriptions(subtag, type, lang, description)
266
VALUES( 'id', 'language', 'en', 'Indonesian');
267
268
INSERT INTO language_descriptions(subtag, type, lang, description)
269
VALUES( 'id', 'language', 'fr', 'Indonésien');
270
271
-- Italian
272
INSERT INTO language_subtag_registry( subtag, type, description, added)
273
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
274
275
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
276
VALUES( 'it','ita');
277
278
INSERT INTO language_descriptions(subtag, type, lang, description)
279
VALUES( 'it', 'language', 'it', 'Italiano');
280
281
INSERT INTO language_descriptions(subtag, type, lang, description)
282
VALUES( 'it', 'language', 'en', 'Italian');
283
284
INSERT INTO language_descriptions(subtag, type, lang, description)
285
VALUES( 'it', 'language', 'fr', 'Italien');
286
287
-- Japanese
288
INSERT INTO language_subtag_registry( subtag, type, description, added)
289
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
290
291
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
292
VALUES( 'ja','jpn');
293
294
INSERT INTO language_descriptions(subtag, type, lang, description)
295
VALUES( 'ja', 'language', 'ja', '日本語');
296
297
INSERT INTO language_descriptions(subtag, type, lang, description)
298
VALUES( 'ja', 'language', 'en', 'Japanese');
299
300
INSERT INTO language_descriptions(subtag, type, lang, description)
301
VALUES( 'ja', 'language', 'fr', 'Japonais');
302
303
-- Korean
304
INSERT INTO language_subtag_registry( subtag, type, description, added)
305
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
306
307
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
308
VALUES( 'ko','kor');
309
310
INSERT INTO language_descriptions(subtag, type, lang, description)
311
VALUES( 'ko', 'language', 'ko', '한국어');
312
313
INSERT INTO language_descriptions(subtag, type, lang, description)
314
VALUES( 'ko', 'language', 'en', 'Korean');
315
316
INSERT INTO language_descriptions(subtag, type, lang, description)
317
VALUES( 'ko', 'language', 'fr', 'Coréen');
318
319
-- Latin
320
INSERT INTO language_subtag_registry( subtag, type, description, added)
321
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
322
323
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
324
VALUES( 'la','lat');
325
326
INSERT INTO language_descriptions(subtag, type, lang, description)
327
VALUES( 'la', 'language', 'la', 'Latina');
328
329
INSERT INTO language_descriptions(subtag, type, lang, description)
330
VALUES( 'la', 'language', 'en', 'Latin');
331
332
INSERT INTO language_descriptions(subtag, type, lang, description)
333
VALUES( 'la', 'language', 'fr', 'Latin');
334
335
-- Norwegian (bokmål)
336
INSERT INTO language_subtag_registry( subtag, type, description, added)
337
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
338
339
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
340
VALUES( 'nb','nor');
341
342
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
343
VALUES( 'nb','nob');
344
345
INSERT INTO language_descriptions(subtag, type, lang, description)
346
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
347
348
INSERT INTO language_descriptions(subtag, type, lang, description)
349
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
350
351
INSERT INTO language_descriptions(subtag, type, lang, description)
352
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
353
354
-- Norwegian (nynorsk)
355
INSERT INTO language_subtag_registry( subtag, type, description, added)
356
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
357
358
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
359
VALUES( 'nn','nno');
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
363
364
INSERT INTO language_descriptions(subtag, type, lang, description)
365
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
366
367
INSERT INTO language_descriptions(subtag, type, lang, description)
368
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
369
370
INSERT INTO language_descriptions(subtag, type, lang, description)
371
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
372
373
-- Persian
374
INSERT INTO language_subtag_registry( subtag, type, description, added)
375
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
376
377
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
378
VALUES( 'fa','per');
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'fa', 'language', 'fa', 'فارسى');
382
383
INSERT INTO language_descriptions(subtag, type, lang, description)
384
VALUES( 'fa', 'language', 'en', 'Persian');
385
386
INSERT INTO language_descriptions(subtag, type, lang, description)
387
VALUES( 'fa', 'language', 'fr', 'Persan');
388
389
-- Polish
390
INSERT INTO language_subtag_registry( subtag, type, description, added)
391
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
392
393
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
394
VALUES( 'pl','pol');
395
396
INSERT INTO language_descriptions(subtag, type, lang, description)
397
VALUES( 'pl', 'language', 'pl', 'Polski');
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'pl', 'language', 'en', 'Polish');
401
402
INSERT INTO language_descriptions(subtag, type, lang, description)
403
VALUES( 'pl', 'language', 'fr', 'Polonais');
404
405
-- Portuguese
406
INSERT INTO language_subtag_registry( subtag, type, description, added)
407
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
408
409
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
410
VALUES( 'pt','por');
411
412
INSERT INTO language_descriptions(subtag, type, lang, description)
413
VALUES( 'pt', 'language', 'pt', 'Português');
414
415
INSERT INTO language_descriptions(subtag, type, lang, description)
416
VALUES( 'pt', 'language', 'en', 'Portuguese');
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'pt', 'language', 'fr', 'Portugais');
420
421
-- Romanian
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
423
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
424
425
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
426
VALUES( 'ro','rum');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES( 'ro', 'language', 'ro', 'Română');
430
431
INSERT INTO language_descriptions(subtag, type, lang, description)
432
VALUES( 'ro', 'language', 'en', 'Romanian');
433
434
INSERT INTO language_descriptions(subtag, type, lang, description)
435
VALUES( 'ro', 'language', 'fr', 'Roumain');
436
437
-- Russian
438
INSERT INTO language_subtag_registry( subtag, type, description, added)
439
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
440
441
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
442
VALUES( 'ru','rus');
443
444
INSERT INTO language_descriptions(subtag, type, lang, description)
445
VALUES( 'ru', 'language', 'ru', 'Русский');
446
447
INSERT INTO language_descriptions(subtag, type, lang, description)
448
VALUES( 'ru', 'language', 'en', 'Russian');
449
450
INSERT INTO language_descriptions(subtag, type, lang, description)
451
VALUES( 'ru', 'language', 'fr', 'Russe');
452
453
-- Spanish, Castilian
454
INSERT INTO language_subtag_registry( subtag, type, description, added)
455
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
456
457
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
458
VALUES( 'es','spa');
459
460
INSERT INTO language_descriptions(subtag, type, lang, description)
461
VALUES( 'es', 'language', 'es', 'Español');
462
463
INSERT INTO language_descriptions(subtag, type, lang, description)
464
VALUES( 'es', 'language', 'en', 'Spanish');
465
466
INSERT INTO language_descriptions(subtag, type, lang, description)
467
VALUES( 'es', 'language', 'fr', 'Espagnol');
468
469
-- Spanish, Catalan
470
INSERT INTO language_subtag_registry( subtag, type, description, added)
471
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
472
473
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
474
VALUES( 'ca','cat');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'ca', 'language', 'es', 'Catalán');
478
479
INSERT INTO language_descriptions(subtag, type, lang, description)
480
VALUES( 'ca', 'language', 'en', 'Catalan');
481
482
INSERT INTO language_descriptions(subtag, type, lang, description)
483
VALUES( 'ca', 'language', 'fr', 'Catalan');
484
485
INSERT INTO language_descriptions(subtag, type, lang, description)
486
VALUES( 'ca', 'language', 'ca', 'Català');
487
488
INSERT INTO language_descriptions(subtag, type, lang, description)
489
VALUES( 'ca', 'language', 'de', 'Katalanisch');
490
491
-- Swedish
492
INSERT INTO language_subtag_registry( subtag, type, description, added)
493
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
494
495
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
496
VALUES( 'sv','swe');
497
498
INSERT INTO language_descriptions(subtag, type, lang, description)
499
VALUES( 'sv', 'language', 'sv', 'Svenska');
500
501
INSERT INTO language_descriptions(subtag, type, lang, description)
502
VALUES( 'sv', 'language', 'en', 'Swedish');   
503
504
INSERT INTO language_descriptions(subtag, type, lang, description)
505
VALUES( 'sv', 'language', 'fr', 'Suédois');
506
507
-- Thai
508
INSERT INTO language_subtag_registry( subtag, type, description, added)
509
VALUES ( 'th', 'language', 'Thai','2005-10-16');
510
511
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
512
VALUES( 'th','tha');
513
514
INSERT INTO language_descriptions(subtag, type, lang, description)
515
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
516
517
INSERT INTO language_descriptions(subtag, type, lang, description)
518
VALUES( 'th', 'language', 'en', 'Thai');   
519
520
INSERT INTO language_descriptions(subtag, type, lang, description)
521
VALUES( 'th', 'language', 'fr', 'Thaï');
522
523
-- Turkish
524
INSERT INTO language_subtag_registry( subtag, type, description, added)
525
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
526
527
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
528
VALUES( 'tr','tur');
529
530
INSERT INTO language_descriptions(subtag, type, lang, description)
531
VALUES( 'tr', 'language', 'tr', 'Türkçe');
532
533
INSERT INTO language_descriptions(subtag, type, lang, description)
534
VALUES( 'tr', 'language', 'en', 'Turkish');   
535
536
INSERT INTO language_descriptions(subtag, type, lang, description)
537
VALUES( 'tr', 'language', 'fr', 'Turc');
538
539
540
-- Ukranian
541
INSERT INTO language_subtag_registry( subtag, type, description, added)
542
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
543
544
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
545
VALUES( 'uk','ukr');
546
547
INSERT INTO language_descriptions(subtag, type, lang, description)
548
VALUES( 'uk', 'language', 'uk', 'Українська');
549
550
INSERT INTO language_descriptions(subtag, type, lang, description)
551
VALUES( 'uk', 'language', 'en', 'Ukranian');
552
553
INSERT INTO language_descriptions(subtag, type, lang, description)
554
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
555
556
-- Croatian
557
INSERT INTO language_subtag_registry( subtag, type, description, added)
558
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
559
560
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
561
VALUES( 'hr','hrv');
562
563
INSERT INTO language_descriptions(subtag, type, lang, description)
564
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
565
566
INSERT INTO language_descriptions(subtag, type, lang, description)
567
VALUES( 'hr', 'language', 'en', 'Croatian');
568
569
INSERT INTO language_descriptions(subtag, type, lang, description)
570
VALUES( 'hr', 'language', 'fr', 'Croate');
571
572
INSERT INTO language_descriptions(subtag, type, lang, description)
573
VALUES( 'hr', 'language', 'de', 'Kroatisch');
574
575
-- SCRIPTS
576
-- Arabic
577
INSERT INTO language_subtag_registry( subtag, type, description, added)
578
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
579
580
INSERT INTO language_descriptions(subtag, type, lang, description)
581
VALUES ( 'Arab','script', 'Arab', 'العربية');
582
583
INSERT INTO language_descriptions(subtag, type, lang, description)
584
VALUES( 'Arab', 'script','en', 'Arabic');
585
586
INSERT INTO language_descriptions(subtag, type, lang, description)
587
VALUES( 'Arab', 'script','fr', 'Arabic');
588
589
-- Cyrillic
590
INSERT INTO language_subtag_registry( subtag, type, description, added)
591
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
595
596
INSERT INTO language_descriptions(subtag, type, lang, description)
597
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
598
599
INSERT INTO language_descriptions(subtag, type, lang, description)
600
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
601
602
-- Greek
603
INSERT INTO language_subtag_registry( subtag, type, description, added)
604
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES ( 'Grek', 'script', 'Grek', '????');
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'Grek', 'script', 'en', 'Greek');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'Grek', 'script', 'fr', 'Greek');
614
615
-- Han - Simplified
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
617
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
618
619
INSERT INTO language_descriptions(subtag, type, lang, description)
620
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
627
628
-- Han - Traditional
629
INSERT INTO language_subtag_registry( subtag, type, description, added)
630
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
631
632
INSERT INTO language_descriptions(subtag, type, lang, description)
633
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
634
635
INSERT INTO language_descriptions(subtag, type, lang, description)
636
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
637
638
-- Hebrew
639
INSERT INTO language_subtag_registry( subtag, type, description, added)
640
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
641
642
INSERT INTO language_descriptions(subtag, type, lang, description)
643
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
644
645
INSERT INTO language_descriptions(subtag, type, lang, description)
646
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
647
648
-- REGIONS
649
-- Canada
650
INSERT INTO language_subtag_registry( subtag, type, description, added)
651
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
652
653
INSERT INTO language_descriptions(subtag, type, lang, description)
654
VALUES( 'CA', 'region', 'en', 'Canada');
655
656
-- France
657
INSERT INTO language_subtag_registry( subtag, type, description, added)
658
VALUES ( 'FR', 'region', 'France','2005-10-16');
659
660
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES ( 'FR', 'region', 'fr', 'France');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'FR', 'region', 'en', 'France');
665
666
-- New Zealand
667
INSERT INTO language_subtag_registry( subtag, type, description, added)
668
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
669
670
INSERT INTO language_descriptions(subtag, type, lang, description)
671
VALUES( 'NZ', 'region', 'en', 'New Zealand');
672
673
-- United Kingdom
674
INSERT INTO language_subtag_registry( subtag, type, description, added)
675
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
676
677
INSERT INTO language_descriptions(subtag, type, lang, description)
678
VALUES( 'GB', 'region', 'en', 'United Kingdom');
679
680
-- United States
681
INSERT INTO language_subtag_registry( subtag, type, description, added)
682
VALUES ( 'US', 'region', 'United States','2005-10-16');
683
684
INSERT INTO language_descriptions(subtag, type, lang, description)
685
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/subtag_registry.txt (-4 lines)
Lines 1-4 Link Here
1
Koha support international
2
3
BIDI , Arabe et Hébreu
4
Liens entre sous-codes de script et langue.
(-)a/installer/data/mysql/it-IT/necessari/subtag_registry.sql (-790 lines)
Lines 1-790 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
2
3
-- http://www.w3.org/International/articles/language-tags/
4
5
-- BIDI Stuff, Arabic and Hebrew
6
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
7
VALUES( 'Arab', 'rtl');
8
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
9
VALUES( 'Hebr', 'rtl');
10
11
-- Default mappings between script and language subcodes
12
INSERT INTO language_script_mapping(language_subtag,script_subtag)
13
VALUES( 'ar', 'Arab');
14
INSERT INTO language_script_mapping(language_subtag,script_subtag)
15
VALUES( 'he', 'Hebr');
16
17
-- EXTENSIONS
18
-- Interface (i)
19
-- SELECT * FROM language_subtag_registry WHERE type='i';
20
-- OPAC
21
INSERT INTO language_subtag_registry( subtag, type, description, added)
22
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
23
24
INSERT INTO language_descriptions(subtag, type, lang, description)
25
VALUES( 'opac', 'i', 'en', 'OPAC');
26
27
INSERT INTO language_descriptions(subtag, type, lang, description)
28
VALUES( 'opac', 'i', 'fr', 'OPAC');
29
30
-- Staff Client
31
INSERT INTO language_subtag_registry( subtag, type, description, added)
32
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
33
34
INSERT INTO language_descriptions(subtag, type, lang, description)
35
VALUES( 'intranet', 'i', 'en', 'Staff Client');
36
37
INSERT INTO language_descriptions(subtag, type, lang, description)
38
VALUES( 'intranet', 'i', 'fr', '????');
39
40
-- Theme (t)
41
INSERT INTO language_subtag_registry( subtag, type, description, added)
42
VALUES ( 'prog', 't', 'Prog','2005-10-16');
43
44
INSERT INTO language_descriptions(subtag, type, lang, description)
45
VALUES( 'prog', 't', 'en', 'Prog');
46
47
INSERT INTO language_descriptions(subtag, type, lang, description)
48
VALUES( 'prog', 't', 'fr', 'Prog');
49
50
-- LANGUAGES
51
52
-- Arabic
53
INSERT INTO language_subtag_registry( subtag, type, description, added)
54
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
55
56
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
57
VALUES( 'ar','ara');
58
59
INSERT INTO language_descriptions(subtag, type, lang, description)
60
VALUES ( 'ar', 'language', 'ar', 'العربية');
61
62
INSERT INTO language_descriptions(subtag, type, lang, description)
63
VALUES( 'ar', 'language', 'en', 'Arabic');
64
65
INSERT INTO language_descriptions(subtag, type, lang, description)
66
VALUES( 'ar', 'language', 'fr', 'Arabe');
67
68
-- Armenian
69
INSERT INTO language_subtag_registry( subtag, type, description, added)
70
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
71
72
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
73
VALUES( 'hy','hy');
74
75
INSERT INTO language_descriptions(subtag, type, lang, description)
76
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
77
78
INSERT INTO language_descriptions(subtag, type, lang, description)
79
VALUES( 'hy', 'language', 'en', 'Armenian');
80
81
INSERT INTO language_descriptions(subtag, type, lang, description)
82
VALUES( 'hy', 'language', 'fr', 'Armenian');
83
84
-- Bulgarian
85
INSERT INTO language_subtag_registry( subtag, type, description, added)
86
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
87
88
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
89
VALUES( 'bg','bul');
90
91
INSERT INTO language_descriptions(subtag, type, lang, description)
92
VALUES ( 'bg', 'language', 'bg', 'Български');
93
94
INSERT INTO language_descriptions(subtag, type, lang, description)
95
VALUES( 'bg', 'language', 'en', 'Bulgarian');
96
97
INSERT INTO language_descriptions(subtag, type, lang, description)
98
VALUES( 'bg', 'language', 'fr', 'Bulgare');
99
100
-- Chinese
101
INSERT INTO language_subtag_registry( subtag, type, description, added)
102
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
103
104
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
105
VALUES( 'zh','chi');
106
107
INSERT INTO language_descriptions(subtag, type, lang, description)
108
VALUES ( 'zh', 'language', 'zh', '中文');
109
110
INSERT INTO language_descriptions(subtag, type, lang, description)
111
VALUES( 'zh', 'language', 'en', 'Chinese');
112
113
INSERT INTO language_descriptions(subtag, type, lang, description)
114
VALUES( 'zh', 'language', 'fr', 'Chinois');
115
116
-- Czech
117
INSERT INTO language_subtag_registry( subtag, type, description, added)
118
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
119
120
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
121
VALUES( 'cs','cze');
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES ( 'cs', 'language', 'cs', 'čeština');
125
126
INSERT INTO language_descriptions(subtag, type, lang, description)
127
VALUES( 'cs', 'language', 'en', 'Czech');
128
129
INSERT INTO language_descriptions(subtag, type, lang, description)
130
VALUES( 'cs', 'language', 'fr', 'Tchèque');
131
132
-- Danish
133
INSERT INTO language_subtag_registry( subtag, type, description, added)
134
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
135
136
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
137
VALUES( 'da','dan');
138
139
INSERT INTO language_descriptions(subtag, type, lang, description)
140
VALUES ( 'da', 'language', 'da', 'Dansk');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES( 'da', 'language', 'en', 'Danish');
144
145
INSERT INTO language_descriptions(subtag, type, lang, description)
146
VALUES( 'da', 'language', 'fr', 'Danois');
147
148
-- Dutch, Flemish
149
INSERT INTO language_subtag_registry( subtag, type, description, added)
150
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
151
152
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
153
VALUES( 'nl','dut');
154
155
INSERT INTO language_descriptions(subtag, type, lang, description)
156
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
157
158
INSERT INTO language_descriptions(subtag, type, lang, description)
159
VALUES( 'nl', 'language', 'en', 'Dutch');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
163
164
-- English
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
166
VALUES ( 'en', 'language', 'English','2005-10-16' );
167
168
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
169
VALUES( 'en','en');
170
171
INSERT INTO language_descriptions(subtag, type, lang, description)
172
VALUES( 'en', 'language', 'en', 'English');
173
174
INSERT INTO language_descriptions(subtag, type, lang, description)
175
VALUES( 'en', 'language', 'fr', 'Anglais');
176
177
-- English
178
INSERT INTO language_subtag_registry( subtag, type, description, added)
179
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
180
181
INSERT INTO language_descriptions(subtag, type, lang, description)
182
VALUES( 'fi', 'language', 'fi', 'suomi');
183
184
INSERT INTO language_descriptions(subtag, type, lang, description)
185
VALUES( 'fi', 'language', 'en', 'Finnish');
186
187
-- French
188
INSERT INTO language_subtag_registry( subtag, type, description, added)
189
VALUES ( 'fr', 'language', 'French','2005-10-16' );
190
191
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
192
VALUES( 'fr','fr');
193
194
INSERT INTO language_descriptions(subtag, type, lang, description)
195
VALUES( 'fr', 'language', 'en', 'French');
196
197
INSERT INTO language_descriptions(subtag, type, lang, description)
198
VALUES( 'fr', 'language', 'fr', 'Français');
199
200
-- INSERT INTO language_descriptions(subtag, type, lang, description)
201
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
202
203
-- Lao
204
INSERT INTO language_subtag_registry( subtag, type, description, added)
205
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
206
207
-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
208
-- VALUES( 'lo','nor'); ???
209
210
INSERT INTO language_descriptions(subtag, type, lang, description)
211
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
212
213
INSERT INTO language_descriptions(subtag, type, lang, description)
214
VALUES( 'lo', 'language', 'en', 'Lao');
215
216
-- German
217
INSERT INTO language_subtag_registry( subtag, type, description, added)
218
VALUES ( 'de', 'language', 'German','2005-10-16' );
219
220
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
221
VALUES( 'de','ger');
222
223
INSERT INTO language_descriptions(subtag, type, lang, description)
224
VALUES( 'de', 'language', 'de', 'Deutsch');
225
226
INSERT INTO language_descriptions(subtag, type, lang, description)
227
VALUES( 'de', 'language', 'en', 'German');
228
229
INSERT INTO language_descriptions(subtag, type, lang, description)
230
VALUES( 'de', 'language', 'fr', 'Allemand');
231
232
-- Greek
233
INSERT INTO language_subtag_registry( subtag, type, description, added)
234
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
235
236
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
237
VALUES( 'el','gre');
238
239
INSERT INTO language_descriptions(subtag, type, lang, description)
240
VALUES( 'el', 'language', 'el', 'ελληνικά');
241
242
INSERT INTO language_descriptions(subtag, type, lang, description)
243
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
244
245
INSERT INTO language_descriptions(subtag, type, lang, description)
246
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
247
248
-- Hebrew
249
INSERT INTO language_subtag_registry( subtag, type, description, added)
250
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
251
252
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
253
VALUES( 'he','heb');
254
255
INSERT INTO language_descriptions(subtag, type, lang, description)
256
VALUES( 'he', 'language', 'he', 'עברית');
257
258
INSERT INTO language_descriptions(subtag, type, lang, description)
259
VALUES( 'he', 'language', 'en', 'Hebrew');
260
261
INSERT INTO language_descriptions(subtag, type, lang, description)
262
VALUES( 'he', 'language', 'fr', 'Hébreu');
263
264
-- Hindi
265
INSERT INTO language_subtag_registry( subtag, type, description, added)
266
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
267
268
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
269
VALUES( 'hi','hin');
270
271
INSERT INTO language_descriptions(subtag, type, lang, description)
272
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
273
274
INSERT INTO language_descriptions(subtag, type, lang, description)
275
VALUES( 'hi', 'language', 'en', 'Hindi');
276
277
INSERT INTO language_descriptions(subtag, type, lang, description)
278
VALUES( 'hi', 'language', 'fr', 'Hindi');
279
280
-- Hungarian
281
INSERT INTO language_subtag_registry( subtag, type, description, added)
282
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
283
284
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
285
VALUES( 'hu','hun');
286
287
INSERT INTO language_descriptions(subtag, type, lang, description)
288
VALUES( 'hu', 'language', 'hu', 'Magyar');
289
290
INSERT INTO language_descriptions(subtag, type, lang, description)
291
VALUES( 'hu', 'language', 'en', 'Hungarian');
292
293
INSERT INTO language_descriptions(subtag, type, lang, description)
294
VALUES( 'hu', 'language', 'fr', 'Hongrois');
295
296
-- Indonesian
297
INSERT INTO language_subtag_registry( subtag, type, description, added)
298
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
299
300
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
301
VALUES( 'id','ind');
302
303
INSERT INTO language_descriptions(subtag, type, lang, description)
304
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
305
306
INSERT INTO language_descriptions(subtag, type, lang, description)
307
VALUES( 'id', 'language', 'en', 'Indonesian');
308
309
INSERT INTO language_descriptions(subtag, type, lang, description)
310
VALUES( 'id', 'language', 'fr', 'Indonésien');
311
312
-- Italian
313
INSERT INTO language_subtag_registry( subtag, type, description, added)
314
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
315
316
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
317
VALUES( 'it','ita');
318
319
INSERT INTO language_descriptions(subtag, type, lang, description)
320
VALUES( 'it', 'language', 'it', 'Italiano');
321
322
INSERT INTO language_descriptions(subtag, type, lang, description)
323
VALUES( 'it', 'language', 'en', 'Italian');
324
325
INSERT INTO language_descriptions(subtag, type, lang, description)
326
VALUES( 'it', 'language', 'fr', 'Italien');
327
328
-- Japanese
329
INSERT INTO language_subtag_registry( subtag, type, description, added)
330
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
331
332
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
333
VALUES( 'ja','jpn');
334
335
INSERT INTO language_descriptions(subtag, type, lang, description)
336
VALUES( 'ja', 'language', 'ja', '日本語');
337
338
INSERT INTO language_descriptions(subtag, type, lang, description)
339
VALUES( 'ja', 'language', 'en', 'Japanese');
340
341
INSERT INTO language_descriptions(subtag, type, lang, description)
342
VALUES( 'ja', 'language', 'fr', 'Japonais');
343
344
-- Korean
345
INSERT INTO language_subtag_registry( subtag, type, description, added)
346
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
347
348
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
349
VALUES( 'ko','kor');
350
351
INSERT INTO language_descriptions(subtag, type, lang, description)
352
VALUES( 'ko', 'language', 'ko', '한국어');
353
354
INSERT INTO language_descriptions(subtag, type, lang, description)
355
VALUES( 'ko', 'language', 'en', 'Korean');
356
357
INSERT INTO language_descriptions(subtag, type, lang, description)
358
VALUES( 'ko', 'language', 'fr', 'Coréen');
359
360
-- Latin
361
INSERT INTO language_subtag_registry( subtag, type, description, added)
362
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
363
364
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
365
VALUES( 'la','lat');
366
367
INSERT INTO language_descriptions(subtag, type, lang, description)
368
VALUES( 'la', 'language', 'la', 'Latina');
369
370
INSERT INTO language_descriptions(subtag, type, lang, description)
371
VALUES( 'la', 'language', 'en', 'Latin');
372
373
INSERT INTO language_descriptions(subtag, type, lang, description)
374
VALUES( 'la', 'language', 'fr', 'Latin');
375
376
-- Galacian
377
378
INSERT INTO language_subtag_registry( subtag, type, description, added)
379
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
380
381
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
382
VALUES( 'gl','glg');
383
384
INSERT INTO language_descriptions(subtag, type, lang, description)
385
VALUES( 'gl', 'language', 'gl', 'Galego');
386
387
INSERT INTO language_descriptions(subtag, type, lang, description)
388
VALUES( 'gl', 'language', 'en', 'Galician');
389
390
-- Norwegian (bokmål)
391
INSERT INTO language_subtag_registry( subtag, type, description, added)
392
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
393
394
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
395
VALUES( 'nb','nor');
396
397
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
398
VALUES( 'nb','nob');
399
400
INSERT INTO language_descriptions(subtag, type, lang, description)
401
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
402
403
INSERT INTO language_descriptions(subtag, type, lang, description)
404
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
405
406
INSERT INTO language_descriptions(subtag, type, lang, description)
407
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
408
409
-- Norwegian (nynorsk)
410
INSERT INTO language_subtag_registry( subtag, type, description, added)
411
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
412
413
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
414
VALUES( 'nn','nno');
415
416
INSERT INTO language_descriptions(subtag, type, lang, description)
417
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
418
419
INSERT INTO language_descriptions(subtag, type, lang, description)
420
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
421
422
INSERT INTO language_descriptions(subtag, type, lang, description)
423
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
424
425
INSERT INTO language_descriptions(subtag, type, lang, description)
426
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
427
428
-- Persian
429
INSERT INTO language_subtag_registry( subtag, type, description, added)
430
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
431
432
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
433
VALUES( 'fa','per');
434
435
INSERT INTO language_descriptions(subtag, type, lang, description)
436
VALUES( 'fa', 'language', 'fa', 'فارسى');
437
438
INSERT INTO language_descriptions(subtag, type, lang, description)
439
VALUES( 'fa', 'language', 'en', 'Persian');
440
441
INSERT INTO language_descriptions(subtag, type, lang, description)
442
VALUES( 'fa', 'language', 'fr', 'Persan');
443
444
-- Polish
445
INSERT INTO language_subtag_registry( subtag, type, description, added)
446
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
447
448
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
449
VALUES( 'pl','pol');
450
451
INSERT INTO language_descriptions(subtag, type, lang, description)
452
VALUES( 'pl', 'language', 'pl', 'Polski');
453
454
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'pl', 'language', 'en', 'Polish');
456
457
INSERT INTO language_descriptions(subtag, type, lang, description)
458
VALUES( 'pl', 'language', 'fr', 'Polonais');
459
460
-- Portuguese
461
INSERT INTO language_subtag_registry( subtag, type, description, added)
462
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
463
464
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
465
VALUES( 'pt','por');
466
467
INSERT INTO language_descriptions(subtag, type, lang, description)
468
VALUES( 'pt', 'language', 'pt', 'Português');
469
470
INSERT INTO language_descriptions(subtag, type, lang, description)
471
VALUES( 'pt', 'language', 'en', 'Portuguese');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES( 'pt', 'language', 'fr', 'Portugais');
475
476
-- Romanian
477
INSERT INTO language_subtag_registry( subtag, type, description, added)
478
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
479
480
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
481
VALUES( 'ro','rum');
482
483
INSERT INTO language_descriptions(subtag, type, lang, description)
484
VALUES( 'ro', 'language', 'ro', 'Română');
485
486
INSERT INTO language_descriptions(subtag, type, lang, description)
487
VALUES( 'ro', 'language', 'en', 'Romanian');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'ro', 'language', 'fr', 'Roumain');
491
492
-- Russian
493
INSERT INTO language_subtag_registry( subtag, type, description, added)
494
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
495
496
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
497
VALUES( 'ru','rus');
498
499
INSERT INTO language_descriptions(subtag, type, lang, description)
500
VALUES( 'ru', 'language', 'ru', 'Русский');
501
502
INSERT INTO language_descriptions(subtag, type, lang, description)
503
VALUES( 'ru', 'language', 'en', 'Russian');
504
505
INSERT INTO language_descriptions(subtag, type, lang, description)
506
VALUES( 'ru', 'language', 'fr', 'Russe');
507
508
-- Serbian
509
INSERT INTO language_subtag_registry( subtag, type, description, added)
510
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
511
512
INSERT INTO language_descriptions(subtag, type, lang, description)
513
VALUES( 'sr', 'language', 'sr', 'српски');
514
515
INSERT INTO language_descriptions(subtag, type, lang, description)
516
VALUES( 'sr', 'language', 'en', 'Serbian');
517
518
-- Spanish, Castilian
519
INSERT INTO language_subtag_registry( subtag, type, description, added)
520
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
521
522
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
523
VALUES( 'es','spa');
524
525
INSERT INTO language_descriptions(subtag, type, lang, description)
526
VALUES( 'es', 'language', 'es', 'Español');
527
528
INSERT INTO language_descriptions(subtag, type, lang, description)
529
VALUES( 'es', 'language', 'en', 'Spanish');
530
531
INSERT INTO language_descriptions(subtag, type, lang, description)
532
VALUES( 'es', 'language', 'fr', 'Espagnol');
533
534
-- Spanish, Catalan
535
INSERT INTO language_subtag_registry( subtag, type, description, added)
536
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
537
538
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
539
VALUES( 'ca','cat');
540
541
INSERT INTO language_descriptions(subtag, type, lang, description)
542
VALUES( 'ca', 'language', 'es', 'Catalán');
543
544
INSERT INTO language_descriptions(subtag, type, lang, description)
545
VALUES( 'ca', 'language', 'en', 'Catalan');
546
547
INSERT INTO language_descriptions(subtag, type, lang, description)
548
VALUES( 'ca', 'language', 'fr', 'Catalan');
549
550
INSERT INTO language_descriptions(subtag, type, lang, description)
551
VALUES( 'ca', 'language', 'ca', 'Català');
552
553
INSERT INTO language_descriptions(subtag, type, lang, description)
554
VALUES( 'ca', 'language', 'de', 'Katalanisch');
555
556
-- Swedish
557
INSERT INTO language_subtag_registry( subtag, type, description, added)
558
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
559
560
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
561
VALUES( 'sv','swe');
562
563
INSERT INTO language_descriptions(subtag, type, lang, description)
564
VALUES( 'sv', 'language', 'sv', 'Svenska');
565
566
INSERT INTO language_descriptions(subtag, type, lang, description)
567
VALUES( 'sv', 'language', 'en', 'Swedish');   
568
569
INSERT INTO language_descriptions(subtag, type, lang, description)
570
VALUES( 'sv', 'language', 'fr', 'Suédois');
571
572
-- Tetum
573
INSERT INTO language_subtag_registry( subtag, type, description, added)
574
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
575
576
INSERT INTO language_descriptions(subtag, type, lang, description)
577
VALUES( 'tet', 'language', 'tet', 'tetun');
578
579
INSERT INTO language_descriptions(subtag, type, lang, description)
580
VALUES( 'tet', 'language', 'en', 'Tetum');
581
582
-- Thai
583
INSERT INTO language_subtag_registry( subtag, type, description, added)
584
VALUES ( 'th', 'language', 'Thai','2005-10-16');
585
586
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
587
VALUES( 'th','tha');
588
589
INSERT INTO language_descriptions(subtag, type, lang, description)
590
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
591
592
INSERT INTO language_descriptions(subtag, type, lang, description)
593
VALUES( 'th', 'language', 'en', 'Thai');   
594
595
INSERT INTO language_descriptions(subtag, type, lang, description)
596
VALUES( 'th', 'language', 'fr', 'Thaï');
597
598
-- Turkish
599
INSERT INTO language_subtag_registry( subtag, type, description, added)
600
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
601
602
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
603
VALUES( 'tr','tur');
604
605
INSERT INTO language_descriptions(subtag, type, lang, description)
606
VALUES( 'tr', 'language', 'tr', 'Türkçe');
607
608
INSERT INTO language_descriptions(subtag, type, lang, description)
609
VALUES( 'tr', 'language', 'en', 'Turkish');   
610
611
INSERT INTO language_descriptions(subtag, type, lang, description)
612
VALUES( 'tr', 'language', 'fr', 'Turc');
613
614
615
-- Ukranian
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
617
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
618
619
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
620
VALUES( 'uk','ukr');
621
622
INSERT INTO language_descriptions(subtag, type, lang, description)
623
VALUES( 'uk', 'language', 'uk', 'Українська');
624
625
INSERT INTO language_descriptions(subtag, type, lang, description)
626
VALUES( 'uk', 'language', 'en', 'Ukranian');
627
628
INSERT INTO language_descriptions(subtag, type, lang, description)
629
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
630
631
-- English
632
INSERT INTO language_subtag_registry( subtag, type, description, added)
633
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
634
635
INSERT INTO language_descriptions(subtag, type, lang, description)
636
VALUES( 'ur', 'language', 'en', 'Urdu');
637
638
INSERT INTO language_descriptions(subtag, type, lang, description)
639
VALUES( 'ur', 'language', 'ur', 'اردو');
640
641
-- SCRIPTS
642
-- Arabic
643
INSERT INTO language_subtag_registry( subtag, type, description, added)
644
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
645
646
INSERT INTO language_descriptions(subtag, type, lang, description)
647
VALUES ( 'Arab','script', 'Arab', 'العربية');
648
649
INSERT INTO language_descriptions(subtag, type, lang, description)
650
VALUES( 'Arab', 'script','en', 'Arabic');
651
652
INSERT INTO language_descriptions(subtag, type, lang, description)
653
VALUES( 'Arab', 'script','fr', 'Arabic');
654
655
-- Cyrillic
656
INSERT INTO language_subtag_registry( subtag, type, description, added)
657
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
658
659
INSERT INTO language_descriptions(subtag, type, lang, description)
660
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
661
662
INSERT INTO language_descriptions(subtag, type, lang, description)
663
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
664
665
INSERT INTO language_descriptions(subtag, type, lang, description)
666
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
667
668
-- Greek
669
INSERT INTO language_subtag_registry( subtag, type, description, added)
670
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
671
672
INSERT INTO language_descriptions(subtag, type, lang, description)
673
VALUES ( 'Grek', 'script', 'Grek', '????');
674
675
INSERT INTO language_descriptions(subtag, type, lang, description)
676
VALUES( 'Grek', 'script', 'en', 'Greek');
677
678
INSERT INTO language_descriptions(subtag, type, lang, description)
679
VALUES( 'Grek', 'script', 'fr', 'Greek');
680
681
-- Han - Simplified
682
INSERT INTO language_subtag_registry( subtag, type, description, added)
683
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
684
685
INSERT INTO language_descriptions(subtag, type, lang, description)
686
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
690
691
INSERT INTO language_descriptions(subtag, type, lang, description)
692
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
693
694
-- Han - Traditional
695
INSERT INTO language_subtag_registry( subtag, type, description, added)
696
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
697
698
INSERT INTO language_descriptions(subtag, type, lang, description)
699
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
700
701
INSERT INTO language_descriptions(subtag, type, lang, description)
702
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
703
704
-- Hebrew
705
INSERT INTO language_subtag_registry( subtag, type, description, added)
706
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
707
708
INSERT INTO language_descriptions(subtag, type, lang, description)
709
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
710
711
INSERT INTO language_descriptions(subtag, type, lang, description)
712
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
713
714
-- Lao
715
INSERT INTO language_subtag_registry( subtag, type, description, added)
716
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
717
718
INSERT INTO language_descriptions(subtag, type, lang, description)
719
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
720
721
INSERT INTO language_descriptions(subtag, type, lang, description)
722
VALUES( 'Laoo', 'script', 'en', 'Lao');
723
724
-- Croatian
725
INSERT INTO language_subtag_registry( subtag, type, description, added)
726
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
727
728
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
729
VALUES( 'hr','hrv');
730
731
INSERT INTO language_descriptions(subtag, type, lang, description)
732
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
733
734
INSERT INTO language_descriptions(subtag, type, lang, description)
735
VALUES( 'hr', 'language', 'en', 'Croatian');
736
737
INSERT INTO language_descriptions(subtag, type, lang, description)
738
VALUES( 'hr', 'language', 'fr', 'Croate');
739
740
INSERT INTO language_descriptions(subtag, type, lang, description)
741
VALUES( 'hr', 'language', 'de', 'Kroatisch');
742
743
744
-- REGIONS
745
-- Canada
746
INSERT INTO language_subtag_registry( subtag, type, description, added)
747
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
748
749
INSERT INTO language_descriptions(subtag, type, lang, description)
750
VALUES( 'CA', 'region', 'en', 'Canada');
751
752
-- Denmark
753
INSERT INTO language_subtag_registry( subtag, type, description, added)
754
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
755
756
INSERT INTO language_descriptions(subtag, type, lang, description)
757
VALUES( 'DK', 'region', 'dk', 'Danmark');
758
759
-- France
760
INSERT INTO language_subtag_registry( subtag, type, description, added)
761
VALUES ( 'FR', 'region', 'France','2005-10-16');
762
763
INSERT INTO language_descriptions(subtag, type, lang, description)
764
VALUES ( 'FR', 'region', 'fr', 'France');
765
766
INSERT INTO language_descriptions(subtag, type, lang, description)
767
VALUES( 'FR', 'region', 'en', 'France');
768
769
-- New Zealand
770
INSERT INTO language_subtag_registry( subtag, type, description, added)
771
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
772
773
INSERT INTO language_descriptions(subtag, type, lang, description)
774
VALUES( 'NZ', 'region', 'en', 'New Zealand');
775
776
-- United Kingdom
777
INSERT INTO language_subtag_registry( subtag, type, description, added)
778
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
779
780
INSERT INTO language_descriptions(subtag, type, lang, description)
781
VALUES( 'GB', 'region', 'en', 'United Kingdom');
782
783
-- United States
784
INSERT INTO language_subtag_registry( subtag, type, description, added)
785
VALUES ( 'US', 'region', 'United States','2005-10-16');
786
787
INSERT INTO language_descriptions(subtag, type, lang, description)
788
VALUES( 'US', 'region', 'en', 'United States');
789
790
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/it-IT/necessari/subtag_registry.txt (-5 lines)
Lines 1-5 Link Here
1
Supporto I18N di Koha
2
3
Gestione lingue scritte da destra (Arabo ed Ebraico).
4
Collegamenti predefinti tra alfabeti e codici di lingua ISO
5
Estensioni delle lingue
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.sql (-819 lines)
Lines 1-819 Link Here
1
-- 
2
-- Default classification sources and filing rules
3
-- for Koha.
4
--
5
-- Copyright (C) 2008 LibLime
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
-- http://www.w3.org/International/articles/language-tags/
23
24
-- BIDI Stuff, Arabic and Hebrew
25
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
26
VALUES( 'Arab', 'rtl');
27
INSERT INTO language_script_bidi(rfc4646_subtag,bidi)
28
VALUES( 'Hebr', 'rtl');
29
30
-- Default mappings between script and language subcodes
31
INSERT INTO language_script_mapping(language_subtag,script_subtag)
32
VALUES( 'ar', 'Arab');
33
INSERT INTO language_script_mapping(language_subtag,script_subtag)
34
VALUES( 'he', 'Hebr');
35
36
-- EXTENSIONS
37
-- Interface (i)
38
-- SELECT * FROM language_subtag_registry WHERE type='i';
39
-- OPAC
40
INSERT INTO language_subtag_registry( subtag, type, description, added)
41
VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
42
43
INSERT INTO language_descriptions(subtag, type, lang, description)
44
VALUES( 'opac', 'i', 'en', 'OPAC');
45
46
INSERT INTO language_descriptions(subtag, type, lang, description)
47
VALUES( 'opac', 'i', 'fr', 'OPAC');
48
49
-- Staff Client
50
INSERT INTO language_subtag_registry( subtag, type, description, added)
51
VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
52
53
INSERT INTO language_descriptions(subtag, type, lang, description)
54
VALUES( 'intranet', 'i', 'en', 'Staff Client');
55
56
INSERT INTO language_descriptions(subtag, type, lang, description)
57
VALUES( 'intranet', 'i', 'fr', '????');
58
59
-- Theme (t)
60
INSERT INTO language_subtag_registry( subtag, type, description, added)
61
VALUES ( 'prog', 't', 'Prog','2005-10-16');
62
63
INSERT INTO language_descriptions(subtag, type, lang, description)
64
VALUES( 'prog', 't', 'en', 'Prog');
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES( 'prog', 't', 'fr', 'Prog');
68
69
-- LANGUAGES
70
71
-- Arabic
72
INSERT INTO language_subtag_registry( subtag, type, description, added)
73
VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
74
75
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
76
VALUES( 'ar','ara');
77
78
INSERT INTO language_descriptions(subtag, type, lang, description)
79
VALUES ( 'ar', 'language', 'ar', 'العربية');
80
81
INSERT INTO language_descriptions(subtag, type, lang, description)
82
VALUES( 'ar', 'language', 'en', 'Arabic');
83
84
INSERT INTO language_descriptions(subtag, type, lang, description)
85
VALUES( 'ar', 'language', 'fr', 'Arabe');
86
87
-- Armenian
88
INSERT INTO language_subtag_registry( subtag, type, description, added)
89
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
90
91
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
92
VALUES( 'hy','arm');
93
94
INSERT INTO language_descriptions(subtag, type, lang, description)
95
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
96
97
INSERT INTO language_descriptions(subtag, type, lang, description)
98
VALUES( 'hy', 'language', 'en', 'Armenian');
99
100
INSERT INTO language_descriptions(subtag, type, lang, description)
101
VALUES( 'hy', 'language', 'fr', 'Armenian');
102
103
-- Bulgarian
104
INSERT INTO language_subtag_registry( subtag, type, description, added)
105
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
106
107
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
108
VALUES( 'bg','bul');
109
110
INSERT INTO language_descriptions(subtag, type, lang, description)
111
VALUES ( 'bg', 'language', 'bg', 'Български');
112
113
INSERT INTO language_descriptions(subtag, type, lang, description)
114
VALUES( 'bg', 'language', 'en', 'Bulgarian');
115
116
INSERT INTO language_descriptions(subtag, type, lang, description)
117
VALUES( 'bg', 'language', 'fr', 'Bulgare');
118
119
-- Chinese
120
INSERT INTO language_subtag_registry( subtag, type, description, added)
121
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
122
123
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
124
VALUES( 'zh','chi');
125
126
INSERT INTO language_descriptions(subtag, type, lang, description)
127
VALUES ( 'zh', 'language', 'zh', '中文');
128
129
INSERT INTO language_descriptions(subtag, type, lang, description)
130
VALUES( 'zh', 'language', 'en', 'Chinese');
131
132
INSERT INTO language_descriptions(subtag, type, lang, description)
133
VALUES( 'zh', 'language', 'fr', 'Chinois');
134
135
-- Czech
136
INSERT INTO language_subtag_registry( subtag, type, description, added)
137
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
138
139
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
140
VALUES( 'cs','cze');
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES ( 'cs', 'language', 'cs', 'čeština');
144
145
INSERT INTO language_descriptions(subtag, type, lang, description)
146
VALUES( 'cs', 'language', 'en', 'Czech');
147
148
INSERT INTO language_descriptions(subtag, type, lang, description)
149
VALUES( 'cs', 'language', 'fr', 'Tchèque');
150
151
-- Danish
152
INSERT INTO language_subtag_registry( subtag, type, description, added)
153
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
154
155
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
156
VALUES( 'da','dan');
157
158
INSERT INTO language_descriptions(subtag, type, lang, description)
159
VALUES ( 'da', 'language', 'da', 'Dansk');
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'da', 'language', 'en', 'Danish');
163
164
INSERT INTO language_descriptions(subtag, type, lang, description)
165
VALUES( 'da', 'language', 'fr', 'Danois');
166
167
-- Dutch, Flemish
168
INSERT INTO language_subtag_registry( subtag, type, description, added)
169
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
170
171
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
172
VALUES( 'nl','dut');
173
174
INSERT INTO language_descriptions(subtag, type, lang, description)
175
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
176
177
INSERT INTO language_descriptions(subtag, type, lang, description)
178
VALUES( 'nl', 'language', 'en', 'Dutch');
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
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
-- Finnish
197
INSERT INTO language_subtag_registry( subtag, type, description, added)
198
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
199
200
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
201
VALUES( 'fi','fin');
202
203
INSERT INTO language_descriptions(subtag, type, lang, description)
204
VALUES( 'fi', 'language', 'fi', 'suomi');
205
206
INSERT INTO language_descriptions(subtag, type, lang, description)
207
VALUES( 'fi', 'language', 'en', 'Finnish');
208
209
-- French
210
INSERT INTO language_subtag_registry( subtag, type, description, added)
211
VALUES ( 'fr', 'language', 'French','2005-10-16' );
212
213
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
214
VALUES( 'fr','fre');
215
216
INSERT INTO language_descriptions(subtag, type, lang, description)
217
VALUES( 'fr', 'language', 'en', 'French');
218
219
INSERT INTO language_descriptions(subtag, type, lang, description)
220
VALUES( 'fr', 'language', 'fr', 'Français');
221
222
-- INSERT INTO language_descriptions(subtag, type, lang, description)
223
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
224
225
-- Lao
226
INSERT INTO language_subtag_registry( subtag, type, description, added)
227
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
228
229
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
230
VALUES( 'lo','lao');
231
232
INSERT INTO language_descriptions(subtag, type, lang, description)
233
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
234
235
INSERT INTO language_descriptions(subtag, type, lang, description)
236
VALUES( 'lo', 'language', 'en', 'Lao');
237
238
-- German
239
INSERT INTO language_subtag_registry( subtag, type, description, added)
240
VALUES ( 'de', 'language', 'German','2005-10-16' );
241
242
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
243
VALUES( 'de','ger');
244
245
INSERT INTO language_descriptions(subtag, type, lang, description)
246
VALUES( 'de', 'language', 'de', 'Deutsch');
247
248
INSERT INTO language_descriptions(subtag, type, lang, description)
249
VALUES( 'de', 'language', 'en', 'German');
250
251
INSERT INTO language_descriptions(subtag, type, lang, description)
252
VALUES( 'de', 'language', 'fr', 'Allemand');
253
254
-- Greek
255
INSERT INTO language_subtag_registry( subtag, type, description, added)
256
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
257
258
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
259
VALUES( 'el','gre');
260
261
INSERT INTO language_descriptions(subtag, type, lang, description)
262
VALUES( 'el', 'language', 'el', 'ελληνικά');
263
264
INSERT INTO language_descriptions(subtag, type, lang, description)
265
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
266
267
INSERT INTO language_descriptions(subtag, type, lang, description)
268
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
269
270
-- Hebrew
271
INSERT INTO language_subtag_registry( subtag, type, description, added)
272
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
273
274
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
275
VALUES( 'he','heb');
276
277
INSERT INTO language_descriptions(subtag, type, lang, description)
278
VALUES( 'he', 'language', 'he', 'עברית');
279
280
INSERT INTO language_descriptions(subtag, type, lang, description)
281
VALUES( 'he', 'language', 'en', 'Hebrew');
282
283
INSERT INTO language_descriptions(subtag, type, lang, description)
284
VALUES( 'he', 'language', 'fr', 'Hébreu');
285
286
-- Hindi
287
INSERT INTO language_subtag_registry( subtag, type, description, added)
288
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
289
290
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
291
VALUES( 'hi','hin');
292
293
INSERT INTO language_descriptions(subtag, type, lang, description)
294
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
295
296
INSERT INTO language_descriptions(subtag, type, lang, description)
297
VALUES( 'hi', 'language', 'en', 'Hindi');
298
299
INSERT INTO language_descriptions(subtag, type, lang, description)
300
VALUES( 'hi', 'language', 'fr', 'Hindi');
301
302
-- Hungarian
303
INSERT INTO language_subtag_registry( subtag, type, description, added)
304
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
305
306
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
307
VALUES( 'hu','hun');
308
309
INSERT INTO language_descriptions(subtag, type, lang, description)
310
VALUES( 'hu', 'language', 'hu', 'Magyar');
311
312
INSERT INTO language_descriptions(subtag, type, lang, description)
313
VALUES( 'hu', 'language', 'en', 'Hungarian');
314
315
INSERT INTO language_descriptions(subtag, type, lang, description)
316
VALUES( 'hu', 'language', 'fr', 'Hongrois');
317
318
-- Indonesian
319
INSERT INTO language_subtag_registry( subtag, type, description, added)
320
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
321
322
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
323
VALUES( 'id','ind');
324
325
INSERT INTO language_descriptions(subtag, type, lang, description)
326
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
327
328
INSERT INTO language_descriptions(subtag, type, lang, description)
329
VALUES( 'id', 'language', 'en', 'Indonesian');
330
331
INSERT INTO language_descriptions(subtag, type, lang, description)
332
VALUES( 'id', 'language', 'fr', 'Indonésien');
333
334
-- Italian
335
INSERT INTO language_subtag_registry( subtag, type, description, added)
336
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
337
338
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
339
VALUES( 'it','ita');
340
341
INSERT INTO language_descriptions(subtag, type, lang, description)
342
VALUES( 'it', 'language', 'it', 'Italiano');
343
344
INSERT INTO language_descriptions(subtag, type, lang, description)
345
VALUES( 'it', 'language', 'en', 'Italian');
346
347
INSERT INTO language_descriptions(subtag, type, lang, description)
348
VALUES( 'it', 'language', 'fr', 'Italien');
349
350
-- Japanese
351
INSERT INTO language_subtag_registry( subtag, type, description, added)
352
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
353
354
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
355
VALUES( 'ja','jpn');
356
357
INSERT INTO language_descriptions(subtag, type, lang, description)
358
VALUES( 'ja', 'language', 'ja', '日本語');
359
360
INSERT INTO language_descriptions(subtag, type, lang, description)
361
VALUES( 'ja', 'language', 'en', 'Japanese');
362
363
INSERT INTO language_descriptions(subtag, type, lang, description)
364
VALUES( 'ja', 'language', 'fr', 'Japonais');
365
366
-- Korean
367
INSERT INTO language_subtag_registry( subtag, type, description, added)
368
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
369
370
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
371
VALUES( 'ko','kor');
372
373
INSERT INTO language_descriptions(subtag, type, lang, description)
374
VALUES( 'ko', 'language', 'ko', '한국어');
375
376
INSERT INTO language_descriptions(subtag, type, lang, description)
377
VALUES( 'ko', 'language', 'en', 'Korean');
378
379
INSERT INTO language_descriptions(subtag, type, lang, description)
380
VALUES( 'ko', 'language', 'fr', 'Coréen');
381
382
-- Latin
383
INSERT INTO language_subtag_registry( subtag, type, description, added)
384
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
385
386
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
387
VALUES( 'la','lat');
388
389
INSERT INTO language_descriptions(subtag, type, lang, description)
390
VALUES( 'la', 'language', 'la', 'Latina');
391
392
INSERT INTO language_descriptions(subtag, type, lang, description)
393
VALUES( 'la', 'language', 'en', 'Latin');
394
395
INSERT INTO language_descriptions(subtag, type, lang, description)
396
VALUES( 'la', 'language', 'fr', 'Latin');
397
398
-- Galician
399
400
INSERT INTO language_subtag_registry( subtag, type, description, added)
401
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
402
403
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
404
VALUES( 'gl','glg');
405
406
INSERT INTO language_descriptions(subtag, type, lang, description)
407
VALUES( 'gl', 'language', 'gl', 'Galego');
408
409
INSERT INTO language_descriptions(subtag, type, lang, description)
410
VALUES( 'gl', 'language', 'en', 'Galician');
411
412
-- Norwegian (bokmål)
413
INSERT INTO language_subtag_registry( subtag, type, description, added)
414
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
415
416
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
417
VALUES( 'nb','nor');
418
419
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
420
VALUES( 'nb','nob');
421
422
INSERT INTO language_descriptions(subtag, type, lang, description)
423
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
424
425
INSERT INTO language_descriptions(subtag, type, lang, description)
426
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
427
428
INSERT INTO language_descriptions(subtag, type, lang, description)
429
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
430
431
-- Norwegian (nynorsk)
432
INSERT INTO language_subtag_registry( subtag, type, description, added)
433
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
434
435
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
436
VALUES( 'nn','nno');
437
438
INSERT INTO language_descriptions(subtag, type, lang, description)
439
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
440
441
INSERT INTO language_descriptions(subtag, type, lang, description)
442
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
443
444
INSERT INTO language_descriptions(subtag, type, lang, description)
445
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
446
447
INSERT INTO language_descriptions(subtag, type, lang, description)
448
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
449
450
-- Persian
451
INSERT INTO language_subtag_registry( subtag, type, description, added)
452
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
453
454
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
455
VALUES( 'fa','per');
456
457
INSERT INTO language_descriptions(subtag, type, lang, description)
458
VALUES( 'fa', 'language', 'fa', 'فارسى');
459
460
INSERT INTO language_descriptions(subtag, type, lang, description)
461
VALUES( 'fa', 'language', 'en', 'Persian');
462
463
INSERT INTO language_descriptions(subtag, type, lang, description)
464
VALUES( 'fa', 'language', 'fr', 'Persan');
465
466
-- Polish
467
INSERT INTO language_subtag_registry( subtag, type, description, added)
468
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
469
470
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
471
VALUES( 'pl','pol');
472
473
INSERT INTO language_descriptions(subtag, type, lang, description)
474
VALUES( 'pl', 'language', 'pl', 'Polski');
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'pl', 'language', 'en', 'Polish');
478
479
INSERT INTO language_descriptions(subtag, type, lang, description)
480
VALUES( 'pl', 'language', 'fr', 'Polonais');
481
482
-- Portuguese
483
INSERT INTO language_subtag_registry( subtag, type, description, added)
484
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
485
486
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
487
VALUES( 'pt','por');
488
489
INSERT INTO language_descriptions(subtag, type, lang, description)
490
VALUES( 'pt', 'language', 'pt', 'Português');
491
492
INSERT INTO language_descriptions(subtag, type, lang, description)
493
VALUES( 'pt', 'language', 'en', 'Portuguese');
494
495
INSERT INTO language_descriptions(subtag, type, lang, description)
496
VALUES( 'pt', 'language', 'fr', 'Portugais');
497
498
-- Romanian
499
INSERT INTO language_subtag_registry( subtag, type, description, added)
500
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
501
502
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
503
VALUES( 'ro','rum');
504
505
INSERT INTO language_descriptions(subtag, type, lang, description)
506
VALUES( 'ro', 'language', 'ro', 'Română');
507
508
INSERT INTO language_descriptions(subtag, type, lang, description)
509
VALUES( 'ro', 'language', 'en', 'Romanian');
510
511
INSERT INTO language_descriptions(subtag, type, lang, description)
512
VALUES( 'ro', 'language', 'fr', 'Roumain');
513
514
-- Russian
515
INSERT INTO language_subtag_registry( subtag, type, description, added)
516
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
517
518
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
519
VALUES( 'ru','rus');
520
521
INSERT INTO language_descriptions(subtag, type, lang, description)
522
VALUES( 'ru', 'language', 'ru', 'Русский');
523
524
INSERT INTO language_descriptions(subtag, type, lang, description)
525
VALUES( 'ru', 'language', 'en', 'Russian');
526
527
INSERT INTO language_descriptions(subtag, type, lang, description)
528
VALUES( 'ru', 'language', 'fr', 'Russe');
529
530
-- Serbian
531
INSERT INTO language_subtag_registry( subtag, type, description, added)
532
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
533
534
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
535
VALUES( 'sr','srp');
536
537
INSERT INTO language_descriptions(subtag, type, lang, description)
538
VALUES( 'sr', 'language', 'sr', 'српски');
539
540
INSERT INTO language_descriptions(subtag, type, lang, description)
541
VALUES( 'sr', 'language', 'en', 'Serbian');
542
543
-- Spanish, Castilian
544
INSERT INTO language_subtag_registry( subtag, type, description, added)
545
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
546
547
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
548
VALUES( 'es','spa');
549
550
INSERT INTO language_descriptions(subtag, type, lang, description)
551
VALUES( 'es', 'language', 'es', 'Español');
552
553
INSERT INTO language_descriptions(subtag, type, lang, description)
554
VALUES( 'es', 'language', 'en', 'Spanish');
555
556
INSERT INTO language_descriptions(subtag, type, lang, description)
557
VALUES( 'es', 'language', 'fr', 'Espagnol');
558
559
-- Spanish, Catalan
560
INSERT INTO language_subtag_registry( subtag, type, description, added)
561
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
562
563
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
564
VALUES( 'ca','cat');
565
566
INSERT INTO language_descriptions(subtag, type, lang, description)
567
VALUES( 'ca', 'language', 'es', 'Catalán');
568
569
INSERT INTO language_descriptions(subtag, type, lang, description)
570
VALUES( 'ca', 'language', 'en', 'Catalan');
571
572
INSERT INTO language_descriptions(subtag, type, lang, description)
573
VALUES( 'ca', 'language', 'fr', 'Catalan');
574
575
INSERT INTO language_descriptions(subtag, type, lang, description)
576
VALUES( 'ca', 'language', 'ca', 'Català');
577
578
INSERT INTO language_descriptions(subtag, type, lang, description)
579
VALUES( 'ca', 'language', 'de', 'Katalanisch');
580
581
-- Swedish
582
INSERT INTO language_subtag_registry( subtag, type, description, added)
583
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
584
585
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
586
VALUES( 'sv','swe');
587
588
INSERT INTO language_descriptions(subtag, type, lang, description)
589
VALUES( 'sv', 'language', 'sv', 'Svenska');
590
591
INSERT INTO language_descriptions(subtag, type, lang, description)
592
VALUES( 'sv', 'language', 'en', 'Swedish');   
593
594
INSERT INTO language_descriptions(subtag, type, lang, description)
595
VALUES( 'sv', 'language', 'fr', 'Suédois');
596
597
-- Tetum
598
INSERT INTO language_subtag_registry( subtag, type, description, added)
599
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
600
601
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
602
VALUES( 'tet','tet');
603
604
INSERT INTO language_descriptions(subtag, type, lang, description)
605
VALUES( 'tet', 'language', 'tet', 'tetun');
606
607
INSERT INTO language_descriptions(subtag, type, lang, description)
608
VALUES( 'tet', 'language', 'en', 'Tetum');
609
610
-- Thai
611
INSERT INTO language_subtag_registry( subtag, type, description, added)
612
VALUES ( 'th', 'language', 'Thai','2005-10-16');
613
614
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
615
VALUES( 'th','tha');
616
617
INSERT INTO language_descriptions(subtag, type, lang, description)
618
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
619
620
INSERT INTO language_descriptions(subtag, type, lang, description)
621
VALUES( 'th', 'language', 'en', 'Thai');   
622
623
INSERT INTO language_descriptions(subtag, type, lang, description)
624
VALUES( 'th', 'language', 'fr', 'Thaï');
625
626
-- Turkish
627
INSERT INTO language_subtag_registry( subtag, type, description, added)
628
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
629
630
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
631
VALUES( 'tr','tur');
632
633
INSERT INTO language_descriptions(subtag, type, lang, description)
634
VALUES( 'tr', 'language', 'tr', 'Türkçe');
635
636
INSERT INTO language_descriptions(subtag, type, lang, description)
637
VALUES( 'tr', 'language', 'en', 'Turkish');   
638
639
INSERT INTO language_descriptions(subtag, type, lang, description)
640
VALUES( 'tr', 'language', 'fr', 'Turc');
641
642
643
-- Ukranian
644
INSERT INTO language_subtag_registry( subtag, type, description, added)
645
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
646
647
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
648
VALUES( 'uk','ukr');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'uk', 'language', 'uk', 'Українська');
652
653
INSERT INTO language_descriptions(subtag, type, lang, description)
654
VALUES( 'uk', 'language', 'en', 'Ukranian');
655
656
INSERT INTO language_descriptions(subtag, type, lang, description)
657
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
658
659
-- Urdu
660
INSERT INTO language_subtag_registry( subtag, type, description, added)
661
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
662
663
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
664
VALUES( 'ur','urd');
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'ur', 'language', 'en', 'Urdu');
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES( 'ur', 'language', 'ur', 'اردو');
671
672
-- SCRIPTS
673
-- Arabic
674
INSERT INTO language_subtag_registry( subtag, type, description, added)
675
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
676
677
INSERT INTO language_descriptions(subtag, type, lang, description)
678
VALUES ( 'Arab','script', 'Arab', 'العربية');
679
680
INSERT INTO language_descriptions(subtag, type, lang, description)
681
VALUES( 'Arab', 'script','en', 'Arabic');
682
683
INSERT INTO language_descriptions(subtag, type, lang, description)
684
VALUES( 'Arab', 'script','fr', 'Arabic');
685
686
-- Cyrillic
687
INSERT INTO language_subtag_registry( subtag, type, description, added)
688
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
689
690
INSERT INTO language_descriptions(subtag, type, lang, description)
691
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
692
693
INSERT INTO language_descriptions(subtag, type, lang, description)
694
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
695
696
INSERT INTO language_descriptions(subtag, type, lang, description)
697
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
698
699
-- Greek
700
INSERT INTO language_subtag_registry( subtag, type, description, added)
701
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
702
703
INSERT INTO language_descriptions(subtag, type, lang, description)
704
VALUES ( 'Grek', 'script', 'Grek', '????');
705
706
INSERT INTO language_descriptions(subtag, type, lang, description)
707
VALUES( 'Grek', 'script', 'en', 'Greek');
708
709
INSERT INTO language_descriptions(subtag, type, lang, description)
710
VALUES( 'Grek', 'script', 'fr', 'Greek');
711
712
-- Han - Simplified
713
INSERT INTO language_subtag_registry( subtag, type, description, added)
714
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
715
716
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
718
719
INSERT INTO language_descriptions(subtag, type, lang, description)
720
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
721
722
INSERT INTO language_descriptions(subtag, type, lang, description)
723
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
724
725
-- Han - Traditional
726
INSERT INTO language_subtag_registry( subtag, type, description, added)
727
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
731
732
INSERT INTO language_descriptions(subtag, type, lang, description)
733
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
734
735
-- Hebrew
736
INSERT INTO language_subtag_registry( subtag, type, description, added)
737
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
738
739
INSERT INTO language_descriptions(subtag, type, lang, description)
740
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
744
745
-- Lao
746
INSERT INTO language_subtag_registry( subtag, type, description, added)
747
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
748
749
INSERT INTO language_descriptions(subtag, type, lang, description)
750
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
751
752
INSERT INTO language_descriptions(subtag, type, lang, description)
753
VALUES( 'Laoo', 'script', 'en', 'Lao');
754
755
-- Croatian
756
INSERT INTO language_subtag_registry( subtag, type, description, added)
757
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
758
759
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
760
VALUES( 'hr','hrv');
761
762
INSERT INTO language_descriptions(subtag, type, lang, description)
763
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
764
765
INSERT INTO language_descriptions(subtag, type, lang, description)
766
VALUES( 'hr', 'language', 'en', 'Croatian');
767
768
INSERT INTO language_descriptions(subtag, type, lang, description)
769
VALUES( 'hr', 'language', 'fr', 'Croate');
770
771
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'hr', 'language', 'de', 'Kroatisch');
773
774
775
-- REGIONS
776
-- Canada
777
INSERT INTO language_subtag_registry( subtag, type, description, added)
778
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
779
780
INSERT INTO language_descriptions(subtag, type, lang, description)
781
VALUES( 'CA', 'region', 'en', 'Canada');
782
783
-- Denmark
784
INSERT INTO language_subtag_registry( subtag, type, description, added)
785
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
786
787
INSERT INTO language_descriptions(subtag, type, lang, description)
788
VALUES( 'DK', 'region', 'dk', 'Danmark');
789
790
-- France
791
INSERT INTO language_subtag_registry( subtag, type, description, added)
792
VALUES ( 'FR', 'region', 'France','2005-10-16');
793
794
INSERT INTO language_descriptions(subtag, type, lang, description)
795
VALUES ( 'FR', 'region', 'fr', 'France');
796
797
INSERT INTO language_descriptions(subtag, type, lang, description)
798
VALUES( 'FR', 'region', 'en', 'France');
799
800
-- New Zealand
801
INSERT INTO language_subtag_registry( subtag, type, description, added)
802
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
803
804
INSERT INTO language_descriptions(subtag, type, lang, description)
805
VALUES( 'NZ', 'region', 'en', 'New Zealand');
806
807
-- United Kingdom
808
INSERT INTO language_subtag_registry( subtag, type, description, added)
809
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
810
811
INSERT INTO language_descriptions(subtag, type, lang, description)
812
VALUES( 'GB', 'region', 'en', 'United Kingdom');
813
814
-- United States
815
INSERT INTO language_subtag_registry( subtag, type, description, added)
816
VALUES ( 'US', 'region', 'United States','2005-10-16');
817
818
INSERT INTO language_descriptions(subtag, type, lang, description)
819
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/subtag_registry.txt (-1 lines)
Line 1 Link Here
1
Støtte for flerspråklighet. 
(-)a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql (-786 lines)
Lines 1-786 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', 'العربية');
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
-- Armenian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'hy','hy');
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES( 'hy', 'language', 'en', 'Armenian');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'fr', 'Armenian');
81
82
-- Bulgarian
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
85
86
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
87
VALUES( 'bg','bul');
88
89
INSERT INTO language_descriptions(subtag, type, lang, description)
90
VALUES ( 'bg', 'language', 'bg', 'Български');
91
92
INSERT INTO language_descriptions(subtag, type, lang, description)
93
VALUES( 'bg', 'language', 'en', 'Bulgarian');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'bg', 'language', 'fr', 'Bulgare');
97
98
-- Chinese
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
101
102
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
103
VALUES( 'zh','chi');
104
105
INSERT INTO language_descriptions(subtag, type, lang, description)
106
VALUES ( 'zh', 'language', 'zh', '中文');
107
108
INSERT INTO language_descriptions(subtag, type, lang, description)
109
VALUES( 'zh', 'language', 'en', 'Chinese');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'zh', 'language', 'fr', 'Chinois');
113
114
-- Czech
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
117
118
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
119
VALUES( 'cs','cze');
120
121
INSERT INTO language_descriptions(subtag, type, lang, description)
122
VALUES ( 'cs', 'language', 'cs', 'čeština');
123
124
INSERT INTO language_descriptions(subtag, type, lang, description)
125
VALUES( 'cs', 'language', 'en', 'Czech');
126
127
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'cs', 'language', 'fr', 'Tchèque');
129
130
-- Danish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
133
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
135
VALUES( 'da','dan');
136
137
INSERT INTO language_descriptions(subtag, type, lang, description)
138
VALUES ( 'da', 'language', 'da', 'Dansk');
139
140
INSERT INTO language_descriptions(subtag, type, lang, description)
141
VALUES( 'da', 'language', 'en', 'Danish');
142
143
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'da', 'language', 'fr', 'Danois');
145
146
-- Dutch, Flemish
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
149
150
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
151
VALUES( 'nl','dut');
152
153
INSERT INTO language_descriptions(subtag, type, lang, description)
154
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES( 'nl', 'language', 'en', 'Dutch');
158
159
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
161
162
-- English
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES( 'en','en');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'en', 'language', 'en', 'English');
171
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
174
175
-- English
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
178
179
INSERT INTO language_descriptions(subtag, type, lang, description)
180
VALUES( 'fi', 'language', 'fi', 'suomi');
181
182
INSERT INTO language_descriptions(subtag, type, lang, description)
183
VALUES( 'fi', 'language', 'en', 'Finnish');
184
185
-- French
186
INSERT INTO language_subtag_registry( subtag, type, description, added)
187
VALUES ( 'fr', 'language', 'French','2005-10-16' );
188
189
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
190
VALUES( 'fr','fr');
191
192
INSERT INTO language_descriptions(subtag, type, lang, description)
193
VALUES( 'fr', 'language', 'en', 'French');
194
195
INSERT INTO language_descriptions(subtag, type, lang, description)
196
VALUES( 'fr', 'language', 'fr', 'Français');
197
198
-- INSERT INTO language_descriptions(subtag, type, lang, description)
199
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
200
201
-- Lao
202
INSERT INTO language_subtag_registry( subtag, type, description, added)
203
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
204
205
-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
206
-- VALUES( 'lo','nor'); ???
207
208
INSERT INTO language_descriptions(subtag, type, lang, description)
209
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
210
211
INSERT INTO language_descriptions(subtag, type, lang, description)
212
VALUES( 'lo', 'language', 'en', 'Lao');
213
214
-- German
215
INSERT INTO language_subtag_registry( subtag, type, description, added)
216
VALUES ( 'de', 'language', 'German','2005-10-16' );
217
218
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
219
VALUES( 'de','ger');
220
221
INSERT INTO language_descriptions(subtag, type, lang, description)
222
VALUES( 'de', 'language', 'de', 'Deutsch');
223
224
INSERT INTO language_descriptions(subtag, type, lang, description)
225
VALUES( 'de', 'language', 'en', 'German');
226
227
INSERT INTO language_descriptions(subtag, type, lang, description)
228
VALUES( 'de', 'language', 'fr', 'Allemand');
229
230
-- Greek
231
INSERT INTO language_subtag_registry( subtag, type, description, added)
232
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
233
234
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
235
VALUES( 'el','gre');
236
237
INSERT INTO language_descriptions(subtag, type, lang, description)
238
VALUES( 'el', 'language', 'el', 'ελληνικά');
239
240
INSERT INTO language_descriptions(subtag, type, lang, description)
241
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
242
243
INSERT INTO language_descriptions(subtag, type, lang, description)
244
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
245
246
-- Hebrew
247
INSERT INTO language_subtag_registry( subtag, type, description, added)
248
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
249
250
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
251
VALUES( 'he','heb');
252
253
INSERT INTO language_descriptions(subtag, type, lang, description)
254
VALUES( 'he', 'language', 'he', 'עברית');
255
256
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'he', 'language', 'en', 'Hebrew');
258
259
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'he', 'language', 'fr', 'Hébreu');
261
262
-- Hindi
263
INSERT INTO language_subtag_registry( subtag, type, description, added)
264
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
265
266
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
267
VALUES( 'hi','hin');
268
269
INSERT INTO language_descriptions(subtag, type, lang, description)
270
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
271
272
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'hi', 'language', 'en', 'Hindi');
274
275
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'hi', 'language', 'fr', 'Hindi');
277
278
-- Hungarian
279
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
281
282
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
283
VALUES( 'hu','hun');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'hu', 'language', 'hu', 'Magyar');
287
288
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'hu', 'language', 'en', 'Hungarian');
290
291
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'hu', 'language', 'fr', 'Hongrois');
293
294
-- Indonesian
295
INSERT INTO language_subtag_registry( subtag, type, description, added)
296
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
297
298
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
299
VALUES( 'id','ind');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'id', 'language', 'en', 'Indonesian');
306
307
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'id', 'language', 'fr', 'Indonésien');
309
310
-- Italian
311
INSERT INTO language_subtag_registry( subtag, type, description, added)
312
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
313
314
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
315
VALUES( 'it','ita');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'it', 'language', 'it', 'Italiano');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'it', 'language', 'en', 'Italian');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'it', 'language', 'fr', 'Italien');
325
326
-- Japanese
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'ja','jpn');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'ja', 'language', 'ja', '日本語');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'ja', 'language', 'en', 'Japanese');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'ja', 'language', 'fr', 'Japonais');
341
342
-- Korean
343
INSERT INTO language_subtag_registry( subtag, type, description, added)
344
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
345
346
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
347
VALUES( 'ko','kor');
348
349
INSERT INTO language_descriptions(subtag, type, lang, description)
350
VALUES( 'ko', 'language', 'ko', '한국어');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'ko', 'language', 'en', 'Korean');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'ko', 'language', 'fr', 'Coréen');
357
358
-- Latin
359
INSERT INTO language_subtag_registry( subtag, type, description, added)
360
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
361
362
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
363
VALUES( 'la','lat');
364
365
INSERT INTO language_descriptions(subtag, type, lang, description)
366
VALUES( 'la', 'language', 'la', 'Latina');
367
368
INSERT INTO language_descriptions(subtag, type, lang, description)
369
VALUES( 'la', 'language', 'en', 'Latin');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'la', 'language', 'fr', 'Latin');
373
374
-- Galacian
375
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
377
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
378
379
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
380
VALUES( 'gl','glg');
381
382
INSERT INTO language_descriptions(subtag, type, lang, description)
383
VALUES( 'gl', 'language', 'gl', 'Galego');
384
385
INSERT INTO language_descriptions(subtag, type, lang, description)
386
VALUES( 'gl', 'language', 'en', 'Galician');
387
388
-- Norwegian (bokmål)
389
INSERT INTO language_subtag_registry( subtag, type, description, added)
390
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
391
392
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
393
VALUES( 'nb','nor');
394
395
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
396
VALUES( 'nb','nob');
397
398
INSERT INTO language_descriptions(subtag, type, lang, description)
399
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
400
401
INSERT INTO language_descriptions(subtag, type, lang, description)
402
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
403
404
INSERT INTO language_descriptions(subtag, type, lang, description)
405
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
406
407
-- Norwegian (nynorsk)
408
INSERT INTO language_subtag_registry( subtag, type, description, added)
409
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
410
411
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
412
VALUES( 'nn','nno');
413
414
INSERT INTO language_descriptions(subtag, type, lang, description)
415
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
416
417
INSERT INTO language_descriptions(subtag, type, lang, description)
418
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
419
420
INSERT INTO language_descriptions(subtag, type, lang, description)
421
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
422
423
INSERT INTO language_descriptions(subtag, type, lang, description)
424
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
425
426
-- Persian
427
INSERT INTO language_subtag_registry( subtag, type, description, added)
428
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
429
430
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
431
VALUES( 'fa','per');
432
433
INSERT INTO language_descriptions(subtag, type, lang, description)
434
VALUES( 'fa', 'language', 'fa', 'فارسى');
435
436
INSERT INTO language_descriptions(subtag, type, lang, description)
437
VALUES( 'fa', 'language', 'en', 'Persian');
438
439
INSERT INTO language_descriptions(subtag, type, lang, description)
440
VALUES( 'fa', 'language', 'fr', 'Persan');
441
442
-- Polish
443
INSERT INTO language_subtag_registry( subtag, type, description, added)
444
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
445
446
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
447
VALUES( 'pl','pol');
448
449
INSERT INTO language_descriptions(subtag, type, lang, description)
450
VALUES( 'pl', 'language', 'pl', 'Polski');
451
452
INSERT INTO language_descriptions(subtag, type, lang, description)
453
VALUES( 'pl', 'language', 'en', 'Polish');
454
455
INSERT INTO language_descriptions(subtag, type, lang, description)
456
VALUES( 'pl', 'language', 'fr', 'Polonais');
457
458
-- Portuguese
459
INSERT INTO language_subtag_registry( subtag, type, description, added)
460
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
461
462
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
463
VALUES( 'pt','pol');
464
465
INSERT INTO language_descriptions(subtag, type, lang, description)
466
VALUES( 'pt', 'language', 'pt', 'Português');
467
468
INSERT INTO language_descriptions(subtag, type, lang, description)
469
VALUES( 'pt', 'language', 'en', 'Portuguese');
470
471
INSERT INTO language_descriptions(subtag, type, lang, description)
472
VALUES( 'pt', 'language', 'fr', 'Portugais');
473
474
-- Romanian
475
INSERT INTO language_subtag_registry( subtag, type, description, added)
476
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
477
478
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
479
VALUES( 'ro','rum');
480
481
INSERT INTO language_descriptions(subtag, type, lang, description)
482
VALUES( 'ro', 'language', 'ro', 'Română');
483
484
INSERT INTO language_descriptions(subtag, type, lang, description)
485
VALUES( 'ro', 'language', 'en', 'Romanian');
486
487
INSERT INTO language_descriptions(subtag, type, lang, description)
488
VALUES( 'ro', 'language', 'fr', 'Roumain');
489
490
-- Russian
491
INSERT INTO language_subtag_registry( subtag, type, description, added)
492
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
493
494
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
495
VALUES( 'ru','rus');
496
497
INSERT INTO language_descriptions(subtag, type, lang, description)
498
VALUES( 'ru', 'language', 'ru', 'Русский');
499
500
INSERT INTO language_descriptions(subtag, type, lang, description)
501
VALUES( 'ru', 'language', 'en', 'Russian');
502
503
INSERT INTO language_descriptions(subtag, type, lang, description)
504
VALUES( 'ru', 'language', 'fr', 'Russe');
505
506
-- Serbian
507
INSERT INTO language_subtag_registry( subtag, type, description, added)
508
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
509
510
INSERT INTO language_descriptions(subtag, type, lang, description)
511
VALUES( 'sr', 'language', 'sr', 'српски');
512
513
INSERT INTO language_descriptions(subtag, type, lang, description)
514
VALUES( 'sr', 'language', 'en', 'Serbian');
515
516
-- Spanish, Castilian
517
INSERT INTO language_subtag_registry( subtag, type, description, added)
518
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
519
520
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
521
VALUES( 'es','spa');
522
523
INSERT INTO language_descriptions(subtag, type, lang, description)
524
VALUES( 'es', 'language', 'es', 'Español');
525
526
INSERT INTO language_descriptions(subtag, type, lang, description)
527
VALUES( 'es', 'language', 'en', 'Spanish');
528
529
INSERT INTO language_descriptions(subtag, type, lang, description)
530
VALUES( 'es', 'language', 'fr', 'Espagnol');
531
532
-- Spanish, Catalan
533
INSERT INTO language_subtag_registry( subtag, type, description, added)
534
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
535
536
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
537
VALUES( 'ca','cat');
538
539
INSERT INTO language_descriptions(subtag, type, lang, description)
540
VALUES( 'ca', 'language', 'es', 'Catalán');
541
542
INSERT INTO language_descriptions(subtag, type, lang, description)
543
VALUES( 'ca', 'language', 'en', 'Catalan');
544
545
INSERT INTO language_descriptions(subtag, type, lang, description)
546
VALUES( 'ca', 'language', 'fr', 'Catalan');
547
548
INSERT INTO language_descriptions(subtag, type, lang, description)
549
VALUES( 'ca', 'language', 'ca', 'Català');
550
551
INSERT INTO language_descriptions(subtag, type, lang, description)
552
VALUES( 'ca', 'language', 'de', 'Katalanisch');
553
554
-- Swedish
555
INSERT INTO language_subtag_registry( subtag, type, description, added)
556
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
557
558
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
559
VALUES( 'sv','swe');
560
561
INSERT INTO language_descriptions(subtag, type, lang, description)
562
VALUES( 'sv', 'language', 'sv', 'Svenska');
563
564
INSERT INTO language_descriptions(subtag, type, lang, description)
565
VALUES( 'sv', 'language', 'en', 'Swedish');
566
567
INSERT INTO language_descriptions(subtag, type, lang, description)
568
VALUES( 'sv', 'language', 'fr', 'Suédois');
569
570
-- Tetum
571
INSERT INTO language_subtag_registry( subtag, type, description, added)
572
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'tet', 'language', 'tet', 'tetun');
576
577
INSERT INTO language_descriptions(subtag, type, lang, description)
578
VALUES( 'tet', 'language', 'en', 'Tetum');
579
580
-- Thai
581
INSERT INTO language_subtag_registry( subtag, type, description, added)
582
VALUES ( 'th', 'language', 'Thai','2005-10-16');
583
584
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
585
VALUES( 'th','tha');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'th', 'language', 'en', 'Thai');
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'th', 'language', 'fr', 'Thaï');
595
596
-- Turkish
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'tr','tur');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'tr', 'language', 'tr', 'Türkçe');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'tr', 'language', 'en', 'Turkish');
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'tr', 'language', 'fr', 'Turc');
611
612
613
-- Ukranian
614
INSERT INTO language_subtag_registry( subtag, type, description, added)
615
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
616
617
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
618
VALUES( 'uk','ukr');
619
620
INSERT INTO language_descriptions(subtag, type, lang, description)
621
VALUES( 'uk', 'language', 'uk', 'Українська');
622
623
INSERT INTO language_descriptions(subtag, type, lang, description)
624
VALUES( 'uk', 'language', 'en', 'Ukranian');
625
626
INSERT INTO language_descriptions(subtag, type, lang, description)
627
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
628
629
-- English
630
INSERT INTO language_subtag_registry( subtag, type, description, added)
631
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
632
633
INSERT INTO language_descriptions(subtag, type, lang, description)
634
VALUES( 'ur', 'language', 'en', 'Urdu');
635
636
INSERT INTO language_descriptions(subtag, type, lang, description)
637
VALUES( 'ur', 'language', 'ur', 'اردو');
638
639
-- SCRIPTS
640
-- Arabic
641
INSERT INTO language_subtag_registry( subtag, type, description, added)
642
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES ( 'Arab','script', 'Arab', 'العربية');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'Arab', 'script','en', 'Arabic');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'Arab', 'script','fr', 'Arabic');
652
653
-- Cyrillic
654
INSERT INTO language_subtag_registry( subtag, type, description, added)
655
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
656
657
INSERT INTO language_descriptions(subtag, type, lang, description)
658
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
659
660
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
665
666
-- Greek
667
INSERT INTO language_subtag_registry( subtag, type, description, added)
668
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
669
670
INSERT INTO language_descriptions(subtag, type, lang, description)
671
VALUES ( 'Grek', 'script', 'Grek', '????');
672
673
INSERT INTO language_descriptions(subtag, type, lang, description)
674
VALUES( 'Grek', 'script', 'en', 'Greek');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES( 'Grek', 'script', 'fr', 'Greek');
678
679
-- Han - Simplified
680
INSERT INTO language_subtag_registry( subtag, type, description, added)
681
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
682
683
INSERT INTO language_descriptions(subtag, type, lang, description)
684
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
685
686
INSERT INTO language_descriptions(subtag, type, lang, description)
687
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
688
689
INSERT INTO language_descriptions(subtag, type, lang, description)
690
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
691
692
-- Han - Traditional
693
INSERT INTO language_subtag_registry( subtag, type, description, added)
694
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
695
696
INSERT INTO language_descriptions(subtag, type, lang, description)
697
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
698
699
INSERT INTO language_descriptions(subtag, type, lang, description)
700
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
701
702
-- Hebrew
703
INSERT INTO language_subtag_registry( subtag, type, description, added)
704
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
705
706
INSERT INTO language_descriptions(subtag, type, lang, description)
707
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
708
709
INSERT INTO language_descriptions(subtag, type, lang, description)
710
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
711
712
-- Lao
713
INSERT INTO language_subtag_registry( subtag, type, description, added)
714
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
715
716
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
718
719
INSERT INTO language_descriptions(subtag, type, lang, description)
720
VALUES( 'Laoo', 'script', 'en', 'Lao');
721
722
-- Croatian
723
INSERT INTO language_subtag_registry( subtag, type, description, added)
724
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
725
726
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
727
VALUES( 'hr','hrv');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
731
732
INSERT INTO language_descriptions(subtag, type, lang, description)
733
VALUES( 'hr', 'language', 'en', 'Croatian');
734
735
INSERT INTO language_descriptions(subtag, type, lang, description)
736
VALUES( 'hr', 'language', 'fr', 'Croate');
737
738
INSERT INTO language_descriptions(subtag, type, lang, description)
739
VALUES( 'hr', 'language', 'de', 'Kroatisch');
740
741
742
-- REGIONS
743
-- Canada
744
INSERT INTO language_subtag_registry( subtag, type, description, added)
745
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
746
747
INSERT INTO language_descriptions(subtag, type, lang, description)
748
VALUES( 'CA', 'region', 'en', 'Canada');
749
750
-- Denmark
751
INSERT INTO language_subtag_registry( subtag, type, description, added)
752
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
753
754
INSERT INTO language_descriptions(subtag, type, lang, description)
755
VALUES( 'DK', 'region', 'dk', 'Danmark');
756
757
-- France
758
INSERT INTO language_subtag_registry( subtag, type, description, added)
759
VALUES ( 'FR', 'region', 'France','2005-10-16');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES ( 'FR', 'region', 'fr', 'France');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'FR', 'region', 'en', 'France');
766
767
-- New Zealand
768
INSERT INTO language_subtag_registry( subtag, type, description, added)
769
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
770
771
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'NZ', 'region', 'en', 'New Zealand');
773
774
-- United Kingdom
775
INSERT INTO language_subtag_registry( subtag, type, description, added)
776
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'GB', 'region', 'en', 'United Kingdom');
780
781
-- United States
782
INSERT INTO language_subtag_registry( subtag, type, description, added)
783
VALUES ( 'US', 'region', 'United States','2005-10-16');
784
785
INSERT INTO language_descriptions(subtag, type, lang, description)
786
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt (-5 lines)
Lines 1-5 Link Here
1
Wsparcie Koha dla I18N
2
3
Tłumaczenia dwukierunkowe, arabski i  and hebrajski
4
Domyślne mapowania pomiędzy skryptem a subkodami języków
5
Rozszerzenia języków
(-)a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql (-786 lines)
Lines 1-786 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', 'العربية');
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
-- Armenian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'hy','hy');
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES( 'hy', 'language', 'en', 'Armenian');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'fr', 'Armenian');
81
82
-- Bulgarian
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
85
86
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
87
VALUES( 'bg','bul');
88
89
INSERT INTO language_descriptions(subtag, type, lang, description)
90
VALUES ( 'bg', 'language', 'bg', 'Български');
91
92
INSERT INTO language_descriptions(subtag, type, lang, description)
93
VALUES( 'bg', 'language', 'en', 'Bulgarian');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'bg', 'language', 'fr', 'Bulgare');
97
98
-- Chinese
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
101
102
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
103
VALUES( 'zh','chi');
104
105
INSERT INTO language_descriptions(subtag, type, lang, description)
106
VALUES ( 'zh', 'language', 'zh', '中文');
107
108
INSERT INTO language_descriptions(subtag, type, lang, description)
109
VALUES( 'zh', 'language', 'en', 'Chinese');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'zh', 'language', 'fr', 'Chinois');
113
114
-- Czech
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
117
118
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
119
VALUES( 'cs','cze');
120
121
INSERT INTO language_descriptions(subtag, type, lang, description)
122
VALUES ( 'cs', 'language', 'cs', 'čeština');
123
124
INSERT INTO language_descriptions(subtag, type, lang, description)
125
VALUES( 'cs', 'language', 'en', 'Czech');
126
127
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'cs', 'language', 'fr', 'Tchèque');
129
130
-- Danish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
133
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
135
VALUES( 'da','dan');
136
137
INSERT INTO language_descriptions(subtag, type, lang, description)
138
VALUES ( 'da', 'language', 'da', 'Dansk');
139
140
INSERT INTO language_descriptions(subtag, type, lang, description)
141
VALUES( 'da', 'language', 'en', 'Danish');
142
143
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'da', 'language', 'fr', 'Danois');
145
146
-- Dutch, Flemish
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
149
150
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
151
VALUES( 'nl','dut');
152
153
INSERT INTO language_descriptions(subtag, type, lang, description)
154
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES( 'nl', 'language', 'en', 'Dutch');
158
159
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
161
162
-- English
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES( 'en','en');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'en', 'language', 'en', 'English');
171
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
174
175
-- English
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
178
179
INSERT INTO language_descriptions(subtag, type, lang, description)
180
VALUES( 'fi', 'language', 'fi', 'suomi');
181
182
INSERT INTO language_descriptions(subtag, type, lang, description)
183
VALUES( 'fi', 'language', 'en', 'Finnish');
184
185
-- French
186
INSERT INTO language_subtag_registry( subtag, type, description, added)
187
VALUES ( 'fr', 'language', 'French','2005-10-16' );
188
189
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
190
VALUES( 'fr','fr');
191
192
INSERT INTO language_descriptions(subtag, type, lang, description)
193
VALUES( 'fr', 'language', 'en', 'French');
194
195
INSERT INTO language_descriptions(subtag, type, lang, description)
196
VALUES( 'fr', 'language', 'fr', 'Français');
197
198
-- INSERT INTO language_descriptions(subtag, type, lang, description)
199
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
200
201
-- Lao
202
INSERT INTO language_subtag_registry( subtag, type, description, added)
203
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
204
205
-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
206
-- VALUES( 'lo','nor'); ???
207
208
INSERT INTO language_descriptions(subtag, type, lang, description)
209
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
210
211
INSERT INTO language_descriptions(subtag, type, lang, description)
212
VALUES( 'lo', 'language', 'en', 'Lao');
213
214
-- German
215
INSERT INTO language_subtag_registry( subtag, type, description, added)
216
VALUES ( 'de', 'language', 'German','2005-10-16' );
217
218
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
219
VALUES( 'de','ger');
220
221
INSERT INTO language_descriptions(subtag, type, lang, description)
222
VALUES( 'de', 'language', 'de', 'Deutsch');
223
224
INSERT INTO language_descriptions(subtag, type, lang, description)
225
VALUES( 'de', 'language', 'en', 'German');
226
227
INSERT INTO language_descriptions(subtag, type, lang, description)
228
VALUES( 'de', 'language', 'fr', 'Allemand');
229
230
-- Greek
231
INSERT INTO language_subtag_registry( subtag, type, description, added)
232
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
233
234
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
235
VALUES( 'el','gre');
236
237
INSERT INTO language_descriptions(subtag, type, lang, description)
238
VALUES( 'el', 'language', 'el', 'ελληνικά');
239
240
INSERT INTO language_descriptions(subtag, type, lang, description)
241
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
242
243
INSERT INTO language_descriptions(subtag, type, lang, description)
244
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
245
246
-- Hebrew
247
INSERT INTO language_subtag_registry( subtag, type, description, added)
248
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
249
250
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
251
VALUES( 'he','heb');
252
253
INSERT INTO language_descriptions(subtag, type, lang, description)
254
VALUES( 'he', 'language', 'he', 'עברית');
255
256
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'he', 'language', 'en', 'Hebrew');
258
259
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'he', 'language', 'fr', 'Hébreu');
261
262
-- Hindi
263
INSERT INTO language_subtag_registry( subtag, type, description, added)
264
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
265
266
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
267
VALUES( 'hi','hin');
268
269
INSERT INTO language_descriptions(subtag, type, lang, description)
270
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
271
272
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'hi', 'language', 'en', 'Hindi');
274
275
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'hi', 'language', 'fr', 'Hindi');
277
278
-- Hungarian
279
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
281
282
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
283
VALUES( 'hu','hun');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'hu', 'language', 'hu', 'Magyar');
287
288
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'hu', 'language', 'en', 'Hungarian');
290
291
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'hu', 'language', 'fr', 'Hongrois');
293
294
-- Indonesian
295
INSERT INTO language_subtag_registry( subtag, type, description, added)
296
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
297
298
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
299
VALUES( 'id','ind');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'id', 'language', 'en', 'Indonesian');
306
307
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'id', 'language', 'fr', 'Indonésien');
309
310
-- Italian
311
INSERT INTO language_subtag_registry( subtag, type, description, added)
312
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
313
314
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
315
VALUES( 'it','ita');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'it', 'language', 'it', 'Italiano');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'it', 'language', 'en', 'Italian');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'it', 'language', 'fr', 'Italien');
325
326
-- Japanese
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'ja','jpn');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'ja', 'language', 'ja', '日本語');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'ja', 'language', 'en', 'Japanese');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'ja', 'language', 'fr', 'Japonais');
341
342
-- Korean
343
INSERT INTO language_subtag_registry( subtag, type, description, added)
344
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
345
346
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
347
VALUES( 'ko','kor');
348
349
INSERT INTO language_descriptions(subtag, type, lang, description)
350
VALUES( 'ko', 'language', 'ko', '한국어');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'ko', 'language', 'en', 'Korean');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'ko', 'language', 'fr', 'Coréen');
357
358
-- Latin
359
INSERT INTO language_subtag_registry( subtag, type, description, added)
360
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
361
362
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
363
VALUES( 'la','lat');
364
365
INSERT INTO language_descriptions(subtag, type, lang, description)
366
VALUES( 'la', 'language', 'la', 'Latina');
367
368
INSERT INTO language_descriptions(subtag, type, lang, description)
369
VALUES( 'la', 'language', 'en', 'Latin');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'la', 'language', 'fr', 'Latin');
373
374
-- Galacian
375
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
377
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
378
379
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
380
VALUES( 'gl','glg');
381
382
INSERT INTO language_descriptions(subtag, type, lang, description)
383
VALUES( 'gl', 'language', 'gl', 'Galego');
384
385
INSERT INTO language_descriptions(subtag, type, lang, description)
386
VALUES( 'gl', 'language', 'en', 'Galician');
387
388
-- Norwegian (bokmål)
389
INSERT INTO language_subtag_registry( subtag, type, description, added)
390
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
391
392
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
393
VALUES( 'nb','nor');
394
395
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
396
VALUES( 'nb','nob');
397
398
INSERT INTO language_descriptions(subtag, type, lang, description)
399
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
400
401
INSERT INTO language_descriptions(subtag, type, lang, description)
402
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
403
404
INSERT INTO language_descriptions(subtag, type, lang, description)
405
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
406
407
-- Norwegian (nynorsk)
408
INSERT INTO language_subtag_registry( subtag, type, description, added)
409
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
410
411
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
412
VALUES( 'nn','nno');
413
414
INSERT INTO language_descriptions(subtag, type, lang, description)
415
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
416
417
INSERT INTO language_descriptions(subtag, type, lang, description)
418
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
419
420
INSERT INTO language_descriptions(subtag, type, lang, description)
421
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
422
423
INSERT INTO language_descriptions(subtag, type, lang, description)
424
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
425
426
-- Persian
427
INSERT INTO language_subtag_registry( subtag, type, description, added)
428
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
429
430
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
431
VALUES( 'fa','per');
432
433
INSERT INTO language_descriptions(subtag, type, lang, description)
434
VALUES( 'fa', 'language', 'fa', 'فارسى');
435
436
INSERT INTO language_descriptions(subtag, type, lang, description)
437
VALUES( 'fa', 'language', 'en', 'Persian');
438
439
INSERT INTO language_descriptions(subtag, type, lang, description)
440
VALUES( 'fa', 'language', 'fr', 'Persan');
441
442
-- Polish
443
INSERT INTO language_subtag_registry( subtag, type, description, added)
444
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
445
446
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
447
VALUES( 'pl','pol');
448
449
INSERT INTO language_descriptions(subtag, type, lang, description)
450
VALUES( 'pl', 'language', 'pl', 'Polski');
451
452
INSERT INTO language_descriptions(subtag, type, lang, description)
453
VALUES( 'pl', 'language', 'en', 'Polish');
454
455
INSERT INTO language_descriptions(subtag, type, lang, description)
456
VALUES( 'pl', 'language', 'fr', 'Polonais');
457
458
-- Portuguese
459
INSERT INTO language_subtag_registry( subtag, type, description, added)
460
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
461
462
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
463
VALUES( 'pt','por');
464
465
INSERT INTO language_descriptions(subtag, type, lang, description)
466
VALUES( 'pt', 'language', 'pt', 'Português');
467
468
INSERT INTO language_descriptions(subtag, type, lang, description)
469
VALUES( 'pt', 'language', 'en', 'Portuguese');
470
471
INSERT INTO language_descriptions(subtag, type, lang, description)
472
VALUES( 'pt', 'language', 'fr', 'Portugais');
473
474
-- Romanian
475
INSERT INTO language_subtag_registry( subtag, type, description, added)
476
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
477
478
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
479
VALUES( 'ro','rum');
480
481
INSERT INTO language_descriptions(subtag, type, lang, description)
482
VALUES( 'ro', 'language', 'ro', 'Română');
483
484
INSERT INTO language_descriptions(subtag, type, lang, description)
485
VALUES( 'ro', 'language', 'en', 'Romanian');
486
487
INSERT INTO language_descriptions(subtag, type, lang, description)
488
VALUES( 'ro', 'language', 'fr', 'Roumain');
489
490
-- Russian
491
INSERT INTO language_subtag_registry( subtag, type, description, added)
492
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
493
494
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
495
VALUES( 'ru','rus');
496
497
INSERT INTO language_descriptions(subtag, type, lang, description)
498
VALUES( 'ru', 'language', 'ru', 'Русский');
499
500
INSERT INTO language_descriptions(subtag, type, lang, description)
501
VALUES( 'ru', 'language', 'en', 'Russian');
502
503
INSERT INTO language_descriptions(subtag, type, lang, description)
504
VALUES( 'ru', 'language', 'fr', 'Russe');
505
506
-- Serbian
507
INSERT INTO language_subtag_registry( subtag, type, description, added)
508
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
509
510
INSERT INTO language_descriptions(subtag, type, lang, description)
511
VALUES( 'sr', 'language', 'sr', 'српски');
512
513
INSERT INTO language_descriptions(subtag, type, lang, description)
514
VALUES( 'sr', 'language', 'en', 'Serbian');
515
516
-- Spanish, Castilian
517
INSERT INTO language_subtag_registry( subtag, type, description, added)
518
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
519
520
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
521
VALUES( 'es','spa');
522
523
INSERT INTO language_descriptions(subtag, type, lang, description)
524
VALUES( 'es', 'language', 'es', 'Español');
525
526
INSERT INTO language_descriptions(subtag, type, lang, description)
527
VALUES( 'es', 'language', 'en', 'Spanish');
528
529
INSERT INTO language_descriptions(subtag, type, lang, description)
530
VALUES( 'es', 'language', 'fr', 'Espagnol');
531
532
-- Spanish, Catalan
533
INSERT INTO language_subtag_registry( subtag, type, description, added)
534
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
535
536
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
537
VALUES( 'ca','cat');
538
539
INSERT INTO language_descriptions(subtag, type, lang, description)
540
VALUES( 'ca', 'language', 'es', 'Catalán');
541
542
INSERT INTO language_descriptions(subtag, type, lang, description)
543
VALUES( 'ca', 'language', 'en', 'Catalan');
544
545
INSERT INTO language_descriptions(subtag, type, lang, description)
546
VALUES( 'ca', 'language', 'fr', 'Catalan');
547
548
INSERT INTO language_descriptions(subtag, type, lang, description)
549
VALUES( 'ca', 'language', 'ca', 'Català');
550
551
INSERT INTO language_descriptions(subtag, type, lang, description)
552
VALUES( 'ca', 'language', 'de', 'Katalanisch');
553
554
-- Swedish
555
INSERT INTO language_subtag_registry( subtag, type, description, added)
556
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
557
558
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
559
VALUES( 'sv','swe');
560
561
INSERT INTO language_descriptions(subtag, type, lang, description)
562
VALUES( 'sv', 'language', 'sv', 'Svenska');
563
564
INSERT INTO language_descriptions(subtag, type, lang, description)
565
VALUES( 'sv', 'language', 'en', 'Swedish');   
566
567
INSERT INTO language_descriptions(subtag, type, lang, description)
568
VALUES( 'sv', 'language', 'fr', 'Suédois');
569
570
-- Tetum
571
INSERT INTO language_subtag_registry( subtag, type, description, added)
572
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'tet', 'language', 'tet', 'tetun');
576
577
INSERT INTO language_descriptions(subtag, type, lang, description)
578
VALUES( 'tet', 'language', 'en', 'Tetum');
579
580
-- Thai
581
INSERT INTO language_subtag_registry( subtag, type, description, added)
582
VALUES ( 'th', 'language', 'Thai','2005-10-16');
583
584
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
585
VALUES( 'th','tha');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'th', 'language', 'en', 'Thai');   
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'th', 'language', 'fr', 'Thaï');
595
596
-- Turkish
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'tr','tur');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'tr', 'language', 'tr', 'Türkçe');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'tr', 'language', 'en', 'Turkish');   
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'tr', 'language', 'fr', 'Turc');
611
612
613
-- Ukranian
614
INSERT INTO language_subtag_registry( subtag, type, description, added)
615
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
616
617
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
618
VALUES( 'uk','ukr');
619
620
INSERT INTO language_descriptions(subtag, type, lang, description)
621
VALUES( 'uk', 'language', 'uk', 'Українська');
622
623
INSERT INTO language_descriptions(subtag, type, lang, description)
624
VALUES( 'uk', 'language', 'en', 'Ukranian');
625
626
INSERT INTO language_descriptions(subtag, type, lang, description)
627
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
628
629
-- English
630
INSERT INTO language_subtag_registry( subtag, type, description, added)
631
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
632
633
INSERT INTO language_descriptions(subtag, type, lang, description)
634
VALUES( 'ur', 'language', 'en', 'Urdu');
635
636
INSERT INTO language_descriptions(subtag, type, lang, description)
637
VALUES( 'ur', 'language', 'ur', 'اردو');
638
639
-- SCRIPTS
640
-- Arabic
641
INSERT INTO language_subtag_registry( subtag, type, description, added)
642
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES ( 'Arab','script', 'Arab', 'العربية');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'Arab', 'script','en', 'Arabic');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'Arab', 'script','fr', 'Arabic');
652
653
-- Cyrillic
654
INSERT INTO language_subtag_registry( subtag, type, description, added)
655
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
656
657
INSERT INTO language_descriptions(subtag, type, lang, description)
658
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
659
660
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
665
666
-- Greek
667
INSERT INTO language_subtag_registry( subtag, type, description, added)
668
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
669
670
INSERT INTO language_descriptions(subtag, type, lang, description)
671
VALUES ( 'Grek', 'script', 'Grek', '????');
672
673
INSERT INTO language_descriptions(subtag, type, lang, description)
674
VALUES( 'Grek', 'script', 'en', 'Greek');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES( 'Grek', 'script', 'fr', 'Greek');
678
679
-- Han - Simplified
680
INSERT INTO language_subtag_registry( subtag, type, description, added)
681
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
682
683
INSERT INTO language_descriptions(subtag, type, lang, description)
684
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
685
686
INSERT INTO language_descriptions(subtag, type, lang, description)
687
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
688
689
INSERT INTO language_descriptions(subtag, type, lang, description)
690
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
691
692
-- Han - Traditional
693
INSERT INTO language_subtag_registry( subtag, type, description, added)
694
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
695
696
INSERT INTO language_descriptions(subtag, type, lang, description)
697
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
698
699
INSERT INTO language_descriptions(subtag, type, lang, description)
700
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
701
702
-- Hebrew
703
INSERT INTO language_subtag_registry( subtag, type, description, added)
704
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
705
706
INSERT INTO language_descriptions(subtag, type, lang, description)
707
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
708
709
INSERT INTO language_descriptions(subtag, type, lang, description)
710
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
711
712
-- Lao
713
INSERT INTO language_subtag_registry( subtag, type, description, added)
714
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
715
716
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
718
719
INSERT INTO language_descriptions(subtag, type, lang, description)
720
VALUES( 'Laoo', 'script', 'en', 'Lao');
721
722
-- Croatian
723
INSERT INTO language_subtag_registry( subtag, type, description, added)
724
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
725
726
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
727
VALUES( 'hr','hrv');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
731
732
INSERT INTO language_descriptions(subtag, type, lang, description)
733
VALUES( 'hr', 'language', 'en', 'Croatian');
734
735
INSERT INTO language_descriptions(subtag, type, lang, description)
736
VALUES( 'hr', 'language', 'fr', 'Croate');
737
738
INSERT INTO language_descriptions(subtag, type, lang, description)
739
VALUES( 'hr', 'language', 'de', 'Kroatisch');
740
741
742
-- REGIONS
743
-- Canada
744
INSERT INTO language_subtag_registry( subtag, type, description, added)
745
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
746
747
INSERT INTO language_descriptions(subtag, type, lang, description)
748
VALUES( 'CA', 'region', 'en', 'Canada');
749
750
-- Denmark
751
INSERT INTO language_subtag_registry( subtag, type, description, added)
752
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
753
754
INSERT INTO language_descriptions(subtag, type, lang, description)
755
VALUES( 'DK', 'region', 'dk', 'Danmark');
756
757
-- France
758
INSERT INTO language_subtag_registry( subtag, type, description, added)
759
VALUES ( 'FR', 'region', 'France','2005-10-16');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES ( 'FR', 'region', 'fr', 'France');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'FR', 'region', 'en', 'France');
766
767
-- New Zealand
768
INSERT INTO language_subtag_registry( subtag, type, description, added)
769
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
770
771
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'NZ', 'region', 'en', 'New Zealand');
773
774
-- United Kingdom
775
INSERT INTO language_subtag_registry( subtag, type, description, added)
776
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'GB', 'region', 'en', 'United Kingdom');
780
781
-- United States
782
INSERT INTO language_subtag_registry( subtag, type, description, added)
783
VALUES ( 'US', 'region', 'United States','2005-10-16');
784
785
INSERT INTO language_descriptions(subtag, type, lang, description)
786
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt (-4 lines)
Lines 1-4 Link Here
1
Поддержка интернационализации (I18N) в Koha
2
Поддержка двунаправленности (BIDI); арабский и иврит. 
3
Стандартное отображение между письмом и подкодами языка.
4
Расширения языка.
(-)a/installer/data/mysql/uk-UA/mandatory/subtag_registry.sql (-786 lines)
Lines 1-786 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', 'العربية');
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
-- Armenian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
69
70
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
71
VALUES( 'hy','hy');
72
73
INSERT INTO language_descriptions(subtag, type, lang, description)
74
VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
75
76
INSERT INTO language_descriptions(subtag, type, lang, description)
77
VALUES( 'hy', 'language', 'en', 'Armenian');
78
79
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'fr', 'Armenian');
81
82
-- Bulgarian
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
85
86
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
87
VALUES( 'bg','bul');
88
89
INSERT INTO language_descriptions(subtag, type, lang, description)
90
VALUES ( 'bg', 'language', 'bg', 'Български');
91
92
INSERT INTO language_descriptions(subtag, type, lang, description)
93
VALUES( 'bg', 'language', 'en', 'Bulgarian');
94
95
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'bg', 'language', 'fr', 'Bulgare');
97
98
-- Chinese
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
101
102
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
103
VALUES( 'zh','chi');
104
105
INSERT INTO language_descriptions(subtag, type, lang, description)
106
VALUES ( 'zh', 'language', 'zh', '中文');
107
108
INSERT INTO language_descriptions(subtag, type, lang, description)
109
VALUES( 'zh', 'language', 'en', 'Chinese');
110
111
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'zh', 'language', 'fr', 'Chinois');
113
114
-- Czech
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
117
118
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
119
VALUES( 'cs','cze');
120
121
INSERT INTO language_descriptions(subtag, type, lang, description)
122
VALUES ( 'cs', 'language', 'cs', 'čeština');
123
124
INSERT INTO language_descriptions(subtag, type, lang, description)
125
VALUES( 'cs', 'language', 'en', 'Czech');
126
127
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'cs', 'language', 'fr', 'Tchèque');
129
130
-- Danish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
133
134
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
135
VALUES( 'da','dan');
136
137
INSERT INTO language_descriptions(subtag, type, lang, description)
138
VALUES ( 'da', 'language', 'da', 'Dansk');
139
140
INSERT INTO language_descriptions(subtag, type, lang, description)
141
VALUES( 'da', 'language', 'en', 'Danish');
142
143
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'da', 'language', 'fr', 'Danois');
145
146
-- Dutch, Flemish
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
149
150
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
151
VALUES( 'nl','dut');
152
153
INSERT INTO language_descriptions(subtag, type, lang, description)
154
VALUES ( 'nl', 'language', 'nl', 'Nederlands');
155
156
INSERT INTO language_descriptions(subtag, type, lang, description)
157
VALUES( 'nl', 'language', 'en', 'Dutch');
158
159
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
161
162
-- English
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
165
166
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
167
VALUES( 'en','en');
168
169
INSERT INTO language_descriptions(subtag, type, lang, description)
170
VALUES( 'en', 'language', 'en', 'English');
171
172
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
174
175
-- English
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
178
179
INSERT INTO language_descriptions(subtag, type, lang, description)
180
VALUES( 'fi', 'language', 'fi', 'suomi');
181
182
INSERT INTO language_descriptions(subtag, type, lang, description)
183
VALUES( 'fi', 'language', 'en', 'Finnish');
184
185
-- French
186
INSERT INTO language_subtag_registry( subtag, type, description, added)
187
VALUES ( 'fr', 'language', 'French','2005-10-16' );
188
189
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
190
VALUES( 'fr','fr');
191
192
INSERT INTO language_descriptions(subtag, type, lang, description)
193
VALUES( 'fr', 'language', 'en', 'French');
194
195
INSERT INTO language_descriptions(subtag, type, lang, description)
196
VALUES( 'fr', 'language', 'fr', 'Français');
197
198
-- INSERT INTO language_descriptions(subtag, type, lang, description)
199
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
200
201
-- Lao
202
INSERT INTO language_subtag_registry( subtag, type, description, added)
203
VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
204
205
-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
206
-- VALUES( 'lo','nor'); ???
207
208
INSERT INTO language_descriptions(subtag, type, lang, description)
209
VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
210
211
INSERT INTO language_descriptions(subtag, type, lang, description)
212
VALUES( 'lo', 'language', 'en', 'Lao');
213
214
-- German
215
INSERT INTO language_subtag_registry( subtag, type, description, added)
216
VALUES ( 'de', 'language', 'German','2005-10-16' );
217
218
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
219
VALUES( 'de','ger');
220
221
INSERT INTO language_descriptions(subtag, type, lang, description)
222
VALUES( 'de', 'language', 'de', 'Deutsch');
223
224
INSERT INTO language_descriptions(subtag, type, lang, description)
225
VALUES( 'de', 'language', 'en', 'German');
226
227
INSERT INTO language_descriptions(subtag, type, lang, description)
228
VALUES( 'de', 'language', 'fr', 'Allemand');
229
230
-- Greek
231
INSERT INTO language_subtag_registry( subtag, type, description, added)
232
VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
233
234
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
235
VALUES( 'el','gre');
236
237
INSERT INTO language_descriptions(subtag, type, lang, description)
238
VALUES( 'el', 'language', 'el', 'ελληνικά');
239
240
INSERT INTO language_descriptions(subtag, type, lang, description)
241
VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
242
243
INSERT INTO language_descriptions(subtag, type, lang, description)
244
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
245
246
-- Hebrew
247
INSERT INTO language_subtag_registry( subtag, type, description, added)
248
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
249
250
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
251
VALUES( 'he','heb');
252
253
INSERT INTO language_descriptions(subtag, type, lang, description)
254
VALUES( 'he', 'language', 'he', 'עברית');
255
256
INSERT INTO language_descriptions(subtag, type, lang, description)
257
VALUES( 'he', 'language', 'en', 'Hebrew');
258
259
INSERT INTO language_descriptions(subtag, type, lang, description)
260
VALUES( 'he', 'language', 'fr', 'Hébreu');
261
262
-- Hindi
263
INSERT INTO language_subtag_registry( subtag, type, description, added)
264
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
265
266
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
267
VALUES( 'hi','hin');
268
269
INSERT INTO language_descriptions(subtag, type, lang, description)
270
VALUES( 'hi', 'language', 'hi', 'हिन्दी');
271
272
INSERT INTO language_descriptions(subtag, type, lang, description)
273
VALUES( 'hi', 'language', 'en', 'Hindi');
274
275
INSERT INTO language_descriptions(subtag, type, lang, description)
276
VALUES( 'hi', 'language', 'fr', 'Hindi');
277
278
-- Hungarian
279
INSERT INTO language_subtag_registry( subtag, type, description, added)
280
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
281
282
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
283
VALUES( 'hu','hun');
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'hu', 'language', 'hu', 'Magyar');
287
288
INSERT INTO language_descriptions(subtag, type, lang, description)
289
VALUES( 'hu', 'language', 'en', 'Hungarian');
290
291
INSERT INTO language_descriptions(subtag, type, lang, description)
292
VALUES( 'hu', 'language', 'fr', 'Hongrois');
293
294
-- Indonesian
295
INSERT INTO language_subtag_registry( subtag, type, description, added)
296
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
297
298
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
299
VALUES( 'id','ind');
300
301
INSERT INTO language_descriptions(subtag, type, lang, description)
302
VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'id', 'language', 'en', 'Indonesian');
306
307
INSERT INTO language_descriptions(subtag, type, lang, description)
308
VALUES( 'id', 'language', 'fr', 'Indonésien');
309
310
-- Italian
311
INSERT INTO language_subtag_registry( subtag, type, description, added)
312
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
313
314
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
315
VALUES( 'it','ita');
316
317
INSERT INTO language_descriptions(subtag, type, lang, description)
318
VALUES( 'it', 'language', 'it', 'Italiano');
319
320
INSERT INTO language_descriptions(subtag, type, lang, description)
321
VALUES( 'it', 'language', 'en', 'Italian');
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'it', 'language', 'fr', 'Italien');
325
326
-- Japanese
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
328
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
329
330
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
331
VALUES( 'ja','jpn');
332
333
INSERT INTO language_descriptions(subtag, type, lang, description)
334
VALUES( 'ja', 'language', 'ja', '日本語');
335
336
INSERT INTO language_descriptions(subtag, type, lang, description)
337
VALUES( 'ja', 'language', 'en', 'Japanese');
338
339
INSERT INTO language_descriptions(subtag, type, lang, description)
340
VALUES( 'ja', 'language', 'fr', 'Japonais');
341
342
-- Korean
343
INSERT INTO language_subtag_registry( subtag, type, description, added)
344
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
345
346
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
347
VALUES( 'ko','kor');
348
349
INSERT INTO language_descriptions(subtag, type, lang, description)
350
VALUES( 'ko', 'language', 'ko', '한국어');
351
352
INSERT INTO language_descriptions(subtag, type, lang, description)
353
VALUES( 'ko', 'language', 'en', 'Korean');
354
355
INSERT INTO language_descriptions(subtag, type, lang, description)
356
VALUES( 'ko', 'language', 'fr', 'Coréen');
357
358
-- Latin
359
INSERT INTO language_subtag_registry( subtag, type, description, added)
360
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
361
362
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
363
VALUES( 'la','lat');
364
365
INSERT INTO language_descriptions(subtag, type, lang, description)
366
VALUES( 'la', 'language', 'la', 'Latina');
367
368
INSERT INTO language_descriptions(subtag, type, lang, description)
369
VALUES( 'la', 'language', 'en', 'Latin');
370
371
INSERT INTO language_descriptions(subtag, type, lang, description)
372
VALUES( 'la', 'language', 'fr', 'Latin');
373
374
-- Galacian
375
376
INSERT INTO language_subtag_registry( subtag, type, description, added)
377
VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
378
379
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
380
VALUES( 'gl','glg');
381
382
INSERT INTO language_descriptions(subtag, type, lang, description)
383
VALUES( 'gl', 'language', 'gl', 'Galego');
384
385
INSERT INTO language_descriptions(subtag, type, lang, description)
386
VALUES( 'gl', 'language', 'en', 'Galician');
387
388
-- Norwegian (bokmål)
389
INSERT INTO language_subtag_registry( subtag, type, description, added)
390
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
391
392
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
393
VALUES( 'nb','nor');
394
395
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
396
VALUES( 'nb','nob');
397
398
INSERT INTO language_descriptions(subtag, type, lang, description)
399
VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
400
401
INSERT INTO language_descriptions(subtag, type, lang, description)
402
VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
403
404
INSERT INTO language_descriptions(subtag, type, lang, description)
405
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
406
407
-- Norwegian (nynorsk)
408
INSERT INTO language_subtag_registry( subtag, type, description, added)
409
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
410
411
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
412
VALUES( 'nn','nno');
413
414
INSERT INTO language_descriptions(subtag, type, lang, description)
415
VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
416
417
INSERT INTO language_descriptions(subtag, type, lang, description)
418
VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
419
420
INSERT INTO language_descriptions(subtag, type, lang, description)
421
VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
422
423
INSERT INTO language_descriptions(subtag, type, lang, description)
424
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
425
426
-- Persian
427
INSERT INTO language_subtag_registry( subtag, type, description, added)
428
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
429
430
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
431
VALUES( 'fa','per');
432
433
INSERT INTO language_descriptions(subtag, type, lang, description)
434
VALUES( 'fa', 'language', 'fa', 'فارسى');
435
436
INSERT INTO language_descriptions(subtag, type, lang, description)
437
VALUES( 'fa', 'language', 'en', 'Persian');
438
439
INSERT INTO language_descriptions(subtag, type, lang, description)
440
VALUES( 'fa', 'language', 'fr', 'Persan');
441
442
-- Polish
443
INSERT INTO language_subtag_registry( subtag, type, description, added)
444
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
445
446
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
447
VALUES( 'pl','pol');
448
449
INSERT INTO language_descriptions(subtag, type, lang, description)
450
VALUES( 'pl', 'language', 'pl', 'Polski');
451
452
INSERT INTO language_descriptions(subtag, type, lang, description)
453
VALUES( 'pl', 'language', 'en', 'Polish');
454
455
INSERT INTO language_descriptions(subtag, type, lang, description)
456
VALUES( 'pl', 'language', 'fr', 'Polonais');
457
458
-- Portuguese
459
INSERT INTO language_subtag_registry( subtag, type, description, added)
460
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
461
462
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
463
VALUES( 'pt','por');
464
465
INSERT INTO language_descriptions(subtag, type, lang, description)
466
VALUES( 'pt', 'language', 'pt', 'Português');
467
468
INSERT INTO language_descriptions(subtag, type, lang, description)
469
VALUES( 'pt', 'language', 'en', 'Portuguese');
470
471
INSERT INTO language_descriptions(subtag, type, lang, description)
472
VALUES( 'pt', 'language', 'fr', 'Portugais');
473
474
-- Romanian
475
INSERT INTO language_subtag_registry( subtag, type, description, added)
476
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
477
478
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
479
VALUES( 'ro','rum');
480
481
INSERT INTO language_descriptions(subtag, type, lang, description)
482
VALUES( 'ro', 'language', 'ro', 'Română');
483
484
INSERT INTO language_descriptions(subtag, type, lang, description)
485
VALUES( 'ro', 'language', 'en', 'Romanian');
486
487
INSERT INTO language_descriptions(subtag, type, lang, description)
488
VALUES( 'ro', 'language', 'fr', 'Roumain');
489
490
-- Russian
491
INSERT INTO language_subtag_registry( subtag, type, description, added)
492
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
493
494
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
495
VALUES( 'ru','rus');
496
497
INSERT INTO language_descriptions(subtag, type, lang, description)
498
VALUES( 'ru', 'language', 'ru', 'Русский');
499
500
INSERT INTO language_descriptions(subtag, type, lang, description)
501
VALUES( 'ru', 'language', 'en', 'Russian');
502
503
INSERT INTO language_descriptions(subtag, type, lang, description)
504
VALUES( 'ru', 'language', 'fr', 'Russe');
505
506
-- Serbian
507
INSERT INTO language_subtag_registry( subtag, type, description, added)
508
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
509
510
INSERT INTO language_descriptions(subtag, type, lang, description)
511
VALUES( 'sr', 'language', 'sr', 'српски');
512
513
INSERT INTO language_descriptions(subtag, type, lang, description)
514
VALUES( 'sr', 'language', 'en', 'Serbian');
515
516
-- Spanish, Castilian
517
INSERT INTO language_subtag_registry( subtag, type, description, added)
518
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
519
520
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
521
VALUES( 'es','spa');
522
523
INSERT INTO language_descriptions(subtag, type, lang, description)
524
VALUES( 'es', 'language', 'es', 'Español');
525
526
INSERT INTO language_descriptions(subtag, type, lang, description)
527
VALUES( 'es', 'language', 'en', 'Spanish');
528
529
INSERT INTO language_descriptions(subtag, type, lang, description)
530
VALUES( 'es', 'language', 'fr', 'Espagnol');
531
532
-- Spanish, Catalan
533
INSERT INTO language_subtag_registry( subtag, type, description, added)
534
VALUES ( 'ca', 'language', 'Catalan','2013-01-12' );
535
536
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
537
VALUES( 'ca','cat');
538
539
INSERT INTO language_descriptions(subtag, type, lang, description)
540
VALUES( 'ca', 'language', 'es', 'Catalán');
541
542
INSERT INTO language_descriptions(subtag, type, lang, description)
543
VALUES( 'ca', 'language', 'en', 'Catalan');
544
545
INSERT INTO language_descriptions(subtag, type, lang, description)
546
VALUES( 'ca', 'language', 'fr', 'Catalan');
547
548
INSERT INTO language_descriptions(subtag, type, lang, description)
549
VALUES( 'ca', 'language', 'ca', 'Català');
550
551
INSERT INTO language_descriptions(subtag, type, lang, description)
552
VALUES( 'ca', 'language', 'de', 'Katalanisch');
553
554
-- Swedish
555
INSERT INTO language_subtag_registry( subtag, type, description, added)
556
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
557
558
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
559
VALUES( 'sv','swe');
560
561
INSERT INTO language_descriptions(subtag, type, lang, description)
562
VALUES( 'sv', 'language', 'sv', 'Svenska');
563
564
INSERT INTO language_descriptions(subtag, type, lang, description)
565
VALUES( 'sv', 'language', 'en', 'Swedish');   
566
567
INSERT INTO language_descriptions(subtag, type, lang, description)
568
VALUES( 'sv', 'language', 'fr', 'Suédois');
569
570
-- Tetum
571
INSERT INTO language_subtag_registry( subtag, type, description, added)
572
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'tet', 'language', 'tet', 'tetun');
576
577
INSERT INTO language_descriptions(subtag, type, lang, description)
578
VALUES( 'tet', 'language', 'en', 'Tetum');
579
580
-- Thai
581
INSERT INTO language_subtag_registry( subtag, type, description, added)
582
VALUES ( 'th', 'language', 'Thai','2005-10-16');
583
584
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
585
VALUES( 'th','tha');
586
587
INSERT INTO language_descriptions(subtag, type, lang, description)
588
VALUES( 'th', 'language', 'th', 'ภาษาไทย');
589
590
INSERT INTO language_descriptions(subtag, type, lang, description)
591
VALUES( 'th', 'language', 'en', 'Thai');   
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'th', 'language', 'fr', 'Thaï');
595
596
-- Turkish
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
598
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
599
600
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
601
VALUES( 'tr','tur');
602
603
INSERT INTO language_descriptions(subtag, type, lang, description)
604
VALUES( 'tr', 'language', 'tr', 'Türkçe');
605
606
INSERT INTO language_descriptions(subtag, type, lang, description)
607
VALUES( 'tr', 'language', 'en', 'Turkish');   
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'tr', 'language', 'fr', 'Turc');
611
612
613
-- Ukranian
614
INSERT INTO language_subtag_registry( subtag, type, description, added)
615
VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
616
617
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
618
VALUES( 'uk','ukr');
619
620
INSERT INTO language_descriptions(subtag, type, lang, description)
621
VALUES( 'uk', 'language', 'uk', 'Українська');
622
623
INSERT INTO language_descriptions(subtag, type, lang, description)
624
VALUES( 'uk', 'language', 'en', 'Ukranian');
625
626
INSERT INTO language_descriptions(subtag, type, lang, description)
627
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
628
629
-- English
630
INSERT INTO language_subtag_registry( subtag, type, description, added)
631
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
632
633
INSERT INTO language_descriptions(subtag, type, lang, description)
634
VALUES( 'ur', 'language', 'en', 'Urdu');
635
636
INSERT INTO language_descriptions(subtag, type, lang, description)
637
VALUES( 'ur', 'language', 'ur', 'اردو');
638
639
-- SCRIPTS
640
-- Arabic
641
INSERT INTO language_subtag_registry( subtag, type, description, added)
642
VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
643
644
INSERT INTO language_descriptions(subtag, type, lang, description)
645
VALUES ( 'Arab','script', 'Arab', 'العربية');
646
647
INSERT INTO language_descriptions(subtag, type, lang, description)
648
VALUES( 'Arab', 'script','en', 'Arabic');
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'Arab', 'script','fr', 'Arabic');
652
653
-- Cyrillic
654
INSERT INTO language_subtag_registry( subtag, type, description, added)
655
VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
656
657
INSERT INTO language_descriptions(subtag, type, lang, description)
658
VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
659
660
INSERT INTO language_descriptions(subtag, type, lang, description)
661
VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
662
663
INSERT INTO language_descriptions(subtag, type, lang, description)
664
VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
665
666
-- Greek
667
INSERT INTO language_subtag_registry( subtag, type, description, added)
668
VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
669
670
INSERT INTO language_descriptions(subtag, type, lang, description)
671
VALUES ( 'Grek', 'script', 'Grek', '????');
672
673
INSERT INTO language_descriptions(subtag, type, lang, description)
674
VALUES( 'Grek', 'script', 'en', 'Greek');
675
676
INSERT INTO language_descriptions(subtag, type, lang, description)
677
VALUES( 'Grek', 'script', 'fr', 'Greek');
678
679
-- Han - Simplified
680
INSERT INTO language_subtag_registry( subtag, type, description, added)
681
VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
682
683
INSERT INTO language_descriptions(subtag, type, lang, description)
684
VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
685
686
INSERT INTO language_descriptions(subtag, type, lang, description)
687
VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
688
689
INSERT INTO language_descriptions(subtag, type, lang, description)
690
VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
691
692
-- Han - Traditional
693
INSERT INTO language_subtag_registry( subtag, type, description, added)
694
VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
695
696
INSERT INTO language_descriptions(subtag, type, lang, description)
697
VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
698
699
INSERT INTO language_descriptions(subtag, type, lang, description)
700
VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
701
702
-- Hebrew
703
INSERT INTO language_subtag_registry( subtag, type, description, added)
704
VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
705
706
INSERT INTO language_descriptions(subtag, type, lang, description)
707
VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
708
709
INSERT INTO language_descriptions(subtag, type, lang, description)
710
VALUES( 'Hebr', 'script', 'en', 'Hebrew');
711
712
-- Lao
713
INSERT INTO language_subtag_registry( subtag, type, description, added)
714
VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
715
716
INSERT INTO language_descriptions(subtag, type, lang, description)
717
VALUES ( 'Laoo', 'script', 'lo', 'Lao');
718
719
INSERT INTO language_descriptions(subtag, type, lang, description)
720
VALUES( 'Laoo', 'script', 'en', 'Lao');
721
722
-- Croatian
723
INSERT INTO language_subtag_registry( subtag, type, description, added)
724
VALUES ( 'hr', 'language', 'Croatian','2014-07-24' );
725
726
INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
727
VALUES( 'hr','hrv');
728
729
INSERT INTO language_descriptions(subtag, type, lang, description)
730
VALUES( 'hr', 'language', 'hr', 'Hrvatski');
731
732
INSERT INTO language_descriptions(subtag, type, lang, description)
733
VALUES( 'hr', 'language', 'en', 'Croatian');
734
735
INSERT INTO language_descriptions(subtag, type, lang, description)
736
VALUES( 'hr', 'language', 'fr', 'Croate');
737
738
INSERT INTO language_descriptions(subtag, type, lang, description)
739
VALUES( 'hr', 'language', 'de', 'Kroatisch');
740
741
742
-- REGIONS
743
-- Canada
744
INSERT INTO language_subtag_registry( subtag, type, description, added)
745
VALUES ( 'CA', 'region', 'Canada','2005-10-16');
746
747
INSERT INTO language_descriptions(subtag, type, lang, description)
748
VALUES( 'CA', 'region', 'en', 'Canada');
749
750
-- Denmark
751
INSERT INTO language_subtag_registry( subtag, type, description, added)
752
VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
753
754
INSERT INTO language_descriptions(subtag, type, lang, description)
755
VALUES( 'DK', 'region', 'dk', 'Danmark');
756
757
-- France
758
INSERT INTO language_subtag_registry( subtag, type, description, added)
759
VALUES ( 'FR', 'region', 'France','2005-10-16');
760
761
INSERT INTO language_descriptions(subtag, type, lang, description)
762
VALUES ( 'FR', 'region', 'fr', 'France');
763
764
INSERT INTO language_descriptions(subtag, type, lang, description)
765
VALUES( 'FR', 'region', 'en', 'France');
766
767
-- New Zealand
768
INSERT INTO language_subtag_registry( subtag, type, description, added)
769
VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
770
771
INSERT INTO language_descriptions(subtag, type, lang, description)
772
VALUES( 'NZ', 'region', 'en', 'New Zealand');
773
774
-- United Kingdom
775
INSERT INTO language_subtag_registry( subtag, type, description, added)
776
VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
777
778
INSERT INTO language_descriptions(subtag, type, lang, description)
779
VALUES( 'GB', 'region', 'en', 'United Kingdom');
780
781
-- United States
782
INSERT INTO language_subtag_registry( subtag, type, description, added)
783
VALUES ( 'US', 'region', 'United States','2005-10-16');
784
785
INSERT INTO language_descriptions(subtag, type, lang, description)
786
VALUES( 'US', 'region', 'en', 'United States');
(-)a/installer/data/mysql/uk-UA/mandatory/subtag_registry.txt (-5 lines)
Lines 1-4 Link Here
1
Підтримка інтернаціоналізації (I18N) в Koha.
2
Підтримка двонаправленого (BIDI) письма, арабська та іврит. 
3
Стандартне відображення між письмом та підкодами мови. 
4
Розширення мови.
5
- 

Return to bug 11593