Ferret File System/v0.1/SQL/folder: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
No edit summary |
m (Woozle moved page FileFerret/SQL/folders to FileFerret/SQL/folder without leaving a redirect: singularizing) |
(No difference)
|
Revision as of 22:42, 27 February 2016
About
fields
- noScan is for blacklisting folders whose contents we really don't want to track, such as temp and trash areas which may become full of frequently-changing but useless clutter, or areas where things that aren't really files are kept (e.g. "/dev"), areas where drives are mounted ("/media", "/mnt"), etc.
history
- 2013-06-30 Added ID_Volume field as part of general schema redesign.
- 2016-02-27 Removed isRecur and Descr, added ID_Link. Moved many fields to dirent and replaced them with ID_Entry.
SQL
<mysql>CREATE TABLE `folders` (
`ID_Entry` INT NOT NULL, `noScan` BOOL DEFAULT FALSE COMMENT "TRUE = for whatever reason, don't bother scanning inside this folder", UNIQUE KEY(`ID_Entry`)
) ENGINE = INNODB;</mysql>