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 -- Items for each Entry
36 entry_id int references entries(id),
38 date timestamp not null default now(),
42 -- HyperEstraier support table
43 create table items_est (
44 path text, -- unique index
45 uri text not null, -- unique index
54 date timestamp not null default now(),
58 create table entry_tag (
59 entry_id int references entries(id),
60 tag_id int references tags(id),
62 t_type text not null, -- index
63 date timestamp not null default now(),
64 primary key (entry_id, tag_id)
68 create table entries_pgbits (
69 issue int not null, -- unique index
71 ) inherits (entries) ;
73 create table items_pgbits (
74 mytitle text not null,
84 create view pgbits_articles as select
86 date(entries_pgbits.date) as issue_date,
89 date(items_pgbits.date) as date
91 join entries_pgbits on entry_id = entries_pgbits.id ;