addon-country.sql

-- phpMyAdmin SQL Dump
-- version 3.4.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 04, 2012 at 07:48 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `Code` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `Name` char(52) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Asia',
  `Region` char(26) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `LocalName` char(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`Code`, `Name`, `Continent`, `Region`, `LocalName`) VALUES
('AD', 'Andorra', 'Europe', 'Southern Europe', 'Andorra'),
('AE', 'United Arab Emirates', 'Asia', 'Middle East', 'Al-Imarat al-´Arabiya al-Muttahida'),
('AF', 'Afghanistan', 'Asia', 'Southern and Central Asia', 'Afganistan/Afqanestan'),
('AG', 'Antigua and Barbuda', 'North America', 'Caribbean', 'Antigua and Barbuda'),
('AI', 'Anguilla', 'North America', 'Caribbean', 'Anguilla'),
('AL', 'Albania', 'Europe', 'Southern Europe', 'Shqipëria'),
('AM', 'Armenia', 'Asia', 'Middle East', 'Hajastan'),
('AO', 'Angola', 'Africa', 'Central Africa', 'Angola'),
('AQ', 'Antarctica', 'Antarctica', 'Antarctica', '–'),
('AR', 'Argentina', 'South America', 'South America', 'Argentina'),
('AS', 'American Samoa', 'Oceania', 'Polynesia', 'Amerika Samoa'),
('AT', 'Austria', 'Europe', 'Western Europe', 'Österreich'),
('AU', 'Australia', 'Oceania', 'Australia and New Zealand', 'Australia'),
('AW', 'Aruba', 'North America', 'Caribbean', 'Aruba'),
('AZ', 'Azerbaijan', 'Asia', 'Middle East', 'Azärbaycan'),
('BA', 'Bosnia and Herzegovina', 'Europe', 'Southern Europe', 'Bosna i Hercegovina'),
('BB', 'Barbados', 'North America', 'Caribbean', 'Barbados'),
('BD', 'Bangladesh', 'Asia', 'Southern and Central Asia', 'Bangladesh'),
('BE', 'Belgium', 'Europe', 'Western Europe', 'België/Belgique'),
('BF', 'Burkina Faso', 'Africa', 'Western Africa', 'Burkina Faso'),
('BG', 'Bulgaria', 'Europe', 'Eastern Europe', 'Balgarija'),
('BH', 'Bahrain', 'Asia', 'Middle East', 'Al-Bahrayn'),
('BI', 'Burundi', 'Africa', 'Eastern Africa', 'Burundi/Uburundi'),
('BJ', 'Benin', 'Africa', 'Western Africa', 'Bénin'),
('BM', 'Bermuda', 'North America', 'North America', 'Bermuda'),
('BN', 'Brunei', 'Asia', 'Southeast Asia', 'Brunei Darussalam'),
('BO', 'Bolivia', 'South America', 'South America', 'Bolivia'),
('BR', 'Brazil', 'South America', 'South America', 'Brasil'),
('BS', 'Bahamas', 'North America', 'Caribbean', 'The Bahamas'),
('BT', 'Bhutan', 'Asia', 'Southern and Central Asia', 'Druk-Yul'),
('BV', 'Bouvet Island', 'Antarctica', 'Antarctica', 'Bouvetøya'),
('BW', 'Botswana', 'Africa', 'Southern Africa', 'Botswana'),
('BY', 'Belarus', 'Europe', 'Eastern Europe', 'Belarus'),
('BZ', 'Belize', 'North America', 'Central America', 'Belize'),
('CA', 'Canada', 'North America', 'North America', 'Canada'),
('CC', 'Cocos (Keeling) Islands', 'Oceania', 'Australia and New Zealand', 'Cocos (Keeling) Islands'),
('CD', 'Congo, The Democratic Republic of the', 'Africa', 'Central Africa', 'République Démocratique du Congo'),
('CF', 'Central African Republic', 'Africa', 'Central Africa', 'Centrafrique/Bê-Afrîka'),
('CG', 'Congo', 'Africa', 'Central Africa', 'Congo'),
('CH', 'Switzerland', 'Europe', 'Western Europe', 'Schweiz/Suisse/Svizzera/Svizra'),
('CI', 'Côte d''Ivoire', 'Africa', 'Western Africa', 'Côte d''Ivoire'),
('CK', 'Cook Islands', 'Oceania', 'Polynesia', 'The Cook Islands'),
('CL', 'Chile', 'South America', 'South America', 'Chile'),
('CM', 'Cameroon', 'Africa', 'Central Africa', 'Cameroun/Cameroon'),
('CN', 'China', 'Asia', 'Eastern Asia', 'Zhongquo'),
('CO', 'Colombia', 'South America', 'South America', 'Colombia'),
('CR', 'Costa Rica', 'North America', 'Central America', 'Costa Rica'),
('CU', 'Cuba', 'North America', 'Caribbean', 'Cuba'),
('CV', 'Cape Verde', 'Africa', 'Western Africa', 'Cabo Verde'),
('CX', 'Christmas Island', 'Oceania', 'Australia and New Zealand', 'Christmas Island'),
('CY', 'Cyprus', 'Asia', 'Middle East', 'Kýpros/Kibris'),
('CZ', 'Czech Republic', 'Europe', 'Eastern Europe', '¸esko'),
('DE', 'Germany', 'Europe', 'Western Europe', 'Deutschland'),
('DJ', 'Djibouti', 'Africa', 'Eastern Africa', 'Djibouti/Jibuti'),
('DK', 'Denmark', 'Europe', 'Nordic Countries', 'Danmark'),
('DM', 'Dominica', 'North America', 'Caribbean', 'Dominica'),
('DO', 'Dominican Republic', 'North America', 'Caribbean', 'República Dominicana'),
('DZ', 'Algeria', 'Africa', 'Northern Africa', 'Al-Jaza’ir/Algérie'),
('EC', 'Ecuador', 'South America', 'South America', 'Ecuador'),
('EE', 'Estonia', 'Europe', 'Baltic Countries', 'Eesti'),
('EG', 'Egypt', 'Africa', 'Northern Africa', 'Misr'),
('EH', 'Western Sahara', 'Africa', 'Northern Africa', 'As-Sahrawiya'),
('ER', 'Eritrea', 'Africa', 'Eastern Africa', 'Ertra'),
('ES', 'Spain', 'Europe', 'Southern Europe', 'España'),
('ET', 'Ethiopia', 'Africa', 'Eastern Africa', 'YeItyop´iya'),
('FI', 'Finland', 'Europe', 'Nordic Countries', 'Suomi'),
('FJ', 'Fiji Islands', 'Oceania', 'Melanesia', 'Fiji Islands'),
('FK', 'Falkland Islands', 'South America', 'South America', 'Falkland Islands'),
('FM', 'Micronesia, Federated States of', 'Oceania', 'Micronesia', 'Micronesia'),
('FO', 'Faroe Islands', 'Europe', 'Nordic Countries', 'Føroyar'),
('FR', 'France', 'Europe', 'Western Europe', 'France'),
('GA', 'Gabon', 'Africa', 'Central Africa', 'Le Gabon'),
('GB', 'United Kingdom', 'Europe', 'British Islands', 'United Kingdom'),
('GD', 'Grenada', 'North America', 'Caribbean', 'Grenada'),
('GE', 'Georgia', 'Asia', 'Middle East', 'Sakartvelo'),
('GF', 'French Guiana', 'South America', 'South America', 'Guyane française'),
('GH', 'Ghana', 'Africa', 'Western Africa', 'Ghana'),
('GI', 'Gibraltar', 'Europe', 'Southern Europe', 'Gibraltar'),
('GL', 'Greenland', 'North America', 'North America', 'Kalaallit Nunaat/Grønland'),
('GM', 'Gambia', 'Africa', 'Western Africa', 'The Gambia'),
('GN', 'Guinea', 'Africa', 'Western Africa', 'Guinée'),
('GP', 'Guadeloupe', 'North America', 'Caribbean', 'Guadeloupe'),
('GQ', 'Equatorial Guinea', 'Africa', 'Central Africa', 'Guinea Ecuatorial'),
('GR', 'Greece', 'Europe', 'Southern Europe', 'Elláda'),
('GS', 'South Georgia and the South Sandwich Isl', 'Antarctica', 'Antarctica', 'South Georgia and the South Sandwich Isl'),
('GT', 'Guatemala', 'North America', 'Central America', 'Guatemala'),
('GU', 'Guam', 'Oceania', 'Micronesia', 'Guam'),
('GW', 'Guinea-Bissau', 'Africa', 'Western Africa', 'Guiné-Bissau'),
('GY', 'Guyana', 'South America', 'South America', 'Guyana'),
('HK', 'Hong Kong', 'Asia', 'Eastern Asia', 'Xianggang/Hong Kong'),
('HM', 'Heard Island and McDonald Islands', 'Antarctica', 'Antarctica', 'Heard and McDonald Islands'),
('HN', 'Honduras', 'North America', 'Central America', 'Honduras'),
('HR', 'Croatia', 'Europe', 'Southern Europe', 'Hrvatska'),
('HT', 'Haiti', 'North America', 'Caribbean', 'Haïti/Dayti'),
('HU', 'Hungary', 'Europe', 'Eastern Europe', 'Magyarország'),
('ID', 'Indonesia', 'Asia', 'Southeast Asia', 'Indonesia'),
('IE', 'Ireland', 'Europe', 'British Islands', 'Ireland/Éire'),
('IL', 'Israel', 'Asia', 'Middle East', 'Yisra’el/Isra’il'),
('IN', 'India', 'Asia', 'Southern and Central Asia', 'Bharat/India'),
('IO', 'British Indian Ocean Territory', 'Africa', 'Eastern Africa', 'British Indian Ocean Territory'),
('IQ', 'Iraq', 'Asia', 'Middle East', 'Al-´Iraq'),
('IR', 'Iran', 'Asia', 'Southern and Central Asia', 'Iran'),
('IS', 'Iceland', 'Europe', 'Nordic Countries', 'Ísland'),
('IT', 'Italy', 'Europe', 'Southern Europe', 'Italia'),
('JM', 'Jamaica', 'North America', 'Caribbean', 'Jamaica'),
('JO', 'Jordan', 'Asia', 'Middle East', 'Al-Urdunn'),
('JP', 'Japan', 'Asia', 'Eastern Asia', 'Nihon/Nippon'),
('KE', 'Kenya', 'Africa', 'Eastern Africa', 'Kenya'),
('KG', 'Kyrgyzstan', 'Asia', 'Southern and Central Asia', 'Kyrgyzstan'),
('KH', 'Cambodia', 'Asia', 'Southeast Asia', 'Kâmpuchéa'),
('KI', 'Kiribati', 'Oceania', 'Micronesia', 'Kiribati'),
('KM', 'Comoros', 'Africa', 'Eastern Africa', 'Komori/Comores'),
('KN', 'Saint Kitts and Nevis', 'North America', 'Caribbean', 'Saint Kitts and Nevis'),
('KP', 'North Korea', 'Asia', 'Eastern Asia', 'Choson Minjujuui In´min Konghwaguk (Bukhan)'),
('KR', 'South Korea', 'Asia', 'Eastern Asia', 'Taehan Min’guk (Namhan)'),
('KW', 'Kuwait', 'Asia', 'Middle East', 'Al-Kuwayt'),
('KY', 'Cayman Islands', 'North America', 'Caribbean', 'Cayman Islands'),
('KZ', 'Kazakstan', 'Asia', 'Southern and Central Asia', 'Qazaqstan'),
('LA', 'Laos', 'Asia', 'Southeast Asia', 'Lao'),
('LB', 'Lebanon', 'Asia', 'Middle East', 'Lubnan'),
('LC', 'Saint Lucia', 'North America', 'Caribbean', 'Saint Lucia'),
('LI', 'Liechtenstein', 'Europe', 'Western Europe', 'Liechtenstein'),
('LK', 'Sri Lanka', 'Asia', 'Southern and Central Asia', 'Sri Lanka/Ilankai'),
('LR', 'Liberia', 'Africa', 'Western Africa', 'Liberia'),
('LS', 'Lesotho', 'Africa', 'Southern Africa', 'Lesotho'),
('LT', 'Lithuania', 'Europe', 'Baltic Countries', 'Lietuva'),
('LU', 'Luxembourg', 'Europe', 'Western Europe', 'Luxembourg/Lëtzebuerg'),
('LV', 'Latvia', 'Europe', 'Baltic Countries', 'Latvija'),
('LY', 'Libyan Arab Jamahiriya', 'Africa', 'Northern Africa', 'Libiya'),
('MA', 'Morocco', 'Africa', 'Northern Africa', 'Al-Maghrib'),
('MC', 'Monaco', 'Europe', 'Western Europe', 'Monaco'),
('MD', 'Moldova', 'Europe', 'Eastern Europe', 'Moldova'),
('MG', 'Madagascar', 'Africa', 'Eastern Africa', 'Madagasikara/Madagascar'),
('MH', 'Marshall Islands', 'Oceania', 'Micronesia', 'Marshall Islands/Majol'),
('MK', 'Macedonia', 'Europe', 'Southern Europe', 'Makedonija'),
('ML', 'Mali', 'Africa', 'Western Africa', 'Mali'),
('MM', 'Myanmar', 'Asia', 'Southeast Asia', 'Myanma Pye'),
('MN', 'Mongolia', 'Asia', 'Eastern Asia', 'Mongol Uls'),
('MO', 'Macao', 'Asia', 'Eastern Asia', 'Macau/Aomen'),
('MP', 'Northern Mariana Islands', 'Oceania', 'Micronesia', 'Northern Mariana Islands'),
('MQ', 'Martinique', 'North America', 'Caribbean', 'Martinique'),
('MR', 'Mauritania', 'Africa', 'Western Africa', 'Muritaniya/Mauritanie'),
('MS', 'Montserrat', 'North America', 'Caribbean', 'Montserrat'),
('MT', 'Malta', 'Europe', 'Southern Europe', 'Malta'),
('MU', 'Mauritius', 'Africa', 'Eastern Africa', 'Mauritius'),
('MV', 'Maldives', 'Asia', 'Southern and Central Asia', 'Dhivehi Raajje/Maldives'),
('MW', 'Malawi', 'Africa', 'Eastern Africa', 'Malawi'),
('MX', 'Mexico', 'North America', 'Central America', 'México'),
('MY', 'Malaysia', 'Asia', 'Southeast Asia', 'Malaysia'),
('MZ', 'Mozambique', 'Africa', 'Eastern Africa', 'Moçambique'),
('NA', 'Namibia', 'Africa', 'Southern Africa', 'Namibia'),
('NC', 'New Caledonia', 'Oceania', 'Melanesia', 'Nouvelle-Calédonie'),
('NE', 'Niger', 'Africa', 'Western Africa', 'Niger'),
('NF', 'Norfolk Island', 'Oceania', 'Australia and New Zealand', 'Norfolk Island'),
('NG', 'Nigeria', 'Africa', 'Western Africa', 'Nigeria'),
('NI', 'Nicaragua', 'North America', 'Central America', 'Nicaragua'),
('NL', 'Netherlands', 'Europe', 'Western Europe', 'Nederland'),
('NO', 'Norway', 'Europe', 'Nordic Countries', 'Norge'),
('NP', 'Nepal', 'Asia', 'Southern and Central Asia', 'Nepal'),
('NR', 'Nauru', 'Oceania', 'Micronesia', 'Naoero/Nauru'),
('NU', 'Niue', 'Oceania', 'Polynesia', 'Niue'),
('NZ', 'New Zealand', 'Oceania', 'Australia and New Zealand', 'New Zealand/Aotearoa'),
('OM', 'Oman', 'Asia', 'Middle East', '´Uman'),
('PA', 'Panama', 'North America', 'Central America', 'Panamá'),
('PE', 'Peru', 'South America', 'South America', 'Perú/Piruw'),
('PF', 'French Polynesia', 'Oceania', 'Polynesia', 'Polynésie française'),
('PG', 'Papua New Guinea', 'Oceania', 'Melanesia', 'Papua New Guinea/Papua Niugini'),
('PH', 'Philippines', 'Asia', 'Southeast Asia', 'Pilipinas'),
('PK', 'Pakistan', 'Asia', 'Southern and Central Asia', 'Pakistan'),
('PL', 'Poland', 'Europe', 'Eastern Europe', 'Polska'),
('PM', 'Saint Pierre and Miquelon', 'North America', 'North America', 'Saint-Pierre-et-Miquelon'),
('PN', 'Pitcairn', 'Oceania', 'Polynesia', 'Pitcairn'),
('PR', 'Puerto Rico', 'North America', 'Caribbean', 'Puerto Rico'),
('PS', 'Palestine', 'Asia', 'Middle East', 'Filastin'),
('PT', 'Portugal', 'Europe', 'Southern Europe', 'Portugal'),
('PW', 'Palau', 'Oceania', 'Micronesia', 'Belau/Palau'),
('PY', 'Paraguay', 'South America', 'South America', 'Paraguay'),
('QA', 'Qatar', 'Asia', 'Middle East', 'Qatar'),
('RE', 'Réunion', 'Africa', 'Eastern Africa', 'Réunion'),
('RO', 'Romania', 'Europe', 'Eastern Europe', 'România'),
('RU', 'Russian Federation', 'Europe', 'Eastern Europe', 'Rossija'),
('RW', 'Rwanda', 'Africa', 'Eastern Africa', 'Rwanda/Urwanda'),
('SA', 'Saudi Arabia', 'Asia', 'Middle East', 'Al-´Arabiya as-Sa´udiya'),
('SB', 'Solomon Islands', 'Oceania', 'Melanesia', 'Solomon Islands'),
('SC', 'Seychelles', 'Africa', 'Eastern Africa', 'Sesel/Seychelles'),
('SD', 'Sudan', 'Africa', 'Northern Africa', 'As-Sudan'),
('SE', 'Sweden', 'Europe', 'Nordic Countries', 'Sverige'),
('SG', 'Singapore', 'Asia', 'Southeast Asia', 'Singapore/Singapura/Xinjiapo/Singapur'),
('SH', 'Saint Helena', 'Africa', 'Western Africa', 'Saint Helena'),
('SI', 'Slovenia', 'Europe', 'Southern Europe', 'Slovenija'),
('SJ', 'Svalbard and Jan Mayen', 'Europe', 'Nordic Countries', 'Svalbard og Jan Mayen'),
('SK', 'Slovakia', 'Europe', 'Eastern Europe', 'Slovensko'),
('SL', 'Sierra Leone', 'Africa', 'Western Africa', 'Sierra Leone'),
('SM', 'San Marino', 'Europe', 'Southern Europe', 'San Marino'),
('SN', 'Senegal', 'Africa', 'Western Africa', 'Sénégal/Sounougal'),
('SO', 'Somalia', 'Africa', 'Eastern Africa', 'Soomaaliya'),
('SR', 'Suriname', 'South America', 'South America', 'Suriname'),
('ST', 'Sao Tome and Principe', 'Africa', 'Central Africa', 'São Tomé e Príncipe'),
('SV', 'El Salvador', 'North America', 'Central America', 'El Salvador'),
('SY', 'Syria', 'Asia', 'Middle East', 'Suriya'),
('SZ', 'Swaziland', 'Africa', 'Southern Africa', 'kaNgwane'),
('TC', 'Turks and Caicos Islands', 'North America', 'Caribbean', 'The Turks and Caicos Islands'),
('TD', 'Chad', 'Africa', 'Central Africa', 'Tchad/Tshad'),
('TF', 'French Southern territories', 'Antarctica', 'Antarctica', 'Terres australes françaises'),
('TG', 'Togo', 'Africa', 'Western Africa', 'Togo'),
('TH', 'Thailand', 'Asia', 'Southeast Asia', 'Prathet Thai'),
('TJ', 'Tajikistan', 'Asia', 'Southern and Central Asia', 'Toçikiston'),
('TK', 'Tokelau', 'Oceania', 'Polynesia', 'Tokelau'),
('TM', 'Turkmenistan', 'Asia', 'Southern and Central Asia', 'Türkmenostan'),
('TN', 'Tunisia', 'Africa', 'Northern Africa', 'Tunis/Tunisie'),
('TO', 'Tonga', 'Oceania', 'Polynesia', 'Tonga'),
('TP', 'East Timor', 'Asia', 'Southeast Asia', 'Timor Timur'),
('TR', 'Turkey', 'Asia', 'Middle East', 'Türkiye'),
('TT', 'Trinidad and Tobago', 'North America', 'Caribbean', 'Trinidad and Tobago'),
('TV', 'Tuvalu', 'Oceania', 'Polynesia', 'Tuvalu'),
('TW', 'Taiwan', 'Asia', 'Eastern Asia', 'T’ai-wan'),
('TZ', 'Tanzania', 'Africa', 'Eastern Africa', 'Tanzania'),
('UA', 'Ukraine', 'Europe', 'Eastern Europe', 'Ukrajina'),
('UG', 'Uganda', 'Africa', 'Eastern Africa', 'Uganda'),
('UM', 'United States Minor Outlying Islands', 'Oceania', 'Micronesia/Caribbean', 'United States Minor Outlying Islands'),
('US', 'United States', 'North America', 'North America', 'United States'),
('UY', 'Uruguay', 'South America', 'South America', 'Uruguay'),
('UZ', 'Uzbekistan', 'Asia', 'Southern and Central Asia', 'Uzbekiston'),
('VA', 'Holy See (Vatican City State)', 'Europe', 'Southern Europe', 'Santa Sede/Città del Vaticano'),
('VC', 'Saint Vincent and the Grenadines', 'North America', 'Caribbean', 'Saint Vincent and the Grenadines'),
('VE', 'Venezuela', 'South America', 'South America', 'Venezuela'),
('VG', 'Virgin Islands, British', 'North America', 'Caribbean', 'British Virgin Islands'),
('VI', 'Virgin Islands, U.S.', 'North America', 'Caribbean', 'Virgin Islands of the United States'),
('VN', 'Vietnam', 'Asia', 'Southeast Asia', 'Viêt Nam'),
('VU', 'Vanuatu', 'Oceania', 'Melanesia', 'Vanuatu'),
('WF', 'Wallis and Futuna', 'Oceania', 'Polynesia', 'Wallis-et-Futuna'),
('WS', 'Samoa', 'Oceania', 'Polynesia', 'Samoa'),
('YE', 'Yemen', 'Asia', 'Middle East', 'Al-Yaman'),
('YT', 'Mayotte', 'Africa', 'Eastern Africa', 'Mayotte'),
('YU', 'Yugoslavia', 'Europe', 'Southern Europe', 'Jugoslavija'),
('ZA', 'South Africa', 'Africa', 'Southern Africa', 'South Africa'),
('ZM', 'Zambia', 'Africa', 'Eastern Africa', 'Zambia'),
('ZW', 'Zimbabwe', 'Africa', 'Eastern Africa', 'Zimbabwe');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;