Last change
on this file since 52 was 27, checked in by Kris Deugau, 14 years ago |
/trunk/uribl
Add URI blacklist database interface code
|
File size:
558 bytes
|
Rev | Line | |
---|
[27] | 1 | CREATE TABLE misc (
|
---|
| 2 | "key" character varying(30),
|
---|
| 3 | value character varying(255)
|
---|
| 4 | );
|
---|
| 5 |
|
---|
| 6 | CREATE 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 |
|
---|
| 14 | CREATE 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.