X-Git-Url: http://git.vrable.net/?a=blobdiff_plain;f=schema.sql;h=8518c4fa7fc2922ae9575b4a50c19a77d3620be6;hb=da87780779a2f165503d019ee0b59d10e5d31ec8;hp=114670c76da37d0ffc04ebdb7026e50340d2fdf4;hpb=c7c7041c1b79ffb27647d74a6a345dfcfbf9f190;p=cumulus.git

diff --git a/schema.sql b/schema.sql
index 114670c..8518c4f 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3,7 +3,7 @@
 --
 -- The index is stored in an SQLite3 database.  This is its schema.
 
--- Index of all blocks which have been stored in one snapshot, by checksum.
+-- Index of all blocks which have been stored in a snapshot, by checksum.
 create table block_index (
     blockid integer primary key,
     segment text,
@@ -12,3 +12,10 @@ create table block_index (
     size integer
 );
 create index block_content_index on block_index(checksum);
+create index block_name_index on block_index(segment, object);
+
+-- Index tracking which blocks are used by which snapshots.
+create table snapshot_contents (
+    blockid integer,
+    snapshot text
+);