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

From Woozle Writes Code
Jump to navigation Jump to search
m (5 revisions imported: moving here)
m (Woozle moved page FileFerret/SQL/file to Ferret File System/v0.1/SQL/file: obsolete)
 
(No difference)

Latest revision as of 13:40, 25 February 2024

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 entry and replaced them with ID_Entry.

SQL

<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>