9 |
|
|
10 |
create table catalog_webarchive ( |
create table catalog_webarchive ( |
11 |
uri text not null, -- unique index |
uri text not null, -- unique index |
12 |
last_crawled timestamp |
last_crawled timestamp, |
13 |
|
primary key(id) |
14 |
) inherits (catalogs) ; |
) inherits (catalogs) ; |
15 |
|
|
16 |
-- Entries in Catalog |
-- Entries in Catalog |
31 |
|
|
32 |
-- Pg General Bits entries |
-- Pg General Bits entries |
33 |
create table entries_pgbits ( |
create table entries_pgbits ( |
34 |
issue int not null -- unique index |
issue int not null, -- unique index |
35 |
|
primary key(id) |
36 |
) inherits (entries) ; |
) inherits (entries) ; |
37 |
|
|
38 |
-- Items in Entries |
-- Items for each Entry |
39 |
create table items ( |
create table items ( |
40 |
id serial, |
id serial, |
41 |
title text, |
title text, |
50 |
create table items_est ( |
create table items_est ( |
51 |
path text, -- unique index |
path text, -- unique index |
52 |
uri text not null, -- unique index |
uri text not null, -- unique index |
53 |
size int |
size int, |
54 |
|
primary key(id) |
55 |
) inherits (items) ; |
) inherits (items) ; |
56 |
|
|
57 |
-- Tags for Entries |
-- Tags for Entries |