Carl said to do it.

[backups/.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index 42bf81168517fc3ede726c710e89c5e6abeae836..5022b71e9e1b07cb35c36f1ca0d297e9b69cb748 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 UNIQUE INDEX filename ON filedata( filename );