X-Git-Url: http://git.pippins.net/embedvideo/.git/?a=blobdiff_plain;f=schema.sql;h=5022b71e9e1b07cb35c36f1ca0d297e9b69cb748;hb=82560c4541eb3d2044bd9b4f359b713245fdac99;hp=42bf81168517fc3ede726c710e89c5e6abeae836;hpb=b6878571e12b7d5de53721f12e8fb956d07e44d6;p=backups%2F.git

diff --git a/schema.sql b/schema.sql
index 42bf811..5022b71 100644
--- a/schema.sql
+++ b/schema.sql
@@ -6,5 +6,7 @@ CREATE TABLE filedata (
   filesize         INTEGER,
   modified_date    INTEGER, -- e.g. 20051016194000 for Oct 10, 2005 at 7:40pm
   filename         VARCHAR,
-  last_backup_date INTEGER
+  last_backup_date INTEGER  -- same format as modified_date
 );
+
+CREATE UNIQUE INDEX filename ON filedata( filename );