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 );