|
-- phpMyAdmin SQL Dump |
|
-- version 3.3.9 |
|
-- http://www.phpmyadmin.net |
|
-- |
|
-- Host: localhost |
|
-- Generation Time: May 05, 2014 at 01:24 PM |
|
-- Server version: 5.5.8 |
|
-- PHP Version: 5.3.5 |
|
|
|
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
|
|
/*!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 `countries` |
|
-- |
|
|
|
CREATE TABLE IF NOT EXISTS `countries` ( |
|
`code` char(2) NOT NULL, |
|
`name` varchar(100) DEFAULT NULL, |
|
PRIMARY KEY (`code`) |
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|
|
|
-- |
|
-- Dumping data for table `countries` |
|
-- |
|
|
|
INSERT INTO `countries` (`code`, `name`) VALUES |
|
('AD', 'Andorra'), |
|
('AE', 'United Arab Emirates'), |
|
('AF', 'Afghanistan'), |
|
('AG', 'Antigua and Barbuda'), |
|
('AI', 'Anguilla'), |
|
('AL', 'Albania'), |
|
('AM', 'Armenia'), |
|
('AO', 'Angola'), |
|
('AQ', 'Antarctica'), |
|
('AR', 'Argentina'), |
|
('AS', 'American Samoa'), |
|
('AT', 'Austria'), |
|
('AU', 'Australia'), |
|
('AW', 'Aruba'), |
|
('AX', 'Åland Islands'), |
|
('AZ', 'Azerbaijan'), |
|
('BA', 'Bosnia and Herzegovina'), |
|
('BB', 'Barbados'), |
|
('BD', 'Bangladesh'), |
|
('BE', 'Belgium'), |
|
('BF', 'Burkina Faso'), |
|
('BG', 'Bulgaria'), |
|
('BH', 'Bahrain'), |
|
('BI', 'Burundi'), |
|
('BJ', 'Benin'), |
|
('BL', 'Saint Barthélemy'), |
|
('BM', 'Bermuda'), |
|
('BN', 'Brunei Darussalam'), |
|
('BO', 'Bolivia'), |
|
('BQ', 'Caribbean Netherlands '), |
|
('BR', 'Brazil'), |
|
('BS', 'Bahamas'), |
|
('BT', 'Bhutan'), |
|
('BV', 'Bouvet Island'), |
|
('BW', 'Botswana'), |
|
('BY', 'Belarus'), |
|
('BZ', 'Belize'), |
|
('CA', 'Canada'), |
|
('CC', 'Cocos (Keeling) Islands'), |
|
('CD', 'Congo, Democratic Republic of'), |
|
('CF', 'Central African Republic'), |
|
('CG', 'Congo'), |
|
('CH', 'Switzerland'), |
|
('CI', 'Côte D’Ivoire'), |
|
('CK', 'Cook Islands'), |
|
('CL', 'Chile'), |
|
('CM', 'Cameroon'), |
|
('CN', 'China'), |
|
('CO', 'Colombia'), |
|
('CR', 'Costa Rica'), |
|
('CU', 'Cuba'), |
|
('CV', 'Cape Verde'), |
|
('CW', 'Curaçao'), |
|
('CX', 'Christmas Island'), |
|
('CY', 'Cyprus'), |
|
('CZ', 'Czech Republic'), |
|
('DE', 'Germany'), |
|
('DJ', 'Djibouti'), |
|
('DK', 'Denmark'), |
|
('DM', 'Dominica'), |
|
('DO', 'Dominican Republic'), |
|
('DZ', 'Algeria'), |
|
('EC', 'Ecuador'), |
|
('EE', 'Estonia'), |
|
('EG', 'Egypt'), |
|
('EH', 'Western Sahara'), |
|
('ER', 'Eritrea'), |
|
('ES', 'Spain'), |
|
('ET', 'Ethiopia'), |
|
('FI', 'Finland'), |
|
('FJ', 'Fiji'), |
|
('FK', 'Falkland Islands'), |
|
('FM', 'Micronesia, Federated States of'), |
|
('FO', 'Faroe Islands'), |
|
('FR', 'France'), |
|
('GA', 'Gabon'), |
|
('GB', 'United Kingdom'), |
|
('GD', 'Grenada'), |
|
('GE', 'Georgia'), |
|
('GF', 'French Guiana'), |
|
('GG', 'Guernsey'), |
|
('GH', 'Ghana'), |
|
('GI', 'Gibraltar'), |
|
('GL', 'Greenland'), |
|
('GM', 'Gambia'), |
|
('GN', 'Guinea'), |
|
('GP', 'Guadeloupe'), |
|
('GQ', 'Equatorial Guinea'), |
|
('GR', 'Greece'), |
|
('GS', 'South Georgia and the South Sandwich Islands'), |
|
('GT', 'Guatemala'), |
|
('GU', 'Guam'), |
|
('GW', 'Guinea-Bissau'), |
|
('GY', 'Guyana'), |
|
('HK', 'Hong Kong'), |
|
('HM', 'Heard and McDonald Islands'), |
|
('HN', 'Honduras'), |
|
('HR', 'Croatia'), |
|
('HT', 'Haiti'), |
|
('HU', 'Hungary'), |
|
('ID', 'Indonesia'), |
|
('IE', 'Ireland'), |
|
('IL', 'Israel'), |
|
('IM', 'Isle of Man'), |
|
('IN', 'India'), |
|
('IO', 'British Indian Ocean Territory'), |
|
('IQ', 'Iraq'), |
|
('IR', 'Iran'), |
|
('IS', 'Iceland'), |
|
('IT', 'Italy'), |
|
('JE', 'Jersey'), |
|
('JM', 'Jamaica'), |
|
('JO', 'Jordan'), |
|
('JP', 'Japan'), |
|
('KE', 'Kenya'), |
|
('KG', 'Kyrgyzstan'), |
|
('KH', 'Cambodia'), |
|
('KI', 'Kiribati'), |
|
('KM', 'Comoros'), |
|
('KN', 'Saint Kitts and Nevis'), |
|
('KP', 'North Korea'), |
|
('KR', 'South Korea'), |
|
('KW', 'Kuwait'), |
|
('KY', 'Cayman Islands'), |
|
('KZ', 'Kazakhstan'), |
|
('LA', 'Lao People’s Democratic Republic'), |
|
('LB', 'Lebanon'), |
|
('LC', 'Saint Lucia'), |
|
('LI', 'Liechtenstein'), |
|
('LK', 'Sri Lanka'), |
|
('LR', 'Liberia'), |
|
('LS', 'Lesotho'), |
|
('LT', 'Lithuania'), |
|
('LU', 'Luxembourg'), |
|
('LV', 'Latvia'), |
|
('LY', 'Libya'), |
|
('MA', 'Morocco'), |
|
('MC', 'Monaco'), |
|
('MD', 'Moldova'), |
|
('ME', 'Montenegro'), |
|
('MF', 'Saint-Martin (France)'), |
|
('MG', 'Madagascar'), |
|
('MH', 'Marshall Islands'), |
|
('MK', 'Macedonia'), |
|
('ML', 'Mali'), |
|
('MM', 'Myanmar'), |
|
('MN', 'Mongolia'), |
|
('MO', 'Macau'), |
|
('MP', 'Northern Mariana Islands'), |
|
('MQ', 'Martinique'), |
|
('MR', 'Mauritania'), |
|
('MS', 'Montserrat'), |
|
('MT', 'Malta'), |
|
('MU', 'Mauritius'), |
|
('MV', 'Maldives'), |
|
('MW', 'Malawi'), |
|
('MX', 'Mexico'), |
|
('MY', 'Malaysia'), |
|
('MZ', 'Mozambique'), |
|
('NA', 'Namibia'), |
|
('NC', 'New Caledonia'), |
|
('NE', 'Niger'), |
|
('NF', 'Norfolk Island'), |
|
('NG', 'Nigeria'), |
|
('NI', 'Nicaragua'), |
|
('NL', 'The Netherlands'), |
|
('NO', 'Norway'), |
|
('NP', 'Nepal'), |
|
('NR', 'Nauru'), |
|
('NU', 'Niue'), |
|
('NZ', 'New Zealand'), |
|
('OM', 'Oman'), |
|
('PA', 'Panama'), |
|
('PE', 'Peru'), |
|
('PF', 'French Polynesia'), |
|
('PG', 'Papua New Guinea'), |
|
('PH', 'Philippines'), |
|
('PK', 'Pakistan'), |
|
('PL', 'Poland'), |
|
('PM', 'St. Pierre and Miquelon'), |
|
('PN', 'Pitcairn'), |
|
('PR', 'Puerto Rico'), |
|
('PS', 'Palestinian Territory, Occupied'), |
|
('PT', 'Portugal'), |
|
('PW', 'Palau'), |
|
('PY', 'Paraguay'), |
|
('QA', 'Qatar'), |
|
('RE', 'Reunion'), |
|
('RO', 'Romania'), |
|
('RS', 'Serbia'), |
|
('RU', 'Russian Federation'), |
|
('RW', 'Rwanda'), |
|
('SA', 'Saudi Arabia'), |
|
('SB', 'Solomon Islands'), |
|
('SC', 'Seychelles'), |
|
('SD', 'Sudan'), |
|
('SE', 'Sweden'), |
|
('SG', 'Singapore'), |
|
('SH', 'Saint Helena'), |
|
('SI', 'Slovenia'), |
|
('SJ', 'Svalbard and Jan Mayen Islands'), |
|
('SK', 'Slovakia (Slovak Republic)'), |
|
('SL', 'Sierra Leone'), |
|
('SM', 'San Marino'), |
|
('SN', 'Senegal'), |
|
('SO', 'Somalia'), |
|
('SR', 'Suriname'), |
|
('SS', 'South Sudan'), |
|
('ST', 'Sao Tome and Principe'), |
|
('SV', 'El Salvador'), |
|
('SX', 'Saint-Martin (Pays-Bas)'), |
|
('SY', 'Syria'), |
|
('SZ', 'Swaziland'), |
|
('TC', 'Turks and Caicos Islands'), |
|
('TD', 'Chad'), |
|
('TF', 'French Southern Territories'), |
|
('TG', 'Togo'), |
|
('TH', 'Thailand'), |
|
('TJ', 'Tajikistan'), |
|
('TK', 'Tokelau'), |
|
('TL', 'Timor-Leste'), |
|
('TM', 'Turkmenistan'), |
|
('TN', 'Tunisia'), |
|
('TO', 'Tonga'), |
|
('TR', 'Turkey'), |
|
('TT', 'Trinidad and Tobago'), |
|
('TV', 'Tuvalu'), |
|
('TW', 'Taiwan'), |
|
('TZ', 'Tanzania'), |
|
('UA', 'Ukraine'), |
|
('UG', 'Uganda'), |
|
('UM', 'United States Minor Outlying Islands'), |
|
('US', 'United States'), |
|
('UY', 'Uruguay'), |
|
('UZ', 'Uzbekistan'), |
|
('VA', 'Vatican'), |
|
('VC', 'Saint Vincent and the Grenadines'), |
|
('VE', 'Venezuela'), |
|
('VG', 'Virgin Islands (British)'), |
|
('VI', 'Virgin Islands (U.S.)'), |
|
('VN', 'Vietnam'), |
|
('VU', 'Vanuatu'), |
|
('WF', 'Wallis and Futuna Islands'), |
|
('WS', 'Samoa'), |
|
('YE', 'Yemen'), |
|
('YT', 'Mayotte'), |
|
('ZA', 'South Africa'), |
|
('ZM', 'Zambia'), |
|
('ZW', 'Zimbabwe'); |