Ferret File System/v0.1/SQL/client

From Woozle Writes Code
Jump to navigation Jump to search

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;