Ferret File System/v0.1/SQL/client: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(Created page with "==About== * '''Purpose''': Tracks network devices where storage devices/media can be hosted. * '''History''': ** '''2012-12-25''' Renamed from "machines" to "hosts" ===machine...")
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Tracks network devices where storage devices/media can be hosted.
* '''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''':
* '''History''':
** '''2012-12-25''' Renamed from "machines" to "hosts"
** '''2012-12-25''' Renamed from "machines" to "hosts".
===machines===
** '''2016-02-27''' Renamed from "hosts" to "client". Removed timestamps.
<mysql>CREATE TABLE `hosts` (
** '''2018-09-27''' Changed db engine from MYISAM to InnoDB
   `ID`       INT NOT NULL AUTO_INCREMENT,
==SQL==
   `NetName`  VARCHAR(63) NOT NULL COMMENT "network name of machine",
<syntaxhighlight lang=mysql>CREATE TABLE `client` (
   `FirstConnected` DATETIME DEFAULT NULL COMMENT "when this host was first connected to the DB",
   `ID`                 INT NOT NULL AUTO_INCREMENT,
   `LastConnected` DATETIME DEFAULT NULL COMMENT "when this host was last connected to the 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",
   UNIQUE KEY(`Name`),
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
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;
Retrieved from "https://wooz.dev/mw/index.php?title=Ferret_File_System/v0.1/SQL/client&oldid=7060"