Файл: source/app/objects/install/data/sampledata/sql/countries.sql
Строк: 1254
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50144
Source Host
: localhost
Source Database : phpadminpro_v1.0
Target
Server Type : MySQL
Target Server Version : 50144
File Encoding
: utf-8
Date: 04/18/2013 14:35:05 PM
*/
SET NAMES utf8;
SET
FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table
structure for `countries`
-- ----------------------------
DROP TABLE IF
EXISTS `countries`;
CREATE TABLE `countries` (
`idCountry` int(5) NOT
NULL AUTO_INCREMENT,
`countryCode` char(2) NOT NULL DEFAULT '',
`countryName` varchar(45) NOT NULL DEFAULT '',
`currencyCode` char(3)
DEFAULT NULL,
`capital` varchar(30) DEFAULT NULL,
`created_by`
bigint(20) DEFAULT NULL,
`created` timestamp NULL DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`modified` timestamp NULL DEFAULT
NULL,
PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM AUTO_INCREMENT=251
DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of
`countries`
-- ----------------------------
BEGIN;
INSERT INTO `countries`
VALUES ('1', 'AD', 'Andorra', 'EUR', 'Andorra la Vella', '4', null, null,
null), ('2', 'AE', 'United Arab Emirates', 'AED', 'Abu Dhabi', '4', null,
null, null), ('3', 'AF', 'Afghanistan', 'AFN', 'Kabul', '4', null, null,
null), ('4', 'AG', 'Antigua and Barbuda', 'XCD', 'St. John\'s', '4', null,
null, null), ('5', 'AI', 'Anguilla', 'XCD', 'The Valley', '4', null, null,
null), ('6', 'AL', 'Albania', 'ALL', 'Tirana', '4', null, null, null),
('7', 'AM', 'Armenia', 'AMD', 'Yerevan', '4', null, null, null), ('8',
'AO', 'Angola', 'AOA', 'Luanda', '4', null, null, null), ('9', 'AQ',
'Antarctica', '', '', '4', null, null, null), ('10', 'AR', 'Argentina',
'ARS', 'Buenos Aires', '4', null, null, null), ('11', 'AS', 'American
Samoa', 'USD', 'Pago Pago', '4', null, null, null), ('12', 'AT', 'Austria',
'EUR', 'Vienna', '4', null, null, null), ('13', 'AU', 'Australia', 'AUD',
'Canberra', '4', null, null, null), ('14', 'AW', 'Aruba', 'AWG',
'Oranjestad', '4', null, null, null), ('16', 'AZ', 'Azerbaijan', 'AZN',
'Baku', '4', null, null, null), ('17', 'BA', 'Bosnia and Herzegovina',
'BAM', 'Sarajevo', '4', null, null, null), ('18', 'BB', 'Barbados', 'BBD',
'Bridgetown', '4', null, null, null), ('19', 'BD', 'Bangladesh', 'BDT',
'Dhaka', '4', null, null, null), ('20', 'BE', 'Belgium', 'EUR', 'Brussels',
'4', null, null, null), ('21', 'BF', 'Burkina Faso', 'XOF', 'Ouagadougou',
'4', null, null, null), ('22', 'BG', 'Bulgaria', 'BGN', 'Sofia', '4', null,
null, null), ('23', 'BH', 'Bahrain', 'BHD', 'Manama', '4', null, null,
null), ('24', 'BI', 'Burundi', 'BIF', 'Bujumbura', '4', null, null, null),
('25', 'BJ', 'Benin', 'XOF', 'Porto-Novo', '4', null, null, null), ('26',
'BL', 'Saint Barthélemy ', 'EUR', 'Gustavia', '4', null, '1',
'2013-04-17 04:37:26'), ('27', 'BM', 'Bermuda', 'BMD', 'Hamilton', '4',
null, null, null), ('28', 'BN', 'Brunei', 'BND', 'Bandar Seri Begawan',
'4', null, null, null), ('29', 'BO', 'Bolivia', 'BOB', 'Sucre', '4', null,
null, null), ('30', 'BQ', 'Bonaire', 'USD', '', '4', null, null, null),
('31', 'BR', 'Brazil', 'BRL', 'BrasÃlia', '4', null, '1', '2013-04-17
04:38:02'), ('32', 'BS', 'Bahamas', 'BSD', 'Nassau', '4', null, null,
null), ('33', 'BT', 'Bhutan', 'BTN', 'Thimphu', '4', null, null, null),
('34', 'BV', 'Bouvet Island', 'NOK', '', '4', null, null, null), ('35',
'BW', 'Botswana', 'BWP', 'Gaborone', '4', null, null, null), ('36', 'BY',
'Belarus', 'BYR', 'Minsk', '4', null, null, null), ('37', 'BZ', 'Belize',
'BZD', 'Belmopan', '4', null, null, null), ('38', 'CA', 'Canada', 'CAD',
'Ottawa', '4', null, null, null), ('39', 'CC', 'Cocos [Keeling] Islands',
'AUD', 'West Island', '4', null, null, null), ('40', 'CD', 'Congo', 'CDF',
'Kinshasa', '4', null, null, null), ('41', 'CF', 'Central African
Republic', 'XAF', 'Bangui', '4', null, null, null), ('42', 'CG', 'Republic
of the Congo', 'XAF', 'Brazzaville', '4', null, null, null), ('43', 'CH',
'Switzerland', 'CHF', 'Berne', '4', null, null, null), ('44', 'CI', 'Ivory
Coast', 'XOF', 'Yamoussoukro', '4', null, null, null), ('45', 'CK', 'Cook
Islands', 'NZD', 'Avarua', '4', null, null, null), ('46', 'CL', 'Chile',
'CLP', 'Santiago', '4', null, null, null), ('47', 'CM', 'Cameroon', 'XAF',
'Yaoundé', '4', null, '1', '2013-04-17 04:40:06'), ('48', 'CN', 'China',
'CNY', 'Beijing', '4', null, null, null), ('49', 'CO', 'Colombia', 'COP',
'Bogotá', '4', null, '1', '2013-04-17 04:40:31'), ('50', 'CR', 'Costa
Rica', 'CRC', 'San José', '4', null, '1', '2013-04-17 04:41:00'), ('51',
'CU', 'Cuba', 'CUP', 'Havana', '4', null, null, null), ('52', 'CV', 'Cape
Verde', 'CVE', 'Praia', '4', null, null, null), ('53', 'CW', 'Curacao',
'ANG', 'Willemstad', '4', null, null, null), ('54', 'CX', 'Christmas
Island', 'AUD', 'The Settlement', '4', null, null, null), ('55', 'CY',
'Cyprus', 'EUR', 'Nicosia', '4', null, null, null), ('56', 'CZ', 'Czechia',
'CZK', 'Prague', '4', null, null, null), ('57', 'DE', 'Germany', 'EUR',
'Berlin', '4', null, null, null), ('58', 'DJ', 'Djibouti', 'DJF',
'Djibouti', null, null, null, null), ('59', 'DK', 'Denmark', 'DKK',
'Copenhagen', null, null, null, null), ('60', 'DM', 'Dominica', 'XCD',
'Roseau', null, null, null, null), ('61', 'DO', 'Dominican Republic',
'DOP', 'Santo Domingo', null, null, null, null), ('62', 'DZ', 'Algeria',
'DZD', 'Algiers', null, null, null, null), ('63', 'EC', 'Ecuador', 'USD',
'Quito', null, null, null, null), ('64', 'EE', 'Estonia', 'EUR', 'Tallinn',
null, null, null, null), ('65', 'EG', 'Egypt', 'EGP', 'Cairo', null, null,
null, null), ('66', 'EH', 'Western Sahara', 'MAD', 'El Aaiún', null,
null, '1', '2013-04-17 04:46:05'), ('67', 'ER', 'Eritrea', 'ERN', 'Asmara',
null, null, null, null), ('68', 'ES', 'Spain', 'EUR', 'Madrid', null, null,
null, null), ('69', 'ET', 'Ethiopia', 'ETB', 'Addis Ababa', null, null,
null, null), ('70', 'FI', 'Finland', 'EUR', 'Helsinki', null, null, null,
null), ('71', 'FJ', 'Fiji', 'FJD', 'Suva', null, null, null, null), ('72',
'FK', 'Falkland Islands', 'FKP', 'Stanley', null, null, null, null), ('73',
'FM', 'Micronesia', 'USD', 'Palikir', null, null, null, null), ('74', 'FO',
'Faroe Islands', 'DKK', 'Tórshavn', null, null, '1', '2013-04-17
04:45:38'), ('75', 'FR', 'France', 'EUR', 'Paris', null, null, null, null),
('76', 'GA', 'Gabon', 'XAF', 'Libreville', null, null, null, null), ('77',
'GB', 'United Kingdom', 'GBP', 'London', null, null, null, null), ('78',
'GD', 'Grenada', 'XCD', 'St. George\'s', null, null, null, null), ('79',
'GE', 'Georgia', 'GEL', 'Tbilisi', null, null, null, null), ('80', 'GF',
'French Guiana', 'EUR', 'Cayenne', null, null, null, null), ('81', 'GG',
'Guernsey', 'GBP', 'St Peter Port', null, null, null, null), ('82', 'GH',
'Ghana', 'GHS', 'Accra', null, null, null, null), ('83', 'GI', 'Gibraltar',
'GIP', 'Gibraltar', null, null, null, null), ('84', 'GL', 'Greenland',
'DKK', 'Nuuk', null, null, null, null), ('85', 'GM', 'Gambia', 'GMD',
'Banjul', null, null, null, null), ('86', 'GN', 'Guinea', 'GNF', 'Conakry',
null, null, null, null), ('87', 'GP', 'Guadeloupe', 'EUR', 'Basse-Terre',
null, null, null, null), ('88', 'GQ', 'Equatorial Guinea', 'XAF', 'Malabo',
null, null, null, null), ('89', 'GR', 'Greece', 'EUR', 'Athens', null,
null, null, null), ('90', 'GS', 'South Georgia and the South Sandwich
Islands', 'GBP', 'Grytviken', null, null, null, null), ('91', 'GT',
'Guatemala', 'GTQ', 'Guatemala City', null, null, null, null), ('93', 'GW',
'Guinea-Bissau', 'XOF', 'Bissau', null, null, null, null), ('94', 'GY',
'Guyana', 'GYD', 'Georgetown', null, null, null, null), ('95', 'HK', 'Hong
Kong', 'HKD', 'Hong Kong', null, null, null, null), ('96', 'HM', 'Heard
Island and McDonald Islands', 'AUD', '', null, null, null, null), ('97',
'HN', 'Honduras', 'HNL', 'Tegucigalpa', null, null, null, null), ('98',
'HR', 'Croatia', 'HRK', 'Zagreb', null, null, null, null), ('99', 'HT',
'Haiti', 'HTG', 'Port-au-Prince', null, null, null, null), ('100', 'HU',
'Hungary', 'HUF', 'Budapest', null, null, null, null), ('101', 'ID',
'Indonesia', 'IDR', 'Jakarta', null, null, null, null), ('102', 'IE',
'Ireland', 'EUR', 'Dublin', null, null, null, null), ('103', 'IL',
'Israel', 'ILS', '', null, null, null, null), ('104', 'IM', 'Isle of Man',
'GBP', 'Douglas', null, null, null, null), ('105', 'IN', 'India', 'INR',
'New Delhi', null, null, null, null), ('106', 'IO', 'British Indian Ocean
Territory', 'USD', '', null, null, null, null), ('107', 'IQ', 'Iraq',
'IQD', 'Baghdad', null, null, null, null), ('108', 'IR', 'Iran', 'IRR',
'Tehran', null, null, null, null), ('109', 'IS', 'Iceland', 'ISK',
'Reykjavik', null, null, null, null), ('110', 'IT', 'Italy', 'EUR', 'Rome',
null, null, null, null), ('111', 'JE', 'Jersey', 'GBP', 'Saint Helier',
null, null, null, null), ('112', 'JM', 'Jamaica', 'JMD', 'Kingston', null,
null, null, null), ('113', 'JO', 'Jordan', 'JOD', 'Amman', null, null,
null, null), ('114', 'JP', 'Japan', 'JPY', 'Tokyo', null, null, null,
null), ('115', 'KE', 'Kenya', 'KES', 'Nairobi', null, null, null, null),
('116', 'KG', 'Kyrgyzstan', 'KGS', 'Bishkek', null, null, null, null),
('117', 'KH', 'Cambodia', 'KHR', 'Phnom Penh', null, null, null, null),
('118', 'KI', 'Kiribati', 'AUD', 'Tarawa', null, null, null, null), ('119',
'KM', 'Comoros', 'KMF', 'Moroni', null, null, null, null), ('120', 'KN',
'Saint Kitts and Nevis', 'XCD', 'Basseterre', null, null, null, null),
('121', 'KP', 'North Korea', 'KPW', 'Pyongyang', null, null, null, null),
('122', 'KR', 'South Korea', 'KRW', 'Seoul', null, null, null, null),
('123', 'KW', 'Kuwait', 'KWD', 'Kuwait City', null, null, null, null),
('124', 'KY', 'Cayman Islands', 'KYD', 'George Town', null, null, null,
null), ('125', 'KZ', 'Kazakhstan', 'KZT', 'Astana', null, null, null,
null), ('126', 'LA', 'Laos', 'LAK', 'Vientiane', null, null, null, null),
('127', 'LB', 'Lebanon', 'LBP', 'Beirut', null, null, null, null), ('128',
'LC', 'Saint Lucia', 'XCD', 'Castries', null, null, null, null), ('129',
'LI', 'Liechtenstein', 'CHF', 'Vaduz', null, null, null, null), ('130',
'LK', 'Sri Lanka', 'LKR', 'Colombo', null, null, null, null), ('131', 'LR',
'Liberia', 'LRD', 'Monrovia', null, null, null, null), ('132', 'LS',
'Lesotho', 'LSL', 'Maseru', null, null, null, null), ('133', 'LT',
'Lithuania', 'LTL', 'Vilnius', null, null, null, null), ('134', 'LU',
'Luxembourg', 'EUR', 'Luxembourg', null, null, null, null), ('135', 'LV',
'Latvia', 'LVL', 'Riga', null, null, null, null), ('136', 'LY', 'Libya',
'LYD', 'Tripoli', null, null, null, null), ('137', 'MA', 'Morocco', 'MAD',
'Rabat', null, null, null, null), ('138', 'MC', 'Monaco', 'EUR', 'Monaco',
null, null, null, null), ('139', 'MD', 'Moldova', 'MDL', 'Chişinău',
null, null, null, null), ('140', 'ME', 'Montenegro', 'EUR', 'Podgorica',
null, null, null, null), ('141', 'MF', 'Saint Martin', 'EUR', 'Marigot',
null, null, null, null), ('142', 'MG', 'Madagascar', 'MGA', 'Antananarivo',
null, null, null, null), ('143', 'MH', 'Marshall Islands', 'USD', 'Majuro',
null, null, null, null), ('144', 'MK', 'Macedonia', 'MKD', 'Skopje', null,
null, null, null), ('145', 'ML', 'Mali', 'XOF', 'Bamako', null, null, null,
null), ('146', 'MM', 'Myanmar [Burma]', 'MMK', 'Nay Pyi Taw', null, null,
null, null), ('147', 'MN', 'Mongolia', 'MNT', 'Ulan Bator', null, null,
null, null), ('148', 'MO', 'Macao', 'MOP', 'Macao', null, null, null,
null), ('149', 'MP', 'Northern Mariana Islands', 'USD', 'Saipan', null,
null, null, null), ('150', 'MQ', 'Martinique', 'EUR', 'Fort-de-France',
null, null, null, null), ('151', 'MR', 'Mauritania', 'MRO', 'Nouakchott',
null, null, null, null), ('152', 'MS', 'Montserrat', 'XCD', 'Plymouth',
null, null, null, null), ('153', 'MT', 'Malta', 'EUR', 'Valletta', null,
null, null, null), ('154', 'MU', 'Mauritius', 'MUR', 'Port Louis', null,
null, null, null), ('155', 'MV', 'Maldives', 'MVR', 'Malé', null, null,
'1', '2013-04-17 04:44:46'), ('156', 'MW', 'Malawi', 'MWK', 'Lilongwe',
null, null, null, null), ('157', 'MX', 'Mexico', 'MXN', 'Mexico City',
null, null, null, null), ('158', 'MY', 'Malaysia', 'MYR', 'Kuala Lumpur',
null, null, null, null), ('159', 'MZ', 'Mozambique', 'MZN', 'Maputo', null,
null, null, null), ('160', 'NA', 'Namibia', 'NAD', 'Windhoek', null, null,
null, null), ('161', 'NC', 'New Caledonia', 'XPF', 'Noumea', null, null,
null, null), ('162', 'NE', 'Niger', 'XOF', 'Niamey', null, null, null,
null), ('163', 'NF', 'Norfolk Island', 'AUD', 'Kingston', null, null, null,
null), ('164', 'NG', 'Nigeria', 'NGN', 'Abuja', null, null, null, null),
('165', 'NI', 'Nicaragua', 'NIO', 'Managua', null, null, null, null),
('166', 'NL', 'Netherlands', 'EUR', 'Amsterdam', null, null, null, null),
('167', 'NO', 'Norway', 'NOK', 'Oslo', null, null, null, null), ('168',
'NP', 'Nepal', 'NPR', 'Kathmandu', null, null, null, null), ('169', 'NR',
'Nauru', 'AUD', '', null, null, null, null), ('170', 'NU', 'Niue', 'NZD',
'Alofi', null, null, null, null), ('171', 'NZ', 'New Zealand', 'NZD',
'Wellington', null, null, null, null), ('172', 'OM', 'Oman', 'OMR',
'Muscat', null, null, null, null), ('173', 'PA', 'Panama', 'PAB', 'Panama
City', null, null, null, null), ('174', 'PE', 'Peru', 'PEN', 'Lima', null,
null, null, null), ('175', 'PF', 'French Polynesia', 'XPF', 'Papeete',
null, null, null, null), ('176', 'PG', 'Papua New Guinea', 'PGK', 'Port
Moresby', null, null, null, null), ('177', 'PH', 'Philippines', 'PHP',
'Manila', null, null, null, null), ('178', 'PK', 'Pakistan', 'PKR',
'Islamabad', null, null, null, null), ('179', 'PL', 'Poland', 'PLN',
'Warsaw', null, null, null, null), ('180', 'PM', 'Saint Pierre and
Miquelon', 'EUR', 'Saint-Pierre', null, null, null, null), ('181', 'PN',
'Pitcairn Islands', 'NZD', 'Adamstown', null, null, null, null), ('182',
'PR', 'Puerto Rico', 'USD', 'San Juan', null, null, null, null), ('183',
'PS', 'Palestine', 'ILS', '', null, null, null, null), ('184', 'PT',
'Portugal', 'EUR', 'Lisbon', null, null, null, null), ('185', 'PW',
'Palau', 'USD', 'Melekeok - Palau State Capital', null, null, null, null),
('186', 'PY', 'Paraguay', 'PYG', 'Asunción', null, null, '1',
'2013-04-17 04:44:16'), ('187', 'QA', 'Qatar', 'QAR', 'Doha', null, null,
null, null), ('188', 'RE', 'Réunion', 'EUR', 'Saint-Denis', null, null,
'1', '2013-04-17 04:43:53'), ('189', 'RO', 'Romania', 'RON', 'Bucharest',
null, null, null, null), ('190', 'RS', 'Serbia', 'RSD', 'Belgrade', null,
null, null, null), ('191', 'RU', 'Russia', 'RUB', 'Moscow', null, null,
null, null), ('192', 'RW', 'Rwanda', 'RWF', 'Kigali', null, null, null,
null), ('193', 'SA', 'Saudi Arabia', 'SAR', 'Riyadh', null, null, null,
null), ('194', 'SB', 'Solomon Islands', 'SBD', 'Honiara', null, null, null,
null), ('195', 'SC', 'Seychelles', 'SCR', 'Victoria', null, null, null,
null), ('196', 'SD', 'Sudan', 'SDG', 'Khartoum', null, null, null, null),
('197', 'SE', 'Sweden', 'SEK', 'Stockholm', null, null, null, null),
('198', 'SG', 'Singapore', 'SGD', 'Singapore', null, null, null, null),
('199', 'SH', 'Saint Helena', 'SHP', 'Jamestown', null, null, null, null),
('200', 'SI', 'Slovenia', 'EUR', 'Ljubljana', null, null, null, null),
('201', 'SJ', 'Svalbard and Jan Mayen', 'NOK', 'Longyearbyen', null, null,
null, null), ('202', 'SK', 'Slovakia', 'EUR', 'Bratislava', null, null,
null, null), ('203', 'SL', 'Sierra Leone', 'SLL', 'Freetown', null, null,
null, null), ('204', 'SM', 'San Marino', 'EUR', 'San Marino', null, null,
null, null), ('205', 'SN', 'Senegal', 'XOF', 'Dakar', null, null, null,
null), ('206', 'SO', 'Somalia', 'SOS', 'Mogadishu', null, null, null,
null), ('207', 'SR', 'Suriname', 'SRD', 'Paramaribo', null, null, null,
null), ('208', 'SS', 'South Sudan', 'SSP', 'Juba', null, null, null, null),
('210', 'SV', 'El Salvador', 'USD', 'San Salvador', null, null, null,
null), ('211', 'SX', 'Sint Maarten', 'ANG', 'Philipsburg', null, null,
null, null), ('212', 'SY', 'Syria', 'SYP', 'Damascus', null, null, null,
null), ('213', 'SZ', 'Swaziland', 'SZL', 'Mbabane', null, null, null,
null), ('214', 'TC', 'Turks and Caicos Islands', 'USD', 'Cockburn Town',
null, null, null, null), ('215', 'TD', 'Chad', 'XAF', 'N\'Djamena', null,
null, null, null), ('217', 'TG', 'Togo', 'XOF', 'Lomé', null, null, '1',
'2013-04-17 04:42:40'), ('218', 'TH', 'Thailand', 'THB', 'Bangkok', null,
null, null, null), ('219', 'TJ', 'Tajikistan', 'TJS', 'Dushanbe', null,
null, null, null), ('220', 'TK', 'Tokelau', 'NZD', '', null, null, null,
null), ('221', 'TL', 'East Timor', 'USD', 'Dili', null, null, null, null),
('222', 'TM', 'Turkmenistan', 'TMT', 'Ashgabat', null, null, null, null),
('223', 'TN', 'Tunisia', 'TND', 'Tunis', null, null, null, null), ('224',
'TO', 'Tonga', 'TOP', 'Nuku\'alofa', null, null, null, null), ('225', 'TR',
'Turkey', 'TRY', 'Ankara', null, null, null, null), ('226', 'TT', 'Trinidad
and Tobago', 'TTD', 'Port of Spain', null, null, null, null), ('227', 'TV',
'Tuvalu', 'AUD', 'Funafuti', null, null, null, null), ('228', 'TW',
'Taiwan', 'TWD', 'Taipei', null, null, null, null), ('229', 'TZ',
'Tanzania', 'TZS', 'Dodoma', null, null, null, null), ('230', 'UA',
'Ukraine', 'UAH', 'Kyiv', null, null, null, null), ('231', 'UG', 'Uganda',
'UGX', 'Kampala', null, null, null, null), ('232', 'UM', 'U.S. Minor
Outlying Islands', 'USD', '', null, null, null, null), ('233', 'US',
'United States', 'USD', 'Washington', null, null, null, null), ('234',
'UY', 'Uruguay', 'UYU', 'Montevideo', null, null, null, null), ('235',
'UZ', 'Uzbekistan', 'UZS', 'Tashkent', null, null, null, null), ('236',
'VA', 'Vatican City', 'EUR', 'Vatican', null, null, null, null), ('237',
'VC', 'Saint Vincent and the Grenadines', 'XCD', 'Kingstown', null, null,
null, null), ('238', 'VE', 'Venezuela', 'VEF', 'Caracas', null, null, null,
null), ('239', 'VG', 'British Virgin Islands', 'USD', 'Road Town', null,
null, null, null), ('240', 'VI', 'U.S. Virgin Islands', 'USD', 'Charlotte
Amalie', null, null, null, null), ('241', 'VN', 'Vietnam', 'VND', 'Hanoi',
null, null, null, null), ('242', 'VU', 'Vanuatu', 'VUV', 'Port Vila', null,
null, null, null), ('243', 'WF', 'Wallis and Futuna', 'XPF', 'Mata-Utu',
null, null, null, null), ('244', 'WS', 'Samoa', 'WST', 'Apia', null, null,
null, null), ('245', 'XK', 'Kosovo', 'EUR', 'Pristina', null, null, null,
null), ('246', 'YE', 'Yemen', 'YER', 'Sanaa', null, null, null, null),
('247', 'YT', 'Mayotte', 'EUR', 'Mamoutzou', null, null, null, null),
('248', 'ZA', 'South Africa', 'ZAR', 'Pretoria', null, null, null, null),
('249', 'ZM', 'Zambia', 'ZMK', 'Lusaka', null, null, null, null), ('250',
'ZW', 'Zimbabwe', 'ZWL', 'Harare', null, null, null, null);
COMMIT;
SET
FOREIGN_KEY_CHECKS = 1;