-- MySQL dump 10.13 Distrib 5.5.15, for linux2.6 (x86_64) -- -- Host: localhost Database: zabbix -- ------------------------------------------------------ -- Server version 5.5.15-log /*!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 DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `eventid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `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` blob NOT NULL, `recovery_msg` int(11) NOT NULL DEFAULT '0', `r_shortdata` varchar(255) NOT NULL DEFAULT '', `r_longdata` blob 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 DEFAULT '0', `actionid` bigint(20) unsigned NOT NULL DEFAULT '0', `eventid` bigint(20) unsigned NOT NULL DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `mediatypeid` bigint(20) unsigned NOT NULL DEFAULT '0', `sendto` varchar(100) NOT NULL DEFAULT '', `subject` varchar(255) NOT NULL DEFAULT '', `message` blob NOT NULL, `status` int(11) NOT NULL DEFAULT '0', `retries` int(11) NOT NULL DEFAULT '0', `error` varchar(128) NOT NULL DEFAULT '', `nextcheck` int(11) NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `templateid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`applicationid`), UNIQUE KEY `applications_2` (`hostid`,`name`), KEY `applications_1` (`templateid`) ) 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 DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `auditid` bigint(20) unsigned NOT NULL DEFAULT '0', `table_name` varchar(64) NOT NULL DEFAULT '', `field_name` varchar(64) NOT NULL DEFAULT '', `oldvalue` blob NOT NULL, `newvalue` blob NOT NULL, PRIMARY KEY (`auditdetailid`), KEY `auditlog_details_1` (`auditid`) ) 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 DEFAULT '0', `proxy_hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `host` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`autoreg_hostid`), KEY `autoreg_host_1` (`proxy_hostid`,`host`) ) 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 DEFAULT '0', `actionid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `alert_history` int(11) NOT NULL DEFAULT '0', `event_history` int(11) NOT NULL DEFAULT '0', `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 NOT NULL DEFAULT '0', `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 'default.css', `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 DEFAULT '0', `max_in_table` int(11) NOT NULL DEFAULT '50', `search_limit` int(11) NOT NULL DEFAULT '1000', PRIMARY KEY (`configid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `druleid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '0', `snmp_community` varchar(255) NOT NULL DEFAULT '0', `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 '', PRIMARY KEY (`dcheckid`), KEY `dchecks_1` (`druleid`) ) 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 DEFAULT '0', `druleid` bigint(20) unsigned 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', PRIMARY KEY (`dhostid`), KEY `dhosts_1` (`druleid`) ) 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 DEFAULT '0', `proxy_hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `iprange` varchar(255) NOT NULL DEFAULT '', `delay` int(11) NOT NULL DEFAULT '0', `nextcheck` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', `unique_dcheckid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`druleid`) ) 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 DEFAULT '0', `dhostid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '0', `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 DEFAULT '0', `ip` varchar(39) NOT NULL DEFAULT '', PRIMARY KEY (`dserviceid`), UNIQUE KEY `dservices_1` (`dcheckid`,`type`,`key_`,`ip`,`port`), KEY `dservices_2` (`dhostid`) ) 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 DEFAULT '0', `actionid` bigint(20) unsigned NOT NULL DEFAULT '0', `triggerid` bigint(20) unsigned NOT NULL DEFAULT '0', `eventid` bigint(20) unsigned NOT NULL DEFAULT '0', `r_eventid` bigint(20) unsigned NOT NULL DEFAULT '0', `nextcheck` int(11) NOT NULL DEFAULT '0', `esc_step` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`escalationid`), KEY `escalations_1` (`actionid`,`triggerid`), KEY `escalations_2` (`status`,`nextcheck`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `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', PRIMARY KEY (`eventid`), KEY `events_1` (`object`,`objectid`,`eventid`), KEY `events_2` (`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 DEFAULT '0', `regexpid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `triggerid` bigint(20) unsigned NOT NULL DEFAULT '0', `lastvalue` varchar(255) DEFAULT 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`) ) 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 DEFAULT '0', `macro` varchar(64) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`globalmacroid`), KEY `globalmacro_1` (`macro`) ) 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 DEFAULT '0', `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', `noneworktimecolor` 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=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `width` int(11) NOT NULL DEFAULT '0', `height` int(11) NOT NULL DEFAULT '0', `yaxismin` double(16,4) NOT NULL DEFAULT '0.0000', `yaxismax` double(16,4) NOT NULL DEFAULT '0.0000', `templateid` bigint(20) unsigned NOT NULL DEFAULT '0', `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 '0', `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 NOT NULL DEFAULT '0', `ymax_itemid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`graphid`), KEY `graphs_graphs_1` (`name`) ) 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 DEFAULT '0', `graphid` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `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 '1', `calc_fnc` int(11) NOT NULL DEFAULT '2', `type` int(11) NOT NULL DEFAULT '0', `periods_cnt` int(11) NOT NULL DEFAULT '5', PRIMARY KEY (`gitemid`), KEY `graphs_items_1` (`itemid`), KEY `graphs_items_2` (`graphid`) ) 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 DEFAULT '0', `name` varchar(64) NOT NULL DEFAULT '', `internal` 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 `help_items` -- DROP TABLE IF EXISTS `help_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `help_items` ( `itemtype` int(11) NOT NULL DEFAULT '0', `key_` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`itemtype`,`key_`) ) 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 DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', KEY `history_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `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', PRIMARY KEY (`id`), UNIQUE KEY `history_log_2` (`itemid`,`id`), KEY `history_log_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', KEY `history_str_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `history_str_sync_1` (`nodeid`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=340338 DEFAULT CHARSET=utf8; /*!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` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` double(16,4) NOT NULL DEFAULT '0.0000', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `history_sync_1` (`nodeid`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=236701770 DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `history_text_2` (`itemid`,`id`), KEY `history_text_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', KEY `history_uint_1` (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `history_uint_sync_1` (`nodeid`,`id`) ) ENGINE=InnoDB AUTO_INCREMENT=127740340 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 DEFAULT '0', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `macro` varchar(64) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`hostmacroid`), KEY `hostmacro_1` (`hostid`,`macro`) ) 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 DEFAULT '0', `proxy_hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `host` varchar(64) NOT NULL DEFAULT '', `dns` varchar(64) NOT NULL DEFAULT '', `useip` int(11) NOT NULL DEFAULT '1', `ip` varchar(39) NOT NULL DEFAULT '127.0.0.1', `port` int(11) NOT NULL DEFAULT '10050', `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', `inbytes` bigint(20) unsigned NOT NULL DEFAULT '0', `outbytes` bigint(20) unsigned NOT NULL DEFAULT '0', `useipmi` int(11) NOT NULL DEFAULT '0', `ipmi_port` int(11) NOT NULL DEFAULT '623', `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 NOT NULL DEFAULT '0', `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_ip` varchar(64) NOT NULL DEFAULT '127.0.0.1', `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 '', PRIMARY KEY (`hostid`), KEY `hosts_1` (`host`), KEY `hosts_2` (`status`), KEY `hosts_3` (`proxy_hostid`) ) 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 DEFAULT '0', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `groupid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`hostgroupid`), KEY `hosts_groups_1` (`hostid`,`groupid`), KEY `hosts_groups_2` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hosts_profiles` -- DROP TABLE IF EXISTS `hosts_profiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hosts_profiles` ( `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `devicetype` varchar(64) NOT NULL DEFAULT '', `name` varchar(64) NOT NULL DEFAULT '', `os` varchar(64) NOT NULL DEFAULT '', `serialno` varchar(64) NOT NULL DEFAULT '', `tag` varchar(64) NOT NULL DEFAULT '', `macaddress` varchar(64) NOT NULL DEFAULT '', `hardware` blob NOT NULL, `software` blob NOT NULL, `contact` blob NOT NULL, `location` blob NOT NULL, `notes` blob NOT NULL, PRIMARY KEY (`hostid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hosts_profiles_ext` -- DROP TABLE IF EXISTS `hosts_profiles_ext`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hosts_profiles_ext` ( `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `device_alias` varchar(64) NOT NULL DEFAULT '', `device_type` varchar(64) NOT NULL DEFAULT '', `device_chassis` varchar(64) NOT NULL DEFAULT '', `device_os` varchar(64) NOT NULL DEFAULT '', `device_os_short` varchar(64) NOT NULL DEFAULT '', `device_hw_arch` varchar(32) NOT NULL DEFAULT '', `device_serial` varchar(64) NOT NULL DEFAULT '', `device_model` varchar(64) NOT NULL DEFAULT '', `device_tag` varchar(64) NOT NULL DEFAULT '', `device_vendor` varchar(64) NOT NULL DEFAULT '', `device_contract` varchar(64) NOT NULL DEFAULT '', `device_who` varchar(64) NOT NULL DEFAULT '', `device_status` varchar(64) NOT NULL DEFAULT '', `device_app_01` varchar(64) NOT NULL DEFAULT '', `device_app_02` varchar(64) NOT NULL DEFAULT '', `device_app_03` varchar(64) NOT NULL DEFAULT '', `device_app_04` varchar(64) NOT NULL DEFAULT '', `device_app_05` varchar(64) NOT NULL DEFAULT '', `device_url_1` varchar(255) NOT NULL DEFAULT '', `device_url_2` varchar(255) NOT NULL DEFAULT '', `device_url_3` varchar(255) NOT NULL DEFAULT '', `device_networks` blob NOT NULL, `device_notes` blob NOT NULL, `device_hardware` blob NOT NULL, `device_software` blob NOT NULL, `ip_subnet_mask` varchar(39) NOT NULL DEFAULT '', `ip_router` varchar(39) NOT NULL DEFAULT '', `ip_macaddress` varchar(64) NOT NULL DEFAULT '', `oob_ip` varchar(39) NOT NULL DEFAULT '', `oob_subnet_mask` varchar(39) NOT NULL DEFAULT '', `oob_router` varchar(39) NOT NULL DEFAULT '', `date_hw_buy` 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_street_1` varchar(128) NOT NULL DEFAULT '', `site_street_2` varchar(128) NOT NULL DEFAULT '', `site_street_3` 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` blob NOT NULL, `poc_1_name` varchar(128) NOT NULL DEFAULT '', `poc_1_email` varchar(128) NOT NULL DEFAULT '', `poc_1_phone_1` varchar(64) NOT NULL DEFAULT '', `poc_1_phone_2` varchar(64) NOT NULL DEFAULT '', `poc_1_cell` varchar(64) NOT NULL DEFAULT '', `poc_1_screen` varchar(64) NOT NULL DEFAULT '', `poc_1_notes` blob NOT NULL, `poc_2_name` varchar(128) NOT NULL DEFAULT '', `poc_2_email` varchar(128) NOT NULL DEFAULT '', `poc_2_phone_1` varchar(64) NOT NULL DEFAULT '', `poc_2_phone_2` varchar(64) NOT NULL DEFAULT '', `poc_2_cell` varchar(64) NOT NULL DEFAULT '', `poc_2_screen` varchar(64) NOT NULL DEFAULT '', `poc_2_notes` blob NOT NULL, PRIMARY KEY (`hostid`) ) 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 DEFAULT '0', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `templateid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`hosttemplateid`), UNIQUE KEY `hosts_templates_1` (`hostid`,`templateid`), KEY `hosts_templates_2` (`templateid`) ) 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 DEFAULT '0', `tablename` varchar(64) NOT NULL DEFAULT '', `field` varchar(64) NOT NULL DEFAULT '', `value` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`housekeeperid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `httptestid` bigint(20) unsigned NOT NULL DEFAULT '0', `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` blob NOT NULL, `required` varchar(255) NOT NULL DEFAULT '', `status_codes` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`httpstepid`), KEY `httpstep_httpstep_1` (`httptestid`) ) 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 DEFAULT '0', `httpstepid` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`httpstepitemid`), UNIQUE KEY `httpstepitem_httpstepitem_1` (`httpstepid`,`itemid`) ) 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 DEFAULT '0', `name` varchar(64) NOT NULL DEFAULT '', `applicationid` bigint(20) unsigned NOT NULL DEFAULT '0', `lastcheck` int(11) NOT NULL DEFAULT '0', `nextcheck` int(11) NOT NULL DEFAULT '0', `curstate` int(11) NOT NULL DEFAULT '0', `curstep` int(11) NOT NULL DEFAULT '0', `lastfailedstep` int(11) NOT NULL DEFAULT '0', `delay` int(11) NOT NULL DEFAULT '60', `status` int(11) NOT NULL DEFAULT '0', `macros` blob NOT NULL, `agent` varchar(255) NOT NULL DEFAULT '', `time` double(16,4) NOT NULL DEFAULT '0.0000', `error` 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 '', PRIMARY KEY (`httptestid`), KEY `httptest_httptest_1` (`applicationid`), KEY `httptest_2` (`name`), KEY `httptest_3` (`status`) ) 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 DEFAULT '0', `httptestid` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`httptestitemid`), UNIQUE KEY `httptestitem_httptestitem_1` (`httptestid`,`itemid`) ) 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 DEFAULT '0', `table_name` varchar(64) NOT NULL DEFAULT '', `field_name` varchar(64) NOT NULL DEFAULT '', `nextid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`nodeid`,`table_name`,`field_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `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 `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 DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', `snmp_community` varchar(64) NOT NULL DEFAULT '', `snmp_oid` varchar(255) NOT NULL DEFAULT '', `snmp_port` int(11) NOT NULL DEFAULT '161', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', `description` 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', `lastvalue` varchar(255) DEFAULT NULL, `lastclock` int(11) DEFAULT NULL, `prevvalue` varchar(255) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0', `value_type` int(11) NOT NULL DEFAULT '0', `trapper_hosts` varchar(255) NOT NULL DEFAULT '', `units` varchar(10) NOT NULL DEFAULT '', `multiplier` int(11) NOT NULL DEFAULT '0', `delta` int(11) NOT NULL DEFAULT '0', `prevorgvalue` varchar(255) DEFAULT NULL, `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` int(11) NOT NULL DEFAULT '0', `logtimefmt` varchar(64) NOT NULL DEFAULT '', `templateid` bigint(20) unsigned NOT NULL DEFAULT '0', `valuemapid` bigint(20) unsigned NOT NULL DEFAULT '0', `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', PRIMARY KEY (`itemid`), UNIQUE KEY `items_1` (`hostid`,`key_`), KEY `items_3` (`status`), KEY `items_4` (`templateid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- 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 DEFAULT '0', `applicationid` bigint(20) unsigned NOT NULL DEFAULT '0', `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemappid`), KEY `items_applications_1` (`applicationid`,`itemid`), KEY `items_applications_2` (`itemid`) ) 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 DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `maintenance_type` int(11) NOT NULL DEFAULT '0', `description` blob 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 DEFAULT '0', `maintenanceid` bigint(20) unsigned NOT NULL DEFAULT '0', `groupid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`maintenance_groupid`), KEY `maintenances_groups_1` (`maintenanceid`,`groupid`) ) 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 DEFAULT '0', `maintenanceid` bigint(20) unsigned NOT NULL DEFAULT '0', `hostid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`maintenance_hostid`), KEY `maintenances_hosts_1` (`maintenanceid`,`hostid`) ) 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 DEFAULT '0', `maintenanceid` bigint(20) unsigned NOT NULL DEFAULT '0', `timeperiodid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`maintenance_timeperiodid`), KEY `maintenances_windows_1` (`maintenanceid`,`timeperiodid`) ) 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 DEFAULT '0', `valuemapid` bigint(20) unsigned NOT NULL DEFAULT '0', `value` varchar(64) NOT NULL DEFAULT '', `newvalue` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`mappingid`), KEY `mappings_1` (`valuemapid`) ) 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 DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `mediatypeid` bigint(20) unsigned NOT NULL DEFAULT '0', `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-23:59', PRIMARY KEY (`mediaid`), KEY `media_1` (`userid`), KEY `media_2` (`mediatypeid`) ) 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 DEFAULT '0', `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 '', 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 DEFAULT '0', `tablename` varchar(64) NOT NULL DEFAULT '', `recordid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `name` varchar(64) NOT NULL DEFAULT '0', `timezone` int(11) NOT NULL DEFAULT '0', `ip` varchar(39) NOT NULL DEFAULT '', `port` int(11) NOT NULL DEFAULT '10051', `slave_history` int(11) NOT NULL DEFAULT '30', `slave_trends` int(11) NOT NULL DEFAULT '365', `nodetype` int(11) NOT NULL DEFAULT '0', `masterid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`nodeid`) ) 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 DEFAULT '0', `operationid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `actionid` bigint(20) unsigned NOT NULL DEFAULT '0', `operationtype` int(11) NOT NULL DEFAULT '0', `object` int(11) NOT NULL DEFAULT '0', `objectid` bigint(20) unsigned NOT NULL DEFAULT '0', `shortdata` varchar(255) NOT NULL DEFAULT '', `longdata` blob NOT NULL, `esc_period` int(11) NOT NULL DEFAULT '0', `esc_step_from` int(11) NOT NULL DEFAULT '0', `esc_step_to` int(11) NOT NULL DEFAULT '0', `default_msg` int(11) NOT NULL DEFAULT '0', `evaltype` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`operationid`), KEY `operations_1` (`actionid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `opmediatypes` -- DROP TABLE IF EXISTS `opmediatypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `opmediatypes` ( `opmediatypeid` bigint(20) unsigned NOT NULL DEFAULT '0', `operationid` bigint(20) unsigned NOT NULL DEFAULT '0', `mediatypeid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`opmediatypeid`), UNIQUE KEY `opmediatypes_1` (`operationid`) ) 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 DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 '', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `proxy_autoreg_host_1` (`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `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 NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `proxy_dhistory_1` (`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `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', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY `proxy_history_1` (`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `test_string` blob 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 DEFAULT '0', `groupid` bigint(20) unsigned NOT NULL DEFAULT '0', `permission` int(11) NOT NULL DEFAULT '0', `id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`rightid`), KEY `rights_1` (`groupid`), KEY `rights_2` (`id`) ) 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 DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT 'Screen', `hsize` int(11) NOT NULL DEFAULT '1', `vsize` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`screenid`) ) 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 DEFAULT '0', `screenid` bigint(20) unsigned NOT NULL DEFAULT '0', `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', PRIMARY KEY (`screenitemid`) ) 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 DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `command` varchar(255) NOT NULL DEFAULT '', `host_access` int(11) NOT NULL DEFAULT '2', `usrgrpid` bigint(20) unsigned NOT NULL DEFAULT '0', `groupid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`scriptid`) ) 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 DEFAULT '0', `serviceid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `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`) ) 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 DEFAULT '0', `serviceupid` bigint(20) unsigned NOT NULL DEFAULT '0', `servicedownid` bigint(20) unsigned NOT NULL DEFAULT '0', `soft` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`linkid`), UNIQUE KEY `services_links_links_2` (`serviceupid`,`servicedownid`), KEY `services_links_links_1` (`servicedownid`) ) 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 DEFAULT '0', `serviceid` bigint(20) unsigned NOT NULL DEFAULT '0', `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_times_1` (`serviceid`,`type`,`ts_from`,`ts_to`) ) 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 DEFAULT '0', `lastaccess` int(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`sessionid`), KEY `sessions_1` (`userid`,`status`) ) 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 DEFAULT '0', `slideshowid` bigint(20) unsigned NOT NULL DEFAULT '0', `screenid` bigint(20) unsigned NOT NULL DEFAULT '0', `step` int(11) NOT NULL DEFAULT '0', `delay` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`slideid`), KEY `slides_slides_1` (`slideshowid`) ) 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 DEFAULT '0', `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 `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 DEFAULT '0', `name` varchar(128) NOT NULL DEFAULT '', `width` int(11) NOT NULL DEFAULT '0', `height` int(11) NOT NULL DEFAULT '0', `backgroundid` bigint(20) unsigned NOT NULL DEFAULT '0', `label_type` int(11) NOT NULL DEFAULT '0', `label_location` int(11) NOT NULL DEFAULT '0', `highlight` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`sysmapid`), KEY `sysmaps_1` (`name`) ) 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 DEFAULT '0', `sysmapid` bigint(20) unsigned NOT NULL DEFAULT '0', `elementid` bigint(20) unsigned NOT NULL DEFAULT '0', `elementtype` int(11) NOT NULL DEFAULT '0', `iconid_off` bigint(20) unsigned NOT NULL DEFAULT '0', `iconid_on` bigint(20) unsigned NOT NULL DEFAULT '0', `iconid_unknown` bigint(20) unsigned NOT NULL DEFAULT '0', `label` varchar(255) NOT NULL DEFAULT '', `label_location` int(11) DEFAULT NULL, `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `url` varchar(255) NOT NULL DEFAULT '', `iconid_disabled` bigint(20) unsigned NOT NULL DEFAULT '0', `iconid_maintenance` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`selementid`) ) 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 DEFAULT '0', `linkid` bigint(20) unsigned NOT NULL DEFAULT '0', `triggerid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) 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 DEFAULT '0', `sysmapid` bigint(20) unsigned NOT NULL DEFAULT '0', `selementid1` bigint(20) unsigned NOT NULL DEFAULT '0', `selementid2` bigint(20) unsigned NOT NULL DEFAULT '0', `drawtype` int(11) NOT NULL DEFAULT '0', `color` varchar(6) NOT NULL DEFAULT '000000', `label` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`linkid`) ) 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 DEFAULT '0', `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 DEFAULT '0', `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', PRIMARY KEY (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `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', PRIMARY KEY (`itemid`,`clock`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!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 DEFAULT '0', `triggerid_down` bigint(20) unsigned NOT NULL DEFAULT '0', `triggerid_up` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`triggerdepid`), KEY `trigger_depends_1` (`triggerid_down`,`triggerid_up`), KEY `trigger_depends_2` (`triggerid_up`) ) 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 DEFAULT '0', `expression` varchar(255) 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', `dep_level` int(11) NOT NULL DEFAULT '0', `comments` blob NOT NULL, `error` varchar(128) NOT NULL DEFAULT '', `templateid` bigint(20) unsigned NOT NULL DEFAULT '0', `type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`triggerid`), KEY `triggers_1` (`status`), KEY `triggers_2` (`value`) ) 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 DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', `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`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- 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 DEFAULT '0', `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 '0', `theme` varchar(128) NOT NULL DEFAULT 'default.css', `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 DEFAULT '0', `usrgrpid` bigint(20) unsigned NOT NULL DEFAULT '0', `userid` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `users_groups_1` (`usrgrpid`,`userid`) ) 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 DEFAULT '0', `name` varchar(64) NOT NULL DEFAULT '', `gui_access` int(11) NOT NULL DEFAULT '0', `users_status` int(11) NOT NULL DEFAULT '0', `api_access` 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 DEFAULT '0', `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 */; -- Dump completed on 2011-10-26 15:59:43