sql/iptocountry.sql


1
2
3
4
5
6
7
8
9
10
11
12


CREATE TABLE iptocountry (
    id integer DEFAULT nextval(('iptocountry_id_seq'::text)::regclass) NOT NULL,
    startip bigint NOT NULL,
    endip bigint NOT NULL,
    countrycode character(2) NOT NULL,
    country character varying(100) NOT NULL
);


ALTER TABLE ONLY iptocountry
    ADD CONSTRAINT iptocountry_pkey PRIMARY KEY (id);