Ferret File System/v0.1/SQL/folder: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
(ID_Volume) |
No edit summary |
||
Line 1: | Line 1: | ||
==About== | ==About== | ||
===fields=== | ===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. | |||
* '''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") | |||
===history=== | ===history=== | ||
* '''2013-06-30''' Added '''ID_Volume''' field as part of general schema redesign. | * '''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 {{l/same|dirent}} and replaced them with '''ID_Entry'''. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `folders` ( | <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", | `noScan` BOOL DEFAULT FALSE COMMENT "TRUE = for whatever reason, don't bother scanning inside this folder", | ||
UNIQUE KEY(`ID_Entry`) | |||
) | ) | ||
ENGINE = | ENGINE = INNODB;</mysql> |
Revision as of 17:17, 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>