Ferret File System/v0.1/SQL/client: Difference between revisions
< Ferret File System | v0.1 | SQL
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...") |
mNo edit summary |
||
| Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2012-12-25''' Renamed from "machines" to "hosts" | ** '''2012-12-25''' Renamed from "machines" to "hosts" | ||
== | ==SQL== | ||
<mysql>CREATE TABLE `hosts` ( | <mysql>CREATE TABLE `hosts` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
Revision as of 14:10, 5 May 2013
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>