Skip to content

Instantly share code, notes, and snippets.


Sitthykun LY sitthykun

  • Niyum Group
  • Phnom Penh, Cambodia
  • Twitter @sitthykun
View GitHub Profile
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,