Ferret File System/v0.1/SQL/event/entry: Difference between revisions
< Ferret File System | v0.1 | SQL | event
Jump to navigation
Jump to search
mNo edit summary |
(explanations) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': logs events that relate to {{l/fileferret/sql|entry|directory entries}}. | |||
===Fields=== | ===Fields=== | ||
* '''didSeek''': | * '''didSeek''': This entry was found in the filesystem during the ''previous'' scan. | ||
* '''didFind''': This entry was found in the filesystem. (didSeek=FALSE, didFind=TRUE: new file found; didSeek=TRUE, didFind=FALSE: file deleted/moved) | * '''didFind''': This entry was found in the filesystem. (didSeek=FALSE, didFind=TRUE: new file found; didSeek=TRUE, didFind=FALSE: file deleted/moved) | ||
==SQL== | ==SQL== | ||
Revision as of 00:48, 28 February 2016
About
- Purpose: logs events that relate to directory entries.
Fields
- didSeek: This entry was found in the filesystem during the previous scan.
- 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>