added primary keys

[webpac2] / sql / schema.sql

diff --git a/sql/schema.sql b/sql/schema.sql
index 2678879..bf03de1 100644 (file)
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -9,7 +9,8 @@ create table catalogs (
 
 create table catalog_webarchive (
        uri     text not null,                  -- unique index
-       last_crawled timestamp
+       last_crawled timestamp,
+       primary key(id)
 ) inherits (catalogs) ;
 
 -- Entries in Catalog
@@ -30,10 +31,11 @@ create table catalog_entry (
 
 -- Pg General Bits entries
 create table entries_pgbits (
-       issue   int not null                    -- unique index
+       issue   int not null,                   -- unique index
+       primary key(id)
 ) inherits (entries) ;
 
--- Items in Entries
+-- Items for each Entry
 create table items (
        id      serial,
        title   text,
@@ -48,7 +50,8 @@ create table items (
 create table items_est (
        path    text,                   -- unique index
        uri     text not null,          -- unique index
-       size    int
+       size    int,
+       primary key(id)
 ) inherits (items) ;
 
 -- Tags for Entries