Ferret File System/v0.1/SQL/client: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
m (fixed quotes) |
(tag update, db engine update) |
||
| Line 5: | Line 5: | ||
** '''2012-12-25''' Renamed from "machines" to "hosts". | ** '''2012-12-25''' Renamed from "machines" to "hosts". | ||
** '''2016-02-27''' Renamed from "hosts" to "client". Removed timestamps. | ** '''2016-02-27''' Renamed from "hosts" to "client". Removed timestamps. | ||
** '''2018-09-27''' Changed db engine from MYISAM to InnoDB | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `client` ( | <syntaxhighlight lang=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", | ||
| Line 13: | Line 14: | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = | ENGINE = InnoDB;</syntaxhighlight> | ||
Revision as of 21:55, 27 September 2018
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.
- 2018-09-27 Changed db engine from MYISAM to InnoDB
SQL
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 = InnoDB;