/[webpac2]/trunk/sql/schema.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/sql/schema.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 25 by dpavlin, Sat Jul 23 15:46:24 2005 UTC revision 26 by dpavlin, Sat Jul 23 18:39:44 2005 UTC
# Line 9  create table catalogs ( Line 9  create table catalogs (
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
# Line 30  create table catalog_entry ( Line 31  create table catalog_entry (
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,
# Line 48  create table items ( Line 50  create table items (
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
Legend:
Removed from v.25  
changed lines
  Added in v.26
  ViewVC Help
Powered by ViewVC 1.1.26