CREATE SCHEMA geography;

USE geography;

-- Continents

CREATE TABLE IF NOT EXISTS `continents` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `continent_code` varchar(2) DEFAULT NULL,
    `continent_name` varchar(30) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

INSERT INTO `continents` (`id`, `continent_code`, `continent_name`) VALUES
(1, 'AF', 'Africa'),
(2, 'AN', 'Antarctica'),
(3, 'AS', 'Asia'),
(4, 'EU', 'Europe'),
(5, 'OC', 'Australia'),
(6, 'NA', 'North America'),
(7, 'SA', 'South America');

-- All countries

CREATE TABLE IF NOT EXISTS `countries` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `phone` int(5) NOT NULL,
    `code` char(2) NOT NULL,
    `name` varchar(80) NOT NULL,
    `capital` varchar(80) DEFAULT NULL,
    `currency` varchar(3) DEFAULT NULL,
    `continent_code` varchar(2) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8;

-- https://www.html-code-generator.com/mysql/country-name-table

INSERT INTO `countries` (`id`, `phone`, `code`, `name`, `capital`, `currency`, `continent_code`) VALUES
(1, 93, 'AF', 'Afghanistan', 'Kabul', 'AFN', 'AS'),
(2, 358, 'AX', 'Aland Islands', 'Mariehamn', 'EUR', 'EU'),
(3, 355, 'AL', 'Albania', 'Tirana', 'ALL', 'EU'),
(4, 213, 'DZ', 'Algeria', 'Algiers', 'DZD', 'AF'),
(5, 1684, 'AS', 'American Samoa', 'Pago Pago', 'USD', 'OC'),
(6, 376, 'AD', 'Andorra', 'Andorra la Vella', 'EUR', 'EU'),
(7, 244, 'AO', 'Angola', 'Luanda', 'AOA', 'AF'),
(8, 1264, 'AI', 'Anguilla', 'The Valley', 'XCD', 'NA'),
(9, 672, 'AQ', 'Antarctica', 'Antarctica', 'AAD', 'AN'),
(10, 1268, 'AG', 'Antigua and Barbuda', 'St. John\'s', 'XCD', 'NA'),
(11, 54, 'AR', 'Argentina', 'Buenos Aires', 'ARS', 'SA'),
(12, 374, 'AM', 'Armenia', 'Yerevan', 'AMD', 'AS'),
(13, 297, 'AW', 'Aruba', 'Oranjestad', 'AWG', 'NA'),
(14, 61, 'AU', 'Australia', 'Canberra', 'AUD', 'OC'),
(15, 43, 'AT', 'Austria', 'Vienna', 'EUR', 'EU'),
(16, 994, 'AZ', 'Azerbaijan', 'Baku', 'AZN', 'AS'),
(17, 1242, 'BS', 'Bahamas', 'Nassau', 'BSD', 'NA'),
(18, 973, 'BH', 'Bahrain', 'Manama', 'BHD', 'AS'),
(19, 880, 'BD', 'Bangladesh', 'Dhaka', 'BDT', 'AS'),
(20, 1246, 'BB', 'Barbados', 'Bridgetown', 'BBD', 'NA'),
(21, 375, 'BY', 'Belarus', 'Minsk', 'BYN', 'EU'),
(22, 32, 'BE', 'Belgium', 'Brussels', 'EUR', 'EU'),
(23, 501, 'BZ', 'Belize', 'Belmopan', 'BZD', 'NA'),
(24, 229, 'BJ', 'Benin', 'Porto-Novo', 'XOF', 'AF'),
(25, 1441, 'BM', 'Bermuda', 'Hamilton', 'BMD', 'NA'),
(26, 975, 'BT', 'Bhutan', 'Thimphu', 'BTN', 'AS'),
(27, 591, 'BO', 'Bolivia', 'Sucre', 'BOB', 'SA'),
(28, 599, 'BQ', 'Bonaire, Sint Eustatius and Saba', 'Kralendijk', 'USD', 'NA'),
(29, 387, 'BA', 'Bosnia and Herzegovina', 'Sarajevo', 'BAM', 'EU'),
(30, 267, 'BW', 'Botswana', 'Gaborone', 'BWP', 'AF'),
(31, 55, 'BV', 'Bouvet Island', '', 'NOK', 'AN'),
(32, 55, 'BR', 'Brazil', 'Brasilia', 'BRL', 'SA'),
(33, 246, 'IO', 'British Indian Ocean Territory', 'Diego Garcia', 'USD', 'AS'),
(34, 673, 'BN', 'Brunei Darussalam', 'Bandar Seri Begawan', 'BND', 'AS'),
(35, 359, 'BG', 'Bulgaria', 'Sofia', 'BGN', 'EU'),
(36, 226, 'BF', 'Burkina Faso', 'Ouagadougou', 'XOF', 'AF'),
(37, 257, 'BI', 'Burundi', 'Bujumbura', 'BIF', 'AF'),
(38, 855, 'KH', 'Cambodia', 'Phnom Penh', 'KHR', 'AS'),
(39, 237, 'CM', 'Cameroon', 'Yaounde', 'XAF', 'AF'),
(40, 1, 'CA', 'Canada', 'Ottawa', 'CAD', 'NA'),
(41, 238, 'CV', 'Cape Verde', 'Praia', 'CVE', 'AF'),
(42, 1345, 'KY', 'Cayman Islands', 'George Town', 'KYD', 'NA'),
(43, 236, 'CF', 'Central African Republic', 'Bangui', 'XAF', 'AF'),
(44, 235, 'TD', 'Chad', 'N\'Djamena', 'XAF', 'AF'),
(45, 56, 'CL', 'Chile', 'Santiago', 'CLP', 'SA'),
(46, 86, 'CN', 'China', 'Beijing', 'CNY', 'AS'),
(47, 61, 'CX', 'Christmas Island', 'Flying Fish Cove', 'AUD', 'AS'),
(48, 672, 'CC', 'Cocos (Keeling) Islands', 'West Island', 'AUD', 'AS'),
(49, 57, 'CO', 'Colombia', 'Bogota', 'COP', 'SA'),
(50, 269, 'KM', 'Comoros', 'Moroni', 'KMF', 'AF'),
(51, 242, 'CG', 'Congo', 'Brazzaville', 'XAF', 'AF'),
(52, 242, 'CD', 'Congo, Democratic Republic of the Congo', 'Kinshasa', 'CDF', 'AF'),
(53, 682, 'CK', 'Cook Islands', 'Avarua', 'NZD', 'OC'),
(54, 506, 'CR', 'Costa Rica', 'San Jose', 'CRC', 'NA'),
(55, 225, 'CI', 'Cote D\'Ivoire', 'Yamoussoukro', 'XOF', 'AF'),
(56, 385, 'HR', 'Croatia', 'Zagreb', 'HRK', 'EU'),
(57, 53, 'CU', 'Cuba', 'Havana', 'CUP', 'NA'),
(58, 599, 'CW', 'Curacao', 'Willemstad', 'ANG', 'NA'),
(59, 357, 'CY', 'Cyprus', 'Nicosia', 'EUR', 'AS'),
(60, 420, 'CZ', 'Czech Republic', 'Prague', 'CZK', 'EU'),
(61, 45, 'DK', 'Denmark', 'Copenhagen', 'DKK', 'EU'),
(62, 253, 'DJ', 'Djibouti', 'Djibouti', 'DJF', 'AF'),
(63, 1767, 'DM', 'Dominica', 'Roseau', 'XCD', 'NA'),
(64, 1809, 'DO', 'Dominican Republic', 'Santo Domingo', 'DOP', 'NA'),
(65, 593, 'EC', 'Ecuador', 'Quito', 'USD', 'SA'),
(66, 20, 'EG', 'Egypt', 'Cairo', 'EGP', 'AF'),
(67, 503, 'SV', 'El Salvador', 'San Salvador', 'USD', 'NA'),
(68, 240, 'GQ', 'Equatorial Guinea', 'Malabo', 'XAF', 'AF'),
(69, 291, 'ER', 'Eritrea', 'Asmara', 'ERN', 'AF'),
(70, 372, 'EE', 'Estonia', 'Tallinn', 'EUR', 'EU'),
(71, 251, 'ET', 'Ethiopia', 'Addis Ababa', 'ETB', 'AF'),
(72, 500, 'FK', 'Falkland Islands (Malvinas)', 'Stanley', 'FKP', 'SA'),
(73, 298, 'FO', 'Faroe Islands', 'Torshavn', 'DKK', 'EU'),
(74, 679, 'FJ', 'Fiji', 'Suva', 'FJD', 'OC'),
(75, 358, 'FI', 'Finland', 'Helsinki', 'EUR', 'EU'),
(76, 33, 'FR', 'France', 'Paris', 'EUR', 'EU'),
(77, 594, 'GF', 'French Guiana', 'Cayenne', 'EUR', 'SA'),
(78, 689, 'PF', 'French Polynesia', 'Papeete', 'XPF', 'OC'),
(79, 262, 'TF', 'French Southern Territories', 'Port-aux-Francais', 'EUR', 'AN'),
(80, 241, 'GA', 'Gabon', 'Libreville', 'XAF', 'AF'),
(81, 220, 'GM', 'Gambia', 'Banjul', 'GMD', 'AF'),
(82, 995, 'GE', 'Georgia', 'Tbilisi', 'GEL', 'AS'),
(83, 49, 'DE', 'Germany', 'Berlin', 'EUR', 'EU'),
(84, 233, 'GH', 'Ghana', 'Accra', 'GHS', 'AF'),
(85, 350, 'GI', 'Gibraltar', 'Gibraltar', 'GIP', 'EU'),
(86, 30, 'GR', 'Greece', 'Athens', 'EUR', 'EU'),
(87, 299, 'GL', 'Greenland', 'Nuuk', 'DKK', 'NA'),
(88, 1473, 'GD', 'Grenada', 'St. George\'s', 'XCD', 'NA'),
(89, 590, 'GP', 'Guadeloupe', 'Basse-Terre', 'EUR', 'NA'),
(90, 1671, 'GU', 'Guam', 'Hagatna', 'USD', 'OC'),
(91, 502, 'GT', 'Guatemala', 'Guatemala City', 'GTQ', 'NA'),
(92, 44, 'GG', 'Guernsey', 'St Peter Port', 'GBP', 'EU'),
(93, 224, 'GN', 'Guinea', 'Conakry', 'GNF', 'AF'),
(94, 245, 'GW', 'Guinea-Bissau', 'Bissau', 'XOF', 'AF'),
(95, 592, 'GY', 'Guyana', 'Georgetown', 'GYD', 'SA'),
(96, 509, 'HT', 'Haiti', 'Port-au-Prince', 'HTG', 'NA'),
(97, 0, 'HM', 'Heard Island and Mcdonald Islands', '', 'AUD', 'AN'),
(98, 39, 'VA', 'Holy See (Vatican City State)', 'Vatican City', 'EUR', 'EU'),
(99, 504, 'HN', 'Honduras', 'Tegucigalpa', 'HNL', 'NA'),
(100, 852, 'HK', 'Hong Kong', 'Hong Kong', 'HKD', 'AS'),
(101, 36, 'HU', 'Hungary', 'Budapest', 'HUF', 'EU'),
(102, 354, 'IS', 'Iceland', 'Reykjavik', 'ISK', 'EU'),
(103, 91, 'IN', 'India', 'New Delhi', 'INR', 'AS'),
(104, 62, 'ID', 'Indonesia', 'Jakarta', 'IDR', 'AS'),
(105, 98, 'IR', 'Iran, Islamic Republic of', 'Tehran', 'IRR', 'AS'),
(106, 964, 'IQ', 'Iraq', 'Baghdad', 'IQD', 'AS'),
(107, 353, 'IE', 'Ireland', 'Dublin', 'EUR', 'EU'),
(108, 44, 'IM', 'Isle of Man', 'Douglas, Isle of Man', 'GBP', 'EU'),
(109, 972, 'IL', 'Israel', 'Jerusalem', 'ILS', 'AS'),
(110, 39, 'IT', 'Italy', 'Rome', 'EUR', 'EU'),
(111, 1876, 'JM', 'Jamaica', 'Kingston', 'JMD', 'NA'),
(112, 81, 'JP', 'Japan', 'Tokyo', 'JPY', 'AS'),
(113, 44, 'JE', 'Jersey', 'Saint Helier', 'GBP', 'EU'),
(114, 962, 'JO', 'Jordan', 'Amman', 'JOD', 'AS'),
(115, 7, 'KZ', 'Kazakhstan', 'Astana', 'KZT', 'AS'),
(116, 254, 'KE', 'Kenya', 'Nairobi', 'KES', 'AF'),
(117, 686, 'KI', 'Kiribati', 'Tarawa', 'AUD', 'OC'),
(118, 850, 'KP', 'Korea, Democratic People\'s Republic of', 'Pyongyang', 'KPW', 'AS'),
(119, 82, 'KR', 'Korea, Republic of', 'Seoul', 'KRW', 'AS'),
(120, 381, 'XK', 'Kosovo', 'Pristina', 'EUR', 'EU'),
(121, 965, 'KW', 'Kuwait', 'Kuwait City', 'KWD', 'AS'),
(122, 996, 'KG', 'Kyrgyzstan', 'Bishkek', 'KGS', 'AS'),
(123, 856, 'LA', 'Lao People\'s Democratic Republic', 'Vientiane', 'LAK', 'AS'),
(124, 371, 'LV', 'Latvia', 'Riga', 'EUR', 'EU'),
(125, 961, 'LB', 'Lebanon', 'Beirut', 'LBP', 'AS'),
(126, 266, 'LS', 'Lesotho', 'Maseru', 'LSL', 'AF'),
(127, 231, 'LR', 'Liberia', 'Monrovia', 'LRD', 'AF'),
(128, 218, 'LY', 'Libyan Arab Jamahiriya', 'Tripolis', 'LYD', 'AF'),
(129, 423, 'LI', 'Liechtenstein', 'Vaduz', 'CHF', 'EU'),
(130, 370, 'LT', 'Lithuania', 'Vilnius', 'EUR', 'EU'),
(131, 352, 'LU', 'Luxembourg', 'Luxembourg', 'EUR', 'EU'),
(132, 853, 'MO', 'Macao', 'Macao', 'MOP', 'AS'),
(133, 389, 'MK', 'Macedonia, the Former Yugoslav Republic of', 'Skopje', 'MKD', 'EU'),
(134, 261, 'MG', 'Madagascar', 'Antananarivo', 'MGA', 'AF'),
(135, 265, 'MW', 'Malawi', 'Lilongwe', 'MWK', 'AF'),
(136, 60, 'MY', 'Malaysia', 'Kuala Lumpur', 'MYR', 'AS'),
(137, 960, 'MV', 'Maldives', 'Male', 'MVR', 'AS'),
(138, 223, 'ML', 'Mali', 'Bamako', 'XOF', 'AF'),
(139, 356, 'MT', 'Malta', 'Valletta', 'EUR', 'EU'),
(140, 692, 'MH', 'Marshall Islands', 'Majuro', 'USD', 'OC'),
(141, 596, 'MQ', 'Martinique', 'Fort-de-France', 'EUR', 'NA'),
(142, 222, 'MR', 'Mauritania', 'Nouakchott', 'MRO', 'AF'),
(143, 230, 'MU', 'Mauritius', 'Port Louis', 'MUR', 'AF'),
(144, 262, 'YT', 'Mayotte', 'Mamoudzou', 'EUR', 'AF'),
(145, 52, 'MX', 'Mexico', 'Mexico City', 'MXN', 'NA'),
(146, 691, 'FM', 'Micronesia, Federated States of', 'Palikir', 'USD', 'OC'),
(147, 373, 'MD', 'Moldova, Republic of', 'Chisinau', 'MDL', 'EU'),
(148, 377, 'MC', 'Monaco', 'Monaco', 'EUR', 'EU'),
(149, 976, 'MN', 'Mongolia', 'Ulan Bator', 'MNT', 'AS'),
(150, 382, 'ME', 'Montenegro', 'Podgorica', 'EUR', 'EU'),
(151, 1664, 'MS', 'Montserrat', 'Plymouth', 'XCD', 'NA'),
(152, 212, 'MA', 'Morocco', 'Rabat', 'MAD', 'AF'),
(153, 258, 'MZ', 'Mozambique', 'Maputo', 'MZN', 'AF'),
(154, 95, 'MM', 'Myanmar', 'Nay Pyi Taw', 'MMK', 'AS'),
(155, 264, 'NA', 'Namibia', 'Windhoek', 'NAD', 'AF'),
(156, 674, 'NR', 'Nauru', 'Yaren', 'AUD', 'OC'),
(157, 977, 'NP', 'Nepal', 'Kathmandu', 'NPR', 'AS'),
(158, 31, 'NL', 'Netherlands', 'Amsterdam', 'EUR', 'EU'),
(159, 599, 'AN', 'Netherlands Antilles', 'Willemstad', 'ANG', 'NA'),
(160, 687, 'NC', 'New Caledonia', 'Noumea', 'XPF', 'OC'),
(161, 64, 'NZ', 'New Zealand', 'Wellington', 'NZD', 'OC'),
(162, 505, 'NI', 'Nicaragua', 'Managua', 'NIO', 'NA'),
(163, 227, 'NE', 'Niger', 'Niamey', 'XOF', 'AF'),
(164, 234, 'NG', 'Nigeria', 'Abuja', 'NGN', 'AF'),
(165, 683, 'NU', 'Niue', 'Alofi', 'NZD', 'OC'),
(166, 672, 'NF', 'Norfolk Island', 'Kingston', 'AUD', 'OC'),
(167, 1670, 'MP', 'Northern Mariana Islands', 'Saipan', 'USD', 'OC'),
(168, 47, 'NO', 'Norway', 'Oslo', 'NOK', 'EU'),
(169, 968, 'OM', 'Oman', 'Muscat', 'OMR', 'AS'),
(170, 92, 'PK', 'Pakistan', 'Islamabad', 'PKR', 'AS'),
(171, 680, 'PW', 'Palau', 'Melekeok', 'USD', 'OC'),
(172, 970, 'PS', 'Palestinian Territory, Occupied', 'East Jerusalem', 'ILS', 'AS'),
(173, 507, 'PA', 'Panama', 'Panama City', 'PAB', 'NA'),
(174, 675, 'PG', 'Papua New Guinea', 'Port Moresby', 'PGK', 'OC'),
(175, 595, 'PY', 'Paraguay', 'Asuncion', 'PYG', 'SA'),
(176, 51, 'PE', 'Peru', 'Lima', 'PEN', 'SA'),
(177, 63, 'PH', 'Philippines', 'Manila', 'PHP', 'AS'),
(178, 64, 'PN', 'Pitcairn', 'Adamstown', 'NZD', 'OC'),
(179, 48, 'PL', 'Poland', 'Warsaw', 'PLN', 'EU'),
(180, 351, 'PT', 'Portugal', 'Lisbon', 'EUR', 'EU'),
(181, 1787, 'PR', 'Puerto Rico', 'San Juan', 'USD', 'NA'),
(182, 974, 'QA', 'Qatar', 'Doha', 'QAR', 'AS'),
(183, 262, 'RE', 'Reunion', 'Saint-Denis', 'EUR', 'AF'),
(184, 40, 'RO', 'Romania', 'Bucharest', 'RON', 'EU'),
(185, 70, 'RU', 'Russian Federation', 'Moscow', 'RUB', 'AS'),
(186, 250, 'RW', 'Rwanda', 'Kigali', 'RWF', 'AF'),
(187, 590, 'BL', 'Saint Barthelemy', 'Gustavia', 'EUR', 'NA'),
(188, 290, 'SH', 'Saint Helena', 'Jamestown', 'SHP', 'AF'),
(189, 1869, 'KN', 'Saint Kitts and Nevis', 'Basseterre', 'XCD', 'NA'),
(190, 1758, 'LC', 'Saint Lucia', 'Castries', 'XCD', 'NA'),
(191, 590, 'MF', 'Saint Martin', 'Marigot', 'EUR', 'NA'),
(192, 508, 'PM', 'Saint Pierre and Miquelon', 'Saint-Pierre', 'EUR', 'NA'),
(193, 1784, 'VC', 'Saint Vincent and the Grenadines', 'Kingstown', 'XCD', 'NA'),
(194, 684, 'WS', 'Samoa', 'Apia', 'WST', 'OC'),
(195, 378, 'SM', 'San Marino', 'San Marino', 'EUR', 'EU'),
(196, 239, 'ST', 'Sao Tome and Principe', 'Sao Tome', 'STD', 'AF'),
(197, 966, 'SA', 'Saudi Arabia', 'Riyadh', 'SAR', 'AS'),
(198, 221, 'SN', 'Senegal', 'Dakar', 'XOF', 'AF'),
(199, 381, 'RS', 'Serbia', 'Belgrade', 'RSD', 'EU'),
(200, 381, 'CS', 'Serbia and Montenegro', 'Belgrade', 'RSD', 'EU'),
(201, 248, 'SC', 'Seychelles', 'Victoria', 'SCR', 'AF'),
(202, 232, 'SL', 'Sierra Leone', 'Freetown', 'SLL', 'AF'),
(203, 65, 'SG', 'Singapore', 'Singapur', 'SGD', 'AS'),
(204, 1, 'SX', 'Sint Maarten', 'Philipsburg', 'ANG', 'NA'),
(205, 421, 'SK', 'Slovakia', 'Bratislava', 'EUR', 'EU'),
(206, 386, 'SI', 'Slovenia', 'Ljubljana', 'EUR', 'EU'),
(207, 677, 'SB', 'Solomon Islands', 'Honiara', 'SBD', 'OC'),
(208, 252, 'SO', 'Somalia', 'Mogadishu', 'SOS', 'AF'),
(209, 27, 'ZA', 'South Africa', 'Pretoria', 'ZAR', 'AF'),
(210, 500, 'GS', 'South Georgia and the South Sandwich Islands', 'Grytviken', 'GBP', 'AN'),
(211, 211, 'SS', 'South Sudan', 'Juba', 'SSP', 'AF'),
(212, 34, 'ES', 'Spain', 'Madrid', 'EUR', 'EU'),
(213, 94, 'LK', 'Sri Lanka', 'Colombo', 'LKR', 'AS'),
(214, 249, 'SD', 'Sudan', 'Khartoum', 'SDG', 'AF'),
(215, 597, 'SR', 'Suriname', 'Paramaribo', 'SRD', 'SA'),
(216, 47, 'SJ', 'Svalbard and Jan Mayen', 'Longyearbyen', 'NOK', 'EU'),
(217, 268, 'SZ', 'Swaziland', 'Mbabane', 'SZL', 'AF'),
(218, 46, 'SE', 'Sweden', 'Stockholm', 'SEK', 'EU'),
(219, 41, 'CH', 'Switzerland', 'Berne', 'CHF', 'EU'),
(220, 963, 'SY', 'Syrian Arab Republic', 'Damascus', 'SYP', 'AS'),
(221, 886, 'TW', 'Taiwan, Province of China', 'Taipei', 'TWD', 'AS'),
(222, 992, 'TJ', 'Tajikistan', 'Dushanbe', 'TJS', 'AS'),
(223, 255, 'TZ', 'Tanzania, United Republic of', 'Dodoma', 'TZS', 'AF'),
(224, 66, 'TH', 'Thailand', 'Bangkok', 'THB', 'AS'),
(225, 670, 'TL', 'Timor-Leste', 'Dili', 'USD', 'AS'),
(226, 228, 'TG', 'Togo', 'Lome', 'XOF', 'AF'),
(227, 690, 'TK', 'Tokelau', '', 'NZD', 'OC'),
(228, 676, 'TO', 'Tonga', 'Nuku\'alofa', 'TOP', 'OC'),
(229, 1868, 'TT', 'Trinidad and Tobago', 'Port of Spain', 'TTD', 'NA'),
(230, 216, 'TN', 'Tunisia', 'Tunis', 'TND', 'AF'),
(231, 90, 'TR', 'Turkey', 'Ankara', 'TRY', 'AS'),
(232, 7370, 'TM', 'Turkmenistan', 'Ashgabat', 'TMT', 'AS'),
(233, 1649, 'TC', 'Turks and Caicos Islands', 'Cockburn Town', 'USD', 'NA'),
(234, 688, 'TV', 'Tuvalu', 'Funafuti', 'AUD', 'OC'),
(235, 256, 'UG', 'Uganda', 'Kampala', 'UGX', 'AF'),
(236, 380, 'UA', 'Ukraine', 'Kiev', 'UAH', 'EU'),
(237, 971, 'AE', 'United Arab Emirates', 'Abu Dhabi', 'AED', 'AS'),
(238, 44, 'GB', 'United Kingdom', 'London', 'GBP', 'EU'),
(239, 1, 'US', 'United States', 'Washington', 'USD', 'NA'),
(240, 1, 'UM', 'United States Minor Outlying Islands', '', 'USD', 'NA'),
(241, 598, 'UY', 'Uruguay', 'Montevideo', 'UYU', 'SA'),
(242, 998, 'UZ', 'Uzbekistan', 'Tashkent', 'UZS', 'AS'),
(243, 678, 'VU', 'Vanuatu', 'Port Vila', 'VUV', 'OC'),
(244, 58, 'VE', 'Venezuela', 'Caracas', 'VEF', 'SA'),
(245, 84, 'VN', 'Viet Nam', 'Hanoi', 'VND', 'AS'),
(246, 1284, 'VG', 'Virgin Islands, British', 'Road Town', 'USD', 'NA'),
(247, 1340, 'VI', 'Virgin Islands, U.s.', 'Charlotte Amalie', 'USD', 'NA'),
(248, 681, 'WF', 'Wallis and Futuna', 'Mata Utu', 'XPF', 'OC'),
(249, 967, 'YE', 'Yemen', 'Sanaa', 'YER', 'AS'),
(250, 260, 'ZM', 'Zambia', 'Lusaka', 'ZMW', 'AF'),
(251, 263, 'ZW', 'Zimbabwe', 'Harare', 'ZWL', 'AF');


