--
-- Table structure for table `countries`
--

CREATE TABLE  IF NOT EXISTS countries (
  id int(11) NOT NULL auto_increment,
  country_name varchar(100) NOT NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY country_name (country_name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- data
--


INSERT INTO countries(country_name) VALUES 
  ('Afghanistan'),('Albania'),('Algeria'),('American Samoa'),('Andorra'),
  ('Angola'),('Anguilla'),('Antarctica'),('Antigua And Barbuda'),('Argentina'),('Armenia'),
  ('Aruba'),('Australia'),('Austria'),('Azerbaijan'),('Bahamas'),('Bahrain'),('Bangladesh'),
  ('Barbados'),('Belarus'),('Belgium'),('Belize'),('Benin'),('Bermuda'),('Bhutan'),('Bolivia'),
  ('Bosnia and Herzegowina'),('Botswana'),('Bouvet Island'),('Brazil'),('British Indian Ocean Territory'),
  ('Brunei Darussalam'),('Bulgaria'),('Burkina Faso'),('Burma'),('Burundi'),('Cambodia'),('Cameroon'),
  ('Canada'),('Cape Verde'),('Cayman Islands'),('Central African Republic'),('Chad'),('Chile'),('China'),
  ('Christmas Island'),('Cocos (Keeling) Islands'),('Colombia'),('Comoros'),('Congo'),
  ('Congo); the Democratic Republic'),('Cook Islands'),('Costa Rica'),('Cote d Ivoire'),
  ('Croatia'),('Cyprus'),('Czech Republic'),('Denmark'),('Djibouti'),('Dominica'),
  ('Dominican Republic'),('East Timor'),('Ecuador'),('Egypt'),('El Salvador'),
  ('England'),('Equatorial Guinea'),('Eritrea'),('Estonia'),('Ethiopia'),
  ('Falkland Islands'),('Faroe Islands'),('Fiji'),('Finland'),('France'),
  ('French Guiana'),('French Polynesia'),('French Southern Territories'),('Gabon'),
  ('Gambia'),('Georgia'),('Germany'),('Ghana'),('Gibraltar'),('Great Britain'),
  ('Greece'),('Greenland'),('Grenada'),('Guadeloupe'),('Guam'),('Guatemala'),
  ('Guinea'),('Guinea-Bissau'),('Guyana'),('Haiti'),('Heard and Mc Donald Islands'),
  ('Holy See (Vatican City State)'),('Honduras'),('Hong Kong'),('Hungary'),('Iceland'),
  ('India'),('Indonesia'),('Ireland'),('Israel'),('Italy'),('Jamaica'),
  ('Japan'),('Jordan'),('Kazakhstan'),('Kenya'),('Kiribati'),
  ('Korea (South)'),('Kuwait'),('Kyrgyzstan'),('Lao People s Democratic Republ'),
  ('Latvia'),('Lebanon'),('Lesotho'),('Liberia'),('Liechtenstein'),('Lithuania'),
  ('Luxembourg'),('Macau'),('Macedonia'),('Madagascar'),('Malawi'),
  ('Malaysia'),('Maldives'),('Mali'),('Malta'),('Marshall Islands'),
  ('Martinique'),('Mauritania'),('Mauritius'),('Mayotte'),('Mexico'),
  ('Micronesia); Federated States o'),('Moldova); Republic of'),('Monaco'),
  ('Mongolia'),('Montserrat'),('Morocco'),('Mozambique'),('Namibia'),
  ('Nauru'),('Nepal'),('Netherlands'),('Netherlands Antilles'),('New Caledonia'),
  ('New Zealand'),('Nicaragua'),('Niger'),('Nigeria'),('Niuev'),
  ('Norfolk Island'),('Northern Ireland'),('Northern Mariana Islands'),('Norway'),
  ('Oman'),('Pakistan'),('Palau'),('Panama'),('Papua New Guinea'),
  ('Paraguay'),('Peru'),('Philippines'),('Pitcairn'),('Poland'),('Portugal'),
  ('Puerto Rico'),('Qatar'),('Reunion'),('Romania'),('Russian Federation'),
  ('Rwanda'),('Saint Kitts and Nevis'),('Saint Lucia'),
  ('Saint Vincent and the Grenadin'),('Samoa (Independent)'),('San Marino'),
  ('Sao Tome and Principe'),('Saudi Arabia'),('Scotland'),('Senegal'),
  ('Seychelles'),('Sierra Leone'),('Singapore'),('Slovakia'),('Slovenia'),
  ('Solomon Islands'),('Somalia'),('South Africa'),('South Georgia and the South Sa'),
  ('Spain'),('Sri Lanka'),('St. Helena'),('St. Pierre and Miquelon'),('Suriname'),
  ('Svalbard and Jan Mayen Islands'),('Swaziland'),('Sweden'),('Switzerland'),
  ('Taiwan'),('Tajikistan'),('Tanzania'),('Thailand'),('Togo'),('Tokelau'),
  ('Tonga'),('Trinidad and Tobago'),('Tunisia'),('Turkey'),('Turkmenistan'),
  ('Turks and Caicos Islands'),('Tuvalu'),('Uganda'),('Ukraine'),
  ('United Arab Emiratesv'),('United States Minor Outlying I'),('United States of America'),
  ('Uruguay'),('Uzbekistan'),('Vanuatu'),('Venezuela'),('Viet Nam'),
  ('Virgin Islands (British)'),('Virgin Islands (U.S.)'),('Wales'),
  ('Wallis and Futuna Islands'),('Western Sahara'),('Yemen'),('Zambia'),
  ('Zimbabwe');