-- MySQL dump 10.13 Distrib 5.6.17-66.0, for Linux (x86_64) -- -- Host: localhost Database: zabbix -- ------------------------------------------------------ -- Server version 5.6.17-66.0-log -- -- Zabbix数据库初始化脚本,采用 TokuDB 引擎 -- Zabbix版本:Zabbix 2.2.0 -- TokuDB版本:Percona-5.6.17, TokuDB-7.1.6(插件加载模式) -- -- created by yejr(http://imysql.com), 2014/06/24 -- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `acknowledges` -- DROP TABLE IF EXISTS `acknowledges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acknowledges` ( `acknowledgeid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `eventid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `message` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`acknowledgeid`), KEY `acknowledges_1` (`userid`), KEY `acknowledges_2` (`eventid`), KEY `acknowledges_3` (`clock`), CONSTRAINT `c_acknowledges_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE, CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `actions` -- DROP TABLE IF EXISTS `actions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actions` ( `actionid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `eventsource` int(11) NOT NULL DEFAULT '0', `evaltype` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `esc_period` int(11) NOT NULL DEFAULT '0', `def_shortdata` varchar(255) NOT NULL DEFAULT '', `def_longdata` text NOT NULL, `recovery_msg` int(11) NOT NULL DEFAULT '0', `r_shortdata` varchar(255) NOT NULL DEFAULT '', `r_longdata` text NOT NULL, PRIMARY KEY (`actionid`), KEY `actions_1` (`eventsource`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `alerts` -- DROP TABLE IF EXISTS `alerts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `alerts` ( `alertid` bigint(20) unsigned NOT NULL, `actionid` bigint(20) unsigned NOT NULL, `eventid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned DEFAULT NULL, `clock` int(11) NOT NULL DEFAULT '0', `mediatypeid` bigint(20) unsigned DEFAULT NULL, `sendto` varchar(100) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `message` text NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `retries` int(11) NOT NULL DEFAULT '0', `error` varchar(128) NOT NULL DEFAULT '', `esc_step` int(11) NOT NULL DEFAULT '0', `alerttype` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`alertid`), KEY `alerts_1` (`actionid`), KEY `alerts_2` (`clock`), KEY `alerts_3` (`eventid`), KEY `alerts_4` (`status`,`retries`), KEY `alerts_5` (`mediatypeid`), KEY `alerts_6` (`userid`), CONSTRAINT `c_alerts_1` FOREIGN KEY (`actionid`) REFERENCES `actions` (`actionid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_3` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE, CONSTRAINT `c_alerts_4` FOREIGN KEY (`mediatypeid`) REFERENCES `media_type` (`mediatypeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `application_template` -- DROP TABLE IF EXISTS `application_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `application_template` ( `application_templateid` bigint(20) unsigned NOT NULL, `applicationid` bigint(20) unsigned NOT NULL, `templateid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`application_templateid`), UNIQUE KEY `application_template_1` (`applicationid`,`templateid`), KEY `application_template_2` (`templateid`), CONSTRAINT `c_application_template_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE, CONSTRAINT `c_application_template_2` FOREIGN KEY (`templateid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `applications` -- DROP TABLE IF EXISTS `applications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `applications` ( `applicationid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`applicationid`), UNIQUE KEY `applications_2` (`hostid`,`name`), CONSTRAINT `c_applications_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `auditlog` -- DROP TABLE IF EXISTS `auditlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auditlog` ( `auditid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `action` int(11) NOT NULL DEFAULT '0', `resourcetype` int(11) NOT NULL DEFAULT '0', `details` varchar(128) NOT NULL DEFAULT '0', `ip` varchar(39) NOT NULL DEFAULT '', `resourceid` bigint(20) unsigned NOT NULL DEFAULT '0', `resourcename` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`auditid`), KEY `auditlog_1` (`userid`,`clock`), KEY `auditlog_2` (`clock`), CONSTRAINT `c_auditlog_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `auditlog_details` -- DROP TABLE IF EXISTS `auditlog_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auditlog_details` ( `auditdetailid` bigint(20) unsigned NOT NULL, `auditid` bigint(20) unsigned NOT NULL, `table_name` varchar(64) NOT NULL DEFAULT '', `field_name` varchar(64) NOT NULL DEFAULT '', `oldvalue` text NOT NULL, `newvalue` text NOT NULL, PRIMARY KEY (`auditdetailid`), KEY `auditlog_details_1` (`auditid`), CONSTRAINT `c_auditlog_details_1` FOREIGN KEY (`auditid`) REFERENCES `auditlog` (`auditid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `autoreg_host` -- DROP TABLE IF EXISTS `autoreg_host`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `autoreg_host` ( `autoreg_hostid` bigint(20) unsigned NOT NULL, `proxy_hostid` bigint(20) unsigned DEFAULT NULL, `host` varchar(64) NOT NULL DEFAULT '', `listen_ip` varchar(39) NOT NULL DEFAULT '', `listen_port` int(11) NOT NULL DEFAULT '0', `listen_dns` varchar(64) NOT NULL DEFAULT '', `host_metadata` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`autoreg_hostid`), KEY `autoreg_host_1` (`proxy_hostid`,`host`), CONSTRAINT `c_autoreg_host_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `conditions` -- DROP TABLE IF EXISTS `conditions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conditions` ( `conditionid` bigint(20) unsigned NOT NULL, `actionid` bigint(20) unsigned NOT NULL, `conditiontype` int(11) NOT NULL DEFAULT '0', `operator` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`conditionid`), KEY `conditions_1` (`actionid`), CONSTRAINT `c_conditions_1` FOREIGN KEY (`actionid`) REFERENCES `actions` (`actionid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `configid` bigint(20) unsigned NOT NULL, `refresh_unsupported` int(11) NOT NULL DEFAULT '0', `work_period` varchar(100) NOT NULL DEFAULT '1-5,00:00-24:00', `alert_usrgrpid` bigint(20) unsigned DEFAULT NULL, `event_ack_enable` int(11) NOT NULL DEFAULT '1', `event_expire` int(11) NOT NULL DEFAULT '7', `event_show_max` int(11) NOT NULL DEFAULT '100', `default_theme` varchar(128) NOT NULL DEFAULT 'originalblue', `authentication_type` int(11) NOT NULL DEFAULT '0', `ldap_host` varchar(255) NOT NULL DEFAULT '', `ldap_port` int(11) NOT NULL DEFAULT '389', `ldap_base_dn` varchar(255) NOT NULL DEFAULT '', `ldap_bind_dn` varchar(255) NOT NULL DEFAULT '', `ldap_bind_password` varchar(128) NOT NULL DEFAULT '', `ldap_search_attribute` varchar(128) NOT NULL DEFAULT '', `dropdown_first_entry` int(11) NOT NULL DEFAULT '1', `dropdown_first_remember` int(11) NOT NULL DEFAULT '1', `discovery_groupid` bigint(20) unsigned NOT NULL, `max_in_table` int(11) NOT NULL DEFAULT '50', `search_limit` int(11) NOT NULL DEFAULT '1000', `severity_color_0` varchar(6) NOT NULL DEFAULT 'DBDBDB', `severity_color_1` varchar(6) NOT NULL DEFAULT 'D6F6FF', `severity_color_2` varchar(6) NOT NULL DEFAULT 'FFF6A5', `severity_color_3` varchar(6) NOT NULL DEFAULT 'FFB689', `severity_color_4` varchar(6) NOT NULL DEFAULT 'FF9999', `severity_color_5` varchar(6) NOT NULL DEFAULT 'FF3838', `severity_name_0` varchar(32) NOT NULL DEFAULT 'Not classified', `severity_name_1` varchar(32) NOT NULL DEFAULT 'Information', `severity_name_2` varchar(32) NOT NULL DEFAULT 'Warning', `severity_name_3` varchar(32) NOT NULL DEFAULT 'Average', `severity_name_4` varchar(32) NOT NULL DEFAULT 'High', `severity_name_5` varchar(32) NOT NULL DEFAULT 'Disaster', `ok_period` int(11) NOT NULL DEFAULT '1800', `blink_period` int(11) NOT NULL DEFAULT '1800', `problem_unack_color` varchar(6) NOT NULL DEFAULT 'DC0000', `problem_ack_color` varchar(6) NOT NULL DEFAULT 'DC0000', `ok_unack_color` varchar(6) NOT NULL DEFAULT '00AA00', `ok_ack_color` varchar(6) NOT NULL DEFAULT '00AA00', `problem_unack_style` int(11) NOT NULL DEFAULT '1', `problem_ack_style` int(11) NOT NULL DEFAULT '1', `ok_unack_style` int(11) NOT NULL DEFAULT '1', `ok_ack_style` int(11) NOT NULL DEFAULT '1', `snmptrap_logging` int(11) NOT NULL DEFAULT '1', `server_check_interval` int(11) NOT NULL DEFAULT '10', `hk_events_mode` int(11) NOT NULL DEFAULT '1', `hk_events_trigger` int(11) NOT NULL DEFAULT '365', `hk_events_internal` int(11) NOT NULL DEFAULT '365', `hk_events_discovery` int(11) NOT NULL DEFAULT '365', `hk_events_autoreg` int(11) NOT NULL DEFAULT '365', `hk_services_mode` int(11) NOT NULL DEFAULT '1', `hk_services` int(11) NOT NULL DEFAULT '365', `hk_audit_mode` int(11) NOT NULL DEFAULT '1', `hk_audit` int(11) NOT NULL DEFAULT '365', `hk_sessions_mode` int(11) NOT NULL DEFAULT '1', `hk_sessions` int(11) NOT NULL DEFAULT '365', `hk_history_mode` int(11) NOT NULL DEFAULT '1', `hk_history_global` int(11) NOT NULL DEFAULT '0', `hk_history` int(11) NOT NULL DEFAULT '90', `hk_trends_mode` int(11) NOT NULL DEFAULT '1', `hk_trends_global` int(11) NOT NULL DEFAULT '0', `hk_trends` int(11) NOT NULL DEFAULT '365', PRIMARY KEY (`configid`), KEY `config_1` (`alert_usrgrpid`), KEY `config_2` (`discovery_groupid`), CONSTRAINT `c_config_1` FOREIGN KEY (`alert_usrgrpid`) REFERENCES `usrgrp` (`usrgrpid`), CONSTRAINT `c_config_2` FOREIGN KEY (`discovery_groupid`) REFERENCES `groups` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dbversion` -- DROP TABLE IF EXISTS `dbversion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dbversion` ( `mandatory` int(11) NOT NULL DEFAULT '0', `optional` int(11) NOT NULL DEFAULT '0' ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dchecks` -- DROP TABLE IF EXISTS `dchecks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dchecks` ( `dcheckid` bigint(20) unsigned NOT NULL, `druleid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '', `snmp_community` varchar(255) NOT NULL DEFAULT '', `ports` varchar(255) NOT NULL DEFAULT '0', `snmpv3_securityname` varchar(64) NOT NULL DEFAULT '', `snmpv3_securitylevel` int(11) NOT NULL DEFAULT '0', `snmpv3_authpassphrase` varchar(64) NOT NULL DEFAULT '', `snmpv3_privpassphrase` varchar(64) NOT NULL DEFAULT '', `uniq` int(11) NOT NULL DEFAULT '0', `snmpv3_authprotocol` int(11) NOT NULL DEFAULT '0', `snmpv3_privprotocol` int(11) NOT NULL DEFAULT '0', `snmpv3_contextname` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`dcheckid`), KEY `dchecks_1` (`druleid`), CONSTRAINT `c_dchecks_1` FOREIGN KEY (`druleid`) REFERENCES `drules` (`druleid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dhosts` -- DROP TABLE IF EXISTS `dhosts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dhosts` ( `dhostid` bigint(20) unsigned NOT NULL, `druleid` bigint(20) unsigned NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `lastup` int(11) NOT NULL DEFAULT '0', `lastdown` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`dhostid`), KEY `dhosts_1` (`druleid`), CONSTRAINT `c_dhosts_1` FOREIGN KEY (`druleid`) REFERENCES `drules` (`druleid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `drules` -- DROP TABLE IF EXISTS `drules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `drules` ( `druleid` bigint(20) unsigned NOT NULL, `proxy_hostid` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL DEFAULT '', `iprange` varchar(255) NOT NULL DEFAULT '', `delay` int(11) NOT NULL DEFAULT '3600', `nextcheck` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`druleid`), KEY `drules_1` (`proxy_hostid`), CONSTRAINT `c_drules_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dservices` -- DROP TABLE IF EXISTS `dservices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dservices` ( `dserviceid` bigint(20) unsigned NOT NULL, `dhostid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', `port` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `lastup` int(11) NOT NULL DEFAULT '0', `lastdown` int(11) NOT NULL DEFAULT '0', `dcheckid` bigint(20) unsigned NOT NULL, `ip` varchar(39) NOT NULL DEFAULT '', `dns` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`dserviceid`), UNIQUE KEY `dservices_1` (`dcheckid`,`type`,`key_`,`ip`,`port`), KEY `dservices_2` (`dhostid`), CONSTRAINT `c_dservices_1` FOREIGN KEY (`dhostid`) REFERENCES `dhosts` (`dhostid`) ON DELETE CASCADE, CONSTRAINT `c_dservices_2` FOREIGN KEY (`dcheckid`) REFERENCES `dchecks` (`dcheckid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `escalations` -- DROP TABLE IF EXISTS `escalations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `escalations` ( `escalationid` bigint(20) unsigned NOT NULL, `actionid` bigint(20) unsigned NOT NULL, `triggerid` bigint(20) unsigned DEFAULT NULL, `eventid` bigint(20) unsigned DEFAULT NULL, `r_eventid` bigint(20) unsigned DEFAULT NULL, `nextcheck` int(11) NOT NULL DEFAULT '0', `esc_step` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`escalationid`), UNIQUE KEY `escalations_1` (`actionid`,`triggerid`,`itemid`,`escalationid`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events` ( `eventid` bigint(20) unsigned NOT NULL, `source` int(11) NOT NULL DEFAULT '0', `object` int(11) NOT NULL DEFAULT '0', `objectid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` int(11) NOT NULL DEFAULT '0', `acknowledged` int(11) NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`eventid`), KEY `events_1` (`source`,`object`,`objectid`,`clock`), KEY `events_2` (`source`,`object`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `expressions` -- DROP TABLE IF EXISTS `expressions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expressions` ( `expressionid` bigint(20) unsigned NOT NULL, `regexpid` bigint(20) unsigned NOT NULL, `expression` varchar(255) NOT NULL DEFAULT '', `expression_type` int(11) NOT NULL DEFAULT '0', `exp_delimiter` varchar(1) NOT NULL DEFAULT '', `case_sensitive` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`expressionid`), KEY `expressions_1` (`regexpid`), CONSTRAINT `c_expressions_1` FOREIGN KEY (`regexpid`) REFERENCES `regexps` (`regexpid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `functions` -- DROP TABLE IF EXISTS `functions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `functions` ( `functionid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `triggerid` bigint(20) unsigned NOT NULL, `function` varchar(12) NOT NULL DEFAULT '', `parameter` varchar(255) NOT NULL DEFAULT '0', PRIMARY KEY (`functionid`), KEY `functions_1` (`triggerid`), KEY `functions_2` (`itemid`,`function`,`parameter`), CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE, CONSTRAINT `c_functions_2` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `globalmacro` -- DROP TABLE IF EXISTS `globalmacro`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `globalmacro` ( `globalmacroid` bigint(20) unsigned NOT NULL, `macro` varchar(64) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`globalmacroid`), KEY `globalmacro_1` (`macro`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `globalvars` -- DROP TABLE IF EXISTS `globalvars`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `globalvars` ( `globalvarid` bigint(20) unsigned NOT NULL, `snmp_lastsize` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`globalvarid`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graph_discovery` -- DROP TABLE IF EXISTS `graph_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graph_discovery` ( `graphdiscoveryid` bigint(20) unsigned NOT NULL, `graphid` bigint(20) unsigned NOT NULL, `parent_graphid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', PRIMARY KEY (`graphdiscoveryid`), UNIQUE KEY `graph_discovery_1` (`graphid`,`parent_graphid`), KEY `graph_discovery_2` (`parent_graphid`), CONSTRAINT `c_graph_discovery_1` FOREIGN KEY (`graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE, CONSTRAINT `c_graph_discovery_2` FOREIGN KEY (`parent_graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graph_theme` -- DROP TABLE IF EXISTS `graph_theme`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graph_theme` ( `graphthemeid` bigint(20) unsigned NOT NULL, `description` varchar(64) NOT NULL DEFAULT '', `theme` varchar(64) NOT NULL DEFAULT '', `backgroundcolor` varchar(6) NOT NULL DEFAULT 'F0F0F0', `graphcolor` varchar(6) NOT NULL DEFAULT 'FFFFFF', `graphbordercolor` varchar(6) NOT NULL DEFAULT '222222', `gridcolor` varchar(6) NOT NULL DEFAULT 'CCCCCC', `maingridcolor` varchar(6) NOT NULL DEFAULT 'AAAAAA', `gridbordercolor` varchar(6) NOT NULL DEFAULT '000000', `textcolor` varchar(6) NOT NULL DEFAULT '202020', `highlightcolor` varchar(6) NOT NULL DEFAULT 'AA4444', `leftpercentilecolor` varchar(6) NOT NULL DEFAULT '11CC11', `rightpercentilecolor` varchar(6) NOT NULL DEFAULT 'CC1111', `nonworktimecolor` varchar(6) NOT NULL DEFAULT 'CCCCCC', `gridview` int(11) NOT NULL DEFAULT '1', `legendview` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`graphthemeid`), KEY `graph_theme_1` (`description`), KEY `graph_theme_2` (`theme`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graphs` -- DROP TABLE IF EXISTS `graphs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graphs` ( `graphid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', `width` int(11) NOT NULL DEFAULT '900', `height` int(11) NOT NULL DEFAULT '200', `yaxismin` double(16,4) NOT NULL DEFAULT '0.0000', `yaxismax` double(16,4) NOT NULL DEFAULT '100.0000', `templateid` bigint(20) unsigned DEFAULT NULL, `show_work_period` int(11) NOT NULL DEFAULT '1', `show_triggers` int(11) NOT NULL DEFAULT '1', `graphtype` int(11) NOT NULL DEFAULT '0', `show_legend` int(11) NOT NULL DEFAULT '1', `show_3d` int(11) NOT NULL DEFAULT '0', `percent_left` double(16,4) NOT NULL DEFAULT '0.0000', `percent_right` double(16,4) NOT NULL DEFAULT '0.0000', `ymin_type` int(11) NOT NULL DEFAULT '0', `ymax_type` int(11) NOT NULL DEFAULT '0', `ymin_itemid` bigint(20) unsigned DEFAULT NULL, `ymax_itemid` bigint(20) unsigned DEFAULT NULL, `flags` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`graphid`), KEY `graphs_1` (`name`), KEY `graphs_2` (`templateid`), KEY `graphs_3` (`ymin_itemid`), KEY `graphs_4` (`ymax_itemid`), CONSTRAINT `c_graphs_1` FOREIGN KEY (`templateid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE, CONSTRAINT `c_graphs_2` FOREIGN KEY (`ymin_itemid`) REFERENCES `items` (`itemid`), CONSTRAINT `c_graphs_3` FOREIGN KEY (`ymax_itemid`) REFERENCES `items` (`itemid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `graphs_items` -- DROP TABLE IF EXISTS `graphs_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `graphs_items` ( `gitemid` bigint(20) unsigned NOT NULL, `graphid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `drawtype` int(11) NOT NULL DEFAULT '0', `sortorder` int(11) NOT NULL DEFAULT '0', `color` varchar(6) NOT NULL DEFAULT '009600', `yaxisside` int(11) NOT NULL DEFAULT '0', `calc_fnc` int(11) NOT NULL DEFAULT '2', `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`gitemid`), KEY `graphs_items_1` (`itemid`), KEY `graphs_items_2` (`graphid`), CONSTRAINT `c_graphs_items_1` FOREIGN KEY (`graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE, CONSTRAINT `c_graphs_items_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `group_discovery` -- DROP TABLE IF EXISTS `group_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `group_discovery` ( `groupid` bigint(20) unsigned NOT NULL, `parent_group_prototypeid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `lastcheck` int(11) NOT NULL DEFAULT '0', `ts_delete` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`groupid`), KEY `c_group_discovery_2` (`parent_group_prototypeid`), CONSTRAINT `c_group_discovery_1` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ON DELETE CASCADE, CONSTRAINT `c_group_discovery_2` FOREIGN KEY (`parent_group_prototypeid`) REFERENCES `group_prototype` (`group_prototypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `group_prototype` -- DROP TABLE IF EXISTS `group_prototype`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `group_prototype` ( `group_prototypeid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `groupid` bigint(20) unsigned DEFAULT NULL, `templateid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`group_prototypeid`), KEY `group_prototype_1` (`hostid`), KEY `c_group_prototype_2` (`groupid`), KEY `c_group_prototype_3` (`templateid`), CONSTRAINT `c_group_prototype_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_group_prototype_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`), CONSTRAINT `c_group_prototype_3` FOREIGN KEY (`templateid`) REFERENCES `group_prototype` (`group_prototypeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `groups` -- DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `groups` ( `groupid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `internal` int(11) NOT NULL DEFAULT '0', `flags` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`groupid`), KEY `groups_1` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history` -- DROP TABLE IF EXISTS `history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_1` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ /*!50100 PARTITION BY RANGE (clock) (PARTITION p201310 VALUES LESS THAN (1380556800) ENGINE = TokuDB, PARTITION p201311 VALUES LESS THAN (1383235200) ENGINE = TokuDB, PARTITION p201312 VALUES LESS THAN (1385827200) ENGINE = TokuDB, PARTITION p201401 VALUES LESS THAN (1388505600) ENGINE = TokuDB, PARTITION p201402 VALUES LESS THAN (1391184000) ENGINE = TokuDB, PARTITION p201403 VALUES LESS THAN (1393603200) ENGINE = TokuDB, PARTITION p201404 VALUES LESS THAN (1396281600) ENGINE = TokuDB, PARTITION p201405 VALUES LESS THAN (1398873600) ENGINE = TokuDB, PARTITION p201406 VALUES LESS THAN (1401552000) ENGINE = TokuDB, PARTITION p201407 VALUES LESS THAN (1404144000) ENGINE = TokuDB, PARTITION p201408 VALUES LESS THAN (1406822400) ENGINE = TokuDB, PARTITION p201409 VALUES LESS THAN (1409500800) ENGINE = TokuDB, PARTITION p201410 VALUES LESS THAN (1412092800) ENGINE = TokuDB, PARTITION p201411 VALUES LESS THAN (1414771200) ENGINE = TokuDB, PARTITION p201412 VALUES LESS THAN (1417363200) ENGINE = TokuDB) */; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_log` -- DROP TABLE IF EXISTS `history_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_log` ( `id` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `timestamp` int(11) NOT NULL DEFAULT '0', `source` varchar(64) NOT NULL DEFAULT '', `severity` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, `logeventid` int(11) NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `history_log_2` (`itemid`,`id`), KEY `history_log_1` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_str` -- DROP TABLE IF EXISTS `history_str`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_str` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_str_1` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ /*!50100 PARTITION BY RANGE (clock) (PARTITION p201310 VALUES LESS THAN (1380556800) ENGINE = TokuDB, PARTITION p201311 VALUES LESS THAN (1383235200) ENGINE = TokuDB, PARTITION p201312 VALUES LESS THAN (1385827200) ENGINE = TokuDB, PARTITION p201401 VALUES LESS THAN (1388505600) ENGINE = TokuDB, PARTITION p201402 VALUES LESS THAN (1391184000) ENGINE = TokuDB, PARTITION p201403 VALUES LESS THAN (1393603200) ENGINE = TokuDB, PARTITION p201404 VALUES LESS THAN (1396281600) ENGINE = TokuDB, PARTITION p201405 VALUES LESS THAN (1398873600) ENGINE = TokuDB, PARTITION p201406 VALUES LESS THAN (1401552000) ENGINE = TokuDB, PARTITION p201407 VALUES LESS THAN (1404144000) ENGINE = TokuDB, PARTITION p201408 VALUES LESS THAN (1406822400) ENGINE = TokuDB, PARTITION p201409 VALUES LESS THAN (1409500800) ENGINE = TokuDB, PARTITION p201410 VALUES LESS THAN (1412092800) ENGINE = TokuDB, PARTITION p201411 VALUES LESS THAN (1414771200) ENGINE = TokuDB, PARTITION p201412 VALUES LESS THAN (1417363200) ENGINE = TokuDB) */; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_str_sync` -- DROP TABLE IF EXISTS `history_str_sync`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_str_sync` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nodeid` int(11) NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `history_str_sync_1` (`nodeid`,`id`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_sync` -- DROP TABLE IF EXISTS `history_sync`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_sync` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nodeid` int(11) NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `history_sync_1` (`nodeid`,`id`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_text` -- DROP TABLE IF EXISTS `history_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_text` ( `id` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `history_text_2` (`itemid`,`id`), KEY `history_text_1` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_uint` -- DROP TABLE IF EXISTS `history_uint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_uint` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', KEY `history_uint_1` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ /*!50100 PARTITION BY RANGE (clock) (PARTITION p201310 VALUES LESS THAN (1380556800) ENGINE = TokuDB, PARTITION p201311 VALUES LESS THAN (1383235200) ENGINE = TokuDB, PARTITION p201312 VALUES LESS THAN (1385827200) ENGINE = TokuDB, PARTITION p201401 VALUES LESS THAN (1388505600) ENGINE = TokuDB, PARTITION p201402 VALUES LESS THAN (1391184000) ENGINE = TokuDB, PARTITION p201403 VALUES LESS THAN (1393603200) ENGINE = TokuDB, PARTITION p201404 VALUES LESS THAN (1396281600) ENGINE = TokuDB, PARTITION p201405 VALUES LESS THAN (1398873600) ENGINE = TokuDB, PARTITION p201406 VALUES LESS THAN (1401552000) ENGINE = TokuDB, PARTITION p201407 VALUES LESS THAN (1404144000) ENGINE = TokuDB, PARTITION p201408 VALUES LESS THAN (1406822400) ENGINE = TokuDB, PARTITION p201409 VALUES LESS THAN (1409500800) ENGINE = TokuDB, PARTITION p201410 VALUES LESS THAN (1412092800) ENGINE = TokuDB, PARTITION p201411 VALUES LESS THAN (1414771200) ENGINE = TokuDB, PARTITION p201412 VALUES LESS THAN (1417363200) ENGINE = TokuDB) */; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `history_uint_sync` -- DROP TABLE IF EXISTS `history_uint_sync`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_uint_sync` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nodeid` int(11) NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `history_uint_sync_1` (`nodeid`,`id`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `host_discovery` -- DROP TABLE IF EXISTS `host_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `host_discovery` ( `hostid` bigint(20) unsigned NOT NULL, `parent_hostid` bigint(20) unsigned DEFAULT NULL, `parent_itemid` bigint(20) unsigned DEFAULT NULL, `host` varchar(64) NOT NULL DEFAULT '', `lastcheck` int(11) NOT NULL DEFAULT '0', `ts_delete` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`hostid`), KEY `c_host_discovery_2` (`parent_hostid`), KEY `c_host_discovery_3` (`parent_itemid`), CONSTRAINT `c_host_discovery_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_host_discovery_2` FOREIGN KEY (`parent_hostid`) REFERENCES `hosts` (`hostid`), CONSTRAINT `c_host_discovery_3` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `host_inventory` -- DROP TABLE IF EXISTS `host_inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `host_inventory` ( `hostid` bigint(20) unsigned NOT NULL, `inventory_mode` int(11) NOT NULL DEFAULT '0', `type` varchar(64) NOT NULL DEFAULT '', `type_full` varchar(64) NOT NULL DEFAULT '', `name` varchar(64) NOT NULL DEFAULT '', `alias` varchar(64) NOT NULL DEFAULT '', `os` varchar(64) NOT NULL DEFAULT '', `os_full` varchar(255) NOT NULL DEFAULT '', `os_short` varchar(64) NOT NULL DEFAULT '', `serialno_a` varchar(64) NOT NULL DEFAULT '', `serialno_b` varchar(64) NOT NULL DEFAULT '', `tag` varchar(64) NOT NULL DEFAULT '', `asset_tag` varchar(64) NOT NULL DEFAULT '', `macaddress_a` varchar(64) NOT NULL DEFAULT '', `macaddress_b` varchar(64) NOT NULL DEFAULT '', `hardware` varchar(255) NOT NULL DEFAULT '', `hardware_full` text NOT NULL, `software` varchar(255) NOT NULL DEFAULT '', `software_full` text NOT NULL, `software_app_a` varchar(64) NOT NULL DEFAULT '', `software_app_b` varchar(64) NOT NULL DEFAULT '', `software_app_c` varchar(64) NOT NULL DEFAULT '', `software_app_d` varchar(64) NOT NULL DEFAULT '', `software_app_e` varchar(64) NOT NULL DEFAULT '', `contact` text NOT NULL, `location` text NOT NULL, `location_lat` varchar(16) NOT NULL DEFAULT '', `location_lon` varchar(16) NOT NULL DEFAULT '', `notes` text NOT NULL, `chassis` varchar(64) NOT NULL DEFAULT '', `model` varchar(64) NOT NULL DEFAULT '', `hw_arch` varchar(32) NOT NULL DEFAULT '', `vendor` varchar(64) NOT NULL DEFAULT '', `contract_number` varchar(64) NOT NULL DEFAULT '', `installer_name` varchar(64) NOT NULL DEFAULT '', `deployment_status` varchar(64) NOT NULL DEFAULT '', `url_a` varchar(255) NOT NULL DEFAULT '', `url_b` varchar(255) NOT NULL DEFAULT '', `url_c` varchar(255) NOT NULL DEFAULT '', `host_networks` text NOT NULL, `host_netmask` varchar(39) NOT NULL DEFAULT '', `host_router` varchar(39) NOT NULL DEFAULT '', `oob_ip` varchar(39) NOT NULL DEFAULT '', `oob_netmask` varchar(39) NOT NULL DEFAULT '', `oob_router` varchar(39) NOT NULL DEFAULT '', `date_hw_purchase` varchar(64) NOT NULL DEFAULT '', `date_hw_install` varchar(64) NOT NULL DEFAULT '', `date_hw_expiry` varchar(64) NOT NULL DEFAULT '', `date_hw_decomm` varchar(64) NOT NULL DEFAULT '', `site_address_a` varchar(128) NOT NULL DEFAULT '', `site_address_b` varchar(128) NOT NULL DEFAULT '', `site_address_c` varchar(128) NOT NULL DEFAULT '', `site_city` varchar(128) NOT NULL DEFAULT '', `site_state` varchar(64) NOT NULL DEFAULT '', `site_country` varchar(64) NOT NULL DEFAULT '', `site_zip` varchar(64) NOT NULL DEFAULT '', `site_rack` varchar(128) NOT NULL DEFAULT '', `site_notes` text NOT NULL, `poc_1_name` varchar(128) NOT NULL DEFAULT '', `poc_1_email` varchar(128) NOT NULL DEFAULT '', `poc_1_phone_a` varchar(64) NOT NULL DEFAULT '', `poc_1_phone_b` varchar(64) NOT NULL DEFAULT '', `poc_1_cell` varchar(64) NOT NULL DEFAULT '', `poc_1_screen` varchar(64) NOT NULL DEFAULT '', `poc_1_notes` text NOT NULL, `poc_2_name` varchar(128) NOT NULL DEFAULT '', `poc_2_email` varchar(128) NOT NULL DEFAULT '', `poc_2_phone_a` varchar(64) NOT NULL DEFAULT '', `poc_2_phone_b` varchar(64) NOT NULL DEFAULT '', `poc_2_cell` varchar(64) NOT NULL DEFAULT '', `poc_2_screen` varchar(64) NOT NULL DEFAULT '', `poc_2_notes` text NOT NULL, PRIMARY KEY (`hostid`), CONSTRAINT `c_host_inventory_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hostmacro` -- DROP TABLE IF EXISTS `hostmacro`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hostmacro` ( `hostmacroid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `macro` varchar(64) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`hostmacroid`), UNIQUE KEY `hostmacro_1` (`hostid`,`macro`), CONSTRAINT `c_hostmacro_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hosts` -- DROP TABLE IF EXISTS `hosts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hosts` ( `hostid` bigint(20) unsigned NOT NULL, `proxy_hostid` bigint(20) unsigned DEFAULT NULL, `host` varchar(64) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `disable_until` int(11) NOT NULL DEFAULT '0', `error` varchar(128) NOT NULL DEFAULT '', `available` int(11) NOT NULL DEFAULT '0', `errors_from` int(11) NOT NULL DEFAULT '0', `lastaccess` int(11) NOT NULL DEFAULT '0', `ipmi_authtype` int(11) NOT NULL DEFAULT '0', `ipmi_privilege` int(11) NOT NULL DEFAULT '2', `ipmi_username` varchar(16) NOT NULL DEFAULT '', `ipmi_password` varchar(20) NOT NULL DEFAULT '', `ipmi_disable_until` int(11) NOT NULL DEFAULT '0', `ipmi_available` int(11) NOT NULL DEFAULT '0', `snmp_disable_until` int(11) NOT NULL DEFAULT '0', `snmp_available` int(11) NOT NULL DEFAULT '0', `maintenanceid` bigint(20) unsigned DEFAULT NULL, `maintenance_status` int(11) NOT NULL DEFAULT '0', `maintenance_type` int(11) NOT NULL DEFAULT '0', `maintenance_from` int(11) NOT NULL DEFAULT '0', `ipmi_errors_from` int(11) NOT NULL DEFAULT '0', `snmp_errors_from` int(11) NOT NULL DEFAULT '0', `ipmi_error` varchar(128) NOT NULL DEFAULT '', `snmp_error` varchar(128) NOT NULL DEFAULT '', `jmx_disable_until` int(11) NOT NULL DEFAULT '0', `jmx_available` int(11) NOT NULL DEFAULT '0', `jmx_errors_from` int(11) NOT NULL DEFAULT '0', `jmx_error` varchar(128) NOT NULL DEFAULT '', `name` varchar(64) NOT NULL DEFAULT '', `flags` int(11) NOT NULL DEFAULT '0', `templateid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`hostid`), KEY `hosts_1` (`host`), KEY `hosts_2` (`status`), KEY `hosts_3` (`proxy_hostid`), KEY `hosts_4` (`name`), KEY `hosts_5` (`maintenanceid`), KEY `c_hosts_3` (`templateid`), CONSTRAINT `c_hosts_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`), CONSTRAINT `c_hosts_2` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`), CONSTRAINT `c_hosts_3` FOREIGN KEY (`templateid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hosts_groups` -- DROP TABLE IF EXISTS `hosts_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hosts_groups` ( `hostgroupid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `groupid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`hostgroupid`), UNIQUE KEY `hosts_groups_1` (`hostid`,`groupid`), KEY `hosts_groups_2` (`groupid`), CONSTRAINT `c_hosts_groups_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_hosts_groups_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hosts_templates` -- DROP TABLE IF EXISTS `hosts_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hosts_templates` ( `hosttemplateid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `templateid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`hosttemplateid`), UNIQUE KEY `hosts_templates_1` (`hostid`,`templateid`), KEY `hosts_templates_2` (`templateid`), CONSTRAINT `c_hosts_templates_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_hosts_templates_2` FOREIGN KEY (`templateid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `housekeeper` -- DROP TABLE IF EXISTS `housekeeper`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `housekeeper` ( `housekeeperid` bigint(20) unsigned NOT NULL, `tablename` varchar(64) NOT NULL DEFAULT '', `field` varchar(64) NOT NULL DEFAULT '', `value` bigint(20) unsigned NOT NULL, PRIMARY KEY (`housekeeperid`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `httpstep` -- DROP TABLE IF EXISTS `httpstep`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `httpstep` ( `httpstepid` bigint(20) unsigned NOT NULL, `httptestid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `no` int(11) NOT NULL DEFAULT '0', `url` varchar(255) NOT NULL DEFAULT '', `timeout` int(11) NOT NULL DEFAULT '30', `posts` text NOT NULL, `required` varchar(255) NOT NULL DEFAULT '', `status_codes` varchar(255) NOT NULL DEFAULT '', `variables` text NOT NULL, PRIMARY KEY (`httpstepid`), KEY `httpstep_1` (`httptestid`), CONSTRAINT `c_httpstep_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `httpstepitem` -- DROP TABLE IF EXISTS `httpstepitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `httpstepitem` ( `httpstepitemid` bigint(20) unsigned NOT NULL, `httpstepid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`httpstepitemid`), UNIQUE KEY `httpstepitem_1` (`httpstepid`,`itemid`), KEY `httpstepitem_2` (`itemid`), CONSTRAINT `c_httpstepitem_1` FOREIGN KEY (`httpstepid`) REFERENCES `httpstep` (`httpstepid`) ON DELETE CASCADE, CONSTRAINT `c_httpstepitem_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `httptest` -- DROP TABLE IF EXISTS `httptest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `httptest` ( `httptestid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `applicationid` bigint(20) unsigned DEFAULT NULL, `nextcheck` int(11) NOT NULL DEFAULT '0', `delay` int(11) NOT NULL DEFAULT '60', `status` int(11) NOT NULL DEFAULT '0', `variables` text NOT NULL, `agent` varchar(255) NOT NULL DEFAULT '', `authentication` int(11) NOT NULL DEFAULT '0', `http_user` varchar(64) NOT NULL DEFAULT '', `http_password` varchar(64) NOT NULL DEFAULT '', `hostid` bigint(20) unsigned NOT NULL, `templateid` bigint(20) unsigned DEFAULT NULL, `http_proxy` varchar(255) NOT NULL DEFAULT '', `retries` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`httptestid`), UNIQUE KEY `httptest_2` (`hostid`,`name`), KEY `httptest_1` (`applicationid`), KEY `httptest_3` (`status`), KEY `httptest_4` (`templateid`), CONSTRAINT `c_httptest_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`), CONSTRAINT `c_httptest_2` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE, CONSTRAINT `c_httptest_3` FOREIGN KEY (`templateid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `httptestitem` -- DROP TABLE IF EXISTS `httptestitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `httptestitem` ( `httptestitemid` bigint(20) unsigned NOT NULL, `httptestid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`httptestitemid`), UNIQUE KEY `httptestitem_1` (`httptestid`,`itemid`), KEY `httptestitem_2` (`itemid`), CONSTRAINT `c_httptestitem_1` FOREIGN KEY (`httptestid`) REFERENCES `httptest` (`httptestid`) ON DELETE CASCADE, CONSTRAINT `c_httptestitem_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `icon_map` -- DROP TABLE IF EXISTS `icon_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `icon_map` ( `iconmapid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `default_iconid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`iconmapid`), KEY `icon_map_1` (`name`), KEY `icon_map_2` (`default_iconid`), CONSTRAINT `c_icon_map_1` FOREIGN KEY (`default_iconid`) REFERENCES `images` (`imageid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `icon_mapping` -- DROP TABLE IF EXISTS `icon_mapping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `icon_mapping` ( `iconmappingid` bigint(20) unsigned NOT NULL, `iconmapid` bigint(20) unsigned NOT NULL, `iconid` bigint(20) unsigned NOT NULL, `inventory_link` int(11) NOT NULL DEFAULT '0', `expression` varchar(64) NOT NULL DEFAULT '', `sortorder` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`iconmappingid`), KEY `icon_mapping_1` (`iconmapid`), KEY `icon_mapping_2` (`iconid`), CONSTRAINT `c_icon_mapping_1` FOREIGN KEY (`iconmapid`) REFERENCES `icon_map` (`iconmapid`) ON DELETE CASCADE, CONSTRAINT `c_icon_mapping_2` FOREIGN KEY (`iconid`) REFERENCES `images` (`imageid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ids` -- DROP TABLE IF EXISTS `ids`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ids` ( `nodeid` int(11) NOT NULL, `table_name` varchar(64) NOT NULL DEFAULT '', `field_name` varchar(64) NOT NULL DEFAULT '', `nextid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`nodeid`,`table_name`,`field_name`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `images` -- DROP TABLE IF EXISTS `images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `images` ( `imageid` bigint(20) unsigned NOT NULL, `imagetype` int(11) NOT NULL DEFAULT '0', `name` varchar(64) NOT NULL DEFAULT '0', `image` longblob NOT NULL, PRIMARY KEY (`imageid`), KEY `images_1` (`imagetype`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `interface` -- DROP TABLE IF EXISTS `interface`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `interface` ( `interfaceid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, `main` int(11) NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', `useip` int(11) NOT NULL DEFAULT '1', `ip` varchar(64) NOT NULL DEFAULT '127.0.0.1', `dns` varchar(64) NOT NULL DEFAULT '', `port` varchar(64) NOT NULL DEFAULT '10050', PRIMARY KEY (`interfaceid`), KEY `interface_1` (`hostid`,`type`), KEY `interface_2` (`ip`,`dns`), CONSTRAINT `c_interface_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `interface_discovery` -- DROP TABLE IF EXISTS `interface_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `interface_discovery` ( `interfaceid` bigint(20) unsigned NOT NULL, `parent_interfaceid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`interfaceid`), KEY `c_interface_discovery_2` (`parent_interfaceid`), CONSTRAINT `c_interface_discovery_1` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`) ON DELETE CASCADE, CONSTRAINT `c_interface_discovery_2` FOREIGN KEY (`parent_interfaceid`) REFERENCES `interface` (`interfaceid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_discovery` -- DROP TABLE IF EXISTS `item_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_discovery` ( `itemdiscoveryid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, `parent_itemid` bigint(20) unsigned NOT NULL, `key_` varchar(255) NOT NULL DEFAULT '', `lastcheck` int(11) NOT NULL DEFAULT '0', `ts_delete` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`itemdiscoveryid`), UNIQUE KEY `item_discovery_1` (`itemid`,`parent_itemid`), KEY `item_discovery_2` (`parent_itemid`), CONSTRAINT `c_item_discovery_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE, CONSTRAINT `c_item_discovery_2` FOREIGN KEY (`parent_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `items` -- DROP TABLE IF EXISTS `items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `items` ( `itemid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `snmp_community` varchar(64) NOT NULL DEFAULT '', `snmp_oid` varchar(255) NOT NULL DEFAULT '', `hostid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `key_` varchar(255) NOT NULL DEFAULT '', `delay` int(11) NOT NULL DEFAULT '0', `history` int(11) NOT NULL DEFAULT '90', `trends` int(11) NOT NULL DEFAULT '365', `status` int(11) NOT NULL DEFAULT '0', `value_type` int(11) NOT NULL DEFAULT '0', `trapper_hosts` varchar(255) NOT NULL DEFAULT '', `units` varchar(255) NOT NULL DEFAULT '', `multiplier` int(11) NOT NULL DEFAULT '0', `delta` int(11) NOT NULL DEFAULT '0', `snmpv3_securityname` varchar(64) NOT NULL DEFAULT '', `snmpv3_securitylevel` int(11) NOT NULL DEFAULT '0', `snmpv3_authpassphrase` varchar(64) NOT NULL DEFAULT '', `snmpv3_privpassphrase` varchar(64) NOT NULL DEFAULT '', `formula` varchar(255) NOT NULL DEFAULT '1', `error` varchar(128) NOT NULL DEFAULT '', `lastlogsize` bigint(20) unsigned NOT NULL DEFAULT '0', `logtimefmt` varchar(64) NOT NULL DEFAULT '', `templateid` bigint(20) unsigned DEFAULT NULL, `valuemapid` bigint(20) unsigned DEFAULT NULL, `delay_flex` varchar(255) NOT NULL DEFAULT '', `params` text NOT NULL, `ipmi_sensor` varchar(128) NOT NULL DEFAULT '', `data_type` int(11) NOT NULL DEFAULT '0', `authtype` int(11) NOT NULL DEFAULT '0', `username` varchar(64) NOT NULL DEFAULT '', `password` varchar(64) NOT NULL DEFAULT '', `publickey` varchar(64) NOT NULL DEFAULT '', `privatekey` varchar(64) NOT NULL DEFAULT '', `mtime` int(11) NOT NULL DEFAULT '0', `flags` int(11) NOT NULL DEFAULT '0', `filter` varchar(255) NOT NULL DEFAULT '', `interfaceid` bigint(20) unsigned DEFAULT NULL, `port` varchar(64) NOT NULL DEFAULT '', `description` text NOT NULL, `inventory_link` int(11) NOT NULL DEFAULT '0', `lifetime` varchar(64) NOT NULL DEFAULT '30', `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) NOT NULL DEFAULT '', 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`), 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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Zabbix数据库初始化脚本,采用 TokuDB 引擎 -- Zabbix版本:Zabbix 2.2.0 -- TokuDB版本:Percona-5.6.17, TokuDB-7.1.6(插件加载模式) -- -- created by yejr(http://imysql.com), 2014/06/24 -- -- -- Table structure for table `items_applications` -- DROP TABLE IF EXISTS `items_applications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `items_applications` ( `itemappid` bigint(20) unsigned NOT NULL, `applicationid` bigint(20) unsigned NOT NULL, `itemid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`itemappid`), UNIQUE KEY `items_applications_1` (`applicationid`,`itemid`), KEY `items_applications_2` (`itemid`), CONSTRAINT `c_items_applications_1` FOREIGN KEY (`applicationid`) REFERENCES `applications` (`applicationid`) ON DELETE CASCADE, CONSTRAINT `c_items_applications_2` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenances` -- DROP TABLE IF EXISTS `maintenances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenances` ( `maintenanceid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', `maintenance_type` int(11) NOT NULL DEFAULT '0', `description` text NOT NULL, `active_since` int(11) NOT NULL DEFAULT '0', `active_till` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`maintenanceid`), KEY `maintenances_1` (`active_since`,`active_till`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenances_groups` -- DROP TABLE IF EXISTS `maintenances_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenances_groups` ( `maintenance_groupid` bigint(20) unsigned NOT NULL, `maintenanceid` bigint(20) unsigned NOT NULL, `groupid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`maintenance_groupid`), UNIQUE KEY `maintenances_groups_1` (`maintenanceid`,`groupid`), KEY `maintenances_groups_2` (`groupid`), CONSTRAINT `c_maintenances_groups_1` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`) ON DELETE CASCADE, CONSTRAINT `c_maintenances_groups_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenances_hosts` -- DROP TABLE IF EXISTS `maintenances_hosts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenances_hosts` ( `maintenance_hostid` bigint(20) unsigned NOT NULL, `maintenanceid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`maintenance_hostid`), UNIQUE KEY `maintenances_hosts_1` (`maintenanceid`,`hostid`), KEY `maintenances_hosts_2` (`hostid`), CONSTRAINT `c_maintenances_hosts_1` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`) ON DELETE CASCADE, CONSTRAINT `c_maintenances_hosts_2` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `maintenances_windows` -- DROP TABLE IF EXISTS `maintenances_windows`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `maintenances_windows` ( `maintenance_timeperiodid` bigint(20) unsigned NOT NULL, `maintenanceid` bigint(20) unsigned NOT NULL, `timeperiodid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`maintenance_timeperiodid`), UNIQUE KEY `maintenances_windows_1` (`maintenanceid`,`timeperiodid`), KEY `maintenances_windows_2` (`timeperiodid`), CONSTRAINT `c_maintenances_windows_1` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`) ON DELETE CASCADE, CONSTRAINT `c_maintenances_windows_2` FOREIGN KEY (`timeperiodid`) REFERENCES `timeperiods` (`timeperiodid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mappings` -- DROP TABLE IF EXISTS `mappings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mappings` ( `mappingid` bigint(20) unsigned NOT NULL, `valuemapid` bigint(20) unsigned NOT NULL, `value` varchar(64) NOT NULL DEFAULT '', `newvalue` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`mappingid`), KEY `mappings_1` (`valuemapid`), CONSTRAINT `c_mappings_1` FOREIGN KEY (`valuemapid`) REFERENCES `valuemaps` (`valuemapid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `media` -- DROP TABLE IF EXISTS `media`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `media` ( `mediaid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `mediatypeid` bigint(20) unsigned NOT NULL, `sendto` varchar(100) NOT NULL DEFAULT '', `active` int(11) NOT NULL DEFAULT '0', `severity` int(11) NOT NULL DEFAULT '63', `period` varchar(100) NOT NULL DEFAULT '1-7,00:00-24:00', PRIMARY KEY (`mediaid`), KEY `media_1` (`userid`), KEY `media_2` (`mediatypeid`), CONSTRAINT `c_media_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE, CONSTRAINT `c_media_2` FOREIGN KEY (`mediatypeid`) REFERENCES `media_type` (`mediatypeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `media_type` -- DROP TABLE IF EXISTS `media_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `media_type` ( `mediatypeid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `description` varchar(100) NOT NULL DEFAULT '', `smtp_server` varchar(255) NOT NULL DEFAULT '', `smtp_helo` varchar(255) NOT NULL DEFAULT '', `smtp_email` varchar(255) NOT NULL DEFAULT '', `exec_path` varchar(255) NOT NULL DEFAULT '', `gsm_modem` varchar(255) NOT NULL DEFAULT '', `username` varchar(255) NOT NULL DEFAULT '', `passwd` varchar(255) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`mediatypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `node_cksum` -- DROP TABLE IF EXISTS `node_cksum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `node_cksum` ( `nodeid` int(11) NOT NULL, `tablename` varchar(64) NOT NULL DEFAULT '', `recordid` bigint(20) unsigned NOT NULL, `cksumtype` int(11) NOT NULL DEFAULT '0', `cksum` text NOT NULL, `sync` char(128) NOT NULL DEFAULT '', KEY `node_cksum_1` (`nodeid`,`cksumtype`,`tablename`,`recordid`), CONSTRAINT `c_node_cksum_1` FOREIGN KEY (`nodeid`) REFERENCES `nodes` (`nodeid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `nodes` -- DROP TABLE IF EXISTS `nodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nodes` ( `nodeid` int(11) NOT NULL, `name` varchar(64) NOT NULL DEFAULT '0', `ip` varchar(39) NOT NULL DEFAULT '', `port` int(11) NOT NULL DEFAULT '10051', `nodetype` int(11) NOT NULL DEFAULT '0', `masterid` int(11) DEFAULT NULL, PRIMARY KEY (`nodeid`), KEY `nodes_1` (`masterid`), CONSTRAINT `c_nodes_1` FOREIGN KEY (`masterid`) REFERENCES `nodes` (`nodeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opcommand` -- DROP TABLE IF EXISTS `opcommand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opcommand` ( `operationid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `scriptid` bigint(20) unsigned DEFAULT NULL, `execute_on` int(11) NOT NULL DEFAULT '0', `port` varchar(64) NOT NULL DEFAULT '', `authtype` int(11) NOT NULL DEFAULT '0', `username` varchar(64) NOT NULL DEFAULT '', `password` varchar(64) NOT NULL DEFAULT '', `publickey` varchar(64) NOT NULL DEFAULT '', `privatekey` varchar(64) NOT NULL DEFAULT '', `command` text NOT NULL, PRIMARY KEY (`operationid`), KEY `opcommand_1` (`scriptid`), CONSTRAINT `c_opcommand_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opcommand_2` FOREIGN KEY (`scriptid`) REFERENCES `scripts` (`scriptid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opcommand_grp` -- DROP TABLE IF EXISTS `opcommand_grp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opcommand_grp` ( `opcommand_grpid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `groupid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`opcommand_grpid`), KEY `opcommand_grp_1` (`operationid`), KEY `opcommand_grp_2` (`groupid`), CONSTRAINT `c_opcommand_grp_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opcommand_grp_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opcommand_hst` -- DROP TABLE IF EXISTS `opcommand_hst`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opcommand_hst` ( `opcommand_hstid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `hostid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`opcommand_hstid`), KEY `opcommand_hst_1` (`operationid`), KEY `opcommand_hst_2` (`hostid`), CONSTRAINT `c_opcommand_hst_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opcommand_hst_2` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opconditions` -- DROP TABLE IF EXISTS `opconditions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opconditions` ( `opconditionid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `conditiontype` int(11) NOT NULL DEFAULT '0', `operator` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`opconditionid`), KEY `opconditions_1` (`operationid`), CONSTRAINT `c_opconditions_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `operations` -- DROP TABLE IF EXISTS `operations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `operations` ( `operationid` bigint(20) unsigned NOT NULL, `actionid` bigint(20) unsigned NOT NULL, `operationtype` int(11) NOT NULL DEFAULT '0', `esc_period` int(11) NOT NULL DEFAULT '0', `esc_step_from` int(11) NOT NULL DEFAULT '1', `esc_step_to` int(11) NOT NULL DEFAULT '1', `evaltype` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`operationid`), KEY `operations_1` (`actionid`), CONSTRAINT `c_operations_1` FOREIGN KEY (`actionid`) REFERENCES `actions` (`actionid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opgroup` -- DROP TABLE IF EXISTS `opgroup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opgroup` ( `opgroupid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `groupid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`opgroupid`), UNIQUE KEY `opgroup_1` (`operationid`,`groupid`), KEY `opgroup_2` (`groupid`), CONSTRAINT `c_opgroup_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opgroup_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opmessage` -- DROP TABLE IF EXISTS `opmessage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opmessage` ( `operationid` bigint(20) unsigned NOT NULL, `default_msg` int(11) NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', `message` text NOT NULL, `mediatypeid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`operationid`), KEY `opmessage_1` (`mediatypeid`), CONSTRAINT `c_opmessage_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opmessage_2` FOREIGN KEY (`mediatypeid`) REFERENCES `media_type` (`mediatypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opmessage_grp` -- DROP TABLE IF EXISTS `opmessage_grp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opmessage_grp` ( `opmessage_grpid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `usrgrpid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`opmessage_grpid`), UNIQUE KEY `opmessage_grp_1` (`operationid`,`usrgrpid`), KEY `opmessage_grp_2` (`usrgrpid`), CONSTRAINT `c_opmessage_grp_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opmessage_grp_2` FOREIGN KEY (`usrgrpid`) REFERENCES `usrgrp` (`usrgrpid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opmessage_usr` -- DROP TABLE IF EXISTS `opmessage_usr`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opmessage_usr` ( `opmessage_usrid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`opmessage_usrid`), UNIQUE KEY `opmessage_usr_1` (`operationid`,`userid`), KEY `opmessage_usr_2` (`userid`), CONSTRAINT `c_opmessage_usr_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_opmessage_usr_2` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `optemplate` -- DROP TABLE IF EXISTS `optemplate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `optemplate` ( `optemplateid` bigint(20) unsigned NOT NULL, `operationid` bigint(20) unsigned NOT NULL, `templateid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`optemplateid`), UNIQUE KEY `optemplate_1` (`operationid`,`templateid`), KEY `optemplate_2` (`templateid`), CONSTRAINT `c_optemplate_1` FOREIGN KEY (`operationid`) REFERENCES `operations` (`operationid`) ON DELETE CASCADE, CONSTRAINT `c_optemplate_2` FOREIGN KEY (`templateid`) REFERENCES `hosts` (`hostid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `profiles` -- DROP TABLE IF EXISTS `profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profiles` ( `profileid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `idx` varchar(96) NOT NULL DEFAULT '', `idx2` bigint(20) unsigned NOT NULL DEFAULT '0', `value_id` bigint(20) unsigned NOT NULL DEFAULT '0', `value_int` int(11) NOT NULL DEFAULT '0', `value_str` varchar(255) NOT NULL DEFAULT '', `source` varchar(96) NOT NULL DEFAULT '', `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`profileid`), KEY `profiles_1` (`userid`,`idx`,`idx2`), KEY `profiles_2` (`userid`,`profileid`), CONSTRAINT `c_profiles_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `proxy_autoreg_host` -- DROP TABLE IF EXISTS `proxy_autoreg_host`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proxy_autoreg_host` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `clock` int(11) NOT NULL DEFAULT '0', `host` varchar(64) NOT NULL DEFAULT '', `listen_ip` varchar(39) NOT NULL DEFAULT '', `listen_port` int(11) NOT NULL DEFAULT '0', `listen_dns` varchar(64) NOT NULL DEFAULT '', `host_metadata` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `proxy_autoreg_host_1` (`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `proxy_dhistory` -- DROP TABLE IF EXISTS `proxy_dhistory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proxy_dhistory` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `clock` int(11) NOT NULL DEFAULT '0', `druleid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `ip` varchar(39) NOT NULL DEFAULT '', `port` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `dcheckid` bigint(20) unsigned DEFAULT NULL, `dns` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `proxy_dhistory_1` (`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `proxy_history` -- DROP TABLE IF EXISTS `proxy_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proxy_history` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `timestamp` int(11) NOT NULL DEFAULT '0', `source` varchar(64) NOT NULL DEFAULT '', `severity` int(11) NOT NULL DEFAULT '0', `value` longtext NOT NULL, `logeventid` int(11) NOT NULL DEFAULT '0', `ns` int(11) NOT NULL DEFAULT '0', `state` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `proxy_history_1` (`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `regexps` -- DROP TABLE IF EXISTS `regexps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `regexps` ( `regexpid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', `test_string` text NOT NULL, PRIMARY KEY (`regexpid`), KEY `regexps_1` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `rights` -- DROP TABLE IF EXISTS `rights`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rights` ( `rightid` bigint(20) unsigned NOT NULL, `groupid` bigint(20) unsigned NOT NULL, `permission` int(11) NOT NULL DEFAULT '0', `id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`rightid`), KEY `rights_1` (`groupid`), KEY `rights_2` (`id`), CONSTRAINT `c_rights_1` FOREIGN KEY (`groupid`) REFERENCES `usrgrp` (`usrgrpid`) ON DELETE CASCADE, CONSTRAINT `c_rights_2` FOREIGN KEY (`id`) REFERENCES `groups` (`groupid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `screens` -- DROP TABLE IF EXISTS `screens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `screens` ( `screenid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `hsize` int(11) NOT NULL DEFAULT '1', `vsize` int(11) NOT NULL DEFAULT '1', `templateid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`screenid`), KEY `screens_1` (`templateid`), CONSTRAINT `c_screens_1` FOREIGN KEY (`templateid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `screens_items` -- DROP TABLE IF EXISTS `screens_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `screens_items` ( `screenitemid` bigint(20) unsigned NOT NULL, `screenid` bigint(20) unsigned NOT NULL, `resourcetype` int(11) NOT NULL DEFAULT '0', `resourceid` bigint(20) unsigned NOT NULL DEFAULT '0', `width` int(11) NOT NULL DEFAULT '320', `height` int(11) NOT NULL DEFAULT '200', `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `colspan` int(11) NOT NULL DEFAULT '0', `rowspan` int(11) NOT NULL DEFAULT '0', `elements` int(11) NOT NULL DEFAULT '25', `valign` int(11) NOT NULL DEFAULT '0', `halign` int(11) NOT NULL DEFAULT '0', `style` int(11) NOT NULL DEFAULT '0', `url` varchar(255) NOT NULL DEFAULT '', `dynamic` int(11) NOT NULL DEFAULT '0', `sort_triggers` int(11) NOT NULL DEFAULT '0', `application` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`screenitemid`), KEY `screens_items_1` (`screenid`), CONSTRAINT `c_screens_items_1` FOREIGN KEY (`screenid`) REFERENCES `screens` (`screenid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scripts` -- DROP TABLE IF EXISTS `scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scripts` ( `scriptid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `command` varchar(255) NOT NULL DEFAULT '', `host_access` int(11) NOT NULL DEFAULT '2', `usrgrpid` bigint(20) unsigned DEFAULT NULL, `groupid` bigint(20) unsigned DEFAULT NULL, `description` text NOT NULL, `confirmation` varchar(255) NOT NULL DEFAULT '', `type` int(11) NOT NULL DEFAULT '0', `execute_on` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`scriptid`), KEY `scripts_1` (`usrgrpid`), KEY `scripts_2` (`groupid`), CONSTRAINT `c_scripts_1` FOREIGN KEY (`usrgrpid`) REFERENCES `usrgrp` (`usrgrpid`), CONSTRAINT `c_scripts_2` FOREIGN KEY (`groupid`) REFERENCES `groups` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `service_alarms` -- DROP TABLE IF EXISTS `service_alarms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `service_alarms` ( `servicealarmid` bigint(20) unsigned NOT NULL, `serviceid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `value` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`servicealarmid`), KEY `service_alarms_1` (`serviceid`,`clock`), KEY `service_alarms_2` (`clock`), CONSTRAINT `c_service_alarms_1` FOREIGN KEY (`serviceid`) REFERENCES `services` (`serviceid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services` ( `serviceid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `algorithm` int(11) NOT NULL DEFAULT '0', `triggerid` bigint(20) unsigned DEFAULT NULL, `showsla` int(11) NOT NULL DEFAULT '0', `goodsla` double(16,4) NOT NULL DEFAULT '99.9000', `sortorder` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`serviceid`), KEY `services_1` (`triggerid`), CONSTRAINT `c_services_1` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `services_links` -- DROP TABLE IF EXISTS `services_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services_links` ( `linkid` bigint(20) unsigned NOT NULL, `serviceupid` bigint(20) unsigned NOT NULL, `servicedownid` bigint(20) unsigned NOT NULL, `soft` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`linkid`), UNIQUE KEY `services_links_2` (`serviceupid`,`servicedownid`), KEY `services_links_1` (`servicedownid`), CONSTRAINT `c_services_links_1` FOREIGN KEY (`serviceupid`) REFERENCES `services` (`serviceid`) ON DELETE CASCADE, CONSTRAINT `c_services_links_2` FOREIGN KEY (`servicedownid`) REFERENCES `services` (`serviceid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `services_times` -- DROP TABLE IF EXISTS `services_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services_times` ( `timeid` bigint(20) unsigned NOT NULL, `serviceid` bigint(20) unsigned NOT NULL, `type` int(11) NOT NULL DEFAULT '0', `ts_from` int(11) NOT NULL DEFAULT '0', `ts_to` int(11) NOT NULL DEFAULT '0', `note` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`timeid`), KEY `services_times_1` (`serviceid`,`type`,`ts_from`,`ts_to`), CONSTRAINT `c_services_times_1` FOREIGN KEY (`serviceid`) REFERENCES `services` (`serviceid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `sessionid` varchar(32) NOT NULL DEFAULT '', `userid` bigint(20) unsigned NOT NULL, `lastaccess` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sessionid`), KEY `sessions_1` (`userid`,`status`), CONSTRAINT `c_sessions_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `slides` -- DROP TABLE IF EXISTS `slides`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `slides` ( `slideid` bigint(20) unsigned NOT NULL, `slideshowid` bigint(20) unsigned NOT NULL, `screenid` bigint(20) unsigned NOT NULL, `step` int(11) NOT NULL DEFAULT '0', `delay` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`slideid`), KEY `slides_1` (`slideshowid`), KEY `slides_2` (`screenid`), CONSTRAINT `c_slides_1` FOREIGN KEY (`slideshowid`) REFERENCES `slideshows` (`slideshowid`) ON DELETE CASCADE, CONSTRAINT `c_slides_2` FOREIGN KEY (`screenid`) REFERENCES `screens` (`screenid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `slideshows` -- DROP TABLE IF EXISTS `slideshows`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `slideshows` ( `slideshowid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `delay` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`slideshowid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmap_element_url` -- DROP TABLE IF EXISTS `sysmap_element_url`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmap_element_url` ( `sysmapelementurlid` bigint(20) unsigned NOT NULL, `selementid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `url` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`sysmapelementurlid`), UNIQUE KEY `sysmap_element_url_1` (`selementid`,`name`), CONSTRAINT `c_sysmap_element_url_1` FOREIGN KEY (`selementid`) REFERENCES `sysmaps_elements` (`selementid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmap_url` -- DROP TABLE IF EXISTS `sysmap_url`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmap_url` ( `sysmapurlid` bigint(20) unsigned NOT NULL, `sysmapid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `url` varchar(255) NOT NULL DEFAULT '', `elementtype` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sysmapurlid`), UNIQUE KEY `sysmap_url_1` (`sysmapid`,`name`), CONSTRAINT `c_sysmap_url_1` FOREIGN KEY (`sysmapid`) REFERENCES `sysmaps` (`sysmapid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmaps` -- DROP TABLE IF EXISTS `sysmaps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmaps` ( `sysmapid` bigint(20) unsigned NOT NULL, `name` varchar(128) NOT NULL DEFAULT '', `width` int(11) NOT NULL DEFAULT '600', `height` int(11) NOT NULL DEFAULT '400', `backgroundid` bigint(20) unsigned DEFAULT NULL, `label_type` int(11) NOT NULL DEFAULT '2', `label_location` int(11) NOT NULL DEFAULT '0', `highlight` int(11) NOT NULL DEFAULT '1', `expandproblem` int(11) NOT NULL DEFAULT '1', `markelements` int(11) NOT NULL DEFAULT '0', `show_unack` int(11) NOT NULL DEFAULT '0', `grid_size` int(11) NOT NULL DEFAULT '50', `grid_show` int(11) NOT NULL DEFAULT '1', `grid_align` int(11) NOT NULL DEFAULT '1', `label_format` int(11) NOT NULL DEFAULT '0', `label_type_host` int(11) NOT NULL DEFAULT '2', `label_type_hostgroup` int(11) NOT NULL DEFAULT '2', `label_type_trigger` int(11) NOT NULL DEFAULT '2', `label_type_map` int(11) NOT NULL DEFAULT '2', `label_type_image` int(11) NOT NULL DEFAULT '2', `label_string_host` varchar(255) NOT NULL DEFAULT '', `label_string_hostgroup` varchar(255) NOT NULL DEFAULT '', `label_string_trigger` varchar(255) NOT NULL DEFAULT '', `label_string_map` varchar(255) NOT NULL DEFAULT '', `label_string_image` varchar(255) NOT NULL DEFAULT '', `iconmapid` bigint(20) unsigned DEFAULT NULL, `expand_macros` int(11) NOT NULL DEFAULT '0', `severity_min` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sysmapid`), KEY `sysmaps_1` (`name`), KEY `sysmaps_2` (`backgroundid`), KEY `sysmaps_3` (`iconmapid`), CONSTRAINT `c_sysmaps_1` FOREIGN KEY (`backgroundid`) REFERENCES `images` (`imageid`), CONSTRAINT `c_sysmaps_2` FOREIGN KEY (`iconmapid`) REFERENCES `icon_map` (`iconmapid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmaps_elements` -- DROP TABLE IF EXISTS `sysmaps_elements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmaps_elements` ( `selementid` bigint(20) unsigned NOT NULL, `sysmapid` bigint(20) unsigned NOT NULL, `elementid` bigint(20) unsigned NOT NULL DEFAULT '0', `elementtype` int(11) NOT NULL DEFAULT '0', `iconid_off` bigint(20) unsigned DEFAULT NULL, `iconid_on` bigint(20) unsigned DEFAULT NULL, `label` varchar(2048) NOT NULL DEFAULT '', `label_location` int(11) NOT NULL DEFAULT '-1', `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `iconid_disabled` bigint(20) unsigned DEFAULT NULL, `iconid_maintenance` bigint(20) unsigned DEFAULT NULL, `elementsubtype` int(11) NOT NULL DEFAULT '0', `areatype` int(11) NOT NULL DEFAULT '0', `width` int(11) NOT NULL DEFAULT '200', `height` int(11) NOT NULL DEFAULT '200', `viewtype` int(11) NOT NULL DEFAULT '0', `use_iconmap` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`selementid`), KEY `sysmaps_elements_1` (`sysmapid`), KEY `sysmaps_elements_2` (`iconid_off`), KEY `sysmaps_elements_3` (`iconid_on`), KEY `sysmaps_elements_4` (`iconid_disabled`), KEY `sysmaps_elements_5` (`iconid_maintenance`), CONSTRAINT `c_sysmaps_elements_1` FOREIGN KEY (`sysmapid`) REFERENCES `sysmaps` (`sysmapid`) ON DELETE CASCADE, CONSTRAINT `c_sysmaps_elements_2` FOREIGN KEY (`iconid_off`) REFERENCES `images` (`imageid`), CONSTRAINT `c_sysmaps_elements_3` FOREIGN KEY (`iconid_on`) REFERENCES `images` (`imageid`), CONSTRAINT `c_sysmaps_elements_4` FOREIGN KEY (`iconid_disabled`) REFERENCES `images` (`imageid`), CONSTRAINT `c_sysmaps_elements_5` FOREIGN KEY (`iconid_maintenance`) REFERENCES `images` (`imageid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmaps_link_triggers` -- DROP TABLE IF EXISTS `sysmaps_link_triggers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmaps_link_triggers` ( `linktriggerid` bigint(20) unsigned NOT NULL, `linkid` bigint(20) unsigned NOT NULL, `triggerid` bigint(20) unsigned NOT NULL, `drawtype` int(11) NOT NULL DEFAULT '0', `color` varchar(6) NOT NULL DEFAULT '000000', PRIMARY KEY (`linktriggerid`), UNIQUE KEY `sysmaps_link_triggers_1` (`linkid`,`triggerid`), KEY `sysmaps_link_triggers_2` (`triggerid`), CONSTRAINT `c_sysmaps_link_triggers_1` FOREIGN KEY (`linkid`) REFERENCES `sysmaps_links` (`linkid`) ON DELETE CASCADE, CONSTRAINT `c_sysmaps_link_triggers_2` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sysmaps_links` -- DROP TABLE IF EXISTS `sysmaps_links`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sysmaps_links` ( `linkid` bigint(20) unsigned NOT NULL, `sysmapid` bigint(20) unsigned NOT NULL, `selementid1` bigint(20) unsigned NOT NULL, `selementid2` bigint(20) unsigned NOT NULL, `drawtype` int(11) NOT NULL DEFAULT '0', `color` varchar(6) NOT NULL DEFAULT '000000', `label` varchar(2048) NOT NULL DEFAULT '', PRIMARY KEY (`linkid`), KEY `sysmaps_links_1` (`sysmapid`), KEY `sysmaps_links_2` (`selementid1`), KEY `sysmaps_links_3` (`selementid2`), CONSTRAINT `c_sysmaps_links_1` FOREIGN KEY (`sysmapid`) REFERENCES `sysmaps` (`sysmapid`) ON DELETE CASCADE, CONSTRAINT `c_sysmaps_links_2` FOREIGN KEY (`selementid1`) REFERENCES `sysmaps_elements` (`selementid`) ON DELETE CASCADE, CONSTRAINT `c_sysmaps_links_3` FOREIGN KEY (`selementid2`) REFERENCES `sysmaps_elements` (`selementid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `timeperiods` -- DROP TABLE IF EXISTS `timeperiods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `timeperiods` ( `timeperiodid` bigint(20) unsigned NOT NULL, `timeperiod_type` int(11) NOT NULL DEFAULT '0', `every` int(11) NOT NULL DEFAULT '0', `month` int(11) NOT NULL DEFAULT '0', `dayofweek` int(11) NOT NULL DEFAULT '0', `day` int(11) NOT NULL DEFAULT '0', `start_time` int(11) NOT NULL DEFAULT '0', `period` int(11) NOT NULL DEFAULT '0', `start_date` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`timeperiodid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `trends` -- DROP TABLE IF EXISTS `trends`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trends` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `num` int(11) NOT NULL DEFAULT '0', `value_min` double(16,4) NOT NULL DEFAULT '0.0000', `value_avg` double(16,4) NOT NULL DEFAULT '0.0000', `value_max` double(16,4) NOT NULL DEFAULT '0.0000', KEY `trends_0` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ /*!50100 PARTITION BY RANGE (clock) (PARTITION p201310 VALUES LESS THAN (1380556800) ENGINE = TokuDB, PARTITION p201311 VALUES LESS THAN (1383235200) ENGINE = TokuDB, PARTITION p201312 VALUES LESS THAN (1385827200) ENGINE = TokuDB, PARTITION p201401 VALUES LESS THAN (1388505600) ENGINE = TokuDB, PARTITION p201402 VALUES LESS THAN (1391184000) ENGINE = TokuDB, PARTITION p201403 VALUES LESS THAN (1393603200) ENGINE = TokuDB, PARTITION p201404 VALUES LESS THAN (1396281600) ENGINE = TokuDB, PARTITION p201405 VALUES LESS THAN (1398873600) ENGINE = TokuDB, PARTITION p201406 VALUES LESS THAN (1401552000) ENGINE = TokuDB, PARTITION p201407 VALUES LESS THAN (1404144000) ENGINE = TokuDB, PARTITION p201408 VALUES LESS THAN (1406822400) ENGINE = TokuDB, PARTITION p201409 VALUES LESS THAN (1409500800) ENGINE = TokuDB, PARTITION p201410 VALUES LESS THAN (1412092800) ENGINE = TokuDB, PARTITION p201411 VALUES LESS THAN (1414771200) ENGINE = TokuDB, PARTITION p201412 VALUES LESS THAN (1417363200) ENGINE = TokuDB) */; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `trends_uint` -- DROP TABLE IF EXISTS `trends_uint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trends_uint` ( `itemid` bigint(20) unsigned NOT NULL, `clock` int(11) NOT NULL DEFAULT '0', `num` int(11) NOT NULL DEFAULT '0', `value_min` bigint(20) unsigned NOT NULL DEFAULT '0', `value_avg` bigint(20) unsigned NOT NULL DEFAULT '0', `value_max` bigint(20) unsigned NOT NULL DEFAULT '0', KEY `trends_uint_0` (`itemid`,`clock`) ) ENGINE=TokuDB DEFAULT CHARSET=utf8 ROW_FORMAT=TOKUDB_QUICKLZ /*!50100 PARTITION BY RANGE (clock) (PARTITION p201310 VALUES LESS THAN (1380556800) ENGINE = TokuDB, PARTITION p201311 VALUES LESS THAN (1383235200) ENGINE = TokuDB, PARTITION p201312 VALUES LESS THAN (1385827200) ENGINE = TokuDB, PARTITION p201401 VALUES LESS THAN (1388505600) ENGINE = TokuDB, PARTITION p201402 VALUES LESS THAN (1391184000) ENGINE = TokuDB, PARTITION p201403 VALUES LESS THAN (1393603200) ENGINE = TokuDB, PARTITION p201404 VALUES LESS THAN (1396281600) ENGINE = TokuDB, PARTITION p201405 VALUES LESS THAN (1398873600) ENGINE = TokuDB, PARTITION p201406 VALUES LESS THAN (1401552000) ENGINE = TokuDB, PARTITION p201407 VALUES LESS THAN (1404144000) ENGINE = TokuDB, PARTITION p201408 VALUES LESS THAN (1406822400) ENGINE = TokuDB, PARTITION p201409 VALUES LESS THAN (1409500800) ENGINE = TokuDB, PARTITION p201410 VALUES LESS THAN (1412092800) ENGINE = TokuDB, PARTITION p201411 VALUES LESS THAN (1414771200) ENGINE = TokuDB, PARTITION p201412 VALUES LESS THAN (1417363200) ENGINE = TokuDB) */; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `trigger_depends` -- DROP TABLE IF EXISTS `trigger_depends`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trigger_depends` ( `triggerdepid` bigint(20) unsigned NOT NULL, `triggerid_down` bigint(20) unsigned NOT NULL, `triggerid_up` bigint(20) unsigned NOT NULL, PRIMARY KEY (`triggerdepid`), UNIQUE KEY `trigger_depends_1` (`triggerid_down`,`triggerid_up`), KEY `trigger_depends_2` (`triggerid_up`), CONSTRAINT `c_trigger_depends_1` FOREIGN KEY (`triggerid_down`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE, CONSTRAINT `c_trigger_depends_2` FOREIGN KEY (`triggerid_up`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `trigger_discovery` -- DROP TABLE IF EXISTS `trigger_discovery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trigger_discovery` ( `triggerdiscoveryid` bigint(20) unsigned NOT NULL, `triggerid` bigint(20) unsigned NOT NULL, `parent_triggerid` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`triggerdiscoveryid`), UNIQUE KEY `trigger_discovery_1` (`triggerid`,`parent_triggerid`), KEY `trigger_discovery_2` (`parent_triggerid`), CONSTRAINT `c_trigger_discovery_1` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE, CONSTRAINT `c_trigger_discovery_2` FOREIGN KEY (`parent_triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `triggers` -- DROP TABLE IF EXISTS `triggers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `triggers` ( `triggerid` bigint(20) unsigned NOT NULL, `expression` varchar(2048) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', `url` varchar(255) NOT NULL DEFAULT '', `status` int(11) NOT NULL DEFAULT '0', `value` int(11) NOT NULL DEFAULT '0', `priority` int(11) NOT NULL DEFAULT '0', `lastchange` int(11) NOT NULL DEFAULT '0', `comments` text NOT NULL, `error` varchar(128) NOT NULL DEFAULT '', `templateid` bigint(20) unsigned DEFAULT NULL, `type` int(11) NOT NULL DEFAULT '0', `state` int(11) NOT NULL DEFAULT '0', `flags` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`triggerid`), KEY `triggers_1` (`status`), KEY `triggers_2` (`value`), KEY `triggers_3` (`templateid`), CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `user_history` -- DROP TABLE IF EXISTS `user_history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_history` ( `userhistoryid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, `title1` varchar(255) NOT NULL DEFAULT '', `url1` varchar(255) NOT NULL DEFAULT '', `title2` varchar(255) NOT NULL DEFAULT '', `url2` varchar(255) NOT NULL DEFAULT '', `title3` varchar(255) NOT NULL DEFAULT '', `url3` varchar(255) NOT NULL DEFAULT '', `title4` varchar(255) NOT NULL DEFAULT '', `url4` varchar(255) NOT NULL DEFAULT '', `title5` varchar(255) NOT NULL DEFAULT '', `url5` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`userhistoryid`), UNIQUE KEY `user_history_1` (`userid`), CONSTRAINT `c_user_history_1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Zabbix数据库初始化脚本,采用 TokuDB 引擎 -- Zabbix版本:Zabbix 2.2.0 -- TokuDB版本:Percona-5.6.17, TokuDB-7.1.6(插件加载模式) -- -- created by yejr(http://imysql.com), 2014/06/24 -- -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `userid` bigint(20) unsigned NOT NULL, `alias` varchar(100) NOT NULL DEFAULT '', `name` varchar(100) NOT NULL DEFAULT '', `surname` varchar(100) NOT NULL DEFAULT '', `passwd` char(32) NOT NULL DEFAULT '', `url` varchar(255) NOT NULL DEFAULT '', `autologin` int(11) NOT NULL DEFAULT '0', `autologout` int(11) NOT NULL DEFAULT '900', `lang` varchar(5) NOT NULL DEFAULT 'en_GB', `refresh` int(11) NOT NULL DEFAULT '30', `type` int(11) NOT NULL DEFAULT '1', `theme` varchar(128) NOT NULL DEFAULT 'default', `attempt_failed` int(11) NOT NULL DEFAULT '0', `attempt_ip` varchar(39) NOT NULL DEFAULT '', `attempt_clock` int(11) NOT NULL DEFAULT '0', `rows_per_page` int(11) NOT NULL DEFAULT '50', PRIMARY KEY (`userid`), KEY `users_1` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users_groups` -- DROP TABLE IF EXISTS `users_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users_groups` ( `id` bigint(20) unsigned NOT NULL, `usrgrpid` bigint(20) unsigned NOT NULL, `userid` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_groups_1` (`usrgrpid`,`userid`), KEY `users_groups_2` (`userid`), CONSTRAINT `c_users_groups_1` FOREIGN KEY (`usrgrpid`) REFERENCES `usrgrp` (`usrgrpid`) ON DELETE CASCADE, CONSTRAINT `c_users_groups_2` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `usrgrp` -- DROP TABLE IF EXISTS `usrgrp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usrgrp` ( `usrgrpid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', `gui_access` int(11) NOT NULL DEFAULT '0', `users_status` int(11) NOT NULL DEFAULT '0', `debug_mode` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`usrgrpid`), KEY `usrgrp_1` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `valuemaps` -- DROP TABLE IF EXISTS `valuemaps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `valuemaps` ( `valuemapid` bigint(20) unsigned NOT NULL, `name` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`valuemapid`), KEY `valuemaps_1` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;