Ferret File System/v0.1/SQL/client

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;