DROP TABLE IF EXISTS paises;
CREATE TABLE paises (
  CountID int(3) NOT NULL auto_increment,
  clave char(3) DEFAULT '' NOT NULL,
  pais varchar(50) DEFAULT '' NOT NULL,
  PRIMARY KEY (CountID,clave,pais)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO paises (clave,pais) values ('AR','Argentina');
INSERT INTO paises (clave,pais) values ('BB','Barbados');
INSERT INTO paises (clave,pais) values ('BO','Bolivia');
INSERT INTO paises (clave,pais) values ('BR','Brazil');
INSERT INTO paises (clave,pais) values ('BS','Bahamas');
INSERT INTO paises (clave,pais) values ('BZ','Belice');
INSERT INTO paises (clave,pais) values ('CA','Canad&aacute;');
INSERT INTO paises (clave,pais) values ('CL','Chile');
INSERT INTO paises (clave,pais) values ('CO','Colombia');
INSERT INTO paises (clave,pais) values ('CR','Costa Rica');
INSERT INTO paises (clave,pais) values ('CU','Cuba');
INSERT INTO paises (clave,pais) values ('DO','Rep&uacute;blica Dominicana');
INSERT INTO paises (clave,pais) values ('EC','Ecuador');
INSERT INTO paises (clave,pais) values ('ES','Espa&ntilde;a');
INSERT INTO paises (clave,pais) values ('GT','Guatemala');
INSERT INTO paises (clave,pais) values ('HN','Honduras');
INSERT INTO paises (clave,pais) values ('JM','Jamaica');
INSERT INTO paises (clave,pais) values ('MX','M&eacute;xico');
INSERT INTO paises (clave,pais) values ('PA','Panam&aacute;');
INSERT INTO paises (clave,pais) values ('PE','Per&uacute;');
INSERT INTO paises (clave,pais) values ('PR','Puerto Rico');
INSERT INTO paises (clave,pais) values ('PT','Portugal');
INSERT INTO paises (clave,pais) values ('PY','Paraguay');
INSERT INTO paises (clave,pais) values ('SV','El Salvador');
INSERT INTO paises (clave,pais) values ('US','Estados Unidos');
INSERT INTO paises (clave,pais) values ('UY','Uruguay');
INSERT INTO paises (clave,pais) values ('VE','Venezuela');
INSERT INTO paises (clave,pais) values ('AI','Antillas');
INSERT INTO paises (clave,pais) values ('AU','Australia');
INSERT INTO paises (clave,pais) values ('AT','Austria');
INSERT INTO paises (clave,pais) values ('BE','Belgica');
INSERT INTO paises (clave,pais) values ('C2','China');
INSERT INTO paises (clave,pais) values ('CY','Chipre');
INSERT INTO paises (clave,pais) values ('CZ','Rep&uacute;blica Checa');
INSERT INTO paises (clave,pais) values ('DK','Dinamarca');
INSERT INTO paises (clave,pais) values ('EE','Estonia');
INSERT INTO paises (clave,pais) values ('FI','Finlandia');
INSERT INTO paises (clave,pais) values ('FR','Francia');
INSERT INTO paises (clave,pais) values ('DE','Alemania');
INSERT INTO paises (clave,pais) values ('GR','Grecia');
INSERT INTO paises (clave,pais) values ('HK','Hong Kong');
INSERT INTO paises (clave,pais) values ('HU','Hungria');
INSERT INTO paises (clave,pais) values ('IS','Islandia');
INSERT INTO paises (clave,pais) values ('IN','India');
INSERT INTO paises (clave,pais) values ('IE','Irlanda');
INSERT INTO paises (clave,pais) values ('IL','Israel');
INSERT INTO paises (clave,pais) values ('IT','Italia');
INSERT INTO paises (clave,pais) values ('JP','Japon');
INSERT INTO paises (clave,pais) values ('LV','Letonia');
INSERT INTO paises (clave,pais) values ('LT','Lituania');
INSERT INTO paises (clave,pais) values ('LU','Luxemburgo');
INSERT INTO paises (clave,pais) values ('MY','Malasia');
INSERT INTO paises (clave,pais) values ('MT','Malta');
INSERT INTO paises (clave,pais) values ('NL','Paises bajos');
INSERT INTO paises (clave,pais) values ('NZ','Nueva Zelanda');
INSERT INTO paises (clave,pais) values ('NO','Noruega');
INSERT INTO paises (clave,pais) values ('PL','Polonia');
INSERT INTO paises (clave,pais) values ('SG','Singapur');
INSERT INTO paises (clave,pais) values ('SK','Slovakia');
INSERT INTO paises (clave,pais) values ('SI','Slovenia');
INSERT INTO paises (clave,pais) values ('ZA','Sudafrica');
INSERT INTO paises (clave,pais) values ('KR','Korea del sur');
INSERT INTO paises (clave,pais) values ('SE','Suecia');
INSERT INTO paises (clave,pais) values ('CH','Suiza');
INSERT INTO paises (clave,pais) values ('TW','Taiwan');
INSERT INTO paises (clave,pais) values ('TH','Tailandia');
INSERT INTO paises (clave,pais) values ('TR','Turquia');
INSERT INTO paises (clave,pais) values ('GB','Reino Unido');