FileFerret/SQL/files

About

 * Purpose: Tracks actual locations of files, and stats which may be different from file to file without affecting the data/content.

SQL
CREATE TABLE `files` ( `ID`          INT          NOT NULL AUTO_INCREMENT,  `ID_Folder`   INT          NOT NULL COMMENT "Folders.ID of parent folder",  `ID_Firev`    INT DEFAULT      NULL COMMENT "Firevs.ID for this file",  `FileName`    VARCHAR(255)          COMMENT "just the filename.ext, not the full path",  `WhenCreated` DATETIME DEFAULT NULL COMMENT "file's creation timestamp",  `WhenChanged` DATETIME DEFAULT NULL COMMENT "file's modification timestamp",  `FirstFound`  DATETIME     NOT NULL COMMENT "time/date when file was first found during a scan",  `LastFound`   DATETIME     NOT NULL COMMENT "time/date when file was most recently found during a scan",  `isFound`     BOOL DEFAULT FALSE    COMMENT "TRUE = was found on most recent scan",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;