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

From Woozle Writes Code
Jump to navigation Jump to search
mNo edit summary
m (Woozle moved page FileFerret/SQL/hosts to FileFerret/SQL/clients without leaving a redirect: more accurate name)
(No difference)

Revision as of 15:19, 27 February 2016

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>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferret_File_System/v0.1/SQL/client&oldid=3572"