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

From Woozle Writes Code
Jump to navigation Jump to search
(moved most fields to dirent)
m (Woozle moved page FileFerret/SQL/files to FileFerret/SQL/file without leaving a redirect: singularizing)
(No difference)

Revision as of 22:41, 27 February 2016

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

SQL

<mysql>CREATE TABLE `files` (

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

) ENGINE = INNODB;</mysql>