Ferret File System/v0.1/SQL/client

About

• Purpose: Tracks network devices where storage devices/media can be hosted.
• History:
  • 2012-12-25 Renamed from "machines" to "hosts"

SQL

<mysql>CREATE TABLE `hosts` (

 `ID`        INT NOT NULL AUTO_INCREMENT,
 `NetName`   VARCHAR(63) NOT NULL COMMENT "network name of machine",
 `FirstConnected` DATETIME DEFAULT NULL COMMENT "when this host was first connected to the DB",
 `LastConnected`  DATETIME DEFAULT NULL COMMENT "when this host was last connected to the DB",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>