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

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page FileFerret/SQL/vols to FileFerret/SQL/volume without leaving a redirect: singularizing)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': record of all known volumes, fixed and removable
* '''Purpose''': record of all known volumes, fixed and removable
* '''Fields''':
===Fields===
** '''Label''': the volume's label, which may not be unique (but may help with identification)
* '''Label''': the volume's label, which may not be unique (but may help with identification)
* '''History''':
* '''isInScan''': if TRUE, a scan is in progress and {{l/same|entry}}.didFind flag may not be accurate
** '''2013-04-21''' created
===History===
** '''2013-06-30''' added '''[[wikipedia:Universally unique identifier|UUID]]''' and '''Descr''' fields
* '''2013-04-21''' created
*** Later, we will probably want to record things like capacity and free space... but later.
* '''2013-06-30''' added '''[[wikipedia:Universally unique identifier|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==
==SQL==
<mysql>CREATE TABLE `vols` (
<syntaxhighlight lang=mysql>CREATE TABLE `volume` (
   `ID`       INT NOT NULL AUTO_INCREMENT,
   `ID`         INT NOT NULL AUTO_INCREMENT,
   Label      VARCHAR(63),
   `Label`       VARCHAR(63),
   UUID        CHAR(36),
   `UUID`       CHAR(36),
   Descr      VARCHAR(127),
   `Descr`       VARCHAR(255),
   PRIMARY KEY(`ID`)
  `isInScan`    BOOL, 
   PRIMARY KEY(`ID`),
  UNIQUE KEY(`UUID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</syntaxhighlight>
==Notes==
This command ([https://toot.cat/@jamey/3634665 via]) seems to be usable for pulling up volume information in a rigorous way:
<syntaxhighlight lang=bash>lsblk --json -o NAME,RM,MOUNTPOINT,SIZE,MODEL,LABEL,UUID</syntaxhighlight>

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"