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

(-)a/installer/data/mysql/en/mandatory/subtag_registry.sql (+119 lines)
Lines 63-68 VALUES( 'ar', 'language', 'en', 'Arabic'); Link Here
63
INSERT INTO language_descriptions(subtag, type, lang, description)
63
INSERT INTO language_descriptions(subtag, type, lang, description)
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
64
VALUES( 'ar', 'language', 'fr', 'Arabe');
65
65
66
INSERT INTO language_descriptions(subtag, type, lang, description)
67
VALUES( 'ar', 'language', 'de', 'Arabisch');
68
66
-- Armenian
69
-- Armenian
67
INSERT INTO language_subtag_registry( subtag, type, description, added)
70
INSERT INTO language_subtag_registry( subtag, type, description, added)
68
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
71
VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
Lines 79-84 VALUES( 'hy', 'language', 'en', 'Armenian'); Link Here
79
INSERT INTO language_descriptions(subtag, type, lang, description)
82
INSERT INTO language_descriptions(subtag, type, lang, description)
80
VALUES( 'hy', 'language', 'fr', 'Armenian');
83
VALUES( 'hy', 'language', 'fr', 'Armenian');
81
84
85
INSERT INTO language_descriptions(subtag, type, lang, description)
86
VALUES( 'hy', 'language', 'de', 'Armenisch');
87
82
-- Bulgarian
88
-- Bulgarian
83
INSERT INTO language_subtag_registry( subtag, type, description, added)
89
INSERT INTO language_subtag_registry( subtag, type, description, added)
84
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
90
VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
Lines 95-100 VALUES( 'bg', 'language', 'en', 'Bulgarian'); Link Here
95
INSERT INTO language_descriptions(subtag, type, lang, description)
101
INSERT INTO language_descriptions(subtag, type, lang, description)
96
VALUES( 'bg', 'language', 'fr', 'Bulgare');
102
VALUES( 'bg', 'language', 'fr', 'Bulgare');
97
103
104
INSERT INTO language_descriptions(subtag, type, lang, description)
105
VALUES( 'bg', 'language', 'de', 'Bulgarisch');
106
98
-- Chinese
107
-- Chinese
99
INSERT INTO language_subtag_registry( subtag, type, description, added)
108
INSERT INTO language_subtag_registry( subtag, type, description, added)
100
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
109
VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
Lines 111-116 VALUES( 'zh', 'language', 'en', 'Chinese'); Link Here
111
INSERT INTO language_descriptions(subtag, type, lang, description)
120
INSERT INTO language_descriptions(subtag, type, lang, description)
112
VALUES( 'zh', 'language', 'fr', 'Chinois');
121
VALUES( 'zh', 'language', 'fr', 'Chinois');
113
122
123
INSERT INTO language_descriptions(subtag, type, lang, description)
124
VALUES( 'zh', 'language', 'de', 'Chinesisch');
125
114
-- Czech
126
-- Czech
115
INSERT INTO language_subtag_registry( subtag, type, description, added)
127
INSERT INTO language_subtag_registry( subtag, type, description, added)
116
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
128
VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
Lines 127-132 VALUES( 'cs', 'language', 'en', 'Czech'); Link Here
127
INSERT INTO language_descriptions(subtag, type, lang, description)
139
INSERT INTO language_descriptions(subtag, type, lang, description)
128
VALUES( 'cs', 'language', 'fr', 'Tchèque');
140
VALUES( 'cs', 'language', 'fr', 'Tchèque');
129
141
142
INSERT INTO language_descriptions(subtag, type, lang, description)
143
VALUES( 'cs', 'language', 'de', 'Tschechisch');
144
130
-- Danish
145
-- Danish
131
INSERT INTO language_subtag_registry( subtag, type, description, added)
146
INSERT INTO language_subtag_registry( subtag, type, description, added)
132
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
147
VALUES ( 'da', 'language', 'Danish','2005-10-16' );
Lines 143-148 VALUES( 'da', 'language', 'en', 'Danish'); Link Here
143
INSERT INTO language_descriptions(subtag, type, lang, description)
158
INSERT INTO language_descriptions(subtag, type, lang, description)
144
VALUES( 'da', 'language', 'fr', 'Danois');
159
VALUES( 'da', 'language', 'fr', 'Danois');
145
160
161
INSERT INTO language_descriptions(subtag, type, lang, description)
162
VALUES( 'da', 'language', 'de', 'Dänisch');
163
146
-- Dutch, Flemish
164
-- Dutch, Flemish
147
INSERT INTO language_subtag_registry( subtag, type, description, added)
165
INSERT INTO language_subtag_registry( subtag, type, description, added)
148
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
166
VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
Lines 159-164 VALUES( 'nl', 'language', 'en', 'Dutch'); Link Here
159
INSERT INTO language_descriptions(subtag, type, lang, description)
177
INSERT INTO language_descriptions(subtag, type, lang, description)
160
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
178
VALUES( 'nl', 'language', 'fr', 'Néerlandais');
161
179
180
INSERT INTO language_descriptions(subtag, type, lang, description)
181
VALUES( 'nl', 'language', 'de', 'Niederländisch');
182
162
-- English
183
-- English
163
INSERT INTO language_subtag_registry( subtag, type, description, added)
184
INSERT INTO language_subtag_registry( subtag, type, description, added)
164
VALUES ( 'en', 'language', 'English','2005-10-16' );
185
VALUES ( 'en', 'language', 'English','2005-10-16' );
Lines 172-177 VALUES( 'en', 'language', 'en', 'English'); Link Here
172
INSERT INTO language_descriptions(subtag, type, lang, description)
193
INSERT INTO language_descriptions(subtag, type, lang, description)
173
VALUES( 'en', 'language', 'fr', 'Anglais');
194
VALUES( 'en', 'language', 'fr', 'Anglais');
174
195
196
INSERT INTO language_descriptions(subtag, type, lang, description)
197
VALUES( 'en', 'language', 'de', 'Englisch');
198
175
-- Finnish
199
-- Finnish
176
INSERT INTO language_subtag_registry( subtag, type, description, added)
200
INSERT INTO language_subtag_registry( subtag, type, description, added)
177
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
201
VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
Lines 185-190 VALUES( 'fi', 'language', 'fi', 'suomi'); Link Here
185
INSERT INTO language_descriptions(subtag, type, lang, description)
209
INSERT INTO language_descriptions(subtag, type, lang, description)
186
VALUES( 'fi', 'language', 'en', 'Finnish');
210
VALUES( 'fi', 'language', 'en', 'Finnish');
187
211
212
INSERT INTO language_descriptions(subtag, type, lang, description)
213
VALUES( 'fi', 'language', 'de', 'Finnisch');
214
188
-- French
215
-- French
189
INSERT INTO language_subtag_registry( subtag, type, description, added)
216
INSERT INTO language_subtag_registry( subtag, type, description, added)
190
VALUES ( 'fr', 'language', 'French','2005-10-16' );
217
VALUES ( 'fr', 'language', 'French','2005-10-16' );
Lines 198-203 VALUES( 'fr', 'language', 'en', 'French'); Link Here
198
INSERT INTO language_descriptions(subtag, type, lang, description)
225
INSERT INTO language_descriptions(subtag, type, lang, description)
199
VALUES( 'fr', 'language', 'fr', 'Français');
226
VALUES( 'fr', 'language', 'fr', 'Français');
200
227
228
INSERT INTO language_descriptions(subtag, type, lang, description)
229
VALUES( 'fr', 'language', 'de', 'Französisch');
230
201
-- INSERT INTO language_descriptions(subtag, type, lang, description)
231
-- INSERT INTO language_descriptions(subtag, type, lang, description)
202
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
232
-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
203
233
Lines 214-219 VALUES( 'lo', 'language', 'lo', 'ພາສາລາ&#375 Link Here
214
INSERT INTO language_descriptions(subtag, type, lang, description)
244
INSERT INTO language_descriptions(subtag, type, lang, description)
215
VALUES( 'lo', 'language', 'en', 'Lao');
245
VALUES( 'lo', 'language', 'en', 'Lao');
216
246
247
INSERT INTO language_descriptions(subtag, type, lang, description)
248
VALUES( 'lo', 'language', 'fr', 'Laotien');
249
250
INSERT INTO language_descriptions(subtag, type, lang, description)
251
VALUES( 'lo', 'language', 'de', 'Laotisch');
252
217
-- German
253
-- German
218
INSERT INTO language_subtag_registry( subtag, type, description, added)
254
INSERT INTO language_subtag_registry( subtag, type, description, added)
219
VALUES ( 'de', 'language', 'German','2005-10-16' );
255
VALUES ( 'de', 'language', 'German','2005-10-16' );
Lines 246-251 VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); Link Here
246
INSERT INTO language_descriptions(subtag, type, lang, description)
282
INSERT INTO language_descriptions(subtag, type, lang, description)
247
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
283
VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
248
284
285
INSERT INTO language_descriptions(subtag, type, lang, description)
286
VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)');
287
249
-- Hebrew
288
-- Hebrew
250
INSERT INTO language_subtag_registry( subtag, type, description, added)
289
INSERT INTO language_subtag_registry( subtag, type, description, added)
251
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
290
VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
Lines 262-267 VALUES( 'he', 'language', 'en', 'Hebrew'); Link Here
262
INSERT INTO language_descriptions(subtag, type, lang, description)
301
INSERT INTO language_descriptions(subtag, type, lang, description)
263
VALUES( 'he', 'language', 'fr', 'Hébreu');
302
VALUES( 'he', 'language', 'fr', 'Hébreu');
264
303
304
INSERT INTO language_descriptions(subtag, type, lang, description)
305
VALUES( 'he', 'language', 'de', 'Hebräisch');
306
265
-- Hindi
307
-- Hindi
266
INSERT INTO language_subtag_registry( subtag, type, description, added)
308
INSERT INTO language_subtag_registry( subtag, type, description, added)
267
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
309
VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
Lines 278-283 VALUES( 'hi', 'language', 'en', 'Hindi'); Link Here
278
INSERT INTO language_descriptions(subtag, type, lang, description)
320
INSERT INTO language_descriptions(subtag, type, lang, description)
279
VALUES( 'hi', 'language', 'fr', 'Hindi');
321
VALUES( 'hi', 'language', 'fr', 'Hindi');
280
322
323
INSERT INTO language_descriptions(subtag, type, lang, description)
324
VALUES( 'hi', 'language', 'de', 'Hindi');
325
281
-- Hungarian
326
-- Hungarian
282
INSERT INTO language_subtag_registry( subtag, type, description, added)
327
INSERT INTO language_subtag_registry( subtag, type, description, added)
283
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
328
VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
Lines 294-299 VALUES( 'hu', 'language', 'en', 'Hungarian'); Link Here
294
INSERT INTO language_descriptions(subtag, type, lang, description)
339
INSERT INTO language_descriptions(subtag, type, lang, description)
295
VALUES( 'hu', 'language', 'fr', 'Hongrois');
340
VALUES( 'hu', 'language', 'fr', 'Hongrois');
296
341
342
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'hu', 'language', 'de', 'Ungarisch');
344
297
-- Indonesian
345
-- Indonesian
298
INSERT INTO language_subtag_registry( subtag, type, description, added)
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
299
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
347
VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
Lines 310-315 VALUES( 'id', 'language', 'en', 'Indonesian'); Link Here
310
INSERT INTO language_descriptions(subtag, type, lang, description)
358
INSERT INTO language_descriptions(subtag, type, lang, description)
311
VALUES( 'id', 'language', 'fr', 'Indonésien');
359
VALUES( 'id', 'language', 'fr', 'Indonésien');
312
360
361
INSERT INTO language_descriptions(subtag, type, lang, description)
362
VALUES( 'id', 'language', 'de', 'Indonesisch');
363
313
-- Italian
364
-- Italian
314
INSERT INTO language_subtag_registry( subtag, type, description, added)
365
INSERT INTO language_subtag_registry( subtag, type, description, added)
315
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
366
VALUES ( 'it', 'language', 'Italian','2005-10-16' );
Lines 326-331 VALUES( 'it', 'language', 'en', 'Italian'); Link Here
326
INSERT INTO language_descriptions(subtag, type, lang, description)
377
INSERT INTO language_descriptions(subtag, type, lang, description)
327
VALUES( 'it', 'language', 'fr', 'Italien');
378
VALUES( 'it', 'language', 'fr', 'Italien');
328
379
380
INSERT INTO language_descriptions(subtag, type, lang, description)
381
VALUES( 'it', 'language', 'de', 'Italienisch');
382
329
-- Japanese
383
-- Japanese
330
INSERT INTO language_subtag_registry( subtag, type, description, added)
384
INSERT INTO language_subtag_registry( subtag, type, description, added)
331
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
385
VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
Lines 342-347 VALUES( 'ja', 'language', 'en', 'Japanese'); Link Here
342
INSERT INTO language_descriptions(subtag, type, lang, description)
396
INSERT INTO language_descriptions(subtag, type, lang, description)
343
VALUES( 'ja', 'language', 'fr', 'Japonais');
397
VALUES( 'ja', 'language', 'fr', 'Japonais');
344
398
399
INSERT INTO language_descriptions(subtag, type, lang, description)
400
VALUES( 'ja', 'language', 'de', 'Japanisch');
401
345
-- Korean
402
-- Korean
346
INSERT INTO language_subtag_registry( subtag, type, description, added)
403
INSERT INTO language_subtag_registry( subtag, type, description, added)
347
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
404
VALUES ( 'ko', 'language', 'Korean','2005-10-16');
Lines 358-363 VALUES( 'ko', 'language', 'en', 'Korean'); Link Here
358
INSERT INTO language_descriptions(subtag, type, lang, description)
415
INSERT INTO language_descriptions(subtag, type, lang, description)
359
VALUES( 'ko', 'language', 'fr', 'Coréen');
416
VALUES( 'ko', 'language', 'fr', 'Coréen');
360
417
418
INSERT INTO language_descriptions(subtag, type, lang, description)
419
VALUES( 'ko', 'language', 'de', 'Koreanisch');
420
361
-- Latin
421
-- Latin
362
INSERT INTO language_subtag_registry( subtag, type, description, added)
422
INSERT INTO language_subtag_registry( subtag, type, description, added)
363
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
423
VALUES ( 'la', 'language', 'Latin','2005-10-16' );
Lines 374-379 VALUES( 'la', 'language', 'en', 'Latin'); Link Here
374
INSERT INTO language_descriptions(subtag, type, lang, description)
434
INSERT INTO language_descriptions(subtag, type, lang, description)
375
VALUES( 'la', 'language', 'fr', 'Latin');
435
VALUES( 'la', 'language', 'fr', 'Latin');
376
436
437
INSERT INTO language_descriptions(subtag, type, lang, description)
438
VALUES( 'la', 'language', 'de', 'Latein');
439
377
-- Galician
440
-- Galician
378
441
379
INSERT INTO language_subtag_registry( subtag, type, description, added)
442
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 388-393 VALUES( 'gl', 'language', 'gl', 'Galego'); Link Here
388
INSERT INTO language_descriptions(subtag, type, lang, description)
451
INSERT INTO language_descriptions(subtag, type, lang, description)
389
VALUES( 'gl', 'language', 'en', 'Galician');
452
VALUES( 'gl', 'language', 'en', 'Galician');
390
453
454
INSERT INTO language_descriptions(subtag, type, lang, description)
455
VALUES( 'gl', 'language', 'fr', 'Galicien');
456
391
-- Norwegian (bokmål)
457
-- Norwegian (bokmål)
392
INSERT INTO language_subtag_registry( subtag, type, description, added)
458
INSERT INTO language_subtag_registry( subtag, type, description, added)
393
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
459
VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
Lines 407-412 VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); Link Here
407
INSERT INTO language_descriptions(subtag, type, lang, description)
473
INSERT INTO language_descriptions(subtag, type, lang, description)
408
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
474
VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
409
475
476
INSERT INTO language_descriptions(subtag, type, lang, description)
477
VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål');
478
410
-- Norwegian (nynorsk)
479
-- Norwegian (nynorsk)
411
INSERT INTO language_subtag_registry( subtag, type, description, added)
480
INSERT INTO language_subtag_registry( subtag, type, description, added)
412
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
481
VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
Lines 426-431 VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); Link Here
426
INSERT INTO language_descriptions(subtag, type, lang, description)
495
INSERT INTO language_descriptions(subtag, type, lang, description)
427
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
496
VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
428
497
498
INSERT INTO language_descriptions(subtag, type, lang, description)
499
VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk');
500
429
-- Persian
501
-- Persian
430
INSERT INTO language_subtag_registry( subtag, type, description, added)
502
INSERT INTO language_subtag_registry( subtag, type, description, added)
431
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
503
VALUES ( 'fa', 'language', 'Persian','2005-10-16');
Lines 442-447 VALUES( 'fa', 'language', 'en', 'Persian'); Link Here
442
INSERT INTO language_descriptions(subtag, type, lang, description)
514
INSERT INTO language_descriptions(subtag, type, lang, description)
443
VALUES( 'fa', 'language', 'fr', 'Persan');
515
VALUES( 'fa', 'language', 'fr', 'Persan');
444
516
517
INSERT INTO language_descriptions(subtag, type, lang, description)
518
VALUES( 'fa', 'language', 'de', 'Persisch');
519
445
-- Polish
520
-- Polish
446
INSERT INTO language_subtag_registry( subtag, type, description, added)
521
INSERT INTO language_subtag_registry( subtag, type, description, added)
447
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
522
VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
Lines 458-463 VALUES( 'pl', 'language', 'en', 'Polish'); Link Here
458
INSERT INTO language_descriptions(subtag, type, lang, description)
533
INSERT INTO language_descriptions(subtag, type, lang, description)
459
VALUES( 'pl', 'language', 'fr', 'Polonais');
534
VALUES( 'pl', 'language', 'fr', 'Polonais');
460
535
536
INSERT INTO language_descriptions(subtag, type, lang, description)
537
VALUES( 'pl', 'language', 'de', 'Polnisch');
538
461
-- Portuguese
539
-- Portuguese
462
INSERT INTO language_subtag_registry( subtag, type, description, added)
540
INSERT INTO language_subtag_registry( subtag, type, description, added)
463
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
541
VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
Lines 474-479 VALUES( 'pt', 'language', 'en', 'Portuguese'); Link Here
474
INSERT INTO language_descriptions(subtag, type, lang, description)
552
INSERT INTO language_descriptions(subtag, type, lang, description)
475
VALUES( 'pt', 'language', 'fr', 'Portugais');
553
VALUES( 'pt', 'language', 'fr', 'Portugais');
476
554
555
INSERT INTO language_descriptions(subtag, type, lang, description)
556
VALUES( 'pt', 'language', 'de', 'Portugiesisch');
557
477
-- Romanian
558
-- Romanian
478
INSERT INTO language_subtag_registry( subtag, type, description, added)
559
INSERT INTO language_subtag_registry( subtag, type, description, added)
479
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
560
VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
Lines 490-495 VALUES( 'ro', 'language', 'en', 'Romanian'); Link Here
490
INSERT INTO language_descriptions(subtag, type, lang, description)
571
INSERT INTO language_descriptions(subtag, type, lang, description)
491
VALUES( 'ro', 'language', 'fr', 'Roumain');
572
VALUES( 'ro', 'language', 'fr', 'Roumain');
492
573
574
INSERT INTO language_descriptions(subtag, type, lang, description)
575
VALUES( 'ro', 'language', 'de', 'Rumänisch');
576
493
-- Russian
577
-- Russian
494
INSERT INTO language_subtag_registry( subtag, type, description, added)
578
INSERT INTO language_subtag_registry( subtag, type, description, added)
495
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
579
VALUES ( 'ru', 'language', 'Russian','2005-10-16');
Lines 506-511 VALUES( 'ru', 'language', 'en', 'Russian'); Link Here
506
INSERT INTO language_descriptions(subtag, type, lang, description)
590
INSERT INTO language_descriptions(subtag, type, lang, description)
507
VALUES( 'ru', 'language', 'fr', 'Russe');
591
VALUES( 'ru', 'language', 'fr', 'Russe');
508
592
593
INSERT INTO language_descriptions(subtag, type, lang, description)
594
VALUES( 'ru', 'language', 'de', 'Russisch');
595
509
-- Serbian
596
-- Serbian
510
INSERT INTO language_subtag_registry( subtag, type, description, added)
597
INSERT INTO language_subtag_registry( subtag, type, description, added)
511
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
598
VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
Lines 519-524 VALUES( 'sr', 'language', 'sr', 'српски'); Link Here
519
INSERT INTO language_descriptions(subtag, type, lang, description)
606
INSERT INTO language_descriptions(subtag, type, lang, description)
520
VALUES( 'sr', 'language', 'en', 'Serbian');
607
VALUES( 'sr', 'language', 'en', 'Serbian');
521
608
609
INSERT INTO language_descriptions(subtag, type, lang, description)
610
VALUES( 'sr', 'language', 'fr', 'Serbe');
611
612
INSERT INTO language_descriptions(subtag, type, lang, description)
613
VALUES( 'sr', 'language', 'de', 'Serbisch');
614
522
-- Spanish, Castilian
615
-- Spanish, Castilian
523
INSERT INTO language_subtag_registry( subtag, type, description, added)
616
INSERT INTO language_subtag_registry( subtag, type, description, added)
524
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
617
VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
Lines 535-540 VALUES( 'es', 'language', 'en', 'Spanish'); Link Here
535
INSERT INTO language_descriptions(subtag, type, lang, description)
628
INSERT INTO language_descriptions(subtag, type, lang, description)
536
VALUES( 'es', 'language', 'fr', 'Espagnol');
629
VALUES( 'es', 'language', 'fr', 'Espagnol');
537
630
631
INSERT INTO language_descriptions(subtag, type, lang, description)
632
VALUES( 'es', 'language', 'de', 'Spanisch');
633
538
-- Swedish
634
-- Swedish
539
INSERT INTO language_subtag_registry( subtag, type, description, added)
635
INSERT INTO language_subtag_registry( subtag, type, description, added)
540
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
636
VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
Lines 551-556 VALUES( 'sv', 'language', 'en', 'Swedish'); Link Here
551
INSERT INTO language_descriptions(subtag, type, lang, description)
647
INSERT INTO language_descriptions(subtag, type, lang, description)
552
VALUES( 'sv', 'language', 'fr', 'Suédois');
648
VALUES( 'sv', 'language', 'fr', 'Suédois');
553
649
650
INSERT INTO language_descriptions(subtag, type, lang, description)
651
VALUES( 'sv', 'language', 'de', 'Schwedisch');
652
554
-- Tetum
653
-- Tetum
555
INSERT INTO language_subtag_registry( subtag, type, description, added)
654
INSERT INTO language_subtag_registry( subtag, type, description, added)
556
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
655
VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
Lines 564-569 VALUES( 'tet', 'language', 'tet', 'tetun'); Link Here
564
INSERT INTO language_descriptions(subtag, type, lang, description)
663
INSERT INTO language_descriptions(subtag, type, lang, description)
565
VALUES( 'tet', 'language', 'en', 'Tetum');
664
VALUES( 'tet', 'language', 'en', 'Tetum');
566
665
666
INSERT INTO language_descriptions(subtag, type, lang, description)
667
VALUES( 'tet', 'language', 'fr', 'Tétoum');
668
669
INSERT INTO language_descriptions(subtag, type, lang, description)
670
VALUES( 'tet', 'language', 'de', 'Tetum');
671
567
-- Thai
672
-- Thai
568
INSERT INTO language_subtag_registry( subtag, type, description, added)
673
INSERT INTO language_subtag_registry( subtag, type, description, added)
569
VALUES ( 'th', 'language', 'Thai','2005-10-16');
674
VALUES ( 'th', 'language', 'Thai','2005-10-16');
Lines 580-585 VALUES( 'th', 'language', 'en', 'Thai'); Link Here
580
INSERT INTO language_descriptions(subtag, type, lang, description)
685
INSERT INTO language_descriptions(subtag, type, lang, description)
581
VALUES( 'th', 'language', 'fr', 'Thaï');
686
VALUES( 'th', 'language', 'fr', 'Thaï');
582
687
688
INSERT INTO language_descriptions(subtag, type, lang, description)
689
VALUES( 'th', 'language', 'de', 'Thailändisch');
690
583
-- Turkish
691
-- Turkish
584
INSERT INTO language_subtag_registry( subtag, type, description, added)
692
INSERT INTO language_subtag_registry( subtag, type, description, added)
585
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
693
VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
Lines 596-601 VALUES( 'tr', 'language', 'en', 'Turkish'); Link Here
596
INSERT INTO language_descriptions(subtag, type, lang, description)
704
INSERT INTO language_descriptions(subtag, type, lang, description)
597
VALUES( 'tr', 'language', 'fr', 'Turc');
705
VALUES( 'tr', 'language', 'fr', 'Turc');
598
706
707
INSERT INTO language_descriptions(subtag, type, lang, description)
708
VALUES( 'tr', 'language', 'de', 'Türkisch');
599
709
600
-- Ukranian
710
-- Ukranian
601
INSERT INTO language_subtag_registry( subtag, type, description, added)
711
INSERT INTO language_subtag_registry( subtag, type, description, added)
Lines 613-618 VALUES( 'uk', 'language', 'en', 'Ukranian'); Link Here
613
INSERT INTO language_descriptions(subtag, type, lang, description)
723
INSERT INTO language_descriptions(subtag, type, lang, description)
614
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
724
VALUES( 'uk', 'language', 'fr', 'Ukrainien');
615
725
726
INSERT INTO language_descriptions(subtag, type, lang, description)
727
VALUES( 'uk', 'language', 'de', 'Ukrainisch');
728
616
-- Urdu
729
-- Urdu
617
INSERT INTO language_subtag_registry( subtag, type, description, added)
730
INSERT INTO language_subtag_registry( subtag, type, description, added)
618
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
731
VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
Lines 626-631 VALUES( 'ur', 'language', 'en', 'Urdu'); Link Here
626
INSERT INTO language_descriptions(subtag, type, lang, description)
739
INSERT INTO language_descriptions(subtag, type, lang, description)
627
VALUES( 'ur', 'language', 'ur', 'اردو');
740
VALUES( 'ur', 'language', 'ur', 'اردو');
628
741
742
INSERT INTO language_descriptions(subtag, type, lang, description)
743
VALUES( 'ur', 'language', 'fr', 'Ourdou');
744
745
INSERT INTO language_descriptions(subtag, type, lang, description)
746
VALUES( 'ur', 'language', 'de', 'Urdu');
747
629
-- SCRIPTS
748
-- SCRIPTS
630
-- Arabic
749
-- Arabic
631
INSERT INTO language_subtag_registry( subtag, type, description, added)
750
INSERT INTO language_subtag_registry( subtag, type, description, added)
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +47 lines)
Lines 6131-6136 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
6131
        UPDATE virtualshelves SET sortfield="copyrightdate" where sortfield="year";
