--- trunk/sql/schema.sql	2005/07/23 15:46:24	24
+++ trunk/sql/schema.sql	2005/07/23 18:39:44	26
@@ -9,7 +9,8 @@
 
 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 @@
 
 -- 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_est (
 	path	text,			-- unique index
 	uri	text not null,		-- unique index
-	size	int
+	size	int,
+	primary key(id)
 ) inherits (items) ;
 
 -- Tags for Entries