Skip to content

Instantly share code, notes, and snippets.

💭
Programming https://gitlab.melroy.org/melroy/air-quality-meter

Melroy van den Berg danger89

💭
Programming https://gitlab.melroy.org/melroy/air-quality-meter
Block or report user

Report or block danger89

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View .about+license.md

A zoomable candlestick chart.

Copyright © 2015, Anil Nair - MIT License

@danger89
danger89 / countries.sql
Last active Sep 3, 2019 — forked from paulochf/countries.sql
All countries of the world in SQL database. See https://gitlab.melroy.org/snippets/6 for comma seperated file (CSV).
View countries.sql
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;
You can’t perform that action at this time.