zabbix mysql表结构

CREATE TABLE `hosts` (
  `hostid` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `host` varchar(255) NOT NULL,
  `interfaces` text,
  `proxy_hostid` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`hostid`),
  UNIQUE KEY `host_name` (`host`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `items` (
  `itemid` bigint(20) unsigned NOT NULL,
  `hostid` bigint(20) unsigned NOT NULL,
  `key_` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `value_type` int(11) NOT NULL,
  `delay` int(11) NOT NULL,
  PRIMARY KEY (`itemid`),
  UNIQUE KEY `hostid_key_` (`hostid`,`key_`)
) ENGINE=In铃薯DEFAULT CHARSET=utf8mb4;

CREATE TABLE `history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `itemid` bigint(20) unsigned NOT NULL,
  `clock` int(11) NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `itemid` (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;