CREATE TABLE `users_langues` (
  `id_site_langue` int(11) NOT NULL,
  `id_ref_langue` int(11) NOT NULL,
  `nom_langue_vo` varchar(25) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id_site_langue`,`id_ref_langue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `users_langues` (`id_site_langue`, `id_ref_langue`, `nom_langue_vo`) VALUES
(1, 1, 'Toutes'),
(1, 2, 'afrikaans'),
(1, 4, 'albanais'),
(1, 5, 'allemand'),
(1, 8, 'anglais'),
(1, 9, 'arabe (autre)'),
(1, 10, 'arabe du Moyen-Orient'),
(1, 11, 'arabe marocain'),
(1, 12, 'arabe égyptien'),
(1, 13, 'araméen'),
(1, 14, 'arménien'),
(1, 17, 'azerbaijani'),
(1, 18, 'basque'),
(1, 19, 'bengali'),
(1, 20, 'berbère'),
(1, 21, 'birman'),
(1, 22, 'biélorusse'),
(1, 23, 'bosniaque'),
(1, 24, 'breton'),
(1, 25, 'bulgare'),
(1, 26, 'catalan'),
(1, 29, 'chinois cantonais'),
(1, 30, 'chinois mandarin'),
(1, 31, 'coréen'),
(1, 32, 'croate'),
(1, 33, 'créole'),
(1, 34, 'danois'),
(1, 35, 'écossais'),
(1, 36, 'espagnol'),
(1, 37, 'espéranto'),
(1, 38, 'estonien'),
(1, 39, 'fidjien'),
(1, 40, 'finnois'),
(1, 41, 'français'),
(1, 42, 'galicien'),
(1, 43, 'gallois'),
(1, 44, 'grec'),
(1, 46, 'géorgien'),
(1, 47, 'hawaïen'),
(1, 48, 'hindi'),
(1, 50, 'hongrois'),
(1, 51, 'hébreu'),
(1, 52, 'ido'),
(1, 53, 'indonésien'),
(1, 55, 'irlandais'),
(1, 56, 'islandais'),
(1, 57, 'italien'),
(1, 58, 'japonais'),
(1, 60, 'kazakh'),
(1, 61, 'khmer'),
(1, 62, 'kurde'),
(1, 64, 'lao'),
(1, 65, 'latin'),
(1, 66, 'letton'),
(1, 67, 'ligurian'),
(1, 68, 'lithuanien'),
(1, 69, 'lombard'),
(1, 70, 'macédonienne'),
(1, 71, 'malaisien'),
(1, 73, 'malgache'),
(1, 74, 'maltais'),
(1, 75, 'marathi'),
(1, 76, 'mongol'),
(1, 77, 'nepali'),
(1, 78, 'newari'),
(1, 79, 'norvégien'),
(1, 80, 'néerlandais'),
(1, 81, 'oriya'),
(1, 82, 'ourdou'),
(1, 83, 'ouzbek'),
(1, 84, 'pashto'),
(1, 85, 'perse (farsi)'),
(1, 86, 'polonais'),
(1, 87, 'portugais'),
(1, 88, 'punjabi'),
(1, 89, 'quechua'),
(1, 90, 'romanche'),
(1, 91, 'roumain'),
(1, 92, 'russe'),
(1, 93, 'sanskrit'),
(1, 94, 'serbo-croate'),
(1, 95, 'shona'),
(1, 96, 'sindhi'),
(1, 97, 'singhalais'),
(1, 98, 'slovaque'),
(1, 99, 'slovène'),
(1, 100, 'somali'),
(1, 101, 'suédois'),
(1, 102, 'swahili'),
(1, 103, 'tagalog (philippines)'),
(1, 104, 'tamil'),
(1, 105, 'tchèque'),
(1, 108, 'thaï'),
(1, 109, 'tibétain'),
(1, 110, 'tongan'),
(1, 111, 'tswana'),
(1, 112, 'turc'),
(1, 113, 'ukrainien'),
(1, 114, 'valencien'),
(1, 115, 'vietnamien'),
(1, 116, 'vénitien'),
(1, 117, 'yiddish'),
(2, 1, 'Todos'),
(2, 2, 'afrikaans'),
(2, 3, 'akan'),
(2, 4, 'albanés'),
(2, 5, 'alemán'),
(2, 8, 'inglés'),
(2, 9, 'árabe, otros'),
(2, 10, 'árabe del Medio Oriente'),
(2, 11, 'árabe marroquí'),
(2, 12, 'árabe egipcio'),
(2, 13, 'arameo'),
(2, 14, 'armenio'),
(2, 17, 'azerbaiyano'),
(2, 18, 'vasco'),
(2, 19, 'bengalí'),
(2, 20, 'berberisco'),
(2, 21, 'birmano'),
(2, 22, 'bieloruso'),
(2, 23, 'bosnio'),
(2, 24, 'bretón'),
(2, 25, 'búlgaro'),
(2, 26, 'catalán'),
(2, 29, 'chino, cantonés'),
(2, 30, 'chino, mandarín'),
(2, 31, 'coreano'),
(2, 32, 'croata'),
(2, 33, 'criollo'),
(2, 34, 'danés'),
(2, 35, 'escocés'),
(2, 36, 'español'),
(2, 37, 'esperanto'),
(2, 38, 'estonio'),
(2, 39, 'fiyiano'),
(2, 40, 'finlandés'),
(2, 41, 'francés'),
(2, 42, 'gallego'),
(2, 43, 'galés'),
(2, 44, 'griego'),
(2, 46, 'georgiano'),
(2, 47, 'hawaiano'),
(2, 48, 'hindi'),
(2, 50, 'húngaro'),
(2, 51, 'hebreo'),
(2, 52, 'ido'),
(2, 53, 'bahasa indonés'),
(2, 55, 'irlandés'),
(2, 56, 'islandés'),
(2, 57, 'italiano'),
(2, 58, 'japonés'),
(2, 60, 'kazakh'),
(2, 61, 'jemer'),
(2, 62, 'kurdo'),
(2, 64, 'laosiano'),
(2, 65, 'latín'),
(2, 66, 'letón'),
(2, 67, 'ligur'),
(2, 68, 'lituano'),
(2, 69, 'lombardo'),
(2, 70, 'macedonio'),
(2, 71, 'bahasa malasio'),
(2, 73, 'malgache'),
(2, 74, 'maltés'),
(2, 75, 'marathi'),
(2, 76, 'mongol'),
(2, 77, 'nepalés'),
(2, 78, 'newari'),
(2, 79, 'noruego'),
(2, 80, 'holandés'),
(2, 81, 'oriyá'),
(2, 82, 'urdu'),
(2, 83, 'uzbeco'),
(2, 84, 'pushtu (pashto)'),
(2, 85, 'persa (farsi)'),
(2, 86, 'polaco'),
(2, 87, 'portugués'),
(2, 88, 'punjabí'),
(2, 89, 'quechua'),
(2, 90, 'romanche'),
(2, 91, 'rumano'),
(2, 92, 'ruso'),
(2, 93, 'sánscrito'),
(2, 94, 'servo-croata'),
(2, 95, 'shona'),
(2, 96, 'sindhi'),
(2, 97, 'cingalés'),
(2, 98, 'eslovaco'),
(2, 99, 'esloveno'),
(2, 100, 'somalí'),
(2, 101, 'sueco'),
(2, 102, 'suajili'),
(2, 103, 'tagalog (filipinas)'),
(2, 104, 'tamil'),
(2, 105, 'checo'),
(2, 108, 'birmano'),
(2, 109, 'tibetano'),
(2, 110, 'tongan'),
(2, 111, 'tswana'),
(2, 112, 'turco'),
(2, 113, 'ucraniano'),
(2, 114, 'valenciano'),
(2, 115, 'vietnamita'),
(2, 116, 'veneciano'),
(2, 117, 'yiddish');

