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

From Woozle Writes Code
Jump to navigation Jump to search
(tidying)
m (fixed quotes)
Line 7: Line 7:
==SQL==
==SQL==
<mysql>CREATE TABLE `client` (
<mysql>CREATE TABLE `client` (
   `ID`             INT NOT NULL AUTO_INCREMENT,
   `ID`                 INT NOT NULL AUTO_INCREMENT,
   `Name`  VARCHAR(63) NOT NULL COMMENT "short identifier; must be unique within FF DB",
   `Name`  VARCHAR(63)     NOT NULL COMMENT "short identifier; must be unique within FF DB",
   `Descr`  VARCHAR(255) DEFAULT NULL COMMENT "optional description of the machine",
   `Descr`  VARCHAR(255) DEFAULT NULL COMMENT "optional description of the machine",
   UNIQUE KEY('Name'),
   UNIQUE KEY(`Name`),
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</mysql>

Revision as of 23:38, 27 February 2016

About

  • Purpose: Tracks how each FF client identifies itself to the system. Defaults to machine's netname, but this is not required.
    • This is just so each instance of FF knows which machine it is running on, and therefore what volumes that machine can access (and how to do so).
  • History:
    • 2012-12-25 Renamed from "machines" to "hosts".
    • 2016-02-27 Renamed from "hosts" to "client". Removed timestamps.

SQL

<mysql>CREATE TABLE `client` ( 

 `ID`                  INT NOT NULL AUTO_INCREMENT,
 `Name`   VARCHAR(63)      NOT NULL COMMENT "short identifier; must be unique within FF DB",
 `Descr`  VARCHAR(255) DEFAULT NULL COMMENT "optional description of the machine",
 UNIQUE KEY(`Name`),
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>

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