Ferret File System/v0.1/SQL/folder: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
No edit summary
 
(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|dirent}} and replaced them with '''ID_Entry'''.
* '''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 `folders` (
<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",
   UNIQUE KEY(`ID_Entry`)
   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>