A basic country table.

country.sql

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

DROP TABLE IF EXISTS country;
CREATE TABLE country (
  country_id int(11) NOT NULL auto_increment,
  zone_id int(11) NOT NULL default '1',
  country_name varchar(64) default NULL,
  country_3_code char(3) default NULL,
  country_2_code char(2) default NULL,
  PRIMARY KEY  (country_id),
  KEY idx_country_name (country_name)
) TYPE=MyISAM COMMENT='Country records';

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

INSERT INTO country VALUES (1,1,'Afghanistan','AFG','AF');
INSERT INTO country VALUES (2,1,'Albania','ALB','AL');
INSERT INTO country VALUES (3,1,'Algeria','DZA','DZ');
INSERT INTO country VALUES (4,1,'American Samoa','ASM','AS');
INSERT INTO country VALUES (5,1,'Andorra','AND','AD');
INSERT INTO country VALUES (6,1,'Angola','AGO','AO');
INSERT INTO country VALUES (7,1,'Anguilla','AIA','AI');
INSERT INTO country VALUES (8,1,'Antarctica','ATA','AQ');
INSERT INTO country VALUES (9,1,'Antigua and Barbuda','ATG','AG');
INSERT INTO country VALUES (10,1,'Argentina','ARG','AR');
INSERT INTO country VALUES (11,1,'Armenia','ARM','AM');
INSERT INTO country VALUES (12,1,'Aruba','ABW','AW');
INSERT INTO country VALUES (13,1,'Australia','AUS','AU');
INSERT INTO country VALUES (14,1,'Austria','AUT','AT');
INSERT INTO country VALUES (15,1,'Azerbaijan','AZE','AZ');
INSERT INTO country VALUES (16,1,'Bahamas','BHS','BS');
INSERT INTO country VALUES (17,1,'Bahrain','BHR','BH');
INSERT INTO country VALUES (18,1,'Bangladesh','BGD','BD');
INSERT INTO country VALUES (19,1,'Barbados','BRB','BB');
INSERT INTO country VALUES (20,1,'Belarus','BLR','BY');
INSERT INTO country VALUES (21,1,'Belgium','BEL','BE');
INSERT INTO country VALUES (22,1,'Belize','BLZ','BZ');
INSERT INTO country VALUES (23,1,'Benin','BEN','BJ');
INSERT INTO country VALUES (24,1,'Bermuda','BMU','BM');
INSERT INTO country VALUES (25,1,'Bhutan','BTN','BT');
INSERT INTO country VALUES (26,1,'Bolivia','BOL','BO');
INSERT INTO country VALUES (27,1,'Bosnia and Herzegowina','BIH','BA');
INSERT INTO country VALUES (28,1,'Botswana','BWA','BW');
INSERT INTO country VALUES (29,1,'Bouvet Island','BVT','BV');
INSERT INTO country VALUES (30,1,'Brazil','BRA','BR');
INSERT INTO country VALUES (31,1,'British Indian Ocean Territory','IOT','IO');
INSERT INTO country VALUES (32,1,'Brunei Darussalam','BRN','BN');
INSERT INTO country VALUES (33,1,'Bulgaria','BGR','BG');
INSERT INTO country VALUES (34,1,'Burkina Faso','BFA','BF');
INSERT INTO country VALUES (35,1,'Burundi','BDI','BI');
INSERT INTO country VALUES (36,1,'Cambodia','KHM','KH');
INSERT INTO country VALUES (37,1,'Cameroon','CMR','CM');
INSERT INTO country VALUES (38,1,'Canada','CAN','CA');
INSERT INTO country VALUES (39,1,'Cape Verde','CPV','CV');
INSERT INTO country VALUES (40,1,'Cayman Islands','CYM','KY');
INSERT INTO country VALUES (41,1,'Central African Republic','CAF','CF');
INSERT INTO country VALUES (42,1,'Chad','TCD','TD');
INSERT INTO country VALUES (43,1,'Chile','CHL','CL');
INSERT INTO country VALUES (44,1,'China','CHN','CN');
INSERT INTO country VALUES (45,1,'Christmas Island','CXR','CX');
INSERT INTO country VALUES (46,1,'Cocos (Keeling) Islands','CCK','CC');
INSERT INTO country VALUES (47,1,'Colombia','COL','CO');
INSERT INTO country VALUES (48,1,'Comoros','COM','KM');
INSERT INTO country VALUES (49,1,'Congo','COG','CG');
INSERT INTO country VALUES (50,1,'Cook Islands','COK','CK');
INSERT INTO country VALUES (51,1,'Costa Rica','CRI','CR');
INSERT INTO country VALUES (52,1,'Cote D\'Ivoire','CIV','CI');
INSERT INTO country VALUES (53,1,'Croatia','HRV','HR');
INSERT INTO country VALUES (54,1,'Cuba','CUB','CU');
INSERT INTO country VALUES (55,1,'Cyprus','CYP','CY');
INSERT INTO country VALUES (56,1,'Czech Republic','CZE','CZ');
INSERT INTO country VALUES (57,1,'Denmark','DNK','DK');
INSERT INTO country VALUES (58,1,'Djibouti','DJI','DJ');
INSERT INTO country VALUES (59,1,'Dominica','DMA','DM');
INSERT INTO country VALUES (60,1,'Dominican Republic','DOM','DO');
INSERT INTO country VALUES (61,1,'East Timor','TMP','TP');
INSERT INTO country VALUES (62,1,'Ecuador','ECU','EC');
INSERT INTO country VALUES (63,1,'Egypt','EGY','EG');
INSERT INTO country VALUES (64,1,'El Salvador','SLV','SV');
INSERT INTO country VALUES (65,1,'Equatorial Guinea','GNQ','GQ');
INSERT INTO country VALUES (66,1,'Eritrea','ERI','ER');
INSERT INTO country VALUES (67,1,'Estonia','EST','EE');
INSERT INTO country VALUES (68,1,'Ethiopia','ETH','ET');
INSERT INTO country VALUES (69,1,'Falkland Islands (Malvinas)','FLK','FK');
INSERT INTO country VALUES (70,1,'Faroe Islands','FRO','FO');
INSERT INTO country VALUES (71,1,'Fiji','FJI','FJ');
INSERT INTO country VALUES (72,1,'Finland','FIN','FI');
INSERT INTO country VALUES (73,1,'France','FRA','FR');
INSERT INTO country VALUES (74,1,'France, Metropolitan','FXX','FX');
INSERT INTO country VALUES (75,1,'French Guiana','GUF','GF');
INSERT INTO country VALUES (76,1,'French Polynesia','PYF','PF');
INSERT INTO country VALUES (77,1,'French Southern Territories','ATF','TF');
INSERT INTO country VALUES (78,1,'Gabon','GAB','GA');
INSERT INTO country VALUES (79,1,'Gambia','GMB','GM');
INSERT INTO country VALUES (80,1,'Georgia','GEO','GE');
INSERT INTO country VALUES (81,1,'Germany','DEU','DE');
INSERT INTO country VALUES (82,1,'Ghana','GHA','GH');
INSERT INTO country VALUES (83,1,'Gibraltar','GIB','GI');
INSERT INTO country VALUES (84,1,'Greece','GRC','GR');
INSERT INTO country VALUES (85,1,'Greenland','GRL','GL');
INSERT INTO country VALUES (86,1,'Grenada','GRD','GD');
INSERT INTO country VALUES (87,1,'Guadeloupe','GLP','GP');
INSERT INTO country VALUES (88,1,'Guam','GUM','GU');
INSERT INTO country VALUES (89,1,'Guatemala','GTM','GT');
INSERT INTO country VALUES (90,1,'Guinea','GIN','GN');
INSERT INTO country VALUES (91,1,'Guinea-bissau','GNB','GW');
INSERT INTO country VALUES (92,1,'Guyana','GUY','GY');
INSERT INTO country VALUES (93,1,'Haiti','HTI','HT');
INSERT INTO country VALUES (94,1,'Heard and Mc Donald Islands','HMD','HM');
INSERT INTO country VALUES (95,1,'Honduras','HND','HN');
INSERT INTO country VALUES (96,1,'Hong Kong','HKG','HK');
INSERT INTO country VALUES (97,1,'Hungary','HUN','HU');
INSERT INTO country VALUES (98,1,'Iceland','ISL','IS');
INSERT INTO country VALUES (99,1,'India','IND','IN');
INSERT INTO country VALUES (100,1,'Indonesia','IDN','ID');
INSERT INTO country VALUES (101,1,'Iran (Islamic Republic of)','IRN','IR');
INSERT INTO country VALUES (102,1,'Iraq','IRQ','IQ');
INSERT INTO country VALUES (103,1,'Ireland','IRL','IE');
INSERT INTO country VALUES (104,1,'Israel','ISR','IL');
INSERT INTO country VALUES (105,1,'Italy','ITA','IT');
INSERT INTO country VALUES (106,1,'Jamaica','JAM','JM');
INSERT INTO country VALUES (107,1,'Japan','JPN','JP');
INSERT INTO country VALUES (108,1,'Jordan','JOR','JO');
INSERT INTO country VALUES (109,1,'Kazakhstan','KAZ','KZ');
INSERT INTO country VALUES (110,1,'Kenya','KEN','KE');
INSERT INTO country VALUES (111,1,'Kiribati','KIR','KI');
INSERT INTO country VALUES (112,1,'Korea, Democratic People\'s Republic of','PRK','KP');
INSERT INTO country VALUES (113,1,'Korea, Republic of','KOR','KR');
INSERT INTO country VALUES (114,1,'Kuwait','KWT','KW');
INSERT INTO country VALUES (115,1,'Kyrgyzstan','KGZ','KG');
INSERT INTO country VALUES (116,1,'Lao People\'s Democratic Republic','LAO','LA');
INSERT INTO country VALUES (117,1,'Latvia','LVA','LV');
INSERT INTO country VALUES (118,1,'Lebanon','LBN','LB');
INSERT INTO country VALUES (119,1,'Lesotho','LSO','LS');
INSERT INTO country VALUES (120,1,'Liberia','LBR','LR');
INSERT INTO country VALUES (121,1,'Libyan Arab Jamahiriya','LBY','LY');
INSERT INTO country VALUES (122,1,'Liechtenstein','LIE','LI');
INSERT INTO country VALUES (123,1,'Lithuania','LTU','LT');
INSERT INTO country VALUES (124,1,'Luxembourg','LUX','LU');
INSERT INTO country VALUES (125,1,'Macau','MAC','MO');
INSERT INTO country VALUES (126,1,'Macedonia, The Former Yugoslav Republic of','MKD','MK');
INSERT INTO country VALUES (127,1,'Madagascar','MDG','MG');
INSERT INTO country VALUES (128,1,'Malawi','MWI','MW');
INSERT INTO country VALUES (129,1,'Malaysia','MYS','MY');
INSERT INTO country VALUES (130,1,'Maldives','MDV','MV');
INSERT INTO country VALUES (131,1,'Mali','MLI','ML');
INSERT INTO country VALUES (132,1,'Malta','MLT','MT');
INSERT INTO country VALUES (133,1,'Marshall Islands','MHL','MH');
INSERT INTO country VALUES (134,1,'Martinique','MTQ','MQ');
INSERT INTO country VALUES (135,1,'Mauritania','MRT','MR');
INSERT INTO country VALUES (136,1,'Mauritius','MUS','MU');
INSERT INTO country VALUES (137,1,'Mayotte','MYT','YT');
INSERT INTO country VALUES (138,1,'Mexico','MEX','MX');
INSERT INTO country VALUES (139,1,'Micronesia, Federated States of','FSM','FM');
INSERT INTO country VALUES (140,1,'Moldova, Republic of','MDA','MD');
INSERT INTO country VALUES (141,1,'Monaco','MCO','MC');
INSERT INTO country VALUES (142,1,'Mongolia','MNG','MN');
INSERT INTO country VALUES (143,1,'Montserrat','MSR','MS');
INSERT INTO country VALUES (144,1,'Morocco','MAR','MA');
INSERT INTO country VALUES (145,1,'Mozambique','MOZ','MZ');
INSERT INTO country VALUES (146,1,'Myanmar','MMR','MM');
INSERT INTO country VALUES (147,1,'Namibia','NAM','NA');
INSERT INTO country VALUES (148,1,'Nauru','NRU','NR');
INSERT INTO country VALUES (149,1,'Nepal','NPL','NP');
INSERT INTO country VALUES (150,1,'Netherlands','NLD','NL');
INSERT INTO country VALUES (151,1,'Netherlands Antilles','ANT','AN');
INSERT INTO country VALUES (152,1,'New Caledonia','NCL','NC');
INSERT INTO country VALUES (153,1,'New Zealand','NZL','NZ');
INSERT INTO country VALUES (154,1,'Nicaragua','NIC','NI');
INSERT INTO country VALUES (155,1,'Niger','NER','NE');
INSERT INTO country VALUES (156,1,'Nigeria','NGA','NG');
INSERT INTO country VALUES (157,1,'Niue','NIU','NU');
INSERT INTO country VALUES (158,1,'Norfolk Island','NFK','NF');
INSERT INTO country VALUES (159,1,'Northern Mariana Islands','MNP','MP');
INSERT INTO country VALUES (160,1,'Norway','NOR','NO');
INSERT INTO country VALUES (161,1,'Oman','OMN','OM');
INSERT INTO country VALUES (162,1,'Pakistan','PAK','PK');
INSERT INTO country VALUES (163,1,'Palau','PLW','PW');
INSERT INTO country VALUES (164,1,'Panama','PAN','PA');
INSERT INTO country VALUES (165,1,'Papua New Guinea','PNG','PG');
INSERT INTO country VALUES (166,1,'Paraguay','PRY','PY');
INSERT INTO country VALUES (167,1,'Peru','PER','PE');
INSERT INTO country VALUES (168,1,'Philippines','PHL','PH');
INSERT INTO country VALUES (169,1,'Pitcairn','PCN','PN');
INSERT INTO country VALUES (170,1,'Poland','POL','PL');
INSERT INTO country VALUES (171,1,'Portugal','PRT','PT');
INSERT INTO country VALUES (172,1,'Puerto Rico','PRI','PR');
INSERT INTO country VALUES (173,1,'Qatar','QAT','QA');
INSERT INTO country VALUES (174,1,'Reunion','REU','RE');
INSERT INTO country VALUES (175,1,'Romania','ROM','RO');
INSERT INTO country VALUES (176,1,'Russian Federation','RUS','RU');
INSERT INTO country VALUES (177,1,'Rwanda','RWA','RW');
INSERT INTO country VALUES (178,1,'Saint Kitts and Nevis','KNA','KN');
INSERT INTO country VALUES (179,1,'Saint Lucia','LCA','LC');
INSERT INTO country VALUES (180,1,'Saint Vincent and the Grenadines','VCT','VC');
INSERT INTO country VALUES (181,1,'Samoa','WSM','WS');
INSERT INTO country VALUES (182,1,'San Marino','SMR','SM');
INSERT INTO country VALUES (183,1,'Sao Tome and Principe','STP','ST');
INSERT INTO country VALUES (184,1,'Saudi Arabia','SAU','SA');
INSERT INTO country VALUES (185,1,'Senegal','SEN','SN');
INSERT INTO country VALUES (186,1,'Seychelles','SYC','SC');
INSERT INTO country VALUES (187,1,'Sierra Leone','SLE','SL');
INSERT INTO country VALUES (188,1,'Singapore','SGP','SG');
INSERT INTO country VALUES (189,1,'Slovakia (Slovak Republic)','SVK','SK');
INSERT INTO country VALUES (190,1,'Slovenia','SVN','SI');
INSERT INTO country VALUES (191,1,'Solomon Islands','SLB','SB');
INSERT INTO country VALUES (192,1,'Somalia','SOM','SO');
INSERT INTO country VALUES (193,1,'South Africa','ZAF','ZA');
INSERT INTO country VALUES (194,1,'South Georgia and the South Sandwich Islands','SGS','GS');
INSERT INTO country VALUES (195,1,'Spain','ESP','ES');
INSERT INTO country VALUES (196,1,'Sri Lanka','LKA','LK');
INSERT INTO country VALUES (197,1,'St. Helena','SHN','SH');
INSERT INTO country VALUES (198,1,'St. Pierre and Miquelon','SPM','PM');
INSERT INTO country VALUES (199,1,'Sudan','SDN','SD');
INSERT INTO country VALUES (200,1,'Suriname','SUR','SR');
INSERT INTO country VALUES (201,1,'Svalbard and Jan Mayen Islands','SJM','SJ');
INSERT INTO country VALUES (202,1,'Swaziland','SWZ','SZ');
INSERT INTO country VALUES (203,1,'Sweden','SWE','SE');
INSERT INTO country VALUES (204,1,'Switzerland','CHE','CH');
INSERT INTO country VALUES (205,1,'Syrian Arab Republic','SYR','SY');
INSERT INTO country VALUES (206,1,'Taiwan','TWN','TW');
INSERT INTO country VALUES (207,1,'Tajikistan','TJK','TJ');
INSERT INTO country VALUES (208,1,'Tanzania, United Republic of','TZA','TZ');
INSERT INTO country VALUES (209,1,'Thailand','THA','TH');
INSERT INTO country VALUES (210,1,'Togo','TGO','TG');
INSERT INTO country VALUES (211,1,'Tokelau','TKL','TK');
INSERT INTO country VALUES (212,1,'Tonga','TON','TO');
INSERT INTO country VALUES (213,1,'Trinidad and Tobago','TTO','TT');
INSERT INTO country VALUES (214,1,'Tunisia','TUN','TN');
INSERT INTO country VALUES (215,1,'Turkey','TUR','TR');
INSERT INTO country VALUES (216,1,'Turkmenistan','TKM','TM');
INSERT INTO country VALUES (217,1,'Turks and Caicos Islands','TCA','TC');
INSERT INTO country VALUES (218,1,'Tuvalu','TUV','TV');
INSERT INTO country VALUES (219,1,'Uganda','UGA','UG');
INSERT INTO country VALUES (220,1,'Ukraine','UKR','UA');
INSERT INTO country VALUES (221,1,'United Arab Emirates','ARE','AE');
INSERT INTO country VALUES (222,1,'United Kingdom','GBR','GB');
INSERT INTO country VALUES (223,1,'United States','USA','US');
INSERT INTO country VALUES (224,1,'United States Minor Outlying Islands','UMI','UM');
INSERT INTO country VALUES (225,1,'Uruguay','URY','UY');
INSERT INTO country VALUES (226,1,'Uzbekistan','UZB','UZ');
INSERT INTO country VALUES (227,1,'Vanuatu','VUT','VU');
INSERT INTO country VALUES (228,1,'Vatican City State (Holy See)','VAT','VA');
INSERT INTO country VALUES (229,1,'Venezuela','VEN','VE');
INSERT INTO country VALUES (230,1,'Viet Nam','VNM','VN');
INSERT INTO country VALUES (231,1,'Virgin Islands (British)','VGB','VG');
INSERT INTO country VALUES (232,1,'Virgin Islands (U.S.)','VIR','VI');
INSERT INTO country VALUES (233,1,'Wallis and Futuna Islands','WLF','WF');
INSERT INTO country VALUES (234,1,'Western Sahara','ESH','EH');
INSERT INTO country VALUES (235,1,'Yemen','YEM','YE');
INSERT INTO country VALUES (236,1,'Yugoslavia','YUG','YU');
INSERT INTO country VALUES (237,1,'Zaire','ZAR','ZR');
INSERT INTO country VALUES (238,1,'Zambia','ZMB','ZM');
INSERT INTO country VALUES (239,1,'Zimbabwe','ZWE','ZW');