source: trunk/uribl/uridb.sql@ 64

Last change on this file since 64 was 27, checked in by Kris Deugau, 14 years ago

/trunk/uribl

Add URI blacklist database interface code

File size: 558 bytes
Line 
1CREATE TABLE misc (
2 "key" character varying(30),
3 value character varying(255)
4);
5
6CREATE TABLE urilist (
7 uri varchar(70) primary key not null,
8 list integer default 2,
9 count integer default 1,
10 added timestamp with time zone default now(),
11 comment varchar(200) not null default ''
12);
13
14CREATE TABLE waslisted (
15 uri varchar(70) primary key not null,
16 list integer default 2,
17 count integer default 1,
18 origadded timestamp with time zone default now(),
19 comment varchar(200) not null default '',
20 delisted timestamp with time zone default now()
21);
22
Note: See TracBrowser for help on using the repository browser.