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

From Woozle Writes Code
Jump to navigation Jump to search
(Created page with "==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 iden...")
 
(UUID, Descr)
Line 5: Line 5:
* '''History''':
* '''History''':
** '''2013-04-21''' created
** '''2013-04-21''' created
** '''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.
==SQL==
==SQL==
<mysql>CREATE TABLE `vols` (
<mysql>CREATE TABLE `vols` (
   `ID`        INT NOT NULL AUTO_INCREMENT,
   `ID`        INT NOT NULL AUTO_INCREMENT,
   Label      VARCHAR(63),
   Label      VARCHAR(63),
  UUID        CHAR(36),
  Descr      VARCHAR(127),
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</mysql>

Revision as of 21:05, 30 June 2013

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>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferret_File_System/v0.1/SQL/volume&oldid=3640"