Ferret File System/v0.1/SQL/volume

About

• Purpose: record of all known volumes, fixed and removable

Fields

• Label: the volume's label, which may not be unique (but may help with identification)
• isInScan: if TRUE, a scan is in progress and entry.didFind flag may not be accurate

History

• 2013-04-21 created
• 2013-06-30 added UUID and Descr fields
  • Later, we will probably want to record things like capacity and free space... but later.
• 2016-02-27 Renamed from "vols" -> "volume"; added isInScan flag

SQL

<mysql>CREATE TABLE `volume` (

 `ID`          INT NOT NULL AUTO_INCREMENT,
 `Label`       VARCHAR(63),
 `UUID`        CHAR(36),
 `Descr`       VARCHAR(255),
 `isInScan`    BOOL,  
 PRIMARY KEY(`ID`),
 UNIQUE KEY(`UUID`)

) ENGINE = MYISAM;</mysql>