8 CREATE TABLE local_user_language (
10 local_user_id int REFERENCES local_user ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
11 language_id int REFERENCES
13 UPDATE CASCADE ON DELETE CASCADE NOT NULL,
14 UNIQUE (local_user_id, language_id)
17 ALTER TABLE local_user RENAME COLUMN lang TO interface_language;
20 LANGUAGE (id, code, name)
21 VALUES (0, 'und', 'Undetermined');
24 ADD COLUMN language_id integer REFERENCES LANGUAGE NOT
29 VALUES ('aa', 'Afaraf');
33 VALUES ('ab', 'аҧсуа бызшәа');
37 VALUES ('ae', 'avesta');
41 VALUES ('af', 'Afrikaans');
45 VALUES ('ak', 'Akan');
49 VALUES ('am', 'አማርኛ');
53 VALUES ('an', 'aragonés');
57 VALUES ('ar', 'اَلْعَرَبِيَّةُ');
61 VALUES ('as', 'অসমীয়া');
65 VALUES ('av', 'авар мацӀ');
69 VALUES ('ay', 'aymar aru');
73 VALUES ('az', 'azərbaycan dili');
77 VALUES ('ba', 'башҡорт теле');
81 VALUES ('be', 'беларуская мова');
85 VALUES ('bg', 'български език');
89 VALUES ('bi', 'Bislama');
93 VALUES ('bm', 'bamanankan');
97 VALUES ('bn', 'বাংলা');
100 LANGUAGE (code, name)
101 VALUES ('bo', 'བོད་ཡིག');
104 LANGUAGE (code, name)
105 VALUES ('br', 'brezhoneg');
108 LANGUAGE (code, name)
109 VALUES ('bs', 'bosanski jezik');
112 LANGUAGE (code, name)
113 VALUES ('ca', 'Català');
116 LANGUAGE (code, name)
117 VALUES ('ce', 'нохчийн мотт');
120 LANGUAGE (code, name)
121 VALUES ('ch', 'Chamoru');
124 LANGUAGE (code, name)
125 VALUES ('co', 'corsu');
128 LANGUAGE (code, name)
129 VALUES ('cr', 'ᓀᐦᐃᔭᐍᐏᐣ');
132 LANGUAGE (code, name)
133 VALUES ('cs', 'čeština');
136 LANGUAGE (code, name)
137 VALUES ('cu', 'ѩзыкъ словѣньскъ');
140 LANGUAGE (code, name)
141 VALUES ('cv', 'чӑваш чӗлхи');
144 LANGUAGE (code, name)
145 VALUES ('cy', 'Cymraeg');
148 LANGUAGE (code, name)
149 VALUES ('da', 'dansk');
152 LANGUAGE (code, name)
153 VALUES ('de', 'Deutsch');
156 LANGUAGE (code, name)
157 VALUES ('dv', 'ދިވެހި');
160 LANGUAGE (code, name)
161 VALUES ('dz', 'རྫོང་ཁ');
164 LANGUAGE (code, name)
165 VALUES ('ee', 'Eʋegbe');
168 LANGUAGE (code, name)
169 VALUES ('el', 'Ελληνικά');
172 LANGUAGE (code, name)
173 VALUES ('en', 'English');
176 LANGUAGE (code, name)
177 VALUES ('eo', 'Esperanto');
180 LANGUAGE (code, name)
181 VALUES ('es', 'Español');
184 LANGUAGE (code, name)
185 VALUES ('et', 'eesti');
188 LANGUAGE (code, name)
189 VALUES ('eu', 'euskara');
192 LANGUAGE (code, name)
193 VALUES ('fa', 'فارسی');
196 LANGUAGE (code, name)
197 VALUES ('ff', 'Fulfulde');
200 LANGUAGE (code, name)
201 VALUES ('fi', 'suomi');
204 LANGUAGE (code, name)
205 VALUES ('fj', 'vosa Vakaviti');
208 LANGUAGE (code, name)
209 VALUES ('fo', 'føroyskt');
212 LANGUAGE (code, name)
213 VALUES ('fr', 'Français');
216 LANGUAGE (code, name)
217 VALUES ('fy', 'Frysk');
220 LANGUAGE (code, name)
221 VALUES ('ga', 'Gaeilge');
224 LANGUAGE (code, name)
225 VALUES ('gd', 'Gàidhlig');
228 LANGUAGE (code, name)
229 VALUES ('gl', 'galego');
232 LANGUAGE (code, name)
233 VALUES ('gn', E'Avañe\'ẽ');
236 LANGUAGE (code, name)
237 VALUES ('gu', 'ગુજરાતી');
240 LANGUAGE (code, name)
241 VALUES ('gv', 'Gaelg');
244 LANGUAGE (code, name)
245 VALUES ('ha', 'هَوُسَ');
248 LANGUAGE (code, name)
249 VALUES ('he', 'עברית');
252 LANGUAGE (code, name)
253 VALUES ('hi', 'हिन्दी');
256 LANGUAGE (code, name)
257 VALUES ('ho', 'Hiri Motu');
260 LANGUAGE (code, name)
261 VALUES ('hr', 'Hrvatski');
264 LANGUAGE (code, name)
265 VALUES ('ht', 'Kreyòl ayisyen');
268 LANGUAGE (code, name)
269 VALUES ('hu', 'magyar');
272 LANGUAGE (code, name)
273 VALUES ('hy', 'Հայերեն');
276 LANGUAGE (code, name)
277 VALUES ('hz', 'Otjiherero');
280 LANGUAGE (code, name)
281 VALUES ('ia', 'Interlingua');
284 LANGUAGE (code, name)
285 VALUES ('id', 'Bahasa Indonesia');
288 LANGUAGE (code, name)
289 VALUES ('ie', 'Interlingue');
292 LANGUAGE (code, name)
293 VALUES ('ig', 'Asụsụ Igbo');
296 LANGUAGE (code, name)
297 VALUES ('ii', 'ꆈꌠ꒿ Nuosuhxop');
300 LANGUAGE (code, name)
301 VALUES ('ik', 'Iñupiaq');
304 LANGUAGE (code, name)
305 VALUES ('io', 'Ido');
308 LANGUAGE (code, name)
309 VALUES ('is', 'Íslenska');
312 LANGUAGE (code, name)
313 VALUES ('it', 'Italiano');
316 LANGUAGE (code, name)
317 VALUES ('iu', 'ᐃᓄᒃᑎᑐᑦ');
320 LANGUAGE (code, name)
321 VALUES ('ja', '日本語');
324 LANGUAGE (code, name)
325 VALUES ('jv', 'basa Jawa');
328 LANGUAGE (code, name)
329 VALUES ('ka', 'ქართული');
332 LANGUAGE (code, name)
333 VALUES ('kg', 'Kikongo');
336 LANGUAGE (code, name)
337 VALUES ('ki', 'Gĩkũyũ');
340 LANGUAGE (code, name)
341 VALUES ('kj', 'Kuanyama');
344 LANGUAGE (code, name)
345 VALUES ('kk', 'қазақ тілі');
348 LANGUAGE (code, name)
349 VALUES ('kl', 'kalaallisut');
352 LANGUAGE (code, name)
353 VALUES ('km', 'ខេមរភាសា');
356 LANGUAGE (code, name)
357 VALUES ('kn', 'ಕನ್ನಡ');
360 LANGUAGE (code, name)
361 VALUES ('ko', '한국어');
364 LANGUAGE (code, name)
365 VALUES ('kr', 'Kanuri');
368 LANGUAGE (code, name)
369 VALUES ('ks', 'कश्मीरी');
372 LANGUAGE (code, name)
373 VALUES ('ku', 'Kurdî');
376 LANGUAGE (code, name)
377 VALUES ('kv', 'коми кыв');
380 LANGUAGE (code, name)
381 VALUES ('kw', 'Kernewek');
384 LANGUAGE (code, name)
385 VALUES ('ky', 'Кыргызча');
388 LANGUAGE (code, name)
389 VALUES ('la', 'latine');
392 LANGUAGE (code, name)
393 VALUES ('lb', 'Lëtzebuergesch');
396 LANGUAGE (code, name)
397 VALUES ('lg', 'Luganda');
400 LANGUAGE (code, name)
401 VALUES ('li', 'Limburgs');
404 LANGUAGE (code, name)
405 VALUES ('ln', 'Lingála');
408 LANGUAGE (code, name)
409 VALUES ('lo', 'ພາສາລາວ');
412 LANGUAGE (code, name)
413 VALUES ('lt', 'lietuvių kalba');
416 LANGUAGE (code, name)
417 VALUES ('lu', 'Kiluba');
420 LANGUAGE (code, name)
421 VALUES ('lv', 'latviešu valoda');
424 LANGUAGE (code, name)
425 VALUES ('mg', 'fiteny malagasy');
428 LANGUAGE (code, name)
429 VALUES ('mh', 'Kajin M̧ajeļ');
432 LANGUAGE (code, name)
433 VALUES ('mi', 'te reo Māori');
436 LANGUAGE (code, name)
437 VALUES ('mk', 'македонски јазик');
440 LANGUAGE (code, name)
441 VALUES ('ml', 'മലയാളം');
444 LANGUAGE (code, name)
445 VALUES ('mn', 'Монгол хэл');
448 LANGUAGE (code, name)
449 VALUES ('mr', 'मराठी');
452 LANGUAGE (code, name)
453 VALUES ('ms', 'Bahasa Melayu');
456 LANGUAGE (code, name)
457 VALUES ('mt', 'Malti');
460 LANGUAGE (code, name)
461 VALUES ('my', 'ဗမာစာ');
464 LANGUAGE (code, name)
465 VALUES ('na', 'Dorerin Naoero');
468 LANGUAGE (code, name)
469 VALUES ('nb', 'Norsk bokmål');
472 LANGUAGE (code, name)
473 VALUES ('nd', 'isiNdebele');
476 LANGUAGE (code, name)
477 VALUES ('ne', 'नेपाली');
480 LANGUAGE (code, name)
481 VALUES ('ng', 'Owambo');
484 LANGUAGE (code, name)
485 VALUES ('nl', 'Nederlands');
488 LANGUAGE (code, name)
489 VALUES ('nn', 'Norsk nynorsk');
492 LANGUAGE (code, name)
493 VALUES ('no', 'Norsk');
496 LANGUAGE (code, name)
497 VALUES ('nr', 'isiNdebele');
500 LANGUAGE (code, name)
501 VALUES ('nv', 'Diné bizaad');
504 LANGUAGE (code, name)
505 VALUES ('ny', 'chiCheŵa');
508 LANGUAGE (code, name)
509 VALUES ('oc', 'occitan');
512 LANGUAGE (code, name)
513 VALUES ('oj', 'ᐊᓂᔑᓈᐯᒧᐎᓐ');
516 LANGUAGE (code, name)
517 VALUES ('om', 'Afaan Oromoo');
520 LANGUAGE (code, name)
521 VALUES ('or', 'ଓଡ଼ିଆ');
524 LANGUAGE (code, name)
525 VALUES ('os', 'ирон æвзаг');
528 LANGUAGE (code, name)
529 VALUES ('pa', 'ਪੰਜਾਬੀ');
532 LANGUAGE (code, name)
533 VALUES ('pi', 'पाऴि');
536 LANGUAGE (code, name)
537 VALUES ('pl', 'Polski');
540 LANGUAGE (code, name)
541 VALUES ('ps', 'پښتو');
544 LANGUAGE (code, name)
545 VALUES ('pt', 'Português');
548 LANGUAGE (code, name)
549 VALUES ('qu', 'Runa Simi');
552 LANGUAGE (code, name)
553 VALUES ('rm', 'rumantsch grischun');
556 LANGUAGE (code, name)
557 VALUES ('rn', 'Ikirundi');
560 LANGUAGE (code, name)
561 VALUES ('ro', 'Română');
564 LANGUAGE (code, name)
565 VALUES ('ru', 'Русский');
568 LANGUAGE (code, name)
569 VALUES ('rw', 'Ikinyarwanda');
572 LANGUAGE (code, name)
573 VALUES ('sa', 'संस्कृतम्');
576 LANGUAGE (code, name)
577 VALUES ('sc', 'sardu');
580 LANGUAGE (code, name)
581 VALUES ('sd', 'सिन्धी');
584 LANGUAGE (code, name)
585 VALUES ('se', 'Davvisámegiella');
588 LANGUAGE (code, name)
589 VALUES ('sg', 'yângâ tî sängö');
592 LANGUAGE (code, name)
593 VALUES ('si', 'සිංහල');
596 LANGUAGE (code, name)
597 VALUES ('sk', 'slovenčina');
600 LANGUAGE (code, name)
601 VALUES ('sl', 'slovenščina');
604 LANGUAGE (code, name)
605 VALUES ('sm', E'gagana fa\'a Samoa');
608 LANGUAGE (code, name)
609 VALUES ('sn', 'chiShona');
612 LANGUAGE (code, name)
613 VALUES ('so', 'Soomaaliga');
616 LANGUAGE (code, name)
617 VALUES ('sq', 'Shqip');
620 LANGUAGE (code, name)
621 VALUES ('sr', 'српски језик');
624 LANGUAGE (code, name)
625 VALUES ('ss', 'SiSwati');
628 LANGUAGE (code, name)
629 VALUES ('st', 'Sesotho');
632 LANGUAGE (code, name)
633 VALUES ('su', 'Basa Sunda');
636 LANGUAGE (code, name)
637 VALUES ('sv', 'Svenska');
640 LANGUAGE (code, name)
641 VALUES ('sw', 'Kiswahili');
644 LANGUAGE (code, name)
645 VALUES ('ta', 'தமிழ்');
648 LANGUAGE (code, name)
649 VALUES ('te', 'తెలుగు');
652 LANGUAGE (code, name)
653 VALUES ('tg', 'тоҷикӣ');
656 LANGUAGE (code, name)
657 VALUES ('th', 'ไทย');
660 LANGUAGE (code, name)
661 VALUES ('ti', 'ትግርኛ');
664 LANGUAGE (code, name)
665 VALUES ('tk', 'Türkmençe');
668 LANGUAGE (code, name)
669 VALUES ('tl', 'Wikang Tagalog');
672 LANGUAGE (code, name)
673 VALUES ('tn', 'Setswana');
676 LANGUAGE (code, name)
677 VALUES ('to', 'faka Tonga');
680 LANGUAGE (code, name)
681 VALUES ('tr', 'Türkçe');
684 LANGUAGE (code, name)
685 VALUES ('ts', 'Xitsonga');
688 LANGUAGE (code, name)
689 VALUES ('tt', 'татар теле');
692 LANGUAGE (code, name)
693 VALUES ('tw', 'Twi');
696 LANGUAGE (code, name)
697 VALUES ('ty', 'Reo Tahiti');
700 LANGUAGE (code, name)
701 VALUES ('ug', 'ئۇيغۇرچە');
704 LANGUAGE (code, name)
705 VALUES ('uk', 'Українська');
708 LANGUAGE (code, name)
709 VALUES ('ur', 'اردو');
712 LANGUAGE (code, name)
713 VALUES ('uz', 'Ўзбек');
716 LANGUAGE (code, name)
717 VALUES ('ve', 'Tshivenḓa');
720 LANGUAGE (code, name)
721 VALUES ('vi', 'Tiếng Việt');
724 LANGUAGE (code, name)
725 VALUES ('vo', 'Volapük');
728 LANGUAGE (code, name)
729 VALUES ('wa', 'walon');
732 LANGUAGE (code, name)
733 VALUES ('wo', 'Wollof');
736 LANGUAGE (code, name)
737 VALUES ('xh', 'isiXhosa');
740 LANGUAGE (code, name)
741 VALUES ('yi', 'ייִדיש');
744 LANGUAGE (code, name)
745 VALUES ('yo', 'Yorùbá');
748 LANGUAGE (code, name)
749 VALUES ('za', 'Saɯ cueŋƅ');
752 LANGUAGE (code, name)
756 LANGUAGE (code, name)
757 VALUES ('zu', 'isiZulu');