diff options
Diffstat (limited to 'frontends/php/create/mysql.sql')
| -rw-r--r-- | frontends/php/create/mysql.sql | 704 |
1 files changed, 704 insertions, 0 deletions
diff --git a/frontends/php/create/mysql.sql b/frontends/php/create/mysql.sql new file mode 100644 index 00000000..d70268b8 --- /dev/null +++ b/frontends/php/create/mysql.sql @@ -0,0 +1,704 @@ +-- +-- ZABBIX +-- Copyright (C) 2000-2005 SIA Zabbix +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation; either version 2 of the License, or +-- (at your option) any later version. +-- +-- This program is distributed in the hope that it will be useful, +-- but WITHOUT ANY WARRANTY; without even the implied warranty of +-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +-- GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License +-- along with this program; if not, write to the Free Software +-- Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. +-- + +-- +-- Table structure for table 'nodes' +-- + +CREATE TABLE nodes ( + nodeid integer DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + timezone integer DEFAULT '0' NOT NULL, + ip varchar(15) DEFAULT '' NOT NULL, + port integer DEFAULT '0' NOT NULL, + slave_history integer DEFAULT '0' NOT NULL, + slave_trends integer DEFAULT '0' NOT NULL, + event_lastid bigint DEFAULT '0' NOT NULL, + history_lastid bigint DEFAULT '0' NOT NULL, + nodetype integer DEFAULT '0' NOT NULL, + masterid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (nodeid) +) type=InnoDB; + +CREATE TABLE node_cksum ( + cksumid bigint DEFAULT '0' NOT NULL, + nodeid bigint DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + fieldname varchar(64) DEFAULT '' NOT NULL, + recordid bigint DEFAULT '0' NOT NULL, + cksumtype integer DEFAULT '0' NOT NULL, + cksum char(32) DEFAULT '' NOT NULL, + PRIMARY KEY (cksumid) +) type=InnoDB; + +CREATE INDEX node_cksum_1 ON node_cksum (nodeid,tablename,fieldname,recordid,cksumtype); + +CREATE TABLE node_configlog ( + conflogid bigint DEFAULT '0' NOT NULL, + nodeid bigint DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + recordid bigint DEFAULT '0' NOT NULL, + operation integer DEFAULT '0' NOT NULL, + sync_master integer DEFAULT '0' NOT NULL, + sync_slave integer DEFAULT '0' NOT NULL, + PRIMARY KEY (nodeid,conflogid) +) type=InnoDB; + +CREATE INDEX node_configlog_1 ON node_configlog (conflogid); +CREATE INDEX node_configlog_2 ON node_configlog (nodeid,tablename); + +CREATE TABLE services ( + serviceid bigint DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + algorithm integer DEFAULT '0' NOT NULL, + triggerid bigint, + showsla integer DEFAULT '0' NOT NULL, + goodsla double(5,2) DEFAULT '99.9' NOT NULL, + sortorder integer DEFAULT '0' NOT NULL, + PRIMARY KEY (serviceid) +) type=InnoDB; + +CREATE TABLE services_times ( + timeid bigint DEFAULT '0' NOT NULL, + serviceid bigint DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + ts_from integer DEFAULT '0' NOT NULL, + ts_to integer DEFAULT '0' NOT NULL, + note varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (timeid) +) type=InnoDB; + +CREATE INDEX services_times_1 ON services_times (serviceid,type,ts_from,ts_to); + +CREATE TABLE services_links ( + linkid bigint DEFAULT '0' NOT NULL, + serviceupid bigint DEFAULT '0' NOT NULL, + servicedownid bigint DEFAULT '0' NOT NULL, + soft integer DEFAULT '0' NOT NULL, + PRIMARY KEY (linkid) +) type=InnoDB; + +CREATE INDEX services_links_1 ON services_links (servicedownid); +CREATE INDEX services_links_2 ON services_links (serviceupid,servicedownid); + +CREATE TABLE graphs_items ( + gitemid bigint DEFAULT '0' NOT NULL, + graphid bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + drawtype integer DEFAULT '0' NOT NULL, + sortorder integer DEFAULT '0' NOT NULL, + color varchar(32) DEFAULT 'Dark Green' NOT NULL, + yaxisside integer DEFAULT '1' NOT NULL, + calc_fnc integer DEFAULT '2' NOT NULL, + type integer DEFAULT '0' NOT NULL, + periods_cnt integer DEFAULT '5' NOT NULL, + PRIMARY KEY (gitemid) +) type=InnoDB; + +CREATE TABLE graphs ( + graphid bigint DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + width integer DEFAULT '0' NOT NULL, + height integer DEFAULT '0' NOT NULL, + yaxistype integer DEFAULT '0' NOT NULL, + yaxismin double(16,4) DEFAULT '0' NOT NULL, + yaxismax double(16,4) DEFAULT '0' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + show_work_period integer DEFAULT '1' NOT NULL, + show_triggers integer DEFAULT '1' NOT NULL, + graphtype integer DEFAULT '0' NOT NULL, + PRIMARY KEY (graphid) +) type=InnoDB; + +CREATE INDEX graphs_1 ON graphs (name); + +CREATE TABLE sysmaps_links ( + linkid bigint DEFAULT '0' NOT NULL, + sysmapid bigint DEFAULT '0' NOT NULL, + selementid1 bigint DEFAULT '0' NOT NULL, + selementid2 bigint DEFAULT '0' NOT NULL, + triggerid bigint, + drawtype_off integer DEFAULT '0' NOT NULL, + color_off varchar(32) DEFAULT 'Black' NOT NULL, + drawtype_on integer DEFAULT '0' NOT NULL, + color_on varchar(32) DEFAULT 'Red' NOT NULL, + PRIMARY KEY (linkid) +) type=InnoDB; + +CREATE TABLE sysmaps_elements ( + selementid bigint DEFAULT '0' NOT NULL, + sysmapid bigint DEFAULT '0' NOT NULL, + elementid bigint DEFAULT '0' NOT NULL, + elementtype integer DEFAULT '0' NOT NULL, + iconid_off bigint DEFAULT '0' NOT NULL, + iconid_on bigint DEFAULT '0' NOT NULL, + label varchar(128) DEFAULT '' NOT NULL, + label_location integer DEFAULT NULL, + x integer DEFAULT '0' NOT NULL, + y integer DEFAULT '0' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (selementid) +) type=InnoDB; + +CREATE TABLE sysmaps ( + sysmapid bigint DEFAULT '0' NOT NULL, + name varchar(128) DEFAULT '' NOT NULL, + width integer DEFAULT '0' NOT NULL, + height integer DEFAULT '0' NOT NULL, + backgroundid bigint DEFAULT '0' NOT NULL, + label_type integer DEFAULT '0' NOT NULL, + label_location integer DEFAULT '0' NOT NULL, + PRIMARY KEY (sysmapid) +) type=InnoDB; + +CREATE INDEX sysmaps_1 ON sysmaps (name); + +CREATE TABLE config ( + configid bigint DEFAULT '0' NOT NULL, + alert_history integer DEFAULT '0' NOT NULL, + event_history integer DEFAULT '0' NOT NULL, + refresh_unsupported integer DEFAULT '0' NOT NULL, + work_period varchar(100) DEFAULT '1-5,00:00-24:00' NOT NULL, + PRIMARY KEY (configid) +) type=InnoDB; + +CREATE TABLE groups ( + groupid bigint DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (groupid) +) type=InnoDB; + +CREATE INDEX groups_1 ON groups (name); + +CREATE TABLE hosts_groups ( + hostgroupid bigint DEFAULT '0' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + groupid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (hostgroupid) +) type=InnoDB; + +CREATE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid); + +CREATE TABLE alerts ( + alertid bigint DEFAULT '0' NOT NULL, + actionid bigint DEFAULT '0' NOT NULL, + triggerid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + mediatypeid bigint DEFAULT '0' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + subject varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + retries integer DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + repeats integer DEFAULT '0' NOT NULL, + maxrepeats integer DEFAULT '0' NOT NULL, + nextcheck integer DEFAULT '0' NOT NULL, + delay integer DEFAULT '0' NOT NULL, + + PRIMARY KEY (alertid) +) type=InnoDB; + +CREATE INDEX alerts_1 ON alerts (actionid); +CREATE INDEX alerts_2 ON alerts (clock); +CREATE INDEX alerts_3 ON alerts (triggerid); +CREATE INDEX alerts_4 ON alerts (status, retries); +CREATE INDEX alerts_5 ON alerts (mediatypeid); +CREATE INDEX alerts_6 ON alerts (userid); + +CREATE TABLE actions ( + actionid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + subject varchar(255) DEFAULT '' NOT NULL, + message blob DEFAULT '' NOT NULL, + recipient integer DEFAULT '0' NOT NULL, + maxrepeats integer DEFAULT '0' NOT NULL, + repeatdelay integer DEFAULT '600' NOT NULL, + source integer DEFAULT '0' NOT NULL, + actiontype integer DEFAULT '0' NOT NULL, + status integer DEFAULT '0' NOT NULL, + scripts blob DEFAULT '' NOT NULL, + PRIMARY KEY (actionid) +) type=InnoDB; + +CREATE TABLE conditions ( + conditionid bigint DEFAULT '0' NOT NULL, + actionid bigint DEFAULT '0' NOT NULL, + conditiontype integer DEFAULT '0' NOT NULL, + operator integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (conditionid) +) type=InnoDB; + +CREATE INDEX conditions_1 ON conditions (actionid); + +CREATE TABLE events ( + eventid bigint DEFAULT '0' NOT NULL, + triggerid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, + acknowledged integer DEFAULT '0' NOT NULL, + PRIMARY KEY (eventid) +) type=InnoDB; + +CREATE INDEX events_1 ON events (triggerid,clock); +CREATE INDEX events_2 ON events (clock); + +CREATE TABLE functions ( + functionid bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + triggerid bigint DEFAULT '0' NOT NULL, + lastvalue varchar(255), + function varchar(12) DEFAULT '' NOT NULL, + parameter varchar(255) DEFAULT '0' NOT NULL, + PRIMARY KEY (functionid) +) type=InnoDB; + +CREATE INDEX functions_1 ON functions (triggerid); +CREATE INDEX functions_2 ON functions (itemid,function,parameter); + +CREATE TABLE history ( + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value double(16,4) DEFAULT '0.0000' NOT NULL +) type=InnoDB; + +CREATE INDEX history_1 ON history (itemid, clock); + +CREATE TABLE history_sync ( + id serial, + nodeid bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value double(16,4) DEFAULT '0.0000' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX history_sync_1 ON history_sync (nodeid, id); + +CREATE TABLE history_uint ( + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value bigint DEFAULT '0' NOT NULL +) type=InnoDB; + +CREATE INDEX history_uint_1 ON history_uint (itemid, clock); + +CREATE TABLE history_uint_sync ( + id serial, + nodeid integer DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid, id); + +CREATE TABLE history_str ( + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL +) type=InnoDB; + +CREATE INDEX history_str_1 ON history_str (itemid, clock); + +CREATE TABLE history_str_sync ( + id serial, + nodeid integer DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid, id); + +CREATE TABLE hosts ( + hostid bigint DEFAULT '0' NOT NULL, + host varchar(64) DEFAULT '' NOT NULL, + useip integer DEFAULT '1' NOT NULL, + ip varchar(15) DEFAULT '127.0.0.1' NOT NULL, + port integer DEFAULT '0' NOT NULL, + status integer DEFAULT '0' NOT NULL, + disable_until integer DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + available integer DEFAULT '0' NOT NULL, + errors_from integer DEFAULT '0' NOT NULL, + PRIMARY KEY (hostid) +) type=InnoDB; + +CREATE INDEX hosts_1 ON hosts (host); +CREATE INDEX hosts_2 ON hosts (status); + +CREATE TABLE items ( + itemid bigint DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + snmp_community varchar(64) DEFAULT '' NOT NULL, + snmp_oid varchar(255) DEFAULT '' NOT NULL, + snmp_port integer DEFAULT '161' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + key_ varchar(64) DEFAULT '' NOT NULL, + delay integer DEFAULT '0' NOT NULL, + history integer DEFAULT '90' NOT NULL, + trends integer DEFAULT '365' NOT NULL, + nextcheck integer DEFAULT '0' NOT NULL, + lastvalue varchar(255) DEFAULT NULL, + lastclock integer DEFAULT NULL, + prevvalue varchar(255) DEFAULT NULL, + status integer DEFAULT '0' NOT NULL, + value_type integer DEFAULT '0' NOT NULL, + trapper_hosts varchar(255) DEFAULT '' NOT NULL, + units varchar(10) DEFAULT '' NOT NULL, + multiplier integer DEFAULT '0' NOT NULL, + delta integer DEFAULT '0' NOT NULL, + prevorgvalue double(16,4) DEFAULT NULL, + snmpv3_securityname varchar(64) DEFAULT '' NOT NULL, + snmpv3_securitylevel integer DEFAULT '0' NOT NULL, + snmpv3_authpassphrase varchar(64) DEFAULT '' NOT NULL, + snmpv3_privpassphrase varchar(64) DEFAULT '' NOT NULL, + + formula varchar(255) DEFAULT '0' NOT NULL, + error varchar(128) DEFAULT '' NOT NULL, + + lastlogsize integer DEFAULT '0' NOT NULL, + logtimefmt varchar(64) DEFAULT '' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + valuemapid bigint DEFAULT '0' NOT NULL, + delay_flex varchar(255) DEFAULT '' NOT NULL, + + PRIMARY KEY (itemid) +) type=InnoDB; + +CREATE INDEX items_1 ON items (hostid,key_); +CREATE INDEX items_2 ON items (nextcheck); +CREATE INDEX items_3 ON items (status); + +CREATE TABLE media ( + mediaid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + mediatypeid bigint DEFAULT '0' NOT NULL, + sendto varchar(100) DEFAULT '' NOT NULL, + active integer DEFAULT '0' NOT NULL, + severity integer DEFAULT '63' NOT NULL, + period varchar(100) DEFAULT '1-7,00:00-23:59' NOT NULL, + PRIMARY KEY (mediaid) +) type=InnoDB; + +CREATE INDEX media_1 ON media (userid); +CREATE INDEX media_2 ON media (mediatypeid); + +CREATE TABLE media_type ( + mediatypeid bigint DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + description varchar(100) DEFAULT '' NOT NULL, + smtp_server varchar(255) DEFAULT '' NOT NULL, + smtp_helo varchar(255) DEFAULT '' NOT NULL, + smtp_email varchar(255) DEFAULT '' NOT NULL, + exec_path varchar(255) DEFAULT '' NOT NULL, + gsm_modem varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (mediatypeid) +) type=InnoDB; + +CREATE TABLE triggers ( + triggerid bigint DEFAULT '0' NOT NULL, + expression varchar(255) DEFAULT '' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + status integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, + priority integer DEFAULT '0' NOT NULL, + lastchange integer DEFAULT '0' NOT NULL, + dep_level integer DEFAULT '0' NOT NULL, + comments blob, + error varchar(128) DEFAULT '' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (triggerid) +) type=InnoDB; + +CREATE INDEX triggers_1 ON triggers (status); +CREATE INDEX triggers_2 ON triggers (value); + +CREATE TABLE trigger_depends ( + triggerdepid bigint DEFAULT '0' NOT NULL, + triggerid_down bigint DEFAULT '0' NOT NULL, + triggerid_up bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (triggerdepid) +) type=InnoDB; + +CREATE INDEX trigger_depends_1 ON trigger_depends (triggerid_down, triggerid_up); +CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up); + +CREATE TABLE users ( + userid bigint DEFAULT '0' NOT NULL, + alias varchar(100) DEFAULT '' NOT NULL, + name varchar(100) DEFAULT '' NOT NULL, + surname varchar(100) DEFAULT '' NOT NULL, + passwd char(32) DEFAULT '' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + autologout integer DEFAULT '900' NOT NULL, + lang varchar(5) DEFAULT 'en_gb' NOT NULL, + refresh integer DEFAULT '30' NOT NULL, + type integer DEFAULT '0' NOT NULL, + PRIMARY KEY (userid) +) type=InnoDB; + +CREATE INDEX users_1 ON users (alias); + +CREATE TABLE auditlog ( + auditid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + action integer DEFAULT '0' NOT NULL, + resourcetype integer DEFAULT '0' NOT NULL, + details varchar(128) DEFAULT '0' NOT NULL, + PRIMARY KEY (auditid) +) type=InnoDB; + +CREATE INDEX auditlog_1 ON auditlog (userid,clock); +CREATE INDEX auditlog_2 ON auditlog (clock); + +CREATE TABLE sessions ( + sessionid varchar(32) NOT NULL DEFAULT '', + userid bigint NOT NULL DEFAULT '0', + lastaccess integer NOT NULL DEFAULT '0', + PRIMARY KEY (sessionid) +) type=InnoDB; + +CREATE TABLE rights ( + rightid bigint DEFAULT '0' NOT NULL, + groupid bigint DEFAULT '0' NOT NULL, + type integer DEFAULT '0' NOT NULL, + permission integer DEFAULT '0' NOT NULL, + id bigint, + PRIMARY KEY (rightid) +) type=InnoDB; + +CREATE INDEX rights_1 ON rights (groupid); + +CREATE TABLE service_alarms ( + servicealarmid bigint DEFAULT '0' NOT NULL, + serviceid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value integer DEFAULT '0' NOT NULL, + PRIMARY KEY (servicealarmid) +) type=InnoDB; + +CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock); +CREATE INDEX service_alarms_2 ON service_alarms (clock); + +CREATE TABLE profiles ( + profileid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + idx varchar(64) DEFAULT '' NOT NULL, + value varchar(255) DEFAULT '' NOT NULL, + valuetype integer DEFAULT 0 NOT NULL, + PRIMARY KEY (profileid) +) type=InnoDB; + +CREATE INDEX profiles_1 ON profiles (userid,idx); + +CREATE TABLE screens ( + screenid bigint DEFAULT '0' NOT NULL, + name varchar(255) DEFAULT 'Screen' NOT NULL, + hsize integer DEFAULT '1' NOT NULL, + vsize integer DEFAULT '1' NOT NULL, + PRIMARY KEY (screenid) +) type=InnoDB; + +CREATE TABLE screens_items ( + screenitemid bigint DEFAULT '0' NOT NULL, + screenid bigint DEFAULT '0' NOT NULL, + resourcetype integer DEFAULT '0' NOT NULL, + resourceid bigint DEFAULT '0' NOT NULL, + width integer DEFAULT '320' NOT NULL, + height integer DEFAULT '200' NOT NULL, + x integer DEFAULT '0' NOT NULL, + y integer DEFAULT '0' NOT NULL, + colspan integer DEFAULT '0' NOT NULL, + rowspan integer DEFAULT '0' NOT NULL, + elements integer DEFAULT '25' NOT NULL, + valign integer DEFAULT '0' NOT NULL, + halign integer DEFAULT '0' NOT NULL, + style integer DEFAULT '0' NOT NULL, + url varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (screenitemid) +) type=InnoDB; + +CREATE TABLE usrgrp ( + usrgrpid bigint DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (usrgrpid) +) type=InnoDB; + +CREATE INDEX usrgrp_1 ON usrgrp (name); + +CREATE TABLE users_groups ( + id bigint DEFAULT '0' NOT NULL, + usrgrpid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX users_groups_1 ON users_groups (usrgrpid,userid); + +CREATE TABLE trends ( + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + num integer DEFAULT '0' NOT NULL, + value_min double(16,4) DEFAULT '0.0000' NOT NULL, + value_avg double(16,4) DEFAULT '0.0000' NOT NULL, + value_max double(16,4) DEFAULT '0.0000' NOT NULL, + PRIMARY KEY (itemid,clock) +) type=InnoDB; + +CREATE TABLE images ( + imageid bigint DEFAULT '0' NOT NULL, + imagetype integer DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '0' NOT NULL, + image longblob DEFAULT '' NOT NULL, + PRIMARY KEY (imageid) +) type=InnoDB; + +CREATE INDEX images_1 ON images (imagetype, name); + +CREATE TABLE hosts_templates ( + hosttemplateid bigint DEFAULT '0' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (hosttemplateid) +) type=InnoDB; + +CREATE INDEX hosts_templates_1 ON hosts_templates (hostid, templateid); + +CREATE TABLE history_log ( + id bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + timestamp integer DEFAULT '0' NOT NULL, + source varchar(64) DEFAULT '' NOT NULL, + severity integer DEFAULT '0' NOT NULL, + value text DEFAULT '' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX history_log_1 ON history_log (itemid, clock); + +CREATE TABLE history_text ( + id bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + value text DEFAULT '' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE INDEX history_text_1 ON history_text (itemid, clock); + +CREATE TABLE hosts_profiles ( + hostid bigint DEFAULT '0' NOT NULL, + devicetype varchar(64) DEFAULT '' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + os varchar(64) DEFAULT '' NOT NULL, + serialno varchar(64) DEFAULT '' NOT NULL, + tag varchar(64) DEFAULT '' NOT NULL, + macaddress varchar(64) DEFAULT '' NOT NULL, + hardware blob DEFAULT '' NOT NULL, + software blob DEFAULT '' NOT NULL, + contact blob DEFAULT '' NOT NULL, + location blob DEFAULT '' NOT NULL, + notes blob DEFAULT '' NOT NULL, + PRIMARY KEY (hostid) +) type=InnoDB; + +CREATE TABLE autoreg ( + id bigint DEFAULT '0' NOT NULL, + priority integer DEFAULT '0' NOT NULL, + pattern varchar(255) DEFAULT '' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (id) +) type=InnoDB; + +CREATE TABLE valuemaps ( + valuemapid bigint DEFAULT '0' NOT NULL, + name varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (valuemapid) +) type=InnoDB; + +CREATE INDEX valuemaps_1 ON valuemaps (name); + +CREATE TABLE mappings ( + mappingid bigint DEFAULT '0' NOT NULL, + valuemapid bigint DEFAULT '0' NOT NULL, + value varchar(64) DEFAULT '' NOT NULL, + newvalue varchar(64) DEFAULT '' NOT NULL, + PRIMARY KEY (mappingid) +) type=InnoDB; + +CREATE INDEX mappings_1 ON mappings (valuemapid); + +CREATE TABLE housekeeper ( + housekeeperid bigint DEFAULT '0' NOT NULL, + tablename varchar(64) DEFAULT '' NOT NULL, + field varchar(64) DEFAULT '' NOT NULL, + value integer DEFAULT '0' NOT NULL, + PRIMARY KEY (housekeeperid) +) type=InnoDB; + +CREATE TABLE acknowledges ( + acknowledgeid bigint DEFAULT '0' NOT NULL, + userid bigint DEFAULT '0' NOT NULL, + eventid bigint DEFAULT '0' NOT NULL, + clock integer DEFAULT '0' NOT NULL, + message varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (acknowledgeid) +) type=InnoDB; + +CREATE INDEX acknowledges_1 ON acknowledges (userid); +CREATE INDEX acknowledges_2 ON acknowledges (eventid); +CREATE INDEX acknowledges_3 ON acknowledges (clock); + +CREATE TABLE applications ( + applicationid bigint DEFAULT '0' NOT NULL, + hostid bigint DEFAULT '0' NOT NULL, + name varchar(255) DEFAULT '' NOT NULL, + templateid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (applicationid) +) type=InnoDB; + +CREATE INDEX applications_1 ON applications (templateid); +CREATE INDEX applications_2 ON applications (hostid,name); + +CREATE TABLE items_applications ( + itemappid bigint DEFAULT '0' NOT NULL, + applicationid bigint DEFAULT '0' NOT NULL, + itemid bigint DEFAULT '0' NOT NULL, + PRIMARY KEY (itemappid) +) type=InnoDB; + +CREATE INDEX items_applications_1 ON items_applications (applicationid,itemid); + +CREATE TABLE help_items ( + itemtype integer DEFAULT '0' NOT NULL, + key_ varchar(64) DEFAULT '' NOT NULL, + description varchar(255) DEFAULT '' NOT NULL, + PRIMARY KEY (itemtype, key_) +) type=InnoDB; |