MariaDB [zabbix]> show create database zabbix\G
*************************** 1. row ***************************
       Database: zabbix
Create Database: CREATE DATABASE `zabbix` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */
1 row in set (0.000 sec)

MariaDB [zabbix]> show create table zabbix.items\G
*************************** 1. row ***************************
       Table: items
Create Table: CREATE TABLE `items` (
  `itemid` bigint(20) unsigned NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0,
  `snmp_oid` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `hostid` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `key_` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `delay` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `history` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '90d',
  `trends` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '365d',
  `status` int(11) NOT NULL DEFAULT 0,
  `value_type` int(11) NOT NULL DEFAULT 0,
  `trapper_hosts` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `units` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `formula` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `logtimefmt` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `templateid` bigint(20) unsigned DEFAULT NULL,
  `valuemapid` bigint(20) unsigned DEFAULT NULL,
  `params` text COLLATE utf8_bin NOT NULL,
  `ipmi_sensor` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `authtype` int(11) NOT NULL DEFAULT 0,
  `username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `password` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `publickey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `privatekey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `flags` int(11) NOT NULL DEFAULT 0,
  `interfaceid` bigint(20) unsigned DEFAULT NULL,
  `description` text COLLATE utf8_bin NOT NULL,
  `inventory_link` int(11) NOT NULL DEFAULT 0,
  `lifetime` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '30d',
  `evaltype` int(11) NOT NULL DEFAULT 0,
  `jmx_endpoint` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `master_itemid` bigint(20) unsigned DEFAULT NULL,
  `timeout` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '3s',
  `url` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `query_fields` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `posts` text COLLATE utf8_bin NOT NULL,
  `status_codes` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '200',
  `follow_redirects` int(11) NOT NULL DEFAULT 1,
  `post_type` int(11) NOT NULL DEFAULT 0,
  `http_proxy` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `headers` text COLLATE utf8_bin NOT 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 NOT NULL DEFAULT '''',
  `ssl_key_file` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `ssl_key_password` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '''',
  `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.000 sec)

MariaDB [zabbix]>