Achraf Soltani achrafsoltani

Computer Scientist.

achrafsoltani / countries.sql

Created February 6, 2018 12:16 — forked from adhipg/countries.sql

Sql dump of all the Countries, Country Codes, Phone codes.

	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;