-- Table structure for table `currency`

CREATE TABLE IF NOT EXISTS `currencies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_code` varchar(3) NOT NULL,
  `currency_name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;


INSERT INTO `currencies` (`id`, `currency_code`, `currency_name`) VALUES
(1, 'AFA', 'Afghan Afghani'),
(2, 'ALL', 'Albanian Lek'),
(3, 'DZD', 'Algerian Dinar'),
(4, 'AOA', 'Angolan Kwanza'),
(5, 'ARS', 'Argentine Peso'),
(6, 'AMD', 'Armenian Dram'),
(7, 'AWG', 'Aruban Florin'),
(8, 'AUD', 'Australian Dollar'),
(9, 'AZN', 'Azerbaijani Manat'),
(10, 'BSD', 'Bahamian Dollar'),
(11, 'BHD', 'Bahraini Dinar'),
(12, 'BDT', 'Bangladeshi Taka'),
(13, 'BBD', 'Barbadian Dollar'),
(14, 'BYR', 'Belarusian Ruble'),
(15, 'BEF', 'Belgian Franc'),
(16, 'BZD', 'Belize Dollar'),
(17, 'BMD', 'Bermudan Dollar'),
(18, 'BTN', 'Bhutanese Ngultrum'),
(19, 'BTC', 'Bitcoin'),
(20, 'BOB', 'Bolivian Boliviano'),
(21, 'BAM', 'Bosnia-Herzegovina Convertible Mark'),
(22, 'BWP', 'Botswanan Pula'),
(23, 'BRL', 'Brazilian Real'),
(24, 'GBP', 'British Pound Sterling'),
(25, 'BND', 'Brunei Dollar'),
(26, 'BGN', 'Bulgarian Lev'),
(27, 'BIF', 'Burundian Franc'),
(28, 'KHR', 'Cambodian Riel'),
(29, 'CAD', 'Canadian Dollar'),
(30, 'CVE', 'Cape Verdean Escudo'),
(31, 'KYD', 'Cayman Islands Dollar'),
(32, 'XOF', 'CFA Franc BCEAO'),
(33, 'XAF', 'CFA Franc BEAC'),
(34, 'XPF', 'CFP Franc'),
(35, 'CLP', 'Chilean Peso'),
(36, 'CNY', 'Chinese Yuan'),
(37, 'COP', 'Colombian Peso'),
(38, 'KMF', 'Comorian Franc'),
(39, 'CDF', 'Congolese Franc'),
(40, 'CRC', 'Costa Rican Colón'),
(41, 'HRK', 'Croatian Kuna'),
(42, 'CUC', 'Cuban Convertible Peso'),
(43, 'CZK', 'Czech Republic Koruna'),
(44, 'DKK', 'Danish Krone'),
(45, 'DJF', 'Djiboutian Franc'),
(46, 'DOP', 'Dominican Peso'),
(47, 'XCD', 'East Caribbean Dollar'),
(48, 'EGP', 'Egyptian Pound'),
(49, 'ERN', 'Eritrean Nakfa'),
(50, 'EEK', 'Estonian Kroon'),
(51, 'ETB', 'Ethiopian Birr'),
(52, 'EUR', 'Euro'),
(53, 'FKP', 'Falkland Islands Pound'),
(54, 'FJD', 'Fijian Dollar'),
(55, 'GMD', 'Gambian Dalasi'),
(56, 'GEL', 'Georgian Lari'),
(57, 'DEM', 'German Mark'),
(58, 'GHS', 'Ghanaian Cedi'),
(59, 'GIP', 'Gibraltar Pound'),
(60, 'GRD', 'Greek Drachma'),
(61, 'GTQ', 'Guatemalan Quetzal'),
(62, 'GNF', 'Guinean Franc'),
(63, 'GYD', 'Guyanaese Dollar'),
(64, 'HTG', 'Haitian Gourde'),
(65, 'HNL', 'Honduran Lempira'),
(66, 'HKD', 'Hong Kong Dollar'),
(67, 'HUF', 'Hungarian Forint'),
(68, 'ISK', 'Icelandic Króna'),
(69, 'INR', 'Indian Rupee'),
(70, 'IDR', 'Indonesian Rupiah'),
(71, 'IRR', 'Iranian Rial'),
(72, 'IQD', 'Iraqi Dinar'),
(73, 'ILS', 'Israeli New Sheqel'),
(74, 'ITL', 'Italian Lira'),
(75, 'JMD', 'Jamaican Dollar'),
(76, 'JPY', 'Japanese Yen'),
(77, 'JOD', 'Jordanian Dinar'),
(78, 'KZT', 'Kazakhstani Tenge'),
(79, 'KES', 'Kenyan Shilling'),
(80, 'KWD', 'Kuwaiti Dinar'),
(81, 'KGS', 'Kyrgystani Som'),
(82, 'LAK', 'Laotian Kip'),
(83, 'LVL', 'Latvian Lats'),
(84, 'LBP', 'Lebanese Pound'),
(85, 'LSL', 'Lesotho Loti'),
(86, 'LRD', 'Liberian Dollar'),
(87, 'LYD', 'Libyan Dinar'),
(88, 'LTL', 'Lithuanian Litas'),
(89, 'MOP', 'Macanese Pataca'),
(90, 'MKD', 'Macedonian Denar'),
(91, 'MGA', 'Malagasy Ariary'),
(92, 'MWK', 'Malawian Kwacha'),
(93, 'MYR', 'Malaysian Ringgit'),
(94, 'MVR', 'Maldivian Rufiyaa'),
(95, 'MRO', 'Mauritanian Ouguiya'),
(96, 'MUR', 'Mauritian Rupee'),
(97, 'MXN', 'Mexican Peso'),
(98, 'MDL', 'Moldovan Leu'),
(99, 'MNT', 'Mongolian Tugrik'),
(100, 'MAD', 'Moroccan Dirham'),
(101, 'MZM', 'Mozambican Metical'),
(102, 'MMK', 'Myanmar Kyat'),
(103, 'NAD', 'Namibian Dollar'),
(104, 'NPR', 'Nepalese Rupee'),
(105, 'ANG', 'Netherlands Antillean Guilder'),
(106, 'TWD', 'New Taiwan Dollar'),
(107, 'NZD', 'New Zealand Dollar'),
(108, 'NIO', 'Nicaraguan Córdoba'),
(109, 'NGN', 'Nigerian Naira'),
(110, 'KPW', 'North Korean Won'),
(111, 'NOK', 'Norwegian Krone'),
(112, 'OMR', 'Omani Rial'),
(113, 'PKR', 'Pakistani Rupee'),
(114, 'PAB', 'Panamanian Balboa'),
(115, 'PGK', 'Papua New Guinean Kina'),
(116, 'PYG', 'Paraguayan Guarani'),
(117, 'PEN', 'Peruvian Nuevo Sol'),
(118, 'PHP', 'Philippine Peso'),
(119, 'PLN', 'Polish Zloty'),
(120, 'QAR', 'Qatari Rial'),
(121, 'RON', 'Romanian Leu'),
(122, 'RUB', 'Russian Ruble'),
(123, 'RWF', 'Rwandan Franc'),
(124, 'SVC', 'Salvadoran Colón'),
(125, 'WST', 'Samoan Tala'),
(126, 'SAR', 'Saudi Riyal'),
(127, 'RSD', 'Serbian Dinar'),
(128, 'SCR', 'Seychellois Rupee'),
(129, 'SLL', 'Sierra Leonean Leone'),
(130, 'SGD', 'Singapore Dollar'),
(131, 'SKK', 'Slovak Koruna'),
(132, 'SBD', 'Solomon Islands Dollar'),
(133, 'SOS', 'Somali Shilling'),
(134, 'ZAR', 'South African Rand'),
(135, 'KRW', 'South Korean Won'),
(136, 'XDR', 'Special Drawing Rights'),
(137, 'LKR', 'Sri Lankan Rupee'),
(138, 'SHP', 'St. Helena Pound'),
(139, 'SDG', 'Sudanese Pound'),
(140, 'SRD', 'Surinamese Dollar'),
(141, 'SZL', 'Swazi Lilangeni'),
(142, 'SEK', 'Swedish Krona'),
(143, 'CHF', 'Swiss Franc'),
(144, 'SYP', 'Syrian Pound'),
(145, 'STD', 'São Tomé and Príncipe Dobra'),
(146, 'TJS', 'Tajikistani Somoni'),
(147, 'TZS', 'Tanzanian Shilling'),
(148, 'THB', 'Thai Baht'),
(149, 'TOP', 'Tongan pa\'anga'),
(150, 'TTD', 'Trinidad & Tobago Dollar'),
(151, 'TND', 'Tunisian Dinar'),
(152, 'TRY', 'Turkish Lira'),
(153, 'TMT', 'Turkmenistani Manat'),
(154, 'UGX', 'Ugandan Shilling'),
(155, 'UAH', 'Ukrainian Hryvnia'),
(156, 'AED', 'United Arab Emirates Dirham'),
(157, 'UYU', 'Uruguayan Peso'),
(158, 'USD', 'US Dollar'),
(159, 'UZS', 'Uzbekistan Som'),
(160, 'VUV', 'Vanuatu Vatu'),
(161, 'VEF', 'Venezuelan Bolivar'),
(162, 'VND', 'Vietnamese Dong'),
(163, 'YER', 'Yemeni Rial'),
(164, 'ZMK', 'Zambian Kwacha');