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) |
m (Woozle moved page FileFerret/SQL/event/entry to Ferret File System/v0.1/SQL/event/entry: obsolete) |
||
| (3 intermediate revisions by the same user not shown) | |||
| 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== | ||
| Line 8: | Line 9: | ||
`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", | ||
Latest revision as of 13:40, 25 February 2024
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>