+CREATE TABLE filedata (
+ filetype CHAR,
+ permissions VARCHAR,
+ username VARCHAR,
+ groupname VARCHAR,
+ filesize INTEGER,
+ modified_date INTEGER, -- e.g. 20051016194000 for Oct 10, 2005 at 7:40pm
+ filename VARCHAR,
+ last_backup_date INTEGER -- same format as modified_date
+);
+
+CREATE UNIQUE INDEX filename ON filedata( filename );