Skip to content

Instantly share code, notes, and snippets.

@lindlau
lindlau / countries.sql
Created November 15, 2016 22:27 — 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;
/** Android IP Camera
*
* Author: Rob Landry
*
* URL: http://github.com/roblandry/android-ip-camera.device
*
* Date: 3/6/15
*
* Version: 1.0.1
*