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),
39 date timestamp not null default now(),
43 -- HyperEstraier support table
44 create table items_est (
45 path text, -- unique index
46 uri text not null, -- unique index
55 date timestamp not null default now(),
59 create table entry_tag (
60 entry_id int references entries(id),
61 tag_id int references tags(id),
63 t_type text not null, -- index
64 date timestamp not null default now(),
65 primary key (entry_id, tag_id)
69 create table entries_pgbits (
70 issue int not null, -- unique index
72 ) inherits (entries) ;
74 create table items_pgbits (
75 mytitle text not null,
85 create view pgbits_articles as select
87 date(entries_pgbits.date) as issue_date,
90 date(items_pgbits.date) as date
92 join entries_pgbits on entry_id = entries_pgbits.id ;