Chris Longbottom clongbottom

clongbottom / countries.sql

Created May 24, 2019 14:33 — 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;