MariaDB [(none)]> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [zabbix]> 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_oid` varchar(512) COLLATE utf8_bin DEFAULT NULL,
  `hostid` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `key_` varchar(2048) 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,
  `formula` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `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 DEFAULT NULL,
  `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,
  `flags` int(11) NOT NULL DEFAULT 0,
  `interfaceid` bigint(20) unsigned DEFAULT NULL,
  `description` text COLLATE utf8_bin DEFAULT NULL,
  `inventory_link` int(11) NOT NULL DEFAULT 0,
  `lifetime` 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 DEFAULT NULL,
  `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 DEFAULT NULL,
  `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,
  `discover` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`itemid`),
  KEY `items_3` (`status`),
  KEY `items_4` (`templateid`),
  KEY `items_5` (`valuemapid`),
  KEY `items_6` (`interfaceid`),
  KEY `items_7` (`master_itemid`),
  KEY `items_1` (`hostid`,`key_`(1021)),
  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,002 sec)

MariaDB [zabbix]>