This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- inspiré de @adhipg (https://gist.github.com/adhipg) (https://gist.github.com/adhipg/1600028) sans être une copie conforme la liste est differente et les pays sont en français les infos manquantes sont remplacé par des zéros | |
| --creation de la table | |
| CREATE TABLE pays ( | |
| id INT(3) NOT NULL, | |
| iso CHAR(2) NOT NULL, | |
| nom VARCHAR(100) NOT NULL, | |
| petitnom VARCHAR(100) NOT NULL, | |
| iso3 CHAR(3) NOT NULL, | |
| numcode INT(3) NOT NULL, | |
| indicatif INT(5) NOT NULL |