+++ /dev/null
-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 );