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/folder to Ferret File System/v0.1/SQL/folder: obsolete) |
||
(4 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
===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| | * '''2016-02-27''' | ||
** Removed '''isRecur''' and '''Descr''', added '''ID_Link'''. | |||
** Moved many fields to {{l/same|entry}} and replaced them with '''ID_Entry'''. | |||
** Renamed from "folders" to "folder". | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `folder` ( | ||
`ID_Entry` INT NOT NULL, | `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", | ||
PRIMARY KEY(`ID_Entry`) | |||
) | ) | ||
ENGINE = INNODB;</mysql> | ENGINE = INNODB;</mysql> |
Latest revision as of 13:40, 25 February 2024
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 entry and replaced them with ID_Entry.
- Renamed from "folders" to "folder".
SQL
<mysql>CREATE TABLE `folder` (
`ID_Entry` INT NOT NULL, `noScan` BOOL DEFAULT FALSE COMMENT "TRUE = for whatever reason, don't bother scanning inside this folder", PRIMARY KEY(`ID_Entry`)
) ENGINE = INNODB;</mysql>