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

Revision as of 22:46, 27 February 2016

Label: the volume's label, which may not be unique (but may help with identification)

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".

<mysql>CREATE TABLE `volume` (

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

) ENGINE = MYISAM;</mysql>

@@ Line 1: / Line 1: @@
 ==About==
 * '''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''':
+===History===
-** '''2013-04-21''' created
+* '''2013-04-21''' created
-** '''2013-06-30''' added '''[[wikipedia:Universally unique identifier|UUID]]''' and '''Descr''' fields
+* '''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.
+** Later, we will probably want to record things like capacity and free space... but later.
+* '''2016-02-27''' Renamed from "vols" -> "volume".
 ==SQL==
-<mysql>CREATE TABLE `vols` (
+<mysql>CREATE TABLE `volume` (
    `ID`        INT NOT NULL AUTO_INCREMENT,
    Label       VARCHAR(63),