Skip to content

Instantly share code, notes, and snippets.

Avatar
🎯
Focusing

Sitthykun LY sitthykun

🎯
Focusing
View GitHub Profile
@sitthykun
sitthykun / countries.sql
Last active Mar 8, 2017 — forked from adhipg/countries.sql
Sql dump of all the Countries, Country Codes, Phone codes. For PostgreSQL
View countries.sql
CREATE TABLE public.countries
(
id serial NOT NULL,
iso character(2) NOT NULL,
iso3 character(3) DEFAULT ''::bpchar,
country_name_upper character varying(45),
country_name character varying(45),
numcode smallint,
phonecode smallint NOT NULL,
status_id integer DEFAULT 1,