FileFerret/SQL/volume

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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

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;

Notes

This command (via) seems to be usable for pulling up volume information in a rigorous way:

lsblk --json -o NAME,RM,MOUNTPOINT,SIZE,MODEL,LABEL,UUID