· 9 years ago · Oct 24, 2016, 12:56 PM
1CREATE TABLE IF NOT EXISTS `networkhardware` (
2 `ID` int(11) NOT NULL AUTO_INCREMENT,
3 `PARENTID` int(11) DEFAULT NULL,
4 `NAME` varchar(255) DEFAULT NULL,
5 `OSNAME` varchar(255) DEFAULT NULL,
6 `OSVERSION` varchar(255) DEFAULT NULL,
7 `OSCOMMENTS` varchar(255) DEFAULT NULL,
8 `PROCESSORT` varchar(255) DEFAULT NULL,
9 `PROCESSORS` int(11) DEFAULT '0',
10 `PROCESSORN` smallint(6) DEFAULT NULL,
11 `MEMORY` int(11) DEFAULT NULL,
12 `MGMTIPADDR` varchar(255) DEFAULT NULL,
13 `ETIME` datetime DEFAULT NULL,
14 `LASTDATE` datetime DEFAULT NULL,
15 `LASTCOME` datetime DEFAULT NULL,
16 `TYPE` int(11) DEFAULT NULL,
17 `DESCRIPTION` varchar(255) DEFAULT NULL,
18 `CHECKSUM` bigint(20) unsigned DEFAULT '262143',
19 `UUID` varchar(255) DEFAULT NULL,
20 `REMOTENAME` varchar(255) DEFAULT NULL,
21 PRIMARY KEY (`ID`),
22 KEY `NAME` (`NAME`),
23 KEY `CHECKSUM` (`CHECKSUM`),
24 KEY `OSNAME` (`OSNAME`),
25 KEY `MEMORY` (`MEMORY`),
26 KEY `ID` (`ID`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;