text: INSERT INTO countries (id,name,iso3166_a2name) VALUES (9, 'United Arab Emirates', 'AE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (15, 'Antigua and Barbuda', 'AG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (4, 'Anguilla', 'AI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (6, 'Albania', 'AL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (11, 'Armenia', 'AM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (3, 'Angola', 'AO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (13, 'Antarctica', 'AQ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (12, 'American Samoa', 'AS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (17, 'Austria', 'AT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (16, 'Australia', 'AU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (1, 'Aruba', 'AW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (18, 'Azerbaijan', 'AZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (27, 'Bosnia and Herzegovina', 'BA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (34, 'Barbados', 'BB');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (23, 'Bangladesh', 'BD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (22, 'Burkina Faso', 'BF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (24, 'Bulgaria', 'BG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (25, 'Bahrain', 'BH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (19, 'Burundi', 'BI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (21, 'Benin', 'BJ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (31, 'Bermuda', 'BM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (35, 'Brunei Darussalam', 'BN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (32, 'Bolivia', 'BO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (33, 'Brazil', 'BR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (26, 'Bahamas', 'BS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (36, 'Bhutan', 'BT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (37, 'Bouvet Island', 'BV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (29, 'Belarus', 'BY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (30, 'Belize', 'BZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (40, 'Canada', 'CA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (41, 'Cocos (Keeling) Islands', 'CC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (39, 'Central African Republic,', 'CF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (48, 'Congo', 'CG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (42, 'Switzerland', 'CH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (49, 'Cook Islands', 'CK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (43, 'Chile', 'CL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (46, 'Cameroon', 'CM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (44, 'China', 'CN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (50, 'Colombia', 'CO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (53, 'Costa Rica', 'CR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (54, 'Cuba', 'CU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (55, 'Christmas Island', 'CX');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (57, 'Cyprus', 'CY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (58, 'Czechia', 'CZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (59, 'Germany', 'DE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (60, 'Djibouti', 'DJ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (62, 'Denmark', 'DK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (61, 'Dominica', 'DM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (64, 'Algeria', 'DZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (65, 'Ecuador', 'EC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (70, 'Estonia', 'EE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (66, 'Egypt', 'EG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (68, 'Western Sahara', 'EH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (67, 'Eritrea', 'ER');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (69, 'Spain', 'ES');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (71, 'Ethiopia', 'ET');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (72, 'Finland', 'FI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (74, 'Falkland Islands (Malvinas)', 'FK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (76, 'Faroe Islands', 'FO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (75, 'France', 'FR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (78, 'Gabon', 'GA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (79, 'United Kingdom', 'GB');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (90, 'Grenada', 'GD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (80, 'Georgia', 'GE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (93, 'French Guiana', 'GF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (82, 'Ghana', 'GH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (83, 'Gibraltar', 'GI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (91, 'Greenland', 'GL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (86, 'Gambia', 'GM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (84, 'Guinea', 'GN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (88, 'Equatorial Guinea', 'GQ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (89, 'Greece', 'GR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (92, 'Guatemala', 'GT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (94, 'Guam', 'GU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (95, 'Guyana', 'GY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (96, 'Hong Kong', 'HK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (98, 'Honduras', 'HN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (99, 'Croatia', 'HR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (100, 'Haiti', 'HT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (101, 'Hungary', 'HU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (102, 'Indonesia', 'ID');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (106, 'Ireland', 'IE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (110, 'Israel', 'IL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (103, 'Isle of Man', 'IM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (104, 'India', 'IN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (108, 'Iraq', 'IQ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (107, 'Iran', 'IR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (109, 'Iceland', 'IS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (111, 'Italy', 'IT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (113, 'Jersey', 'JE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (112, 'Jamaica', 'JM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (114, 'Jordan', 'JO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (115, 'Japan', 'JP');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (117, 'Kenya', 'KE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (118, 'Kyrgyzstan', 'KG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (119, 'Cambodia', 'KH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (120, 'Kiribati', 'KI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (121, 'Saint Kitts and Nevis', 'KN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (122, 'Korea (the Republic of)', 'KR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (123, 'Kuwait', 'KW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (56, 'Cayman Islands', 'KY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (116, 'Kazakhstan', 'KZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (125, 'Lebanon', 'LB');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (128, 'Saint Lucia', 'LC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (129, 'Liechtenstein', 'LI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (130, 'Sri Lanka', 'LK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (216, 'TJK', 'TJ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (243, 'YUG', 'YU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (7, 'Andorra', 'AD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (2, 'Afghanistan', 'AF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (10, 'Argentina', 'AR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (5, 'Åland Islands', 'AX');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (20, 'Belgium', 'BE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (28, 'Saint Barthélemy', 'BL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (246, 'Bonaire, Sint Eustatius and Saba', 'BQ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (38, 'Botswana', 'BW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (47, 'Congo, the Democratic Republic of the', 'CD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (45, 'Côte d''Ivoire', 'CI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (52, 'Cabo Verde', 'CV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (247, 'Curaçao', 'CW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (63, 'Dominican Republic', 'DO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (73, 'Fiji', 'FJ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (77, 'Micronesia, Federated  of', 'FM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (81, 'Guernsey', 'GG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (85, 'Guadeloupe', 'GP');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (194, 'South Georgia and the South Sandwich Islands', 'GS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (87, 'Guinea-Bissau', 'GW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (97, 'Heard Island and McDonald Islands', 'HM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (105, 'British Indian Ocean Territory', 'IO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (51, 'Comoros', 'KM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (180, 'Korea (the Democratic People''s Republic of)', 'KP');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (124, 'Lao People''s Democratic Republic', 'LA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (126, 'Liberia', 'LR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (131, 'Lesotho', 'LS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (132, 'Lithuania', 'LT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (133, 'Luxembourg', 'LU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (134, 'Latvia', 'LV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (127, 'Libya', 'LY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (137, 'Morocco', 'MA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (138, 'Monaco', 'MC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (139, 'Moldova', 'MD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (147, 'Montenegro', 'ME');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (248, 'Saint Martin (French part)', 'MF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (140, 'Madagascar', 'MG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (143, 'Marshall Islands', 'MH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (144, 'Macedonia, the former Yugoslav Republic of', 'MK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (145, 'Mali', 'ML');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (146, 'Myanmar', 'MM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (148, 'Mongolia', 'MN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (135, 'Macao', 'MO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (149, 'Northern Mariana Islands', 'MP');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (153, 'Martinique', 'MQ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (151, 'Mauritania', 'MR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (152, 'Montserrat', 'MS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (136, 'Malta', 'MT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (154, 'Mauritius', 'MU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (141, 'Maldives', 'MV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (155, 'Malawi', 'MW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (142, 'Mexico', 'MX');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (156, 'Malaysia', 'MY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (150, 'Mozambique', 'MZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (158, 'Namibia', 'NA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (159, 'New Caledonia', 'NC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (160, 'Niger', 'NE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (161, 'Norfolk Island', 'NF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (162, 'Nigeria', 'NG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (163, 'Nicaragua', 'NI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (165, 'Netherlands', 'NL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (166, 'Norway', 'NO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (167, 'Nepal', 'NP');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (168, 'Nauru', 'NR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (164, 'Niue', 'NU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (169, 'New Zealand', 'NZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (170, 'Oman', 'OM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (172, 'Panama', 'PA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (174, 'Peru', 'PE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (184, 'French Polynesia', 'PF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (177, 'Papua New Guinea', 'PG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (175, 'Philippines', 'PH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (171, 'Pakistan', 'PK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (178, 'Poland', 'PL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (202, 'Saint Pierre and Miquelon', 'PM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (173, 'Pitcairn', 'PN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (179, 'Puerto Rico', 'PR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (183, 'Palestine, State of', 'PS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (181, 'Portugal', 'PT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (176, 'Palau', 'PW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (182, 'Paraguay', 'PY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (185, 'Qatar', 'QA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (186, 'Réunion', 'RE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (187, 'Romania', 'RO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (203, 'Serbia', 'RS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (188, 'Russian Federation', 'RU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (189, 'Rwanda', 'RW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (190, 'Saudi Arabia', 'SA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (197, 'Solomon Islands', 'SB');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (210, 'Seychelles', 'SC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (191, 'Sudan', 'SD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (208, 'Sweden', 'SE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (193, 'Singapore', 'SG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (195, 'Saint Helena, Ascension and Tristan da Cunha', 'SH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (207, 'Slovenia', 'SI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (196, 'Svalbard and Jan Mayen', 'SJ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (206, 'Slovakia', 'SK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (198, 'Sierra Leone', 'SL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (200, 'San Marino', 'SM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (192, 'Senegal', 'SN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (201, 'Somalia', 'SO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (205, 'Suriname', 'SR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (249, 'South Sudan', 'SS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (204, 'Sao Tome and Principe', 'ST');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (199, 'El Salvador', 'SV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (250, 'Sint Maarten (Dutch part)', 'SX');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (211, 'Syrian Arab Republic', 'SY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (209, 'Swaziland', 'SZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (212, 'Turks and Caicos Islands', 'TC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (213, 'Chad', 'TD');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (14, 'French Southern Territories', 'TF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (214, 'Togo', 'TG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (215, 'Thailand', 'TH');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (217, 'Tokelau', 'TK');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (219, 'Timor-Leste', 'TL');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (218, 'Turkmenistan', 'TM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (222, 'Tunisia', 'TN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (220, 'Tonga', 'TO');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (223, 'Turkey', 'TR');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (221, 'Trinidad and Tobago', 'TT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (224, 'Tuvalu', 'TV');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (225, 'Taiwan', 'TW');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (226, 'Tanzania, United Republic of', 'TZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (228, 'Ukraine', 'UA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (227, 'Uganda', 'UG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (229, 'United  Minor Outlying Islands', 'UM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (231, 'United', 'US');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (230, 'Uruguay', 'UY');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (232, 'Uzbekistan', 'UZ');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (233, 'Holy See (Vatican City State)', 'VA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (234, 'Saint Vincent and the Grenadines', 'VC');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (235, 'Venezuela, Bolivarian Republic of', 'VE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (236, 'Virgin Islands, British', 'VG');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (237, 'Virgin Islands, U.S.', 'VI');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (238, 'Viet Nam', 'VN');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (239, 'Vanuatu', 'VU');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (240, 'Wallis and Futuna', 'WF');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (241, 'Samoa', 'WS');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (242, 'Yemen', 'YE');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (157, 'Mayotte', 'YT');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (244, 'South Africa', 'ZA');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (245, 'Zambia', 'ZM');
  INSERT INTO countries (id,name,iso3166_a2name) VALUES (251, 'Zimbabwe', 'ZW');
  
  INSERT INTO languages (id, version, name, iso639_1) VALUES (1, 1, 'Abkhaz', 'ab');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (2, 1, 'Afar', 'aa');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (3, 1, 'Afrikaans', 'af');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (4, 1, 'Akan', 'ak');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (5, 1, 'Albanian', 'sq');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (6, 1, 'Amharic', 'am');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (7, 1, 'Arabic', 'ar');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (8, 1, 'Aragonese', 'an');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (9, 1, 'Armenian', 'hy');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (10, 1, 'Assamese', 'as');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (11, 1, 'Avaric', 'av');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (12, 1, 'Avestan', 'ae');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (13, 1, 'Aymara', 'ay');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (14, 1, 'Azerbaijani', 'az');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (15, 1, 'Bambara', 'bm');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (16, 1, 'Bashkir', 'ba');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (17, 1, 'Basque', 'eu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (18, 1, 'Belarusian', 'be');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (19, 1, 'Bengali, Bangla', 'bn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (20, 1, 'Bihari', 'bh');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (21, 1, 'Bislama', 'bi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (22, 1, 'Bosnian', 'bs');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (23, 1, 'Breton', 'br');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (24, 1, 'Bulgarian', 'bg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (25, 1, 'Burmese', 'my');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (26, 1, 'Catalan', 'ca');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (27, 1, 'Chamorro', 'ch');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (28, 1, 'Chechen', 'ce');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (29, 1, 'Chichewa, Chewa, Nyanja', 'ny');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (30, 1, 'Chinese', 'zh');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (31, 1, 'Chuvash', 'cv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (32, 1, 'Cornish', 'kw');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (33, 1, 'Corsican', 'co');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (34, 1, 'Cree', 'cr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (35, 1, 'Croatian', 'hr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (36, 1, 'Czech', 'cs');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (37, 1, 'Danish', 'da');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (38, 1, 'Divehi, Dhivehi, Maldivian', 'dv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (39, 1, 'Dutch', 'nl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (40, 1, 'Dzongkha', 'dz');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (41, 1, 'English', 'en');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (42, 1, 'Esperanto', 'eo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (43, 1, 'Estonian', 'et');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (44, 1, 'Ewe', 'ee');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (45, 1, 'Faroese', 'fo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (46, 1, 'Fijian', 'fj');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (47, 1, 'Finnish', 'fi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (48, 1, 'French', 'fr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (49, 1, 'Fula, Fulah, Pulaar, Pular', 'ff');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (50, 1, 'Galician', 'gl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (51, 1, 'Georgian', 'ka');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (52, 1, 'German', 'de');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (53, 1, 'Greek (modern)', 'el');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (54, 1, 'Guaraní', 'gn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (55, 1, 'Gujarati', 'gu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (56, 1, 'Haitian, Haitian Creole', 'ht');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (57, 1, 'Hausa', 'ha');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (58, 1, 'Hebrew (modern)', 'he');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (59, 1, 'Herero', 'hz');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (60, 1, 'Hindi', 'hi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (61, 1, 'Hiri Motu', 'ho');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (62, 1, 'Hungarian', 'hu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (63, 1, 'Interlingua', 'ia');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (64, 1, 'Indonesian', 'id');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (65, 1, 'Interlingue', 'ie');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (66, 1, 'Irish', 'ga');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (67, 1, 'Igbo', 'ig');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (68, 1, 'Inupiaq', 'ik');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (69, 1, 'Ido', 'io');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (70, 1, 'Icelandic', 'is');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (71, 1, 'Italian', 'it');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (72, 1, 'Inuktitut', 'iu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (73, 1, 'Japanese', 'ja');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (74, 1, 'Javanese', 'jv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (75, 1, 'Kalaallisut, Greenlandic', 'kl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (76, 1, 'Kannada', 'kn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (77, 1, 'Kanuri', 'kr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (78, 1, 'Kashmiri', 'ks');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (79, 1, 'Kazakh', 'kk');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (80, 1, 'Khmer', 'km');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (81, 1, 'Kikuyu, Gikuyu', 'ki');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (82, 1, 'Kinyarwanda', 'rw');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (83, 1, 'Kyrgyz', 'ky');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (84, 1, 'Komi', 'kv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (85, 1, 'Kongo', 'kg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (86, 1, 'Korean', 'ko');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (87, 1, 'Kurdish', 'ku');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (88, 1, 'Kwanyama, Kuanyama', 'kj');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (89, 1, 'Latin', 'la');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (90, 1, 'Luxembourgish, Letzeburgesch', 'lb');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (91, 1, 'Ganda', 'lg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (92, 1, 'Limburgish, Limburgan, Limburger', 'li');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (93, 1, 'Lingala', 'ln');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (94, 1, 'Lao', 'lo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (95, 1, 'Lithuanian', 'lt');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (96, 1, 'Luba-Katanga', 'lu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (97, 1, 'Latvian', 'lv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (98, 1, 'Manx', 'gv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (99, 1, 'Macedonian', 'mk');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (100, 1, 'Malagasy', 'mg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (101, 1, 'Malay', 'ms');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (102, 1, 'Malayalam', 'ml');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (103, 1, 'Maltese', 'mt');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (104, 1, 'M?ori', 'mi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (105, 1, 'Marathi', 'mr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (106, 1, 'Marshallese', 'mh');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (107, 1, 'Mongolian', 'mn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (108, 1, 'Nauruan', 'na');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (109, 1, 'Navajo, Navaho', 'nv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (110, 1, 'Northern Ndebele', 'nd');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (111, 1, 'Nepali', 'ne');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (112, 1, 'Ndonga', 'ng');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (113, 1, 'Norwegian Bokmål', 'nb');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (114, 1, 'Norwegian Nynorsk', 'nn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (115, 1, 'Norwegian', 'no');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (116, 1, 'Nuosu', 'ii');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (117, 1, 'Southern Ndebele', 'nr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (118, 1, 'Occitan', 'oc');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (119, 1, 'Ojibwe, Ojibwa', 'oj');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (120, 1, 'Old Church Slavonic, Church Slavonic, Old Bulgarian', 'cu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (121, 1, 'Oromo', 'om');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (122, 1, 'Oriya', 'or');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (123, 1, 'Ossetian, Ossetic', 'os');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (124, 1, 'Panjabi, Punjabi', 'pa');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (125, 1, 'P?li', 'pi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (126, 1, 'Persian (Farsi)', 'fa');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (127, 1, 'Polish', 'pl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (128, 1, 'Pashto, Pushto', 'ps');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (129, 1, 'Portuguese', 'pt');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (130, 1, 'Quechua', 'qu');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (131, 1, 'Romansh', 'rm');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (132, 1, 'Kirundi', 'rn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (133, 1, 'Reunionese, Reunion Creole', 'rc');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (134, 1, 'Romanian', 'ro');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (135, 1, 'Russian', 'ru');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (136, 1, 'Sanskrit', 'sa');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (137, 1, 'Sardinian', 'sc');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (138, 1, 'Sindhi', 'sd');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (139, 1, 'Northern Sami', 'se');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (140, 1, 'Samoan', 'sm');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (141, 1, 'Sango', 'sg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (142, 1, 'Serbian', 'sr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (143, 1, 'Scottish Gaelic, Gaelic', 'gd');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (144, 1, 'Shona', 'sn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (145, 1, 'Sinhalese, Sinhala', 'si');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (146, 1, 'Slovak', 'sk');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (147, 1, 'Slovene', 'sl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (148, 1, 'Somali', 'so');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (149, 1, 'Southern Sotho', 'st');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (150, 1, 'Spanish', 'es');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (151, 1, 'Sundanese', 'su');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (152, 1, 'Swahili', 'sw');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (153, 1, 'Swati', 'ss');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (154, 1, 'Swedish', 'sv');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (155, 1, 'Tamil', 'ta');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (156, 1, 'Telugu', 'te');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (157, 1, 'Tajik', 'tg');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (158, 1, 'Thai', 'th');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (159, 1, 'Tigrinya', 'ti');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (160, 1, 'Tibetan Standard, Tibetan, Central', 'bo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (161, 1, 'Turkmen', 'tk');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (162, 1, 'Tagalog', 'tl');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (163, 1, 'Tswana', 'tn');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (164, 1, 'Tonga (Tonga Islands)', 'to');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (165, 1, 'Turkish', 'tr');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (166, 1, 'Tsonga', 'ts');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (167, 1, 'Tatar', 'tt');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (168, 1, 'Twi', 'tw');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (169, 1, 'Tahitian', 'ty');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (170, 1, 'Uyghur', 'ug');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (171, 1, 'Ukrainian', 'uk');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (172, 1, 'Urdu', 'ur');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (173, 1, 'Uzbek', 'uz');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (174, 1, 'Venda', 've');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (175, 1, 'Vietnamese', 'vi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (176, 1, 'Volapük', 'vo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (177, 1, 'Walloon', 'wa');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (178, 1, 'Welsh', 'cy');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (179, 1, 'Wolof', 'wo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (180, 1, 'Western Frisian', 'fy');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (181, 1, 'Xhosa', 'xh');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (182, 1, 'Yiddish', 'yi');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (183, 1, 'Yoruba', 'yo');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (184, 1, 'Zhuang, Chuang', 'za');
  INSERT INTO languages (id, version, name, iso639_1) VALUES (185, 1, 'Zulu', 'zu');
  
  INSERT INTO language_locales (id, version, locale) VALUES (1,1,'en');
  INSERT INTO language_locales (id, version, locale) VALUES (2,1,'en_GB');
  INSERT INTO language_locales (id, version, locale) VALUES (3,1,'en_US');
  INSERT INTO language_locales (id, version, locale) VALUES (4,1,'de');
  INSERT INTO language_locales (id, version, locale) VALUES (5,1,'de_AT');
  INSERT INTO language_locales (id, version, locale) VALUES (6,1,'de_CH');
  INSERT INTO language_locales (id, version, locale) VALUES (7,1,'de_DE');
  INSERT INTO language_locales (id, version, locale) VALUES (8,1,'es');
  INSERT INTO language_locales (id, version, locale) VALUES (9,1,'es_ES');
  INSERT INTO language_locales (id, version, locale) VALUES (10,1,'fr');
  INSERT INTO language_locales (id, version, locale) VALUES (11,1,'fr_BE');
  INSERT INTO language_locales (id, version, locale) VALUES (12,1,'fr_CH');
  INSERT INTO language_locales (id, version, locale) VALUES (13,1,'fr_FR');
  INSERT INTO language_locales (id, version, locale) VALUES (14,1,'it');
  INSERT INTO language_locales (id, version, locale) VALUES (15,1,'it_IT');
  INSERT INTO language_locales (id, version, locale) VALUES (16,1,'nl');
  INSERT INTO language_locales (id, version, locale) VALUES (17,1,'nl_BE');
  INSERT INTO language_locales (id, version, locale) VALUES (18,1,'nl_NL');
  
  INSERT INTO bundle_applications (id, version, name, default_locale_id) VALUES (1, 1, 'base-bundle-application', 1);
  
  INSERT INTO bundle_applications (id, version, name, default_locale_id) VALUES (2, 1, 'foo-bar.com', 4);
  
  INSERT INTO basenames (id, version, name) VALUES (1,1,'base-resource-bundles');
  INSERT INTO basenames (id, version, name) VALUES (2,1,'test');
  
  INSERT INTO basenames (id, version, name) VALUES (3,1,'foo');
  
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (1, 1, 1, 4, 1);
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (2, 1, 1, 2, 1);
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (3, 1, 2, 7, 1);
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (4, 1, 2, 3, 1);
  
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (5, 1, 3, 4, 2);
  INSERT INTO bundlenames (id, version, base_name_id, locale_id, owner_id) VALUES (6, 1, 3, 1, 2);
  
  INSERT INTO properties_keys (id, version, name) VALUES (1, 1, 'resource.bundles.test.label');
  INSERT INTO properties_keys (id, version, name) VALUES (2, 1, 'com.example.gui.window.buttons.save');
  INSERT INTO properties_keys (id, version, name) VALUES (3, 1, 'com.example.gui.window.title');
  INSERT INTO properties_keys (id, version, name) VALUES (4, 1, 'com.example.gui.prop.with.params.label');
  INSERT INTO properties_keys (id, version, name) VALUES (5, 1, 'com.example.gui.window.buttons.cancel');
  
  INSERT INTO properties_keys (id, version, name) VALUES (6, 1, 'com.foo-bar.gui.window.buttons.save');
  INSERT INTO properties_keys (id, version, name) VALUES (7, 1, 'com.foo-bar.gui.window.title');
  INSERT INTO properties_keys (id, version, name) VALUES (8, 1, 'com.foo-bar.gui.window.buttons.cancel');
  INSERT INTO properties_keys (id, version, name) VALUES (9, 1, 'com.foo-bar.gui.window.buttons.choose');
  INSERT INTO properties_keys (id, version, name) VALUES (10, 1, 'com.foo-bar.gui.window.buttons.back');
  
  INSERT INTO properties_values (id, version, name) VALUES (1, 1, 'Erstes label');
  INSERT INTO properties_values (id, version, name) VALUES (2, 1, 'First label');
  INSERT INTO properties_values (id, version, name) VALUES (3, 1, 'Speichern');
  INSERT INTO properties_values (id, version, name) VALUES (4, 1, 'Hallo, dort!');
  INSERT INTO properties_values (id, version, name) VALUES (5, 1, 'Hallo ich bin {0} und komme aus {1}.');
  INSERT INTO properties_values (id, version, name) VALUES (6, 1, 'Abbrechen');
  INSERT INTO properties_values (id, version, name) VALUES (7, 1, 'Save');
  INSERT INTO properties_values (id, version, name) VALUES (8, 1, 'Hello, there!');
  INSERT INTO properties_values (id, version, name) VALUES (9, 1, 'Hello i am {0} and i come from {1}.');
  INSERT INTO properties_values (id, version, name) VALUES (10, 1, 'Cancel');
  
  INSERT INTO properties_values (id, version, name) VALUES (11, 1, 'Sichern');
  INSERT INTO properties_values (id, version, name) VALUES (12, 1, 'Eingang');
  INSERT INTO properties_values (id, version, name) VALUES (13, 1, 'Annulieren');
  INSERT INTO properties_values (id, version, name) VALUES (14, 1, 'Auswahl');
  INSERT INTO properties_values (id, version, name) VALUES (15, 1, 'Hinten');
  INSERT INTO properties_values (id, version, name) VALUES (16, 1, 'Persist');
  INSERT INTO properties_values (id, version, name) VALUES (17, 1, 'Entrace');
  INSERT INTO properties_values (id, version, name) VALUES (18, 1, 'Revoke');
  INSERT INTO properties_values (id, version, name) VALUES (19, 1, 'Choose');
  INSERT INTO properties_values (id, version, name) VALUES (20, 1, 'Back');
  
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (1, 1, 1, 1, 1);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (2, 1, 1, 2, 2);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (3, 1, 2, 3, 3);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (4, 1, 3, 4, 3);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (5, 1, 4, 5, 3);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (6, 1, 5, 6, 3);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (7, 1, 2, 7, 4);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (8, 1, 3, 8, 4);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (9, 1, 4, 9, 4);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (10, 1, 5, 10, 4);
  
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (11, 1, 6, 11, 5);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (12, 1, 7, 12, 5);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (13, 1, 8, 13, 5);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (14, 1, 9, 14, 5);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (15, 1, 10, 15, 5);
  
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (16, 1, 6, 16, 6);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (17, 1, 7, 17, 6);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (18, 1, 8, 18, 6);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (19, 1, 9, 19, 6);
  INSERT INTO resourcebundles (id, version, properties_key_id, properties_value_id, bundlename_id) VALUES (20, 1, 10, 20, 6);
  
  alter sequence hibernate_sequence restart with 30;