source: trunk/uribl/uridb.sql

CREATE TABLE misc (
    "key" character varying(30),
    value character varying(255)
);

CREATE TABLE urilist (
        uri varchar(70) primary key not null,
        list integer default 2,
        count integer default 1,
        added timestamp with time zone default now(),
        comment varchar(200) not null default ''
);

CREATE TABLE waslisted (
        uri varchar(70) primary key not null,
        list integer default 2,
        count integer default 1,
        origadded timestamp with time zone default now(),
        comment varchar(200) not null default '',
        delisted timestamp with time zone default now()
);