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)
• 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.

SQL

<mysql>CREATE TABLE `vols` (

 `ID`        INT NOT NULL AUTO_INCREMENT,
 Label       VARCHAR(63),
 UUID        CHAR(36),
 Descr       VARCHAR(127),
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>