text: /* 
   * To change this license header, choose License Headers in Project Properties.
   * To change this template file, choose Tools | Templates
   * and open the template in the editor.
   */
  /**
   * Author:  root
   * Created: 10 Aug, 2018
   */
  
  INSERT INTO `countries` (`id`, `country_name`) VALUES
  (1, 'Afghanistan'),
  (2, 'Albania'),
  (3, 'Algeria'),
  (4, 'Andorra'),
  (5, 'Angola'),
  (6, 'Antigua and Barbuda'),
  (7, 'Argentina'),
  (8, 'Armenia'),
  (9, 'Australia'),
  (10, 'Austria'),
  (11, 'Azerbaijan'),
  (12, 'Bahamas, The'),
  (13, 'Bahrain'),
  (14, 'Bangladesh'),
  (15, 'Barbados'),
  (16, 'Belarus'),
  (17, 'Belgium'),
  (18, 'Belize'),
  (19, 'Benin'),
  (20, 'Bhutan'),
  (21, 'Bolivia'),
  (22, 'Bosnia and Herzegovina'),
  (23, 'Botswana'),
  (24, 'Brazil'),
  (25, 'Brunei'),
  (26, 'Bulgaria'),
  (27, 'Burkina Faso'),
  (28, 'Burma'),
  (29, 'Burundi'),
  (30, 'Cambodia'),
  (31, 'Cameroon'),
  (32, 'Canada'),
  (33, 'Cape Verde'),
  (34, 'Central Africa'),
  (35, 'Chad'),
  (36, 'Chile'),
  (37, 'China'),
  (38, 'Colombia'),
  (39, 'Comoros'),
  (40, 'Congo, Democratic Republic of the'),
  (41, 'Costa Rica'),
  (42, 'Cote dIvoire'),
  (43, 'Crete'),
  (44, 'Croatia'),
  (45, 'Cuba'),
  (46, 'Cyprus'),
  (47, 'Czech Republic'),
  (48, 'Denmark'),
  (49, 'Djibouti'),
  (50, 'Dominican Republic'),
  (51, 'East Timor'),
  (52, 'Ecuador'),
  (53, 'Egypt'),
  (54, 'El Salvador'),
  (55, 'Equatorial Guinea'),
  (56, 'Eritrea'),
  (57, 'Estonia'),
  (58, 'Ethiopia'),
  (59, 'Fiji'),
  (60, 'Finland'),
  (61, 'France'),
  (62, 'Gabon'),
  (63, 'Gambia, The'),
  (64, 'Georgia'),
  (65, 'Germany'),
  (66, 'Ghana'),
  (67, 'Greece'),
  (68, 'Grenada'),
  (69, 'Guadeloupe'),
  (70, 'Guatemala'),
  (71, 'Guinea'),
  (72, 'Guinea-Bissau'),
  (73, 'Guyana'),
  (74, 'Haiti'),
  (75, 'Holy See'),
  (76, 'Honduras'),
  (77, 'Hong Kong'),
  (78, 'Hungary'),
  (79, 'Iceland'),
  (80, 'India'),
  (81, 'Indonesia'),
  (82, 'Iran'),
  (83, 'Iraq'),
  (84, 'Ireland'),
  (85, 'Israel'),
  (86, 'Italy'),
  (87, 'Ivory Coast'),
  (88, 'Jamaica'),
  (89, 'Japan'),
  (90, 'Jordan'),
  (91, 'Kazakhstan'),
  (92, 'Kenya'),
  (93, 'Kiribati'),
  (94, 'Korea, North'),
  (95, 'Korea, South'),
  (96, 'Kosovo'),
  (97, 'Kuwait'),
  (98, 'Kyrgyzstan'),
  (99, 'Laos'),
  (100, 'Latvia'),
  (101, 'Lebanon'),
  (102, 'Lesotho'),
  (103, 'Liberia'),
  (104, 'Libya'),
  (105, 'Liechtenstein'),
  (106, 'Lithuania'),
  (107, 'Macau'),
  (108, 'Macedonia'),
  (109, 'Madagascar'),
  (110, 'Malawi'),
  (111, 'Malaysia'),
  (112, 'Maldives'),
  (113, 'Mali'),
  (114, 'Malta'),
  (115, 'Marshall Islands'),
  (116, 'Mauritania'),
  (117, 'Mauritius'),
  (118, 'Mexico'),
  (119, 'Micronesia'),
  (120, 'Moldova'),
  (121, 'Monaco'),
  (122, 'Mongolia'),
  (123, 'Montenegro'),
  (124, 'Morocco'),
  (125, 'Mozambique'),
  (126, 'Namibia'),
  (127, 'Nauru'),
  (128, 'Nepal'),
  (129, 'Netherlands'),
  (130, 'New Zealand'),
  (131, 'Nicaragua'),
  (132, 'Niger'),
  (133, 'Nigeria'),
  (134, 'North Korea'),
  (135, 'Norway'),
  (136, 'Oman'),
  (137, 'Pakistan'),
  (138, 'Palau'),
  (139, 'Panama'),
  (140, 'Papua New Guinea'),
  (141, 'Paraguay'),
  (142, 'Peru'),
  (143, 'Philippines'),
  (144, 'Poland'),
  (145, 'Portugal'),
  (146, 'Qatar'),
  (147, 'Romania'),
  (148, 'Russia'),
  (149, 'Rwanda'),
  (150, 'Saint Lucia'),
  (151, 'Saint Vincent and the Grenadines'),
  (152, 'Samoa'),
  (153, 'San Marino'),
  (154, 'Sao Tome and Principe'),
  (155, 'Saudi Arabia'),
  (156, 'Scotland'),
  (157, 'Senegal'),
  (158, 'Serbia'),
  (159, 'Seychelles'),
  (160, 'Sierra Leone'),
  (161, 'Singapore'),
  (162, 'Slovakia'),
  (163, 'Slovenia'),
  (164, 'Solomon Islands'),
  (165, 'Somalia'),
  (166, 'South Africa'),
  (167, 'South Korea'),
  (168, 'Spain'),
  (169, 'Sri Lanka'),
  (170, 'Sudan'),
  (171, 'Suriname'),
  (172, 'Swaziland'),
  (173, 'Sweden'),
  (174, 'Switzerland'),
  (175, 'Syria'),
  (176, 'Taiwan'),
  (177, 'Tajikistan'),
  (178, 'Tanzania'),
  (179, 'Thailand'),
  (180, 'Tibet'),
  (181, 'Timor-Leste'),
  (182, 'Togo'),
  (183, 'Tonga'),
  (184, 'Trinidad and Tobago'),
  (185, 'Tunisia'),
  (186, 'Turkey'),
  (187, 'Turkmenistan'),
  (188, 'Tuvalu'),
  (189, 'Uganda'),
  (190, 'Ukraine'),
  (191, 'United Arab Emirates'),
  (192, 'United Kingdom'),
  (193, 'United States'),
  (194, 'Uruguay'),
  (195, 'Uzbekistan'),
  (196, 'Vanuatu'),
  (197, 'Venezuela'),
  (198, 'Vietnam'),
  (199, 'Yemen'),
  (200, 'Zambia'),
  (201, 'Zimbabwe');
  