2 -- Default classification sources and filing rules
5 -- Copyright (C) 2008 LibLime
7 -- This file is part of Koha.
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
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.
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.
22 -- http://www.w3.org/International/articles/language-tags/
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');
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');
38 -- SELECT * FROM language_subtag_registry WHERE type='i';
40 INSERT INTO language_subtag_registry( subtag, type, description, added)
41 VALUES ( 'opac', 'i', 'OPAC','2005-10-16');
43 INSERT INTO language_descriptions(subtag, type, lang, description)
44 VALUES( 'opac', 'i', 'en', 'OPAC');
46 INSERT INTO language_descriptions(subtag, type, lang, description)
47 VALUES( 'opac', 'i', 'fr', 'OPAC');
50 INSERT INTO language_subtag_registry( subtag, type, description, added)
51 VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16');
53 INSERT INTO language_descriptions(subtag, type, lang, description)
54 VALUES( 'intranet', 'i', 'en', 'Staff Client');
56 INSERT INTO language_descriptions(subtag, type, lang, description)
57 VALUES( 'intranet', 'i', 'fr', '????');
60 INSERT INTO language_subtag_registry( subtag, type, description, added)
61 VALUES ( 'prog', 't', 'Prog','2005-10-16');
63 INSERT INTO language_descriptions(subtag, type, lang, description)
64 VALUES( 'prog', 't', 'en', 'Prog');
66 INSERT INTO language_descriptions(subtag, type, lang, description)
67 VALUES( 'prog', 't', 'fr', 'Prog');
72 INSERT INTO language_subtag_registry( subtag, type, description, added)
73 VALUES ( 'ar', 'language', 'Arabic','2005-10-16');
75 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
78 INSERT INTO language_descriptions(subtag, type, lang, description)
79 VALUES ( 'ar', 'language', 'ar', 'العربية');
81 INSERT INTO language_descriptions(subtag, type, lang, description)
82 VALUES( 'ar', 'language', 'en', 'Arabic');
84 INSERT INTO language_descriptions(subtag, type, lang, description)
85 VALUES( 'ar', 'language', 'fr', 'Arabe');
88 INSERT INTO language_subtag_registry( subtag, type, description, added)
89 VALUES ( 'hy', 'language', 'Armenian','2005-10-16');
91 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
94 INSERT INTO language_descriptions(subtag, type, lang, description)
95 VALUES ( 'hy', 'language', 'hy', 'Հայերէն');
97 INSERT INTO language_descriptions(subtag, type, lang, description)
98 VALUES( 'hy', 'language', 'en', 'Armenian');
100 INSERT INTO language_descriptions(subtag, type, lang, description)
101 VALUES( 'hy', 'language', 'fr', 'Armenian');
104 INSERT INTO language_subtag_registry( subtag, type, description, added)
105 VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16');
107 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
110 INSERT INTO language_descriptions(subtag, type, lang, description)
111 VALUES ( 'bg', 'language', 'bg', 'Български');
113 INSERT INTO language_descriptions(subtag, type, lang, description)
114 VALUES( 'bg', 'language', 'en', 'Bulgarian');
116 INSERT INTO language_descriptions(subtag, type, lang, description)
117 VALUES( 'bg', 'language', 'fr', 'Bulgare');
120 INSERT INTO language_subtag_registry( subtag, type, description, added)
121 VALUES ( 'zh', 'language', 'Chinese','2005-10-16');
123 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
126 INSERT INTO language_descriptions(subtag, type, lang, description)
127 VALUES ( 'zh', 'language', 'zh', '中文');
129 INSERT INTO language_descriptions(subtag, type, lang, description)
130 VALUES( 'zh', 'language', 'en', 'Chinese');
132 INSERT INTO language_descriptions(subtag, type, lang, description)
133 VALUES( 'zh', 'language', 'fr', 'Chinois');
136 INSERT INTO language_subtag_registry( subtag, type, description, added)
137 VALUES ( 'cs', 'language', 'Czech','2005-10-16' );
139 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
142 INSERT INTO language_descriptions(subtag, type, lang, description)
143 VALUES ( 'cs', 'language', 'cs', 'čeština');
145 INSERT INTO language_descriptions(subtag, type, lang, description)
146 VALUES( 'cs', 'language', 'en', 'Czech');
148 INSERT INTO language_descriptions(subtag, type, lang, description)
149 VALUES( 'cs', 'language', 'fr', 'Tchèque');
152 INSERT INTO language_subtag_registry( subtag, type, description, added)
153 VALUES ( 'da', 'language', 'Danish','2005-10-16' );
155 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
158 INSERT INTO language_descriptions(subtag, type, lang, description)
159 VALUES ( 'da', 'language', 'da', 'Dansk');
161 INSERT INTO language_descriptions(subtag, type, lang, description)
162 VALUES( 'da', 'language', 'en', 'Danish');
164 INSERT INTO language_descriptions(subtag, type, lang, description)
165 VALUES( 'da', 'language', 'fr', 'Danois');
168 INSERT INTO language_subtag_registry( subtag, type, description, added)
169 VALUES ( 'nl', 'language', 'Dutch','2005-10-16' );
171 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
174 INSERT INTO language_descriptions(subtag, type, lang, description)
175 VALUES ( 'nl', 'language', 'nl', 'Nederlands');
177 INSERT INTO language_descriptions(subtag, type, lang, description)
178 VALUES( 'nl', 'language', 'en', 'Dutch');
180 INSERT INTO language_descriptions(subtag, type, lang, description)
181 VALUES( 'nl', 'language', 'fr', 'Néerlandais');
184 INSERT INTO language_subtag_registry( subtag, type, description, added)
185 VALUES ( 'en', 'language', 'English','2005-10-16' );
187 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
190 INSERT INTO language_descriptions(subtag, type, lang, description)
191 VALUES( 'en', 'language', 'en', 'English');
193 INSERT INTO language_descriptions(subtag, type, lang, description)
194 VALUES( 'en', 'language', 'fr', 'Anglais');
197 INSERT INTO language_subtag_registry( subtag, type, description, added)
198 VALUES ( 'fi', 'language', 'Finnish','2005-10-16' );
200 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
203 INSERT INTO language_descriptions(subtag, type, lang, description)
204 VALUES( 'fi', 'language', 'fi', 'suomi');
206 INSERT INTO language_descriptions(subtag, type, lang, description)
207 VALUES( 'fi', 'language', 'en', 'Finnish');
210 INSERT INTO language_subtag_registry( subtag, type, description, added)
211 VALUES ( 'fr', 'language', 'French','2005-10-16' );
213 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
216 INSERT INTO language_descriptions(subtag, type, lang, description)
217 VALUES( 'fr', 'language', 'en', 'French');
219 INSERT INTO language_descriptions(subtag, type, lang, description)
220 VALUES( 'fr', 'language', 'fr', 'Français');
222 -- INSERT INTO language_descriptions(subtag, type, lang, description)
223 -- VALUES( 'fr-CA', 'language', 'fr-CA', 'français');
226 INSERT INTO language_subtag_registry( subtag, type, description, added)
227 VALUES ( 'lo', 'language', 'Lao','2005-10-16' );
229 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
232 INSERT INTO language_descriptions(subtag, type, lang, description)
233 VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ');
235 INSERT INTO language_descriptions(subtag, type, lang, description)
236 VALUES( 'lo', 'language', 'en', 'Lao');
239 INSERT INTO language_subtag_registry( subtag, type, description, added)
240 VALUES ( 'de', 'language', 'German','2005-10-16' );
242 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
245 INSERT INTO language_descriptions(subtag, type, lang, description)
246 VALUES( 'de', 'language', 'de', 'Deutsch');
248 INSERT INTO language_descriptions(subtag, type, lang, description)
249 VALUES( 'de', 'language', 'en', 'German');
251 INSERT INTO language_descriptions(subtag, type, lang, description)
252 VALUES( 'de', 'language', 'fr', 'Allemand');
255 INSERT INTO language_subtag_registry( subtag, type, description, added)
256 VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16');
258 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
261 INSERT INTO language_descriptions(subtag, type, lang, description)
262 VALUES( 'el', 'language', 'el', 'ελληνικά');
264 INSERT INTO language_descriptions(subtag, type, lang, description)
265 VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]');
267 INSERT INTO language_descriptions(subtag, type, lang, description)
268 VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)');
271 INSERT INTO language_subtag_registry( subtag, type, description, added)
272 VALUES ( 'he', 'language', 'Hebrew','2005-10-16');
274 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
277 INSERT INTO language_descriptions(subtag, type, lang, description)
278 VALUES( 'he', 'language', 'he', 'עברית');
280 INSERT INTO language_descriptions(subtag, type, lang, description)
281 VALUES( 'he', 'language', 'en', 'Hebrew');
283 INSERT INTO language_descriptions(subtag, type, lang, description)
284 VALUES( 'he', 'language', 'fr', 'Hébreu');
287 INSERT INTO language_subtag_registry( subtag, type, description, added)
288 VALUES ( 'hi', 'language', 'Hindi','2005-10-16');
290 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
293 INSERT INTO language_descriptions(subtag, type, lang, description)
294 VALUES( 'hi', 'language', 'hi', 'हिन्दी');
296 INSERT INTO language_descriptions(subtag, type, lang, description)
297 VALUES( 'hi', 'language', 'en', 'Hindi');
299 INSERT INTO language_descriptions(subtag, type, lang, description)
300 VALUES( 'hi', 'language', 'fr', 'Hindi');
303 INSERT INTO language_subtag_registry( subtag, type, description, added)
304 VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' );
306 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
309 INSERT INTO language_descriptions(subtag, type, lang, description)
310 VALUES( 'hu', 'language', 'hu', 'Magyar');
312 INSERT INTO language_descriptions(subtag, type, lang, description)
313 VALUES( 'hu', 'language', 'en', 'Hungarian');
315 INSERT INTO language_descriptions(subtag, type, lang, description)
316 VALUES( 'hu', 'language', 'fr', 'Hongrois');
319 INSERT INTO language_subtag_registry( subtag, type, description, added)
320 VALUES ( 'id', 'language', 'Indonesian','2005-10-16' );
322 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
325 INSERT INTO language_descriptions(subtag, type, lang, description)
326 VALUES( 'id', 'language', 'id', 'Bahasa Indonesia');
328 INSERT INTO language_descriptions(subtag, type, lang, description)
329 VALUES( 'id', 'language', 'en', 'Indonesian');
331 INSERT INTO language_descriptions(subtag, type, lang, description)
332 VALUES( 'id', 'language', 'fr', 'Indonésien');
335 INSERT INTO language_subtag_registry( subtag, type, description, added)
336 VALUES ( 'it', 'language', 'Italian','2005-10-16' );
338 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
341 INSERT INTO language_descriptions(subtag, type, lang, description)
342 VALUES( 'it', 'language', 'it', 'Italiano');
344 INSERT INTO language_descriptions(subtag, type, lang, description)
345 VALUES( 'it', 'language', 'en', 'Italian');
347 INSERT INTO language_descriptions(subtag, type, lang, description)
348 VALUES( 'it', 'language', 'fr', 'Italien');
351 INSERT INTO language_subtag_registry( subtag, type, description, added)
352 VALUES ( 'ja', 'language', 'Japanese','2005-10-16');
354 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
357 INSERT INTO language_descriptions(subtag, type, lang, description)
358 VALUES( 'ja', 'language', 'ja', '日本語');
360 INSERT INTO language_descriptions(subtag, type, lang, description)
361 VALUES( 'ja', 'language', 'en', 'Japanese');
363 INSERT INTO language_descriptions(subtag, type, lang, description)
364 VALUES( 'ja', 'language', 'fr', 'Japonais');
367 INSERT INTO language_subtag_registry( subtag, type, description, added)
368 VALUES ( 'ko', 'language', 'Korean','2005-10-16');
370 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
373 INSERT INTO language_descriptions(subtag, type, lang, description)
374 VALUES( 'ko', 'language', 'ko', '한국어');
376 INSERT INTO language_descriptions(subtag, type, lang, description)
377 VALUES( 'ko', 'language', 'en', 'Korean');
379 INSERT INTO language_descriptions(subtag, type, lang, description)
380 VALUES( 'ko', 'language', 'fr', 'Coréen');
383 INSERT INTO language_subtag_registry( subtag, type, description, added)
384 VALUES ( 'la', 'language', 'Latin','2005-10-16' );
386 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
389 INSERT INTO language_descriptions(subtag, type, lang, description)
390 VALUES( 'la', 'language', 'la', 'Latina');
392 INSERT INTO language_descriptions(subtag, type, lang, description)
393 VALUES( 'la', 'language', 'en', 'Latin');
395 INSERT INTO language_descriptions(subtag, type, lang, description)
396 VALUES( 'la', 'language', 'fr', 'Latin');
400 INSERT INTO language_subtag_registry( subtag, type, description, added)
401 VALUES ( 'gl', 'language', 'Galician','2005-10-16' );
403 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
406 INSERT INTO language_descriptions(subtag, type, lang, description)
407 VALUES( 'gl', 'language', 'gl', 'Galego');
409 INSERT INTO language_descriptions(subtag, type, lang, description)
410 VALUES( 'gl', 'language', 'en', 'Galician');
412 -- Norwegian (bokmål)
413 INSERT INTO language_subtag_registry( subtag, type, description, added)
414 VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' );
416 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
419 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
422 INSERT INTO language_descriptions(subtag, type, lang, description)
423 VALUES( 'nb', 'language', 'nb', 'Norsk bokmål');
425 INSERT INTO language_descriptions(subtag, type, lang, description)
426 VALUES( 'nb', 'language', 'en', 'Norwegian bokmål');
428 INSERT INTO language_descriptions(subtag, type, lang, description)
429 VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål');
431 -- Norwegian (nynorsk)
432 INSERT INTO language_subtag_registry( subtag, type, description, added)
433 VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' );
435 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
438 INSERT INTO language_descriptions(subtag, type, lang, description)
439 VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk');
441 INSERT INTO language_descriptions(subtag, type, lang, description)
442 VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk');
444 INSERT INTO language_descriptions(subtag, type, lang, description)
445 VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk');
447 INSERT INTO language_descriptions(subtag, type, lang, description)
448 VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk');
451 INSERT INTO language_subtag_registry( subtag, type, description, added)
452 VALUES ( 'fa', 'language', 'Persian','2005-10-16');
454 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
457 INSERT INTO language_descriptions(subtag, type, lang, description)
458 VALUES( 'fa', 'language', 'fa', 'فارسى');
460 INSERT INTO language_descriptions(subtag, type, lang, description)
461 VALUES( 'fa', 'language', 'en', 'Persian');
463 INSERT INTO language_descriptions(subtag, type, lang, description)
464 VALUES( 'fa', 'language', 'fr', 'Persan');
467 INSERT INTO language_subtag_registry( subtag, type, description, added)
468 VALUES ( 'pl', 'language', 'Polish','2005-10-16' );
470 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
473 INSERT INTO language_descriptions(subtag, type, lang, description)
474 VALUES( 'pl', 'language', 'pl', 'Polski');
476 INSERT INTO language_descriptions(subtag, type, lang, description)
477 VALUES( 'pl', 'language', 'en', 'Polish');
479 INSERT INTO language_descriptions(subtag, type, lang, description)
480 VALUES( 'pl', 'language', 'fr', 'Polonais');
483 INSERT INTO language_subtag_registry( subtag, type, description, added)
484 VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' );
486 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
489 INSERT INTO language_descriptions(subtag, type, lang, description)
490 VALUES( 'pt', 'language', 'pt', 'Português');
492 INSERT INTO language_descriptions(subtag, type, lang, description)
493 VALUES( 'pt', 'language', 'en', 'Portuguese');
495 INSERT INTO language_descriptions(subtag, type, lang, description)
496 VALUES( 'pt', 'language', 'fr', 'Portugais');
499 INSERT INTO language_subtag_registry( subtag, type, description, added)
500 VALUES ( 'ro', 'language', 'Romanian','2005-10-16' );
502 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
505 INSERT INTO language_descriptions(subtag, type, lang, description)
506 VALUES( 'ro', 'language', 'ro', 'Română');
508 INSERT INTO language_descriptions(subtag, type, lang, description)
509 VALUES( 'ro', 'language', 'en', 'Romanian');
511 INSERT INTO language_descriptions(subtag, type, lang, description)
512 VALUES( 'ro', 'language', 'fr', 'Roumain');
515 INSERT INTO language_subtag_registry( subtag, type, description, added)
516 VALUES ( 'ru', 'language', 'Russian','2005-10-16');
518 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
521 INSERT INTO language_descriptions(subtag, type, lang, description)
522 VALUES( 'ru', 'language', 'ru', 'Русский');
524 INSERT INTO language_descriptions(subtag, type, lang, description)
525 VALUES( 'ru', 'language', 'en', 'Russian');
527 INSERT INTO language_descriptions(subtag, type, lang, description)
528 VALUES( 'ru', 'language', 'fr', 'Russe');
531 INSERT INTO language_subtag_registry( subtag, type, description, added)
532 VALUES ( 'sr', 'language', 'Serbian','2005-10-16' );
534 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
537 INSERT INTO language_descriptions(subtag, type, lang, description)
538 VALUES( 'sr', 'language', 'sr', 'српски');
540 INSERT INTO language_descriptions(subtag, type, lang, description)
541 VALUES( 'sr', 'language', 'en', 'Serbian');
543 -- Spanish, Castilian
544 INSERT INTO language_subtag_registry( subtag, type, description, added)
545 VALUES ( 'es', 'language', 'Spanish','2005-10-16' );
547 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
550 INSERT INTO language_descriptions(subtag, type, lang, description)
551 VALUES( 'es', 'language', 'es', 'Español');
553 INSERT INTO language_descriptions(subtag, type, lang, description)
554 VALUES( 'es', 'language', 'en', 'Spanish');
556 INSERT INTO language_descriptions(subtag, type, lang, description)
557 VALUES( 'es', 'language', 'fr', 'Espagnol');
560 INSERT INTO language_subtag_registry( subtag, type, description, added)
561 VALUES ( 'sv', 'language', 'Swedish','2005-10-16' );
563 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
566 INSERT INTO language_descriptions(subtag, type, lang, description)
567 VALUES( 'sv', 'language', 'sv', 'Svenska');
569 INSERT INTO language_descriptions(subtag, type, lang, description)
570 VALUES( 'sv', 'language', 'en', 'Swedish');
572 INSERT INTO language_descriptions(subtag, type, lang, description)
573 VALUES( 'sv', 'language', 'fr', 'Suédois');
576 INSERT INTO language_subtag_registry( subtag, type, description, added)
577 VALUES ( 'tet', 'language', 'Tetum','2005-10-16' );
579 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
580 VALUES( 'tet','tet');
582 INSERT INTO language_descriptions(subtag, type, lang, description)
583 VALUES( 'tet', 'language', 'tet', 'tetun');
585 INSERT INTO language_descriptions(subtag, type, lang, description)
586 VALUES( 'tet', 'language', 'en', 'Tetum');
589 INSERT INTO language_subtag_registry( subtag, type, description, added)
590 VALUES ( 'th', 'language', 'Thai','2005-10-16');
592 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
595 INSERT INTO language_descriptions(subtag, type, lang, description)
596 VALUES( 'th', 'language', 'th', 'ภาษาไทย');
598 INSERT INTO language_descriptions(subtag, type, lang, description)
599 VALUES( 'th', 'language', 'en', 'Thai');
601 INSERT INTO language_descriptions(subtag, type, lang, description)
602 VALUES( 'th', 'language', 'fr', 'Thaï');
605 INSERT INTO language_subtag_registry( subtag, type, description, added)
606 VALUES ( 'tr', 'language', 'Turkish','2005-10-16' );
608 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
611 INSERT INTO language_descriptions(subtag, type, lang, description)
612 VALUES( 'tr', 'language', 'tr', 'Türkçe');
614 INSERT INTO language_descriptions(subtag, type, lang, description)
615 VALUES( 'tr', 'language', 'en', 'Turkish');
617 INSERT INTO language_descriptions(subtag, type, lang, description)
618 VALUES( 'tr', 'language', 'fr', 'Turc');
622 INSERT INTO language_subtag_registry( subtag, type, description, added)
623 VALUES ( 'uk', 'language', 'Ukranian','2005-10-16');
625 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
628 INSERT INTO language_descriptions(subtag, type, lang, description)
629 VALUES( 'uk', 'language', 'uk', 'Українська');
631 INSERT INTO language_descriptions(subtag, type, lang, description)
632 VALUES( 'uk', 'language', 'en', 'Ukranian');
634 INSERT INTO language_descriptions(subtag, type, lang, description)
635 VALUES( 'uk', 'language', 'fr', 'Ukrainien');
638 INSERT INTO language_subtag_registry( subtag, type, description, added)
639 VALUES ( 'ur', 'language', 'Urdu','2005-10-16' );
641 INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code)
644 INSERT INTO language_descriptions(subtag, type, lang, description)
645 VALUES( 'ur', 'language', 'en', 'Urdu');
647 INSERT INTO language_descriptions(subtag, type, lang, description)
648 VALUES( 'ur', 'language', 'ur', 'اردو');
652 INSERT INTO language_subtag_registry( subtag, type, description, added)
653 VALUES ( 'Arab', 'script', 'Arabic','2005-10-16');
655 INSERT INTO language_descriptions(subtag, type, lang, description)
656 VALUES ( 'Arab','script', 'Arab', 'العربية');
658 INSERT INTO language_descriptions(subtag, type, lang, description)
659 VALUES( 'Arab', 'script','en', 'Arabic');
661 INSERT INTO language_descriptions(subtag, type, lang, description)
662 VALUES( 'Arab', 'script','fr', 'Arabic');
665 INSERT INTO language_subtag_registry( subtag, type, description, added)
666 VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16');
668 INSERT INTO language_descriptions(subtag, type, lang, description)
669 VALUES ( 'Cyrl', 'script', 'Cyrl', '????');
671 INSERT INTO language_descriptions(subtag, type, lang, description)
672 VALUES( 'Cyrl', 'script', 'en', 'Cyrillic');
674 INSERT INTO language_descriptions(subtag, type, lang, description)
675 VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic');
678 INSERT INTO language_subtag_registry( subtag, type, description, added)
679 VALUES ( 'Grek', 'script', 'Greek','2005-10-16');
681 INSERT INTO language_descriptions(subtag, type, lang, description)
682 VALUES ( 'Grek', 'script', 'Grek', '????');
684 INSERT INTO language_descriptions(subtag, type, lang, description)
685 VALUES( 'Grek', 'script', 'en', 'Greek');
687 INSERT INTO language_descriptions(subtag, type, lang, description)
688 VALUES( 'Grek', 'script', 'fr', 'Greek');
691 INSERT INTO language_subtag_registry( subtag, type, description, added)
692 VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16');
694 INSERT INTO language_descriptions(subtag, type, lang, description)
695 VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)');
697 INSERT INTO language_descriptions(subtag, type, lang, description)
698 VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)');
700 INSERT INTO language_descriptions(subtag, type, lang, description)
701 VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)');
704 INSERT INTO language_subtag_registry( subtag, type, description, added)
705 VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16');
707 INSERT INTO language_descriptions(subtag, type, lang, description)
708 VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)');
710 INSERT INTO language_descriptions(subtag, type, lang, description)
711 VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)');
714 INSERT INTO language_subtag_registry( subtag, type, description, added)
715 VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16');
717 INSERT INTO language_descriptions(subtag, type, lang, description)
718 VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew');
720 INSERT INTO language_descriptions(subtag, type, lang, description)
721 VALUES( 'Hebr', 'script', 'en', 'Hebrew');
724 INSERT INTO language_subtag_registry( subtag, type, description, added)
725 VALUES ( 'Laoo', 'script', 'Lao','2005-10-16');
727 INSERT INTO language_descriptions(subtag, type, lang, description)
728 VALUES ( 'Laoo', 'script', 'lo', 'Lao');
730 INSERT INTO language_descriptions(subtag, type, lang, description)
731 VALUES( 'Laoo', 'script', 'en', 'Lao');
735 INSERT INTO language_subtag_registry( subtag, type, description, added)
736 VALUES ( 'CA', 'region', 'Canada','2005-10-16');
738 INSERT INTO language_descriptions(subtag, type, lang, description)
739 VALUES( 'CA', 'region', 'en', 'Canada');
742 INSERT INTO language_subtag_registry( subtag, type, description, added)
743 VALUES ( 'DK', 'region', 'Denmark','2005-10-16');
745 INSERT INTO language_descriptions(subtag, type, lang, description)
746 VALUES( 'DK', 'region', 'dk', 'Danmark');
749 INSERT INTO language_subtag_registry( subtag, type, description, added)
750 VALUES ( 'FR', 'region', 'France','2005-10-16');
752 INSERT INTO language_descriptions(subtag, type, lang, description)
753 VALUES ( 'FR', 'region', 'fr', 'France');
755 INSERT INTO language_descriptions(subtag, type, lang, description)
756 VALUES( 'FR', 'region', 'en', 'France');
759 INSERT INTO language_subtag_registry( subtag, type, description, added)
760 VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16');
762 INSERT INTO language_descriptions(subtag, type, lang, description)
763 VALUES( 'NZ', 'region', 'en', 'New Zealand');
766 INSERT INTO language_subtag_registry( subtag, type, description, added)
767 VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16');
769 INSERT INTO language_descriptions(subtag, type, lang, description)
770 VALUES( 'GB', 'region', 'en', 'United Kingdom');
773 INSERT INTO language_subtag_registry( subtag, type, description, added)
774 VALUES ( 'US', 'region', 'United States','2005-10-16');
776 INSERT INTO language_descriptions(subtag, type, lang, description)
777 VALUES( 'US', 'region', 'en', 'United States');