DROP TABLE IF EXISTS country;
CREATE TABLE country (
  short_code varchar(2) NOT NULL COMMENT 'ISO 3166-1 2 Letter Code',
  name varchar(100) NOT NULL,
  PRIMARY KEY  (short_code),
  UNIQUE KEY UNQ_COUNTRY_NAME (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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