Ferret File System/v0.1/SQL/client: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
m (Woozle moved page FileFerret/SQL/clients to FileFerret/SQL/client without leaving a redirect) |
(tidying) |
||
| Line 4: | Line 4: | ||
* '''History''': | * '''History''': | ||
** '''2012-12-25''' Renamed from "machines" to "hosts". | ** '''2012-12-25''' Renamed from "machines" to "hosts". | ||
** '''2016-02-27''' Renamed from "hosts" to " | ** '''2016-02-27''' Renamed from "hosts" to "client". Removed timestamps. | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <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'), | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
Revision as of 22:52, 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>