Ferret File System/v0.1/SQL/folder

From Woozle Writes Code
< Ferret File System‎ | v0.1‎ | SQL
Revision as of 22:42, 27 February 2016 by Woozle (talk | contribs) (Woozle moved page FileFerret/SQL/folders to FileFerret/SQL/folder without leaving a redirect: singularizing)
Jump to navigation Jump to search

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>