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

From Woozle Writes Code
Jump to navigation Jump to search
No edit summary
 
(One intermediate revision by the same user not shown)
(No difference)

Latest revision as of 13:40, 25 February 2024

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
Retrieved from "https://wooz.dev/mw/index.php?title=Ferret_File_System/v0.1/SQL/volume&oldid=7082"