Skip to content

Instantly share code, notes, and snippets.

View sitthykun's full-sized avatar

Sitthykun LY sitthykun

View GitHub Profile
sitthykun / countries.sql
Last active March 8, 2017 15:18 — 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,