text: CREATE TABLE list (id VARCHAR(10) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "list" ("id", "value") VALUES (E'AF', E'Afghanistan');
  INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Afrique du Sud');
  INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albanie');
  INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Algérie');
  INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Allemagne');
  INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorre');
  INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
  INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguilla');
  INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarctique');
  INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua-et-Barbuda');
  INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Arabie saoudite');
  INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentine');
  INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Arménie');
  INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
  INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Australie');
  INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Autriche');
  INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbaïdjan');
  INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamas');
  INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahreïn');
  INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladesh');
  INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbade');
  INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Bélarus');
  INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Belgique');
  INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
  INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Bénin');
  INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudes');
  INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhoutan');
  INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolivie');
  INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnie-Herzégovine');
  INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botswana');
  INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brésil');
  INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
  INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgarie');
  INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkina Faso');
  INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
  INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Cambodge');
  INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Cameroun');
  INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Canada');
  INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Cap-Vert');
  INSERT INTO "list" ("id", "value") VALUES (E'EA', E'Ceuta et Melilla');
  INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Chili');
  INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Chine');
  INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Chypre');
  INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Cité du Vatican');
  INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Colombie');
  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'Corée du Nord');
  INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Corée du Sud');
  INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Costa Rica');
  INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Côte d’Ivoire');
  INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Croatie');
  INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Cuba');
  INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
  INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Danemark');
  INSERT INTO "list" ("id", "value") VALUES (E'DG', E'Diego Garcia');
  INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Djibouti');
  INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominique');
  INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Égypte');
  INSERT INTO "list" ("id", "value") VALUES (E'SV', E'El Salvador');
  INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Émirats arabes unis');
  INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Équateur');
  INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Érythrée');
  INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Espagne');
  INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estonie');
  INSERT INTO "list" ("id", "value") VALUES (E'US', E'États-Unis');
  INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Éthiopie');
  INSERT INTO "list" ("id", "value") VALUES (E'EZ', E'Eurozone');
  INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fidji');
  INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finlande');
  INSERT INTO "list" ("id", "value") VALUES (E'FR', E'France');
  INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
  INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambie');
  INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Géorgie');
  INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Géorgie du Sud et îles Sandwich du Sud');
  INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ghana');
  INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltar');
  INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Grèce');
  INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenade');
  INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Groenland');
  INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadeloupe');
  INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
  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'GN', E'Guinée');
  INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Guinée équatoriale');
  INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Guinée-Bissau');
  INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyana');
  INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Guyane française');
  INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haïti');
  INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduras');
  INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hongrie');
  INSERT INTO "list" ("id", "value") VALUES (E'CX', E'île Christmas');
  INSERT INTO "list" ("id", "value") VALUES (E'AC', E'île de l’Ascension');
  INSERT INTO "list" ("id", "value") VALUES (E'IM', E'île de Man');
  INSERT INTO "list" ("id", "value") VALUES (E'NF', E'île Norfolk');
  INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Îles Caïmans');
  INSERT INTO "list" ("id", "value") VALUES (E'IC', E'îles Canaries');
  INSERT INTO "list" ("id", "value") VALUES (E'CC', E'îles Cocos (Keeling)');
  INSERT INTO "list" ("id", "value") VALUES (E'CK', E'îles Cook');
  INSERT INTO "list" ("id", "value") VALUES (E'AX', E'îles d’Åland');
  INSERT INTO "list" ("id", "value") VALUES (E'FO', E'îles Féroé');
  INSERT INTO "list" ("id", "value") VALUES (E'FK', E'îles Malouines');
  INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Îles Marshall');
  INSERT INTO "list" ("id", "value") VALUES (E'UM', E'îles mineures éloignées des États-Unis');
  INSERT INTO "list" ("id", "value") VALUES (E'PN', E'îles Pitcairn');
  INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Îles Salomon');
  INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Îles Turques-et-Caïques');
  INSERT INTO "list" ("id", "value") VALUES (E'VI', E'îles Vierges américaines');
  INSERT INTO "list" ("id", "value") VALUES (E'VG', E'îles Vierges britanniques');
  INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Inde');
  INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonésie');
  INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irak');
  INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iran');
  INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlande');
  INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islande');
  INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israël');
  INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Italie');
  INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaïque');
  INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japon');
  INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
  INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordanie');
  INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazakhstan');
  INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenya');
  INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirghizistan');
  INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
  INSERT INTO "list" ("id", "value") VALUES (E'XK', E'Kosovo');
  INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Koweït');
  INSERT INTO "list" ("id", "value") VALUES (E'RE', E'la Réunion');
  INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
  INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesotho');
  INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Lettonie');
  INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Liban');
  INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Libéria');
  INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libye');
  INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Liechtenstein');
  INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituanie');
  INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luxembourg');
  INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Macédoine');
  INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagascar');
  INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malaisie');
  INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malawi');
  INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldives');
  INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
  INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malte');
  INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Mariannes du Nord');
  INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Maroc');
  INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinique');
  INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maurice');
  INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritanie');
  INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayotte');
  INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Mexique');
  INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Micronésie');
  INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldavie');
  INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monaco');
  INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongolie');
  INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Monténégro');
  INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrat');
  INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambique');
  INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Myanmar');
  INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibie');
  INSERT INTO "list" ("id", "value") VALUES (E'UN', E'Nations Unies');
  INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
  INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Népal');
  INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nicaragua');
  INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Niger');
  INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigéria');
  INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
  INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norvège');
  INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nouvelle-Calédonie');
  INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nouvelle-Zélande');
  INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Oman');
  INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Ouganda');
  INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Ouzbékistan');
  INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistan');
  INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palaos');
  INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
  INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papouasie-Nouvelle-Guinée');
  INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguay');
  INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Pays-Bas');
  INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Pays-Bas caribéens');
  INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Pérou');
  INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Philippines');
  INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Pologne');
  INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polynésie française');
  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'QA', E'Qatar');
  INSERT INTO "list" ("id", "value") VALUES (E'HK', E'R.A.S. chinoise de Hong Kong');
  INSERT INTO "list" ("id", "value") VALUES (E'MO', E'R.A.S. chinoise de Macao');
  INSERT INTO "list" ("id", "value") VALUES (E'CF', E'République centrafricaine');
  INSERT INTO "list" ("id", "value") VALUES (E'DO', E'République dominicaine');
  INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Roumanie');
  INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Royaume-Uni');
  INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Russie');
  INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Rwanda');
  INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Sahara occidental');
  INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Saint-Barthélemy');
  INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Saint-Christophe-et-Niévès');
  INSERT INTO "list" ("id", "value") VALUES (E'SM', E'Saint-Marin');
  INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Saint-Martin (France)');
  INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Saint-Martin (Pays-Bas)');
  INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Saint-Pierre-et-Miquelon');
  INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Saint-Vincent-et-les Grenadines');
  INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Sainte-Hélène');
  INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Sainte-Lucie');
  INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
  INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa américaines');
  INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Sao Tomé-et-Principe');
  INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Sénégal');
  INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbie');
  INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seychelles');
  INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sierra Leone');
  INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapour');
  INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovaquie');
  INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovénie');
  INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somalie');
  INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Soudan');
  INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Soudan du Sud');
  INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri Lanka');
  INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Suède');
  INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Suisse');
  INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Suriname');
  INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard et Jan Mayen');
  INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Swaziland');
  INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Syrie');
  INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tadjikistan');
  INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taïwan');
  INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzanie');
  INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Tchad');
  INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Tchéquie');
  INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Terres australes françaises');
  INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Territoire britannique de l’océan Indien');
  INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Territoires palestiniens');
  INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Thaïlande');
  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'TK', E'Tokelau');
  INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tonga');
  INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinité-et-Tobago');
  INSERT INTO "list" ("id", "value") VALUES (E'TA', E'Tristan da Cunha');
  INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunisie');
  INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkménistan');
  INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turquie');
  INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
  INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukraine');
  INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Uruguay');
  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'Vietnam');
  INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis-et-Futuna');
  INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Yémen');
  INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambie');
  INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabwe');
  