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

Latest revision as of 13:40, 25 February 2024

Purpose: Tracks actual locations of files, and stats which may be different from file to file without affecting the data/content.

<mysql>CREATE TABLE `file` (

 `ID_Entry`    INT          NOT NULL AUTO_INCREMENT,
 `ID_Firev`    INT DEFAULT      NULL COMMENT "Firev.ID for this file",
 PRIMARY KEY(`ID_Entry`)

) ENGINE = INNODB;</mysql>

@@ Line 1: / Line 1: @@
 ==About==
 * '''Purpose''': Tracks actual locations of files, and stats which may be different from file to file without affecting the data/content.
+===fields===
+===history===
+* '''2016-02-27''' Moved many fields to {{l/same|entry}} and replaced them with '''ID_Entry'''.
 ==SQL==
-<mysql>CREATE TABLE `files` (
+<mysql>CREATE TABLE `file` (
-   `ID`          INT          NOT NULL AUTO_INCREMENT,
+   `ID_Entry`    INT          NOT NULL AUTO_INCREMENT,
-  `ID_Folder`   INT          NOT NULL COMMENT "Folders.ID of parent folder",
+   `ID_Firev`    INT DEFAULT      NULL COMMENT "Firev.ID for this file",
-   `ID_Firev`    INT DEFAULT      NULL COMMENT "Firevs.ID for this file",
+   PRIMARY KEY(`ID_Entry`)
-  `FileName`    VARCHAR(255)          COMMENT "just the filename.ext, not the full path",
-  `WhenCreated` DATETIME DEFAULT NULL COMMENT "file's creation timestamp",
-  `WhenChanged` DATETIME DEFAULT NULL COMMENT "file's modification timestamp",
-  `FirstFound`  DATETIME     NOT NULL COMMENT "time/date when file was first found during a scan",
-  `LastFound`   DATETIME     NOT NULL COMMENT "time/date when file was most recently found during a scan",
-  `isFound`     BOOL DEFAULT FALSE    COMMENT "TRUE = was found on most recent scan",
-   PRIMARY KEY(`ID`)
 )
-ENGINE = MYISAM;</mysql>
+ENGINE = INNODB;</mysql>