2 create table catalogs (
6 date timestamp not null default now(),
10 create table catalog_webarchive (
11 uri text not null, -- unique index
12 last_crawled timestamp,
14 ) inherits (catalogs) ;
17 create table entries (
21 date timestamp not null default now(),
25 create table catalog_entry (
26 catalog_id int references catalogs(id),
27 entry_id int references entries(id),
28 e_type text not null, -- index
29 primary key (catalog_id, entry_id)
32 -- Pg General Bits entries
33 create table entries_pgbits (
34 issue int not null, -- unique index
36 ) inherits (entries) ;
38 -- Items for each Entry
42 entry_id int references entries(id),
45 date timestamp not null default now(),
49 -- HyperEstraier support table
50 create table items_est (
51 path text, -- unique index
52 uri text not null, -- unique index
61 date timestamp not null default now(),
65 create table entry_tag (
66 entry_id int references entries(id),
67 tag_id int references tags(id),
69 t_type text not null, -- index
70 date timestamp not null default now(),
71 primary key (entry_id, tag_id)