Ferret File System/v0.1/SQL/event/entry: Difference between revisions
< Ferret File System | v0.1 | SQL | event
Jump to navigation
Jump to search
(Created page with "==About== ===Fields=== * '''didSeek''': We looked for this entry because it already existed in the database. * '''didFind''': This entry was found in the filesystem. (didSeek=...") |
(might as well specify INNODB, even though it is the default) |
||
| Line 13: | Line 13: | ||
PRIMARY KEY(`ID_Event`) | PRIMARY KEY(`ID_Event`) | ||
) | ) | ||
</mysql> | ENGINE = INNODB;</mysql> | ||
Revision as of 23:40, 27 February 2016
About
Fields
- didSeek: We looked for this entry because it already existed in the database.
- didFind: This entry was found in the filesystem. (didSeek=FALSE, didFind=TRUE: new file found; didSeek=TRUE, didFind=FALSE: file deleted/moved)
SQL
<mysql>CREATE TABLE `event_entry` (
`ID_Event` INT NOT NULL, `didSeek` BIT, `didFind` BIT, `Size` LONGINT, `WhenCreated` DATETIME DEFAULT NULL COMMENT "entry's creation timestamp, if set", `WhenChanged` DATETIME DEFAULT NULL COMMENT "entry's modification timestamp, if set", PRIMARY KEY(`ID_Event`)
) ENGINE = INNODB;</mysql>