Ferret File System/v0.1/SQL/event/entry: Difference between revisions

From Woozle Writes Code
< 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` LONGINT,
   `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>