mysql> show create table items; +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | items | CREATE TABLE `items` ( `itemid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `snmp_community` varchar(64) COLLATE utf8_bin DEFAULT NULL, `snmp_oid` varchar(512) COLLATE utf8_bin DEFAULT NULL, `hostid` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `key_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `delay` varchar(1024) COLLATE utf8_bin DEFAULT NULL, `history` varchar(255) COLLATE utf8_bin DEFAULT NULL, `trends` varchar(255) COLLATE utf8_bin DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0', `value_type` int(11) NOT NULL DEFAULT '0', `trapper_hosts` varchar(255) COLLATE utf8_bin DEFAULT NULL, `units` varchar(255) COLLATE utf8_bin DEFAULT NULL, `snmpv3_securityname` varchar(64) COLLATE utf8_bin DEFAULT NULL, `snmpv3_securitylevel` int(11) NOT NULL DEFAULT '0', `snmpv3_authpassphrase` varchar(64) COLLATE utf8_bin DEFAULT NULL, `snmpv3_privpassphrase` varchar(64) COLLATE utf8_bin DEFAULT NULL, `formula` varchar(255) COLLATE utf8_bin DEFAULT NULL, `error` varchar(2048) COLLATE utf8_bin DEFAULT NULL, `lastlogsize` bigint(20) unsigned NOT NULL DEFAULT '0', `logtimefmt` varchar(64) COLLATE utf8_bin DEFAULT NULL, `templateid` bigint(20) unsigned DEFAULT NULL, `valuemapid` bigint(20) unsigned DEFAULT NULL, `params` text COLLATE utf8_bin, `ipmi_sensor` varchar(128) COLLATE utf8_bin DEFAULT NULL, `authtype` int(11) NOT NULL DEFAULT '0', `username` varchar(64) COLLATE utf8_bin DEFAULT NULL, `password` varchar(64) COLLATE utf8_bin DEFAULT NULL, `publickey` varchar(64) COLLATE utf8_bin DEFAULT NULL, `privatekey` varchar(64) COLLATE utf8_bin DEFAULT NULL, `mtime` int(11) NOT NULL DEFAULT '0', `flags` int(11) NOT NULL DEFAULT '0', `interfaceid` bigint(20) unsigned DEFAULT NULL, `port` varchar(64) COLLATE utf8_bin DEFAULT NULL, `description` text COLLATE utf8_bin, `inventory_link` int(11) NOT NULL DEFAULT '0', `lifetime` varchar(255) COLLATE utf8_bin DEFAULT NULL, `snmpv3_authprotocol` int(11) NOT NULL DEFAULT '0', `snmpv3_privprotocol` int(11) NOT NULL DEFAULT '0', `state` int(11) NOT NULL DEFAULT '0', `snmpv3_contextname` varchar(255) COLLATE utf8_bin DEFAULT NULL, `evaltype` int(11) NOT NULL DEFAULT '0', `jmx_endpoint` varchar(255) COLLATE utf8_bin DEFAULT NULL, `master_itemid` bigint(20) unsigned DEFAULT NULL, `timeout` varchar(255) COLLATE utf8_bin DEFAULT NULL, `url` varchar(2048) COLLATE utf8_bin DEFAULT NULL, `query_fields` varchar(2048) COLLATE utf8_bin DEFAULT NULL, `posts` text COLLATE utf8_bin, `status_codes` varchar(255) COLLATE utf8_bin DEFAULT NULL, `follow_redirects` int(11) NOT NULL DEFAULT '1', `post_type` int(11) NOT NULL DEFAULT '0', `http_proxy` varchar(255) COLLATE utf8_bin DEFAULT NULL, `headers` text COLLATE utf8_bin, `retrieve_mode` int(11) NOT NULL DEFAULT '0', `request_method` int(11) NOT NULL DEFAULT '0', `output_format` int(11) NOT NULL DEFAULT '0', `ssl_cert_file` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ssl_key_file` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ssl_key_password` varchar(64) COLLATE utf8_bin DEFAULT NULL, `verify_peer` int(11) NOT NULL DEFAULT '0', `verify_host` int(11) NOT NULL DEFAULT '0', `allow_traps` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`itemid`), UNIQUE KEY `items_1` (`hostid`,`key_`), KEY `items_3` (`status`), KEY `items_4` (`templateid`), KEY `items_5` (`valuemapid`), KEY `items_6` (`interfaceid`), KEY `items_7` (`master_itemid`), CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE, CONSTRAINT `c_items_3` FOREIGN KEY (`valuemapid`) REFERENCES `valuemaps` (`valuemapid`), CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`), CONSTRAINT `c_items_5` FOREIGN KEY (`master_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)