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 |
adhipg
/ countries.sql
Created
January 12, 2012 11:41
Sql dump of all the Countries, Country Codes, Phone codes.
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
| CREATE TABLE IF NOT EXISTS `country` ( | |
| `id` int(11) NOT NULL AUTO_INCREMENT, | |
| `iso` char(2) NOT NULL, | |
| `name` varchar(80) NOT NULL, | |
| `nicename` varchar(80) NOT NULL, | |
| `iso3` char(3) DEFAULT NULL, | |
| `numcode` smallint(6) DEFAULT NULL, | |
| `phonecode` int(5) NOT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |