1 SET FOREIGN_KEY_CHECKS=0;
3 -- http://www.w3.org/International/articles/language-tags/
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');
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');
19 -- SELECT * FROM language_subtag_registry WHERE type='i';
21 INSERT INTO language_subtag_registry( subtag, type, description, added)
22 VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
24 INSERT INTO language_descriptions(subtag, type, lang, description)
25 VALUES( 'opac', 'i', 'en', 'OPAC');
27 INSERT INTO language_descriptions(subtag, type, lang, description)
28 VALUES( 'opac', 'i', 'fr', 'OPAC');
31 INSERT INTO language_subtag_registry( subtag, type, description, added)
32 VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
34 INSERT INTO language_descriptions(subtag, type, lang, description)
35 VALUES( 'intranet', 'i', 'en', 'Staff Client');
37 INSERT INTO language_descriptions(subtag, type, lang, description)
38 VALUES( 'intranet', 'i', 'fr', '????');
41 INSERT INTO language_subtag_registry( subtag, type, description, added)
42 VALUES ( 'prog', 't', 'Prog','2005-10-16');
44 INSERT INTO language_descriptions(subtag, type, lang, description)
45 VALUES( 'prog', 't', 'en', 'Prog');
47 INSERT INTO language_descriptions(subtag, type, lang, description)
48 VALUES( 'prog', 't', 'fr', 'Prog');
53 INSERT INTO language_subtag_registry( subtag, type, description, added)
54 VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
56 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
59 INSERT INTO language_descriptions(subtag, type, lang, description)
60 VALUES ( 'ar', 'language', 'ar', 'العربية');
62 INSERT INTO language_descriptions(subtag, type, lang, description)
63 VALUES( 'ar', 'language', 'en', 'Arabic');
65 INSERT INTO language_descriptions(subtag, type, lang, description)
66 VALUES( 'ar', 'language', 'fr', 'Arabe');
69 INSERT INTO language_subtag_registry( subtag, type, description, added)
70 VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
72 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
75 INSERT INTO language_descriptions(subtag, type, lang, description)
76 VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
78 INSERT INTO language_descriptions(subtag, type, lang, description)
79 VALUES( 'hy', 'language', 'en', 'Armenian');
81 INSERT INTO language_descriptions(subtag, type, lang, description)
82 VALUES( 'hy', 'language', 'fr', 'Armenian');
85 INSERT INTO language_subtag_registry( subtag, type, description, added)
86 VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
88 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
91 INSERT INTO language_descriptions(subtag, type, lang, description)
92 VALUES ( 'bg', 'language', 'bg', 'Български');
94 INSERT INTO language_descriptions(subtag, type, lang, description)
95 VALUES( 'bg', 'language', 'en', 'Bulgarian');
97 INSERT INTO language_descriptions(subtag, type, lang, description)
98 VALUES( 'bg', 'language', 'fr', 'Bulgare');
101 INSERT INTO language_subtag_registry( subtag, type, description, added)
102 VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
104 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
107 INSERT INTO language_descriptions(subtag, type, lang, description)
108 VALUES ( 'zh', 'language', 'zh', '中文');
110 INSERT INTO language_descriptions(subtag, type, lang, description)
111 VALUES( 'zh', 'language', 'en', 'Chinese');
113 INSERT INTO language_descriptions(subtag, type, lang, description)
114 VALUES( 'zh', 'language', 'fr', 'Chinois');
117 INSERT INTO language_subtag_registry( subtag, type, description, added)
118 VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
120 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
123 INSERT INTO language_descriptions(subtag, type, lang, description)
124 VALUES ( 'cs', 'language', 'cs', 'čeština');
126 INSERT INTO language_descriptions(subtag, type, lang, description)
127 VALUES( 'cs', 'language', 'en', 'Czech');
129 INSERT INTO language_descriptions(subtag, type, lang, description)
130 VALUES( 'cs', 'language', 'fr', 'Tchèque');
133 INSERT INTO language_subtag_registry( subtag, type, description, added)
134 VALUES ( 'da', 'language', 'Danish','2005-10-16' );
136 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
139 INSERT INTO language_descriptions(subtag, type, lang, description)
140 VALUES ( 'da', 'language', 'da', 'Dansk');
142 INSERT INTO language_descriptions(subtag, type, lang, description)
143 VALUES( 'da', 'language', 'en', 'Danish');
145 INSERT INTO language_descriptions(subtag, type, lang, description)
146 VALUES( 'da', 'language', 'fr', 'Danois');
149 INSERT INTO language_subtag_registry( subtag, type, description, added)
150 VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
152 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
155 INSERT INTO language_descriptions(subtag, type, lang, description)
156 VALUES ( 'nl', 'language', 'nl', 'Nederlands');
158 INSERT INTO language_descriptions(subtag, type, lang, description)
159 VALUES( 'nl', 'language', 'en', 'Dutch');
161 INSERT INTO language_descriptions(subtag, type, lang, description)
162 VALUES( 'nl', 'language', 'fr', 'Néerlandais');
165 INSERT INTO language_subtag_registry( subtag, type, description, added)
166 VALUES ( 'en', 'language', 'English','2005-10-16' );
168 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
171 INSERT INTO language_descriptions(subtag, type, lang, description)
172 VALUES( 'en', 'language', 'en', 'English');
174 INSERT INTO language_descriptions(subtag, type, lang, description)
175 VALUES( 'en', 'language', 'fr', 'Anglais');
178 INSERT INTO language_subtag_registry( subtag, type, description, added)
179 VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
181 INSERT INTO language_descriptions(subtag, type, lang, description)
182 VALUES( 'fi', 'language', 'fi', 'suomi');
184 INSERT INTO language_descriptions(subtag, type, lang, description)
185 VALUES( 'fi', 'language', 'en', 'Finnish');
188 INSERT INTO language_subtag_registry( subtag, type, description, added)
189 VALUES ( 'fr', 'language', 'French','2005-10-16' );
191 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
194 INSERT INTO language_descriptions(subtag, type, lang, description)
195 VALUES( 'fr', 'language', 'en', 'French');
197 INSERT INTO language_descriptions(subtag, type, lang, description)
198 VALUES( 'fr', 'language', 'fr', 'Français');
200 -- INSERT INTO language_descriptions(subtag, type, lang, description)
201 -- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
204 INSERT INTO language_subtag_registry( subtag, type, description, added)
205 VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
207 -- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
208 -- VALUES( 'lo','nor'); ???
210 INSERT INTO language_descriptions(subtag, type, lang, description)
211 VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
213 INSERT INTO language_descriptions(subtag, type, lang, description)
214 VALUES( 'lo', 'language', 'en', 'Lao');
217 INSERT INTO language_subtag_registry( subtag, type, description, added)
218 VALUES ( 'de', 'language', 'German','2005-10-16' );
220 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
223 INSERT INTO language_descriptions(subtag, type, lang, description)
224 VALUES( 'de', 'language', 'de', 'Deutsch');
226 INSERT INTO language_descriptions(subtag, type, lang, description)
227 VALUES( 'de', 'language', 'en', 'German');
229 INSERT INTO language_descriptions(subtag, type, lang, description)
230 VALUES( 'de', 'language', 'fr', 'Allemand');
233 INSERT INTO language_subtag_registry( subtag, type, description, added)
234 VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
236 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
239 INSERT INTO language_descriptions(subtag, type, lang, description)
240 VALUES( 'el', 'language', 'el', 'ελληνικά');
242 INSERT INTO language_descriptions(subtag, type, lang, description)
243 VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
245 INSERT INTO language_descriptions(subtag, type, lang, description)
246 VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
249 INSERT INTO language_subtag_registry( subtag, type, description, added)
250 VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
252 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
255 INSERT INTO language_descriptions(subtag, type, lang, description)
256 VALUES( 'he', 'language', 'he', 'עברית');
258 INSERT INTO language_descriptions(subtag, type, lang, description)
259 VALUES( 'he', 'language', 'en', 'Hebrew');
261 INSERT INTO language_descriptions(subtag, type, lang, description)
262 VALUES( 'he', 'language', 'fr', 'Hébreu');
265 INSERT INTO language_subtag_registry( subtag, type, description, added)
266 VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
268 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
271 INSERT INTO language_descriptions(subtag, type, lang, description)
272 VALUES( 'hi', 'language', 'hi', 'हिन्दी');
274 INSERT INTO language_descriptions(subtag, type, lang, description)
275 VALUES( 'hi', 'language', 'en', 'Hindi');
277 INSERT INTO language_descriptions(subtag, type, lang, description)
278 VALUES( 'hi', 'language', 'fr', 'Hindi');
281 INSERT INTO language_subtag_registry( subtag, type, description, added)
282 VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
284 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
287 INSERT INTO language_descriptions(subtag, type, lang, description)
288 VALUES( 'hu', 'language', 'hu', 'Magyar');
290 INSERT INTO language_descriptions(subtag, type, lang, description)
291 VALUES( 'hu', 'language', 'en', 'Hungarian');
293 INSERT INTO language_descriptions(subtag, type, lang, description)
294 VALUES( 'hu', 'language', 'fr', 'Hongrois');
297 INSERT INTO language_subtag_registry( subtag, type, description, added)
298 VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
300 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
303 INSERT INTO language_descriptions(subtag, type, lang, description)
304 VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
306 INSERT INTO language_descriptions(subtag, type, lang, description)
307 VALUES( 'id', 'language', 'en', 'Indonesian');
309 INSERT INTO language_descriptions(subtag, type, lang, description)
310 VALUES( 'id', 'language', 'fr', 'Indonésien');
313 INSERT INTO language_subtag_registry( subtag, type, description, added)
314 VALUES ( 'it', 'language', 'Italian','2005-10-16' );
316 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
319 INSERT INTO language_descriptions(subtag, type, lang, description)
320 VALUES( 'it', 'language', 'it', 'Italiano');
322 INSERT INTO language_descriptions(subtag, type, lang, description)
323 VALUES( 'it', 'language', 'en', 'Italian');
325 INSERT INTO language_descriptions(subtag, type, lang, description)
326 VALUES( 'it', 'language', 'fr', 'Italien');
329 INSERT INTO language_subtag_registry( subtag, type, description, added)
330 VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
332 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
335 INSERT INTO language_descriptions(subtag, type, lang, description)
336 VALUES( 'ja', 'language', 'ja', '日本語');
338 INSERT INTO language_descriptions(subtag, type, lang, description)
339 VALUES( 'ja', 'language', 'en', 'Japanese');
341 INSERT INTO language_descriptions(subtag, type, lang, description)
342 VALUES( 'ja', 'language', 'fr', 'Japonais');
345 INSERT INTO language_subtag_registry( subtag, type, description, added)
346 VALUES ( 'ko', 'language', 'Korean','2005-10-16');
348 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
351 INSERT INTO language_descriptions(subtag, type, lang, description)
352 VALUES( 'ko', 'language', 'ko', '한국어');
354 INSERT INTO language_descriptions(subtag, type, lang, description)
355 VALUES( 'ko', 'language', 'en', 'Korean');
357 INSERT INTO language_descriptions(subtag, type, lang, description)
358 VALUES( 'ko', 'language', 'fr', 'Coréen');
361 INSERT INTO language_subtag_registry( subtag, type, description, added)
362 VALUES ( 'la', 'language', 'Latin','2005-10-16' );
364 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
367 INSERT INTO language_descriptions(subtag, type, lang, description)
368 VALUES( 'la', 'language', 'la', 'Latina');
370 INSERT INTO language_descriptions(subtag, type, lang, description)
371 VALUES( 'la', 'language', 'en', 'Latin');
373 INSERT INTO language_descriptions(subtag, type, lang, description)
374 VALUES( 'la', 'language', 'fr', 'Latin');
378 INSERT INTO language_subtag_registry( subtag, type, description, added)
379 VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
381 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
384 INSERT INTO language_descriptions(subtag, type, lang, description)
385 VALUES( 'gl', 'language', 'gl', 'Galego');
387 INSERT INTO language_descriptions(subtag, type, lang, description)
388 VALUES( 'gl', 'language', 'en', 'Galician');
390 -- Norwegian (bokmål)
391 INSERT INTO language_subtag_registry( subtag, type, description, added)
392 VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
394 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
397 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
400 INSERT INTO language_descriptions(subtag, type, lang, description)
401 VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
403 INSERT INTO language_descriptions(subtag, type, lang, description)
404 VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
406 INSERT INTO language_descriptions(subtag, type, lang, description)
407 VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
409 -- Norwegian (nynorsk)
410 INSERT INTO language_subtag_registry( subtag, type, description, added)
411 VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
413 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
416 INSERT INTO language_descriptions(subtag, type, lang, description)
417 VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
419 INSERT INTO language_descriptions(subtag, type, lang, description)
420 VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
422 INSERT INTO language_descriptions(subtag, type, lang, description)
423 VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
425 INSERT INTO language_descriptions(subtag, type, lang, description)
426 VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
429 INSERT INTO language_subtag_registry( subtag, type, description, added)
430 VALUES ( 'fa', 'language', 'Persian','2005-10-16');
432 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
435 INSERT INTO language_descriptions(subtag, type, lang, description)
436 VALUES( 'fa', 'language', 'fa', 'فارسى');
438 INSERT INTO language_descriptions(subtag, type, lang, description)
439 VALUES( 'fa', 'language', 'en', 'Persian');
441 INSERT INTO language_descriptions(subtag, type, lang, description)
442 VALUES( 'fa', 'language', 'fr', 'Persan');
445 INSERT INTO language_subtag_registry( subtag, type, description, added)
446 VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
448 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
451 INSERT INTO language_descriptions(subtag, type, lang, description)
452 VALUES( 'pl', 'language', 'pl', 'Polski');
454 INSERT INTO language_descriptions(subtag, type, lang, description)
455 VALUES( 'pl', 'language', 'en', 'Polish');
457 INSERT INTO language_descriptions(subtag, type, lang, description)
458 VALUES( 'pl', 'language', 'fr', 'Polonais');
461 INSERT INTO language_subtag_registry( subtag, type, description, added)
462 VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
464 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
467 INSERT INTO language_descriptions(subtag, type, lang, description)
468 VALUES( 'pt', 'language', 'pt', 'Português');
470 INSERT INTO language_descriptions(subtag, type, lang, description)
471 VALUES( 'pt', 'language', 'en', 'Portuguese');
473 INSERT INTO language_descriptions(subtag, type, lang, description)
474 VALUES( 'pt', 'language', 'fr', 'Portugais');
477 INSERT INTO language_subtag_registry( subtag, type, description, added)
478 VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
480 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
483 INSERT INTO language_descriptions(subtag, type, lang, description)
484 VALUES( 'ro', 'language', 'ro', 'Română');
486 INSERT INTO language_descriptions(subtag, type, lang, description)
487 VALUES( 'ro', 'language', 'en', 'Romanian');
489 INSERT INTO language_descriptions(subtag, type, lang, description)
490 VALUES( 'ro', 'language', 'fr', 'Roumain');
493 INSERT INTO language_subtag_registry( subtag, type, description, added)
494 VALUES ( 'ru', 'language', 'Russian','2005-10-16');
496 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
499 INSERT INTO language_descriptions(subtag, type, lang, description)
500 VALUES( 'ru', 'language', 'ru', 'Русский');
502 INSERT INTO language_descriptions(subtag, type, lang, description)
503 VALUES( 'ru', 'language', 'en', 'Russian');
505 INSERT INTO language_descriptions(subtag, type, lang, description)
506 VALUES( 'ru', 'language', 'fr', 'Russe');
509 INSERT INTO language_subtag_registry( subtag, type, description, added)
510 VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
512 INSERT INTO language_descriptions(subtag, type, lang, description)
513 VALUES( 'sr', 'language', 'sr', 'српски');
515 INSERT INTO language_descriptions(subtag, type, lang, description)
516 VALUES( 'sr', 'language', 'en', 'Serbian');
518 -- Spanish, Castilian
519 INSERT INTO language_subtag_registry( subtag, type, description, added)
520 VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
522 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
525 INSERT INTO language_descriptions(subtag, type, lang, description)
526 VALUES( 'es', 'language', 'es', 'Español');
528 INSERT INTO language_descriptions(subtag, type, lang, description)
529 VALUES( 'es', 'language', 'en', 'Spanish');
531 INSERT INTO language_descriptions(subtag, type, lang, description)
532 VALUES( 'es', 'language', 'fr', 'Espagnol');
535 INSERT INTO language_subtag_registry( subtag, type, description, added)
536 VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
538 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
541 INSERT INTO language_descriptions(subtag, type, lang, description)
542 VALUES( 'sv', 'language', 'sv', 'Svenska');
544 INSERT INTO language_descriptions(subtag, type, lang, description)
545 VALUES( 'sv', 'language', 'en', 'Swedish');
547 INSERT INTO language_descriptions(subtag, type, lang, description)
548 VALUES( 'sv', 'language', 'fr', 'Suédois');
551 INSERT INTO language_subtag_registry( subtag, type, description, added)
552 VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
554 INSERT INTO language_descriptions(subtag, type, lang, description)
555 VALUES( 'tet', 'language', 'tet', 'tetun');
557 INSERT INTO language_descriptions(subtag, type, lang, description)
558 VALUES( 'tet', 'language', 'en', 'Tetum');
561 INSERT INTO language_subtag_registry( subtag, type, description, added)
562 VALUES ( 'th', 'language', 'Thai','2005-10-16');
564 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
567 INSERT INTO language_descriptions(subtag, type, lang, description)
568 VALUES( 'th', 'language', 'th', 'ภาษาไทย');
570 INSERT INTO language_descriptions(subtag, type, lang, description)
571 VALUES( 'th', 'language', 'en', 'Thai');
573 INSERT INTO language_descriptions(subtag, type, lang, description)
574 VALUES( 'th', 'language', 'fr', 'Thaï');
577 INSERT INTO language_subtag_registry( subtag, type, description, added)
578 VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
580 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
583 INSERT INTO language_descriptions(subtag, type, lang, description)
584 VALUES( 'tr', 'language', 'tr', 'Türkçe');
586 INSERT INTO language_descriptions(subtag, type, lang, description)
587 VALUES( 'tr', 'language', 'en', 'Turkish');
589 INSERT INTO language_descriptions(subtag, type, lang, description)
590 VALUES( 'tr', 'language', 'fr', 'Turc');
594 INSERT INTO language_subtag_registry( subtag, type, description, added)
595 VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
597 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
600 INSERT INTO language_descriptions(subtag, type, lang, description)
601 VALUES( 'uk', 'language', 'uk', 'Українська');
603 INSERT INTO language_descriptions(subtag, type, lang, description)
604 VALUES( 'uk', 'language', 'en', 'Ukranian');
606 INSERT INTO language_descriptions(subtag, type, lang, description)
607 VALUES( 'uk', 'language', 'fr', 'Ukrainien');
610 INSERT INTO language_subtag_registry( subtag, type, description, added)
611 VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
613 INSERT INTO language_descriptions(subtag, type, lang, description)
614 VALUES( 'ur', 'language', 'en', 'Urdu');
616 INSERT INTO language_descriptions(subtag, type, lang, description)
617 VALUES( 'ur', 'language', 'ur', 'اردو');
621 INSERT INTO language_subtag_registry( subtag, type, description, added)
622 VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
624 INSERT INTO language_descriptions(subtag, type, lang, description)
625 VALUES ( 'Arab','script', 'Arab', 'العربية');
627 INSERT INTO language_descriptions(subtag, type, lang, description)
628 VALUES( 'Arab', 'script','en', 'Arabic');
630 INSERT INTO language_descriptions(subtag, type, lang, description)
631 VALUES( 'Arab', 'script','fr', 'Arabic');
634 INSERT INTO language_subtag_registry( subtag, type, description, added)
635 VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
637 INSERT INTO language_descriptions(subtag, type, lang, description)
638 VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
640 INSERT INTO language_descriptions(subtag, type, lang, description)
641 VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
643 INSERT INTO language_descriptions(subtag, type, lang, description)
644 VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
647 INSERT INTO language_subtag_registry( subtag, type, description, added)
648 VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
650 INSERT INTO language_descriptions(subtag, type, lang, description)
651 VALUES ( 'Grek', 'script', 'Grek', '????');
653 INSERT INTO language_descriptions(subtag, type, lang, description)
654 VALUES( 'Grek', 'script', 'en', 'Greek');
656 INSERT INTO language_descriptions(subtag, type, lang, description)
657 VALUES( 'Grek', 'script', 'fr', 'Greek');
660 INSERT INTO language_subtag_registry( subtag, type, description, added)
661 VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
663 INSERT INTO language_descriptions(subtag, type, lang, description)
664 VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
666 INSERT INTO language_descriptions(subtag, type, lang, description)
667 VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
669 INSERT INTO language_descriptions(subtag, type, lang, description)
670 VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
673 INSERT INTO language_subtag_registry( subtag, type, description, added)
674 VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
676 INSERT INTO language_descriptions(subtag, type, lang, description)
677 VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
679 INSERT INTO language_descriptions(subtag, type, lang, description)
680 VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
683 INSERT INTO language_subtag_registry( subtag, type, description, added)
684 VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
686 INSERT INTO language_descriptions(subtag, type, lang, description)
687 VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
689 INSERT INTO language_descriptions(subtag, type, lang, description)
690 VALUES( 'Hebr', 'script', 'en', 'Hebrew');
693 INSERT INTO language_subtag_registry( subtag, type, description, added)
694 VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
696 INSERT INTO language_descriptions(subtag, type, lang, description)
697 VALUES ( 'Laoo', 'script', 'lo', 'Lao');
699 INSERT INTO language_descriptions(subtag, type, lang, description)
700 VALUES( 'Laoo', 'script', 'en', 'Lao');
704 INSERT INTO language_subtag_registry( subtag, type, description, added)
705 VALUES ( 'CA', 'region', 'Canada','2005-10-16');
707 INSERT INTO language_descriptions(subtag, type, lang, description)
708 VALUES( 'CA', 'region', 'en', 'Canada');
711 INSERT INTO language_subtag_registry( subtag, type, description, added)
712 VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
714 INSERT INTO language_descriptions(subtag, type, lang, description)
715 VALUES( 'DK', 'region', 'dk', 'Danmark');
718 INSERT INTO language_subtag_registry( subtag, type, description, added)
719 VALUES ( 'FR', 'region', 'France','2005-10-16');
721 INSERT INTO language_descriptions(subtag, type, lang, description)
722 VALUES ( 'FR', 'region', 'fr', 'France');
724 INSERT INTO language_descriptions(subtag, type, lang, description)
725 VALUES( 'FR', 'region', 'en', 'France');
728 INSERT INTO language_subtag_registry( subtag, type, description, added)
729 VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
731 INSERT INTO language_descriptions(subtag, type, lang, description)
732 VALUES( 'NZ', 'region', 'en', 'New Zealand');
735 INSERT INTO language_subtag_registry( subtag, type, description, added)
736 VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
738 INSERT INTO language_descriptions(subtag, type, lang, description)
739 VALUES( 'GB', 'region', 'en', 'United Kingdom');
742 INSERT INTO language_subtag_registry( subtag, type, description, added)
743 VALUES ( 'US', 'region', 'United States','2005-10-16');
745 INSERT INTO language_descriptions(subtag, type, lang, description)
746 VALUES( 'US', 'region', 'en', 'United States');
748 SET FOREIGN_KEY_CHECKS=1;