FileFerret/SQL/hosts

About

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

SQL
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;