-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Erstellungszeit: 09. Jul 2021 um 13:12
-- Server-Version: 10.4.8-MariaDB
-- PHP-Version: 7.3.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Datenbank: `rlaxx-backend`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `languages`
--

CREATE TABLE `languages` (
  `id` tinyint(3) UNSIGNED NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso_2` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso_3` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `translated_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Daten für Tabelle `languages`
--

INSERT INTO `languages` (`id`, `name`, `iso_2`, `iso_3`, `translated_name`) VALUES
(1, 'Afar', 'aa', 'aar', NULL),
(2, 'Abkhazian', 'ab', 'abk', NULL),
(3, 'Afrikaans', 'af', 'afr', NULL),
(4, 'Akan', 'ak', 'aka', NULL),
(5, 'Albanian', 'sq', 'sqi', NULL),
(6, 'Amharic', 'am', 'amh', NULL),
(7, 'Arabic', 'ar', 'ara', NULL),
(8, 'Aragonese', 'an', 'arg', NULL),
(9, 'Armenian', 'hy', 'hye', NULL),
(10, 'Assamese', 'as', 'asm', NULL),
(11, 'Avaric', 'av', 'ava', NULL),
(12, 'Avestan', 'ae', 'ave', NULL),
(13, 'Aymara', 'ay', 'aym', NULL),
(14, 'Azerbaijani', 'az', 'aze', NULL),
(15, 'Bashkir', 'ba', 'bak', NULL),
(16, 'Bambara', 'bm', 'bam', NULL),
(17, 'Basque', 'eu', 'eus', NULL),
(18, 'Belarusian', 'be', 'bel', NULL),
(19, 'Bengali', 'bn', 'ben', NULL),
(20, 'Bihari languages', 'bh', 'bih', NULL),
(21, 'Bislama', 'bi', 'bis', NULL),
(22, 'Tibetan', 'bo', 'bod', NULL),
(23, 'Bosnian', 'bs', 'bos', NULL),
(24, 'Breton', 'br', 'bre', NULL),
(25, 'Bulgarian', 'bg', 'bul', NULL),
(26, 'Burmese', 'my', 'mya', NULL),
(27, 'Catalan', 'ca', 'cat', NULL),
(28, 'Czech', 'cs', 'ces', NULL),
(29, 'Chamorro', 'ch', 'cha', NULL),
(30, 'Chechen', 'ce', 'che', NULL),
(31, 'Chinese', 'zh', 'zho', NULL),
(32, 'Church Slavic', 'cu', 'chu', NULL),
(33, 'Chuvash', 'cv', 'chv', NULL),
(34, 'Cornish', 'kw', 'cor', NULL),
(35, 'Corsican', 'co', 'cos', NULL),
(36, 'Cree', 'cr', 'cre', NULL),
(37, 'Welsh', 'cy', 'cym', NULL),
(38, 'Danish', 'da', 'dan', NULL),
(39, 'German', 'de', 'deu', 'Deutsch'),
(40, 'Divehi', 'dv', 'div', NULL),
(41, 'Dutch', 'nl', 'nld', NULL),
(42, 'Dzongkha', 'dz', 'dzo', NULL),
(43, 'Greek', 'el', 'ell', NULL),
(44, 'English', 'en', 'eng', 'English'),
(45, 'Esperanto', 'eo', 'epo', NULL),
(46, 'Estonian', 'et', 'est', NULL),
(47, 'Ewe', 'ee', 'ewe', NULL),
(48, 'Faroese', 'fo', 'fao', NULL),
(49, 'Persian', 'fa', 'fas', NULL),
(50, 'Fijian', 'fj', 'fij', NULL),
(51, 'Finnish', 'fi', 'fin', NULL),
(52, 'French', 'fr', 'fra', NULL),
(53, 'Western Frisian', 'fy', 'fry', NULL),
(54, 'Fulah', 'ff', 'ful', NULL),
(55, 'Georgian', 'ka', 'kat', NULL),
(56, 'Gaelic', 'gd', 'gla', NULL),
(57, 'Irish', 'ga', 'gle', NULL),
(58, 'Galician', 'gl', 'glg', NULL),
(59, 'Manx', 'gv', 'glv', NULL),
(60, 'Guarani', 'gn', 'grn', NULL),
(61, 'Gujarati', 'gu', 'guj', NULL),
(62, 'Haitian', 'ht', 'hat', NULL),
(63, 'Hausa', 'ha', 'hau', NULL),
(64, 'Hebrew', 'he', 'heb', NULL),
(65, 'Herero', 'hz', 'her', NULL),
(66, 'Hindi', 'hi', 'hin', NULL),
(67, 'Hiri Motu', 'ho', 'hmo', NULL),
(68, 'Croatian', 'hr', 'hrv', NULL),
(69, 'Hungarian', 'hu', 'hun', NULL),
(70, 'Igbo', 'ig', 'ibo', NULL),
(71, 'Icelandic', 'is', 'isl', NULL),
(72, 'Ido', 'io', 'ido', NULL),
(73, 'Sichuan Yi', 'ii', 'iii', NULL),
(74, 'Inuktitut', 'iu', 'iku', NULL),
(75, 'Interlingue', 'ie', 'ile', NULL),
(76, 'Interlingua (International Auxiliary Language', 'ia', 'ina', NULL),
(77, 'Indonesian', 'id', 'ind', NULL),
(78, 'Inupiaq', 'ik', 'ipk', NULL),
(79, 'Italian', 'it', 'ita', NULL),
(80, 'Javanese', 'jv', 'jav', NULL),
(81, 'Japanese', 'ja', 'jpn', NULL),
(82, 'Kalaallisut', 'kl', 'kal', NULL),
(83, 'Kannada', 'kn', 'kan', NULL),
(84, 'Kashmiri', 'ks', 'kas', NULL),
(85, 'Kanuri', 'kr', 'kau', NULL),
(86, 'Kazakh', 'kk', 'kaz', NULL),
(87, 'Central Khmer', 'km', 'khm', NULL),
(88, 'Kikuyu', 'ki', 'kik', NULL),
(89, 'Kinyarwanda', 'rw', 'kin', NULL),
(90, 'Kirghiz', 'ky', 'kir', NULL),
(91, 'Komi', 'kv', 'kom', NULL),
(92, 'Kongo', 'kg', 'kon', NULL),
(93, 'Korean', 'ko', 'kor', NULL),
(94, 'Kuanyama', 'kj', 'kua', NULL),
(95, 'Kurdish', 'ku', 'kur', NULL),
(96, 'Lao', 'lo', 'lao', NULL),
(97, 'Latin', 'la', 'lat', NULL),
(98, 'Latvian', 'lv', 'lav', NULL),
(99, 'Limburgan', 'li', 'lim', NULL),
(100, 'Lingala', 'ln', 'lin', NULL),
(101, 'Lithuanian', 'lt', 'lit', NULL),
(102, 'Luxembourgish', 'lb', 'ltz', NULL),
(103, 'Luba-Katanga', 'lu', 'lub', NULL),
(104, 'Ganda', 'lg', 'lug', NULL),
(105, 'Macedonian', 'mk', 'mkd', NULL),
(106, 'Marshallese', 'mh', 'mah', NULL),
(107, 'Malayalam', 'ml', 'mal', NULL),
(108, 'Maori', 'mi', 'mri', NULL),
(109, 'Marathi', 'mr', 'mar', NULL),
(110, 'Malay', 'ms', 'msa', NULL),
(111, 'Malagasy', 'mg', 'mlg', NULL),
(112, 'Maltese', 'mt', 'mlt', NULL),
(113, 'Mongolian', 'mn', 'mon', NULL),
(114, 'Nauru', 'na', 'nau', NULL),
(115, 'Navajo', 'nv', 'nav', NULL),
(116, 'Ndebele, South', 'nr', 'nbl', NULL),
(117, 'Ndebele, North', 'nd', 'nde', NULL),
(118, 'Ndonga', 'ng', 'ndo', NULL),
(119, 'Nepali', 'ne', 'nep', NULL),
(120, 'Norwegian Nynorsk', 'nn', 'nno', NULL),
(121, 'BokmÃ¥l, Norwegian', 'nb', 'nob', NULL),
(122, 'Norwegian', 'no', 'nor', NULL),
(123, 'Chichewa', 'ny', 'nya', NULL),
(124, 'Occitan (post 1500)', 'oc', 'oci', NULL),
(125, 'Ojibwa', 'oj', 'oji', NULL),
(126, 'Oriya', 'or', 'ori', NULL),
(127, 'Oromo', 'om', 'orm', NULL),
(128, 'Ossetian', 'os', 'oss', NULL),
(129, 'Panjabi', 'pa', 'pan', NULL),
(130, 'Pali', 'pi', 'pli', NULL),
(131, 'Polish', 'pl', 'pol', NULL),
(132, 'Portuguese', 'pt', 'por', NULL),
(133, 'Pushto', 'ps', 'pus', NULL),
(134, 'Quechua', 'qu', 'que', NULL),
(135, 'Romansh', 'rm', 'roh', NULL),
(136, 'Romanian', 'ro', 'ron', NULL),
(137, 'Rundi', 'rn', 'run', NULL),
(138, 'Russian', 'ru', 'rus', NULL),
(139, 'Sango', 'sg', 'sag', NULL),
(140, 'Sanskrit', 'sa', 'san', NULL),
(141, 'Sinhala', 'si', 'sin', NULL),
(142, 'Slovak', 'sk', 'slk', NULL),
(143, 'Slovenian', 'sl', 'slv', NULL),
(144, 'Northern Sami', 'se', 'sme', NULL),
(145, 'Samoan', 'sm', 'smo', NULL),
(146, 'Shona', 'sn', 'sna', NULL),
(147, 'Sindhi', 'sd', 'snd', NULL),
(148, 'Somali', 'so', 'som', NULL),
(149, 'Sotho, Southern', 'st', 'sot', NULL),
(150, 'Spanish', 'es', 'spa', NULL),
(151, 'Sardinian', 'sc', 'srd', NULL),
(152, 'Serbian', 'sr', 'srp', NULL),
(153, 'Swati', 'ss', 'ssw', NULL),
(154, 'Sundanese', 'su', 'sun', NULL),
(155, 'Swahili', 'sw', 'swa', NULL),
(156, 'Swedish', 'sv', 'swe', NULL),
(157, 'Tahitian', 'ty', 'tah', NULL),
(158, 'Tamil', 'ta', 'tam', NULL),
(159, 'Tatar', 'tt', 'tat', NULL),
(160, 'Telugu', 'te', 'tel', NULL),
(161, 'Tajik', 'tg', 'tgk', NULL),
(162, 'Tagalog', 'tl', 'tgl', NULL),
(163, 'Thai', 'th', 'tha', NULL),
(164, 'Tigrinya', 'ti', 'tir', NULL),
(165, 'Tonga (Tonga Islands)', 'to', 'ton', NULL),
(166, 'Tswana', 'tn', 'tsn', NULL),
(167, 'Tsonga', 'ts', 'tso', NULL),
(168, 'Turkmen', 'tk', 'tuk', NULL),
(169, 'Turkish', 'tr', 'tur', NULL),
(170, 'Twi', 'tw', 'twi', NULL),
(171, 'Uighur', 'ug', 'uig', NULL),
(172, 'Ukrainian', 'uk', 'ukr', NULL),
(173, 'Urdu', 'ur', 'urd', NULL),
(174, 'Uzbek', 'uz', 'uzb', NULL),
(175, 'Venda', 've', 'ven', NULL),
(176, 'Vietnamese', 'vi', 'vie', NULL),
(177, 'VolapÃ¼k', 'vo', 'vol', NULL),
(178, 'Walloon', 'wa', 'wln', NULL),
(179, 'Wolof', 'wo', 'wol', NULL),
(180, 'Xhosa', 'xh', 'xho', NULL),
(181, 'Yiddish', 'yi', 'yid', NULL),
(182, 'Yoruba', 'yo', 'yor', NULL),
(183, 'Zhuang', 'za', 'zha', NULL),
(184, 'Zulu', 'zu', 'zul', NULL),
(185, '', 'XX', 'XXX', NULL);

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `languages`
--
ALTER TABLE `languages`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=186;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
