/*
 Name: pays.sql
 Date: Jully 09, 2004
 Author: Philippe Torloting www.phive-online.com
 Apropos: 1 table Mysql contenant 238 pays du monde en fr  
    */
 
 
  CREATE TABLE  tpays  
  (
  PAYSID INT NOT NULL auto_increment,
  PAYSNAME VARCHAR(80) NOT NULL,
  PAYSCODE CHAR(2) NOT NULL,
  PRIMARY KEY  (PAYSID)
  );
   
 
INSERT INTO tpays values('','France','fr');
INSERT INTO tpays values('','Afghanistan','af');
INSERT INTO tpays values('','Afrique du sud','za');
INSERT INTO tpays values('','Albanie','al');
INSERT INTO tpays values('','Algérie','dz');
INSERT INTO tpays values('','Allemagne','de');
INSERT INTO tpays values('','Arabie saoudite','sa');
INSERT INTO tpays values('','Argentine','ar');
INSERT INTO tpays values('','Australie','au');
INSERT INTO tpays values('','Autriche','at');
INSERT INTO tpays values('','Belgique','be');
INSERT INTO tpays values('','Brésil','br');
INSERT INTO tpays values('','Bulgarie','bg');
INSERT INTO tpays values('','Canada','ca');
INSERT INTO tpays values('','Chili','cl');
INSERT INTO tpays values('','Chine (Rép. pop.)','cn');
INSERT INTO tpays values('','Colombie','co');
INSERT INTO tpays values('','Corée, Sud','kr');
INSERT INTO tpays values('','Costa Rica','cr');
INSERT INTO tpays values('','Croatie','hr');
INSERT INTO tpays values('','Danemark','dk');
INSERT INTO tpays values('','Égypte','eg');
INSERT INTO tpays values('','Émirats arabes unis','ae');
INSERT INTO tpays values('','Équateur','ec');
INSERT INTO tpays values('','États-Unis','us');
INSERT INTO tpays values('','El Salvador','sv');
INSERT INTO tpays values('','Espagne','es');
INSERT INTO tpays values('','Finlande','fi');
INSERT INTO tpays values('','Grèce','gr');
INSERT INTO tpays values('','Hong Kong','hk');
INSERT INTO tpays values('','Hongrie','hu');
INSERT INTO tpays values('','Inde','in');
INSERT INTO tpays values('','Indonésie','id');
INSERT INTO tpays values('','Irlande','ie');
INSERT INTO tpays values('','Israël','il');
INSERT INTO tpays values('','Italie','it');
INSERT INTO tpays values('','Japon','jp');
INSERT INTO tpays values('','Jordanie','jo');
INSERT INTO tpays values('','Liban','lb');
INSERT INTO tpays values('','Malaisie','my');
INSERT INTO tpays values('','Maroc','ma');
INSERT INTO tpays values('','Mexique','mx');
INSERT INTO tpays values('','Norvège','no');
INSERT INTO tpays values('','Nouvelle-Zélande','nz');
INSERT INTO tpays values('','Pérou','pe');
INSERT INTO tpays values('','Pakistan','pk');
INSERT INTO tpays values('','Pays-Bas','nl');
INSERT INTO tpays values('','Philippines','ph');
INSERT INTO tpays values('','Pologne','pl');
INSERT INTO tpays values('','Porto Rico','pr');
INSERT INTO tpays values('','Portugal','pt');
INSERT INTO tpays values('','République tchèque','cz');
INSERT INTO tpays values('','Roumanie','ro');
INSERT INTO tpays values('','Royaume-Uni','uk');
INSERT INTO tpays values('','Russie','ru');
INSERT INTO tpays values('','Singapour','sg');
INSERT INTO tpays values('','Suède','se');
INSERT INTO tpays values('','Suisse','ch');
INSERT INTO tpays values('','Taiwan','tw');
INSERT INTO tpays values('','Thailande','th');
INSERT INTO tpays values('','Turquie','tr');
INSERT INTO tpays values('','Ukraine','ua');
INSERT INTO tpays values('','Venezuela','ve');
INSERT INTO tpays values('','Yougoslavie','yu');
INSERT INTO tpays values('','Samoa','as');
INSERT INTO tpays values('','Andorre','ad');
INSERT INTO tpays values('','Angola','ao');
INSERT INTO tpays values('','Anguilla','ai');
INSERT INTO tpays values('','Antarctique','aq');
INSERT INTO tpays values('','Antigua et Barbuda','ag');
INSERT INTO tpays values('','Arménie','am');
INSERT INTO tpays values('','Aruba','aw');
INSERT INTO tpays values('','Azerbaïdjan','az');
INSERT INTO tpays values('','Bahamas','bs');
INSERT INTO tpays values('','Bahrain','bh');
INSERT INTO tpays values('','Bangladesh','bd');
INSERT INTO tpays values('','Biélorussie','by');
INSERT INTO tpays values('','Belize','bz');
INSERT INTO tpays values('','Benin','bj');
INSERT INTO tpays values('','Bermudes (Les)','bm');
INSERT INTO tpays values('','Bhoutan','bt');
INSERT INTO tpays values('','Bolivie','bo');
INSERT INTO tpays values('','Bosnie-Herzégovine','ba');
INSERT INTO tpays values('','Botswana','bw');
INSERT INTO tpays values('','Bouvet (Îles)','bv');
INSERT INTO tpays values('','Territoire britannique de l\'océan Indien','io');
INSERT INTO tpays values('','Vierges britanniques (Îles)','vg');
INSERT INTO tpays values('','Brunei','bn');
INSERT INTO tpays values('','Burkina Faso','bf');
INSERT INTO tpays values('','Burundi','bi');
INSERT INTO tpays values('','Cambodge','kh');
INSERT INTO tpays values('','Cameroun','cm');
INSERT INTO tpays values('','Cap Vert','cv');
INSERT INTO tpays values('','Cayman (Îles)','ky');
INSERT INTO tpays values('','République centrafricaine','cf');
INSERT INTO tpays values('','Tchad','td');
INSERT INTO tpays values('','Christmas (Île)','cx');
INSERT INTO tpays values('','Cocos (Îles)','cc');
INSERT INTO tpays values('','Comores','km');
INSERT INTO tpays values('','Rép. Dém. du Congo','cg');
INSERT INTO tpays values('','Cook (Îles)','ck');
INSERT INTO tpays values('','Cuba','cu');
INSERT INTO tpays values('','Chypre','cy');
INSERT INTO tpays values('','Djibouti','dj');
INSERT INTO tpays values('','Dominique','dm');
INSERT INTO tpays values('','République Dominicaine','do');
INSERT INTO tpays values('','Timor','tp');
INSERT INTO tpays values('','Guinée Equatoriale','gq');
INSERT INTO tpays values('','Érythrée','er');
INSERT INTO tpays values('','Estonie','ee');
INSERT INTO tpays values('','Ethiopie','et');
INSERT INTO tpays values('','Falkland (Île)','fk');
INSERT INTO tpays values('','Féroé (Îles)','fo');
INSERT INTO tpays values('','Fidji (République des)','fj');
INSERT INTO tpays values('','Guyane française','gf');
INSERT INTO tpays values('','Polynésie française','pf');
INSERT INTO tpays values('','Territoires français du sud','tf');
INSERT INTO tpays values('','Gabon','ga');
INSERT INTO tpays values('','Gambie','gm');
INSERT INTO tpays values('','Géorgie','ge');
INSERT INTO tpays values('','Ghana','gh');
INSERT INTO tpays values('','Gibraltar','gi');
INSERT INTO tpays values('','Groenland','gl');
INSERT INTO tpays values('','Grenade','gd');
INSERT INTO tpays values('','Guadeloupe','gp');
INSERT INTO tpays values('','Guam','gu');
INSERT INTO tpays values('','Guatemala','gt');
INSERT INTO tpays values('','Guinée','gn');
INSERT INTO tpays values('','Guinée-Bissau','gw');
INSERT INTO tpays values('','Guyane','gy');
INSERT INTO tpays values('','Haïti','ht');
INSERT INTO tpays values('','Heard et McDonald (Îles)','hm');
INSERT INTO tpays values('','Honduras','hn');
INSERT INTO tpays values('','Islande','is');
INSERT INTO tpays values('','Iran','ir');
INSERT INTO tpays values('','Irak','iq');
INSERT INTO tpays values('','Côte d\'Ivoire','ci');
INSERT INTO tpays values('','Jamaïque','jm');
INSERT INTO tpays values('','Kazakhstan','kz');
INSERT INTO tpays values('','Kenya','ke');
INSERT INTO tpays values('','Kiribati','ki');
INSERT INTO tpays values('','Corée du Nord','kp');
INSERT INTO tpays values('','Koweit','kw');
INSERT INTO tpays values('','Kirghizistan','kg');
INSERT INTO tpays values('','Laos','la');
INSERT INTO tpays values('','Lettonie','lv');
INSERT INTO tpays values('','Lesotho','ls');
INSERT INTO tpays values('','Libéria','lr');
INSERT INTO tpays values('','Libye','ly');
INSERT INTO tpays values('','Liechtenstein','li');
INSERT INTO tpays values('','Lithuanie','lt');
INSERT INTO tpays values('','Luxembourg','lu');
INSERT INTO tpays values('','Macau','mo');
INSERT INTO tpays values('','Macédoine','mk');
INSERT INTO tpays values('','Madagascar','mg');
INSERT INTO tpays values('','Malawi','mw');
INSERT INTO tpays values('','Maldives (Îles)','mv');
INSERT INTO tpays values('','Mali','ml');
INSERT INTO tpays values('','Malte','mt');
INSERT INTO tpays values('','Marshall (Îles)','mh');
INSERT INTO tpays values('','Martinique','mq');
INSERT INTO tpays values('','Mauritanie','mr');
INSERT INTO tpays values('','Maurice','mu');
INSERT INTO tpays values('','Mayotte','yt');
INSERT INTO tpays values('','Micronésie (États fédérés de)','fm');
INSERT INTO tpays values('','Moldavie','md');
INSERT INTO tpays values('','Monaco','mc');
INSERT INTO tpays values('','Mongolie','mn');
INSERT INTO tpays values('','Montserrat','ms');
INSERT INTO tpays values('','Mozambique','mz');
INSERT INTO tpays values('','Myanmar','mm');
INSERT INTO tpays values('','Namibie','na');
INSERT INTO tpays values('','Nauru','nr');
INSERT INTO tpays values('','Nepal','np');
INSERT INTO tpays values('','Antilles néerlandaises','an');
INSERT INTO tpays values('','Nouvelle Calédonie','nc');
INSERT INTO tpays values('','Nicaragua','ni');
INSERT INTO tpays values('','Niger','ne');
INSERT INTO tpays values('','Nigeria','ng');
INSERT INTO tpays values('','Niue','nu');
INSERT INTO tpays values('','Norfolk (Îles)','nf');
INSERT INTO tpays values('','Mariannes du Nord (Îles)','mp');
INSERT INTO tpays values('','Oman','om');
INSERT INTO tpays values('','Palau','pw');
INSERT INTO tpays values('','Panama','pa');
INSERT INTO tpays values('','Papouasie-Nouvelle-Guinée','pg');
INSERT INTO tpays values('','Paraguay','py');
INSERT INTO tpays values('','Pitcairn (Îles)','pn');
INSERT INTO tpays values('','Qatar','qa');
INSERT INTO tpays values('','Réunion (La)','re');
INSERT INTO tpays values('','Rwanda','rw');
INSERT INTO tpays values('','Géorgie du Sud et Sandwich du Sud (Îles)','gs');
INSERT INTO tpays values('','Saint-Kitts et Nevis','kn');
INSERT INTO tpays values('','Sainte Lucie','lc');
INSERT INTO tpays values('','Saint Vincent et les Grenadines','vc');
INSERT INTO tpays values('','Samoa','ws');
INSERT INTO tpays values('','Saint-Marin (Rép. de)','sm');
INSERT INTO tpays values('','São Tomé et Príncipe (Rép.)','st');
INSERT INTO tpays values('','Sénégal','sn');
INSERT INTO tpays values('','Seychelles','sc');
INSERT INTO tpays values('','Sierra Leone','sl');
INSERT INTO tpays values('','Slovaquie','sk');
INSERT INTO tpays values('','Slovénie','si');
INSERT INTO tpays values('','Somalie','so');
INSERT INTO tpays values('','Sri Lanka','lk');
INSERT INTO tpays values('','Sainte Hélène','sh');
INSERT INTO tpays values('','Saint Pierre et Miquelon','pm');
INSERT INTO tpays values('','Soudan','sd');
INSERT INTO tpays values('','Suriname','sr');
INSERT INTO tpays values('','Svalbard et Jan Mayen (Îles)','sj');
INSERT INTO tpays values('','Swaziland','sz');
INSERT INTO tpays values('','Syrie','sy');
INSERT INTO tpays values('','Tadjikistan','tj');
INSERT INTO tpays values('','Tanzanie','tz');
INSERT INTO tpays values('','Togo','tg');
INSERT INTO tpays values('','Tokelau','tk');
INSERT INTO tpays values('','Tonga','to');
INSERT INTO tpays values('','Trinité et Tobago','tt');
INSERT INTO tpays values('','Tunisie','tn');
INSERT INTO tpays values('','Turkménistan','tm');
INSERT INTO tpays values('','Turks et Caïques (Îles)','tc');
INSERT INTO tpays values('','Tuvalu','tv');
INSERT INTO tpays values('','Îles Mineures Éloignées des États-Unis','um');
INSERT INTO tpays values('','Ouganda','ug');
INSERT INTO tpays values('','Uruguay','uy');
INSERT INTO tpays values('','Ouzbékistan','uz');
INSERT INTO tpays values('','Vanuatu','vu');
INSERT INTO tpays values('','Vatican (Etat du)','va');
INSERT INTO tpays values('','Vietnam','vn');
INSERT INTO tpays values('','Vierges (Îles)','vi');
INSERT INTO tpays values('','Wallis et Futuna (Îles)','wf');
INSERT INTO tpays values('','Sahara Occidental','eh');
INSERT INTO tpays values('','Yemen','ye');
INSERT INTO tpays values('','Zaïre','zr');
INSERT INTO tpays values('','Zambie','zm');
INSERT INTO tpays values('','Zimbabwe','zw');
INSERT INTO tpays values('','La Barbad','bb');