6131
        UPDATE virtualshelves SET sortfield="copyrightdate" where sortfield="year";
6132
    });
6132
    });
6133
    print "Upgrade to $DBversion done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed)\n";
6133
    print "Upgrade to $DBversion done (Bug 9167: Update the virtualshelves.sortfield column with 'copyrightdate' if needed)\n";
6134
    SetVersion($DBversion);
6135
}
6136
6137
$DBversion = "XXX";
6138
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
6139
    print "Upgrade to $DBversion done (Bug 9056: add German and a couple of French translations to language_descriptions";
6140
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ar', 'language', 'de', 'Arabisch')");
6141
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hy', 'language', 'de', 'Armenisch')");
6142
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'bg', 'language', 'de', 'Bulgarisch')");
6143
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'zh', 'language', 'de', 'Chinesisch')");
6144
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'cs', 'language', 'de', 'Tschechisch')");
6145
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'da', 'language', 'de', 'Dänisch')");
6146
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nl', 'language', 'de', 'Niederländisch')");
6147
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'en', 'language', 'de', 'Englisch')");
6148
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fi', 'language', 'de', 'Finnisch')");
6149
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fr', 'language', 'de', 'Französisch')");
6150
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'lo', 'language', 'fr', 'Laotien')");
6151
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'lo', 'language', 'de', 'Laotisch')");
6152
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)')");
6153
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'he', 'language', 'de', 'Hebräisch')");
6154
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hi', 'language', 'de', 'Hindi')");
6155
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'hu', 'language', 'de', 'Ungarisch')");
6156
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'id', 'language', 'de', 'Indonesisch')");
6157
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'it', 'language', 'de', 'Italienisch')");
6158
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ja', 'language', 'de', 'Japanisch')");
6159
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ko', 'language', 'de', 'Koreanisch')");
6160
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'la', 'language', 'de', 'Latein')");
6161
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'gl', 'language', 'fr', 'Galicien')");
6162
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'gl', 'language', 'de', 'Galizisch')");
6163
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nb', 'language', 'de', 'Norwegisch bokm&#229;l')");
6164
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk')");
6165
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'fa', 'language', 'de', 'Persisch')");
6166
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'pl', 'language', 'de', 'Polnisch')");
6167
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'pt', 'language', 'de', 'Portugiesisch')");
6168
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ro', 'language', 'de', 'Rumänisch')");
6169
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ru', 'language', 'de', 'Russisch')");
6170
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sr', 'language', 'fr', 'Serbe')");
6171
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sr', 'language', 'de', 'Serbisch')");
6172
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'es', 'language', 'de', 'Spanisch')");
6173
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'sv', 'language', 'de', 'Schwedisch')");
6174
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tet', 'language', 'fr', 'Tétoum')");
6175
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tet', 'language', 'de', 'Tetum')");
6176
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'th', 'language', 'de', 'Thailändisch')");
6177
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'tr', 'language', 'de', 'Türkisch')");
6178
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'uk', 'language', 'de', 'Ukrainisch')");
6179
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ur', 'language', 'fr', 'Ourdou')");
6180
    $dbh->do("INSERT INTO language_descriptions (subtag, type, lang, description) VALUES( 'ur', 'language', 'de', 'Urdu')");
6134
    SetVersion ($DBversion);
6181
    SetVersion ($DBversion);
6135
}
6182
}
6136
6183
6137
- 

Return to bug 9056