Ferret File System/v0.1/SQL/event/entry: Difference between revisions
< Ferret File System | v0.1 | SQL | event
Jump to navigation
Jump to search
(might as well specify INNODB, even though it is the default) |
mNo edit summary |
||
| Line 8: | Line 8: | ||
`didSeek` BIT, | `didSeek` BIT, | ||
`didFind` BIT, | `didFind` BIT, | ||
`Size` | `Size` BIGINT, | ||
`WhenCreated` DATETIME DEFAULT NULL COMMENT "entry's creation timestamp, if set", | `WhenCreated` DATETIME DEFAULT NULL COMMENT "entry's creation timestamp, if set", | ||
`WhenChanged` DATETIME DEFAULT NULL COMMENT "entry's modification timestamp, if set", | `WhenChanged` DATETIME DEFAULT NULL COMMENT "entry's modification timestamp, if set", | ||
Revision as of 23:49, 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` BIGINT, `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>