Routine commit

[backups/.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index 42bf81168517fc3ede726c710e89c5e6abeae836..73f6e76ffcaf473e059756fde5538827b2c9c769 100644 (file)
--- 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