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 "clients". Removed timestamps.
• Future: "Name" should be a unique key.

SQL

<mysql>CREATE TABLE `hosts` (

 `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",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>