Minor documemtation update.

[cumulus.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index 6d89b4b..2cca99a 100644 (file)
--- a/schema.sql
+++ b/schema.sql
@@ -14,7 +14,9 @@ create table snapshots (
 -- List of segments which have been created.
 create table segments (
     segmentid integer primary key,
-    segment text unique not null
+    segment text unique not null,
+    path text,
+    checksum text
 );
 
 -- Index of all blocks which have been stored in a snapshot, by checksum.
@@ -42,7 +44,7 @@ create unique index snapshot_contents_unique
 create view segment_info as select * from
     (select segmentid, max(timestamp) as mtime,
             sum(size) as size, count(*) as objects
-       from block_index natural join segments group by segmentid)
+       from block_index join segments using (segmentid) group by segmentid)
 natural join
     (select segmentid, sum(size) as used, count(*) as objects_used
        from block_index where blockid in