Skip to content

Instantly share code, notes, and snippets.

@fnkenda
fnkenda / countries.sql
Last active February 20, 2023 07:06 — forked from adhipg/countries.sql
Country phone code must be 243 for the DRC (THE DEMOCRATIC REPUBLIC OF THE CONGO) and not 242 this one is for the Republic of Congo. Two different countries.
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;