CREATE TABLE list (id VARCHAR(64) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));

INSERT INTO "list" ("id", "value") VALUES (E'AF', E'Afeganistão');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'África do Sul');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Alanda');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albânia');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Alemanha');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorra');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguila');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antártida');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antígua e Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Arábia Saudita');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Argélia');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentina');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Arménia');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Austrália');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Áustria');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbaijão');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Baamas');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladeche');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbados');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Barém');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Bélgica');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benim');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudas');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Bielorrússia');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolívia');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bósnia e Herzegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botsuana');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brasil');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgária');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burquina Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Butão');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Cabo Verde');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Camarões');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Camboja');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Canadá');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Catar');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Cazaquistão');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Chade');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Chéquia');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Chile');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'China');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Chipre');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Cidade do Vaticano');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Colômbia');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Comores');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Congo-Brazzaville');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Congo-Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Coreia do Norte');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Coreia do Sul');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Costa Rica');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Côte d’Ivoire (Costa do Marfim)');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Croácia');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Cuba');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçau');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Dinamarca');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Domínica');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Egito');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Emirados Árabes Unidos');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Equador');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritreia');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Eslováquia');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Eslovénia');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Espanha');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Essuatíni');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Estados Unidos');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estónia');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiópia');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiji');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipinas');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finlândia');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'França');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabão');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gâmbia');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Gana');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Geórgia');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltar');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Granada');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Grécia');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Gronelândia');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadalupe');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guame');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Guatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernesey');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guiana');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Guiana Francesa');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Guiné');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Guiné Equatorial');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Guiné-Bissau');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduras');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong, RAE da China');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hungria');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Iémen');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Ilha Bouvet');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Ilha de Man');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Ilha do Natal');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Ilha Norfolk');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Ilhas Caimão');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Ilhas Cook');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Ilhas dos Cocos (Keeling)');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Ilhas Faroé');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Ilhas Geórgia do Sul e Sandwich do Sul');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Ilhas Heard e McDonald');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Ilhas Malvinas (Falkland)');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Ilhas Marianas do Norte');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Ilhas Marshall');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Ilhas Menores Afastadas dos EUA');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Ilhas Pitcairn');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Ilhas Salomão');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Ilhas Turcas e Caicos');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Ilhas Virgens Britânicas');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Ilhas Virgens dos EUA');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Índia');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonésia');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Irão');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Iraque');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlanda');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islândia');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israel');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Itália');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaica');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japão');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Jibuti');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordânia');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Koweit');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesoto');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Letónia');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Líbano');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Libéria');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Líbia');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Listenstaine');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituânia');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luxemburgo');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macau, RAE da China');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Macedónia do Norte');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagáscar');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Maiote');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malásia');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Maláui');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldivas');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malta');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Marrocos');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinica');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maurícia');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritânia');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'México');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Mianmar (Birmânia)');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Micronésia');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Moçambique');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldávia');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Mónaco');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongólia');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Monserrate');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Montenegro');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namíbia');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepal');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nicarágua');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Níger');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigéria');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niuê');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Noruega');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nova Caledónia');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nova Zelândia');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omã');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Países Baixos');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Países Baixos Caribenhos');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palau');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panamá');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papua-Nova Guiné');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Paquistão');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguai');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polinésia Francesa');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polónia');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Porto Rico');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugal');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Quénia');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Quirguistão');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Quiribáti');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Reino Unido');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'República Centro-Africana');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'República Dominicana');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Reunião');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Roménia');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruanda');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rússia');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa Americana');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Santa Helena');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Santa Lúcia');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'São Bartolomeu');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'São Cristóvão e Neves');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'São Marinho');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'São Martinho');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'São Martinho (Sint Maarten)');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'São Pedro e Miquelão');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'São Tomé e Príncipe');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'São Vicente e Granadinas');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Sara Ocidental');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seicheles');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Serra Leoa');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Sérvia');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapura');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Síria');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somália');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri Lanca');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudão');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Sudão do Sul');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Suécia');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Suíça');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Suriname');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard e Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tailândia');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taiwan');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tajiquistão');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzânia');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Território Britânico do Oceano Índico');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Territórios Austrais Franceses');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Territórios palestinianos');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timor-Leste');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tonga');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Toquelau');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trindade e Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunísia');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turquemenistão');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turquia');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ucrânia');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Uganda');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Uruguai');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Usbequistão');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuela');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietname');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis e Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zâmbia');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabué');
