INSERT INTO countries (id, country, country_code, phone_code) VALUES
(1, 'Afghanistan', 'AF', '+93'),
(2, 'Albania', 'AL', '+355'),
(3, 'Algeria', 'DZ', '+213'),
(4, 'American Samoa', 'AS', '+1-684'),
(5, 'Andorra', 'AD', '+376'),
(6, 'Angola', 'AO', '+244'),
(7, 'Anguilla', 'AI', '+1-264'),
(8, 'Antarctica', 'AQ', '+672'),
(9, 'Antigua and Barbuda', 'AG', '+1-268'),
(10, 'Argentina', 'AR', '+54'),
(11, 'Armenia', 'AM', '+374'),
(12, 'Aruba', 'AW', '+297'),
(13, 'Australia', 'AU', '+61'),
(14, 'Austria', 'AT', '+43'),
(15, 'Azerbaijan', 'AZ', '+994'),
(16, 'Bahamas', 'BS', '+1-242'),
(17, 'Bahrain', 'BH', '+973'),
(18, 'Bangladesh', 'BD', '+880'),
(19, 'Barbados', 'BB', '+1-246'),
(20, 'Belarus', 'BY', '+375'),
(21, 'Belgium', 'BE', '+32'),
(22, 'Belize', 'BZ', '+501'),
(23, 'Benin', 'BJ', '+229'),
(24, 'Bermuda', 'BM', '+1-441'),
(25, 'Bhutan', 'BT', '+975'),
(26, 'Bolivia', 'BO', '+591'),
(27, 'Bonaire, Sint Eustatius and Saba', 'BQ', '+599'),
(28, 'Bosnia and Herzegovina', 'BA', '+387'),
(29, 'Botswana', 'BW', '+267'),
(30, 'Brazil', 'BR', '+55'),
(31, 'British Indian Ocean Territory', 'IO', '+246'),
(32, 'British Virgin Islands', 'VG', '+1-284'),
(33, 'Brunei', 'BN', '+673'),
(34, 'Bulgaria', 'BG', '+359'),
(35, 'Burkina Faso', 'BF', '+226'),
(36, 'Burundi', 'BI', '+257'),
(37, 'Cambodia', 'KH', '+855'),
(38, 'Cameroon', 'CM', '+237'),
(39, 'Canada', 'CA', '+1'),
(40, 'Cape Verde', 'CV', '+238'),
(41, 'Cayman Islands', 'KY', '+1-345'),
(42, 'Central African Republic', 'CF', '+236'),
(43, 'Chad', 'TD', '+235'),
(44, 'Chile', 'CL', '+56'),
(45, 'China', 'CN', '+86'),
(46, 'Christmas Island', 'CX', '+61'),
(47, 'Cocos Islands', 'CC', '+61'),
(48, 'Colombia', 'CO', '+57'),
(49, 'Comoros', 'KM', '+269'),
(50, 'Cook Islands', 'CK', '+682'),
(51, 'Costa Rica', 'CR', '+506'),
(52, 'Croatia', 'HR', '+385'),
(53, 'Cuba', 'CU', '+53'),
(54, 'Curacao', 'CW', '+599'),
(55, 'Cyprus', 'CY', '+357'),
(56, 'Czech Republic', 'CZ', '+420'),
(57, 'Democratic Republic of the Congo', 'CD', '+243'),
(58, 'Denmark', 'DK', '+45'),
(59, 'Djibouti', 'DJ', '+253'),
(60, 'Dominica', 'DM', '+1-767'),
(61, 'Dominican Republic', 'DO', '+1-809, 1-'),
(62, 'East Timor', 'TL', '+670'),
(63, 'Ecuador', 'EC', '+593'),
(64, 'Egypt', 'EG', '+20'),
(65, 'El Salvador', 'SV', '+503'),
(66, 'Equatorial Guinea', 'GQ', '+240'),
(67, 'Eritrea', 'ER', '+291'),
(68, 'Estonia', 'EE', '+372'),
(69, 'Ethiopia', 'ET', '+251'),
(70, 'Falkland Islands', 'FK', '+500'),
(71, 'Faroe Islands', 'FO', '+298'),
(72, 'Fiji', 'FJ', '+679'),
(73, 'Finland', 'FI', '+358'),
(74, 'France', 'FR', '+33'),
(75, 'French Guiana', 'GF', '+594'),
(76, 'French Polynesia', 'PF', '+689'),
(77, 'Gabon', 'GA', '+241'),
(78, 'Gambia', 'GM', '+220'),
(79, 'Georgia', 'GE', '+995'),
(80, 'Germany', 'DE', '+49'),
(81, 'Ghana', 'GH', '+233'),
(82, 'Gibraltar', 'GI', '+350'),
(83, 'Greece', 'GR', '+30'),
(84, 'Greenland', 'GL', '+299'),
(85, 'Grenada', 'GD', '+1-473'),
(86, 'Guadeloupe', 'GP', '+590'),
(87, 'Guam', 'GU', '+1-671'),
(88, 'Guatemala', 'GT', '+502'),
(89, 'Guernsey', 'GG', '+44-1481'),
(90, 'Guinea', 'GN', '+224'),
(91, 'Guinea-Bissau', 'GW', '+245'),
(92, 'Guyana', 'GY', '+592'),
(93, 'Haiti', 'HT', '+509'),
(94, 'Honduras', 'HN', '+504'),
(95, 'Hong Kong', 'HK', '+852'),
(96, 'Hungary', 'HU', '+36'),
(97, 'Iceland', 'IS', '+354'),
(98, 'India', 'IN', '+91'),
(99, 'Indonesia', 'ID', '+62'),
(100, 'Iran', 'IR', '+98'),
(101, 'Iraq', 'IQ', '+964'),
(102, 'Ireland', 'IE', '+353'),
(103, 'Isle of Man', 'IM', '+44-1624'),
(104, 'Israel', 'IL', '+972'),
(105, 'Italy', 'IT', '+39'),
(106, 'Ivory Coast', 'CI', '+225'),
(107, 'Jamaica', 'JM', '+1-876'),
(108, 'Japan', 'JP', '+81'),
(109, 'Jersey', 'JE', '+44-1534'),
(110, 'Jordan', 'JO', '+962'),
(111, 'Kazakhstan', 'KZ', '+7'),
(112, 'Kenya', 'KE', '+254'),
(113, 'Kiribati', 'KI', '+686'),
(114, 'Kosovo', 'XK', '+383'),
(115, 'Kuwait', 'KW', '+965'),
(116, 'Kyrgyzstan', 'KG', '+996'),
(117, 'Laos', 'LA', '+856'),
(118, 'Latvia', 'LV', '+371'),
(119, 'Lebanon', 'LB', '+961'),
(120, 'Lesotho', 'LS', '+266'),
(121, 'Liberia', 'LR', '+231'),
(122, 'Libya', 'LY', '+218'),
(123, 'Liechtenstein', 'LI', '+423'),
(124, 'Lithuania', 'LT', '+370'),
(125, 'Luxembourg', 'LU', '+352'),
(126, 'Macau', 'MO', '+853'),
(127, 'Macedonia', 'MK', '+389'),
(128, 'Madagascar', 'MG', '+261'),
(129, 'Malawi', 'MW', '+265'),
(130, 'Malaysia', 'MY', '+60'),
(131, 'Maldives', 'MV', '+960'),
(132, 'Mali', 'ML', '+223'),
(133, 'Malta', 'MT', '+356'),
(134, 'Marshall Islands', 'MH', '+692'),
(135, 'Martinique', 'MQ', '+596'),
(136, 'Mauritania', 'MR', '+222'),
(137, 'Mauritius', 'MU', '+230'),
(138, 'Mayotte', 'YT', '+262'),
(139, 'Mexico', 'MX', '+52'),
(140, 'Micronesia', 'FM', '+691'),
(141, 'Moldova', 'MD', '+373'),
(142, 'Monaco', 'MC', '+377'),
(143, 'Mongolia', 'MN', '+976'),
(144, 'Montenegro', 'ME', '+382'),
(145, 'Montserrat', 'MS', '+1-664'),
(146, 'Morocco', 'MA', '+212'),
(147, 'Mozambique', 'MZ', '+258'),
(148, 'Myanmar', 'MM', '+95'),
(149, 'Namibia', 'NA', '+264'),
(150, 'Nauru', 'NR', '+674'),
(151, 'Nepal', 'NP', '+977'),
(152, 'Netherlands', 'NL', '+31'),
(153, 'Netherlands Antilles', 'AN', '+599'),
(154, 'New Caledonia', 'NC', '+687'),
(155, 'New Zealand', 'NZ', '+64'),
(156, 'Nicaragua', 'NI', '+505'),
(157, 'Niger', 'NE', '+227'),
(158, 'Nigeria', 'NG', '+234'),
(159, 'Niue', 'NU', '+683'),
(160, 'Norfolk Island', 'NF', '+6723'),
(161, 'North Korea', 'KP', '+850'),
(162, 'Northern Mariana Islands', 'MP', '+1-670'),
(163, 'Norway', 'NO', '+47'),
(164, 'Oman', 'OM', '+968'),
(165, 'Pakistan', 'PK', '+92'),
(166, 'Palau', 'PW', '+680'),
(167, 'Palestine', 'PS', '+970'),
(168, 'Panama', 'PA', '+507'),
(169, 'Papua New Guinea', 'PG', '+675'),
(170, 'Paraguay', 'PY', '+595'),
(171, 'Peru', 'PE', '+51'),
(172, 'Philippines', 'PH', '+63'),
(173, 'Pitcairn', 'PN', '+64'),
(174, 'Poland', 'PL', '+48'),
(175, 'Portugal', 'PT', '+351'),
(176, 'Puerto Rico', 'PR', '+1-787, 1-'),
(177, 'Qatar', 'QA', '+974'),
(178, 'Republic of the Congo', 'CG', '+242'),
(179, 'Reunion', 'RE', '+262'),
(180, 'Romania', 'RO', '+40'),
(181, 'Russia', 'RU', '+7'),
(182, 'Rwanda', 'RW', '+250'),
(183, 'Saint Barthelemy', 'BL', '+590'),
(184, 'Saint Helena', 'SH', '+290'),
(185, 'Saint Kitts and Nevis', 'KN', '+1-869'),
(186, 'Saint Lucia', 'LC', '+1-758'),
(187, 'Saint Martin', 'MF', '+590'),
(188, 'Saint Pierre and Miquelon', 'PM', '+508'),
(189, 'Saint Vincent and the Grenadines', 'VC', '+1-784'),
(190, 'Samoa', 'WS', '+685'),
(191, 'San Marino', 'SM', '+378'),
(192, 'Sao Tome and Principe', 'ST', '+239'),
(193, 'Saudi Arabia', 'SA', '+966'),
(194, 'Senegal', 'SN', '+221'),
(195, 'Serbia', 'RS', '+381'),
(196, 'Seychelles', 'SC', '+248'),
(197, 'Sierra Leone', 'SL', '+232'),
(198, 'Singapore', 'SG', '+65'),
(199, 'Sint Maarten', 'SX', '+1-721'),
(200, 'Slovakia', 'SK', '+421'),
(201, 'Slovenia', 'SI', '+386'),
(202, 'Solomon Islands', 'SB', '+677'),
(203, 'Somalia', 'SO', '+252'),
(204, 'South Africa', 'ZA', '+27'),
(205, 'South Korea', 'KR', '+82'),
(206, 'South Georgia and the South Sandwich Islands', 'GS', '+500'),
(207, 'South Sudan', 'SS', '+211'),
(208, 'Spain', 'ES', '+34'),
(209, 'Sri Lanka', 'LK', '+94'),
(210, 'Sudan', 'SD', '+249'),
(211, 'Suriname', 'SR', '+597'),
(212, 'Svalbard and Jan Mayen', 'SJ', '+47'),
(213, 'Swaziland', 'SZ', '+268'),
(214, 'Sweden', 'SE', '+46'),
(215, 'Switzerland', 'CH', '+41'),
(216, 'Syria', 'SY', '+963'),
(217, 'Taiwan', 'TW', '+886'),
(218, 'Tajikistan', 'TJ', '+992'),
(219, 'Tanzania', 'TZ', '+255'),
(220, 'Thailand', 'TH', '+66'),
(221, 'Togo', 'TG', '+228'),
(222, 'Tokelau', 'TK', '+690'),
(223, 'Tonga', 'TO', '+676'),
(224, 'Trinidad and Tobago', 'TT', '+1-868'),
(225, 'Tunisia', 'TN', '+216'),
(226, 'Turkey', 'TR', '+90'),
(227, 'Turkmenistan', 'TM', '+993'),
(228, 'Turks and Caicos Islands', 'TC', '+1-649'),
(229, 'Tuvalu', 'TV', '+688'),
(230, 'U.S. Virgin Islands', 'VI', '+1-340'),
(231, 'Uganda', 'UG', '+256'),
(232, 'Ukraine', 'UA', '+380'),
(233, 'United Arab Emirates', 'AE', '+971'),
(234, 'United Kingdom of Great Britain and Northern Ireland', 'GB', '+44'),
(235, 'United States of America', 'US', '+1'),
(236, 'Uruguay', 'UY', '+598'),
(237, 'Uzbekistan', 'UZ', '+998'),
(238, 'Vanuatu', 'VU', '+678'),
(239, 'Vatican', 'VA', '+379'),
(240, 'Venezuela', 'VE', '+58'),
(241, 'Vietnam', 'VN', '+84'),
(242, 'Wallis and Futuna', 'WF', '+681'),
(243, 'Western Sahara', 'EH', '+212'),
(244, 'Yemen', 'YE', '+967'),
(245, 'Zambia', 'ZM', '+260'),
(246, 'Zimbabwe', 'ZW', '+263');