-CREATE TABLE file (
- CHAR type,
- VARCHAR permissions,
- VARCHAR user,
- VARCHAR group,
- INTEGER size,
- INTEGER modified_date,
- VARCHAR name
-)
+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 );