X-Git-Url: http://git.pippins.net/embedvideo/.git/static/%24link?a=blobdiff_plain;f=schema.sql;h=73f6e76ffcaf473e059756fde5538827b2c9c769;hb=e0c6c331bc17ad8b85fd9db1be947a5c89064906;hp=42bf81168517fc3ede726c710e89c5e6abeae836;hpb=8d352159cb90b923e34c879242ed7516418ec827;p=backups%2F.git

diff --git a/schema.sql b/schema.sql
index 42bf811..73f6e76 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 INDEX filename ON filedata