Ferret File System/v0.1/SQL/file: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
m (Woozle moved page FileFerret/SQL/files to FileFerret/SQL/file without leaving a redirect: singularizing) |
(singularizing; dirent->entry) |
||
| Line 3: | Line 3: | ||
===fields=== | ===fields=== | ||
===history=== | ===history=== | ||
* '''2016-02-27''' Moved many fields to {{l/same| | * '''2016-02-27''' Moved many fields to {{l/same|entry}} and replaced them with '''ID_Entry'''. | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `file` ( | ||
`ID_Entry` INT NOT NULL AUTO_INCREMENT, | `ID_Entry` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Firev` INT DEFAULT NULL COMMENT " | `ID_Firev` INT DEFAULT NULL COMMENT "Firev.ID for this file", | ||
PRIMARY KEY(`ID_Entry`) | |||
) | ) | ||
ENGINE = INNODB;</mysql> | ENGINE = INNODB;</mysql> | ||
Revision as of 22:42, 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 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>