Ferret File System/v0.1/SQL/client: Difference between revisions
< Ferret File System | v0.1 | SQL
Jump to navigation
Jump to search
(tidying) |
m (Woozle moved page FileFerret/SQL/client to Ferret File System/v0.1/SQL/client: obsolete) |
||
| (3 intermediate revisions by the same user not shown) | |||
| 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` | `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( | UNIQUE KEY(`Name`), | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = | ENGINE = InnoDB;</syntaxhighlight> | ||
Latest revision as of 13:40, 25 February 2024
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;