CREATE TABLE role ( roleid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, readonly integer DEFAULT '0' NOT NULL, PRIMARY KEY (roleid) ); CREATE UNIQUE INDEX role_1 ON role (name); CREATE TABLE ugset ( ugsetid bigint NOT NULL, hash varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (ugsetid) ); CREATE INDEX ugset_1 ON ugset (hash); CREATE TABLE users ( userid bigint NOT NULL, username varchar(100) DEFAULT '' NOT NULL, name varchar(100) DEFAULT '' NOT NULL, surname varchar(100) DEFAULT '' NOT NULL, passwd varchar(60) DEFAULT '' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, autologin integer DEFAULT '0' NOT NULL, autologout varchar(32) DEFAULT '15m' NOT NULL, lang varchar(7) DEFAULT 'default' NOT NULL, refresh varchar(32) DEFAULT '30s' NOT NULL, theme varchar(128) DEFAULT 'default' NOT NULL, attempt_failed integer DEFAULT 0 NOT NULL, attempt_ip varchar(39) DEFAULT '' NOT NULL, attempt_clock integer DEFAULT 0 NOT NULL, rows_per_page integer DEFAULT 50 NOT NULL, timezone varchar(50) DEFAULT 'default' NOT NULL, roleid bigint DEFAULT NULL NULL, userdirectoryid bigint DEFAULT NULL NULL, ts_provisioned integer DEFAULT '0' NOT NULL, PRIMARY KEY (userid) ); CREATE UNIQUE INDEX users_1 ON users (username); CREATE INDEX users_2 ON users (userdirectoryid); CREATE INDEX users_3 ON users (roleid); CREATE TABLE maintenances ( maintenanceid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, maintenance_type integer DEFAULT '0' NOT NULL, description text DEFAULT '' NOT NULL, active_since integer DEFAULT '0' NOT NULL, active_till integer DEFAULT '0' NOT NULL, tags_evaltype integer DEFAULT '0' NOT NULL, PRIMARY KEY (maintenanceid) ); CREATE INDEX maintenances_1 ON maintenances (active_since,active_till); CREATE UNIQUE INDEX maintenances_2 ON maintenances (name); CREATE TABLE hgset ( hgsetid bigint NOT NULL, hash varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (hgsetid) ); CREATE INDEX hgset_1 ON hgset (hash); CREATE TABLE hosts ( hostid bigint NOT NULL, proxyid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, ipmi_authtype integer DEFAULT '-1' NOT NULL, ipmi_privilege integer DEFAULT '2' NOT NULL, ipmi_username varchar(16) DEFAULT '' NOT NULL, ipmi_password varchar(20) DEFAULT '' NOT NULL, maintenanceid bigint NULL, maintenance_status integer DEFAULT '0' NOT NULL, maintenance_type integer DEFAULT '0' NOT NULL, maintenance_from integer DEFAULT '0' NOT NULL, name varchar(128) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, templateid bigint NULL, description text DEFAULT '' NOT NULL, tls_connect integer DEFAULT '1' NOT NULL, tls_accept integer DEFAULT '1' NOT NULL, tls_issuer varchar(1024) DEFAULT '' NOT NULL, tls_subject varchar(1024) DEFAULT '' NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, discover integer DEFAULT '0' NOT NULL, custom_interfaces integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, name_upper varchar(128) DEFAULT '' NOT NULL, vendor_name varchar(64) DEFAULT '' NOT NULL, vendor_version varchar(32) DEFAULT '' NOT NULL, proxy_groupid bigint NULL, monitored_by integer DEFAULT '0' NOT NULL, wizard_ready integer DEFAULT '0' NOT NULL, readme text DEFAULT '' NOT NULL, PRIMARY KEY (hostid) ); CREATE INDEX hosts_1 ON hosts (host); CREATE INDEX hosts_2 ON hosts (status); CREATE INDEX hosts_3 ON hosts (proxyid); CREATE INDEX hosts_4 ON hosts (name); CREATE INDEX hosts_5 ON hosts (maintenanceid); CREATE INDEX hosts_6 ON hosts (name_upper); CREATE INDEX hosts_7 ON hosts (templateid); CREATE INDEX hosts_8 ON hosts (proxy_groupid); CREATE INDEX hosts_9 ON hosts (uuid); CREATE TABLE hstgrp ( groupid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (groupid) ); CREATE UNIQUE INDEX hstgrp_1 ON hstgrp (type,name); CREATE INDEX hstgrp_2 ON hstgrp (uuid); CREATE TABLE hgset_group ( hgsetid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (hgsetid,groupid) ); CREATE INDEX hgset_group_1 ON hgset_group (groupid); CREATE TABLE host_hgset ( hostid bigint NOT NULL, hgsetid bigint NOT NULL, PRIMARY KEY (hostid) ); CREATE INDEX host_hgset_1 ON host_hgset (hgsetid); CREATE TABLE group_prototype ( group_prototypeid bigint NOT NULL, hostid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, groupid bigint NULL, templateid bigint NULL, PRIMARY KEY (group_prototypeid) ); CREATE INDEX group_prototype_1 ON group_prototype (hostid); CREATE INDEX group_prototype_2 ON group_prototype (groupid); CREATE INDEX group_prototype_3 ON group_prototype (templateid); CREATE TABLE group_discovery ( groupdiscoveryid bigint NOT NULL, groupid bigint NOT NULL, parent_group_prototypeid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (groupdiscoveryid) ); CREATE UNIQUE INDEX group_discovery_1 ON group_discovery (groupid,parent_group_prototypeid); CREATE INDEX group_discovery_2 ON group_discovery (parent_group_prototypeid); CREATE TABLE drules ( druleid bigint NOT NULL, proxyid bigint NULL, name varchar(255) DEFAULT '' NOT NULL, iprange varchar(2048) DEFAULT '' NOT NULL, delay varchar(255) DEFAULT '1h' NOT NULL, status integer DEFAULT '0' NOT NULL, concurrency_max integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (druleid) ); CREATE INDEX drules_1 ON drules (proxyid); CREATE UNIQUE INDEX drules_2 ON drules (name); CREATE TABLE dchecks ( dcheckid bigint NOT NULL, druleid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, key_ varchar(2048) DEFAULT '' NOT NULL, snmp_community varchar(255) DEFAULT '' NOT NULL, ports varchar(255) DEFAULT '0' NOT 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, uniq integer DEFAULT '0' NOT NULL, snmpv3_authprotocol integer DEFAULT '0' NOT NULL, snmpv3_privprotocol integer DEFAULT '0' NOT NULL, snmpv3_contextname varchar(255) DEFAULT '' NOT NULL, host_source integer DEFAULT '1' NOT NULL, name_source integer DEFAULT '0' NOT NULL, allow_redirect integer DEFAULT '0' NOT NULL, PRIMARY KEY (dcheckid) ); CREATE INDEX dchecks_1 ON dchecks (druleid,host_source,name_source); CREATE TABLE httptest ( httptestid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, delay varchar(255) DEFAULT '1m' NOT NULL, status integer DEFAULT '0' NOT NULL, agent varchar(255) DEFAULT 'Zabbix' NOT NULL, authentication integer DEFAULT '0' NOT NULL, http_user varchar(255) DEFAULT '' NOT NULL, http_password varchar(255) DEFAULT '' NOT NULL, hostid bigint NOT NULL, templateid bigint NULL, http_proxy varchar(255) DEFAULT '' NOT NULL, retries integer DEFAULT '1' NOT NULL, ssl_cert_file varchar(255) DEFAULT '' NOT NULL, ssl_key_file varchar(255) DEFAULT '' NOT NULL, ssl_key_password varchar(64) DEFAULT '' NOT NULL, verify_peer integer DEFAULT '0' NOT NULL, verify_host integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (httptestid) ); CREATE UNIQUE INDEX httptest_2 ON httptest (hostid,name); CREATE INDEX httptest_3 ON httptest (status); CREATE INDEX httptest_4 ON httptest (templateid); CREATE INDEX httptest_5 ON httptest (uuid); CREATE TABLE httpstep ( httpstepid bigint NOT NULL, httptestid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, no integer DEFAULT '0' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, timeout varchar(255) DEFAULT '15s' NOT NULL, posts text DEFAULT '' NOT NULL, required varchar(255) DEFAULT '' NOT NULL, status_codes varchar(255) DEFAULT '' NOT NULL, follow_redirects integer DEFAULT '1' NOT NULL, retrieve_mode integer DEFAULT '0' NOT NULL, post_type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httpstepid) ); CREATE INDEX httpstep_1 ON httpstep (httptestid); CREATE TABLE interface ( interfaceid bigint NOT NULL, hostid bigint NOT NULL, main integer DEFAULT '0' NOT NULL, type integer DEFAULT '1' NOT NULL, useip integer DEFAULT '1' NOT NULL, ip varchar(64) DEFAULT '127.0.0.1' NOT NULL, dns varchar(255) DEFAULT '' NOT NULL, port varchar(64) DEFAULT '10050' NOT NULL, available integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, errors_from integer DEFAULT '0' NOT NULL, disable_until integer DEFAULT '0' NOT NULL, PRIMARY KEY (interfaceid) ); CREATE INDEX interface_1 ON interface (hostid,type); CREATE INDEX interface_2 ON interface (ip,dns); CREATE INDEX interface_3 ON interface (available); CREATE TABLE valuemap ( valuemapid bigint NOT NULL, hostid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (valuemapid) ); CREATE UNIQUE INDEX valuemap_1 ON valuemap (hostid,name); CREATE INDEX valuemap_2 ON valuemap (uuid); CREATE TABLE items ( itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, snmp_oid varchar(512) DEFAULT '' NOT NULL, hostid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, key_ varchar(2048) DEFAULT '' NOT NULL, delay varchar(1024) DEFAULT '0' NOT NULL, history varchar(255) DEFAULT '31d' NOT NULL, trends varchar(255) DEFAULT '365d' NOT NULL, status integer DEFAULT '0' NOT NULL, value_type integer DEFAULT '0' NOT NULL, trapper_hosts varchar(255) DEFAULT '' NOT NULL, units varchar(255) DEFAULT '' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, logtimefmt varchar(64) DEFAULT '' NOT NULL, templateid bigint NULL, valuemapid bigint NULL, params text DEFAULT '' NOT NULL, ipmi_sensor varchar(128) DEFAULT '' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, password varchar(255) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, interfaceid bigint NULL, description text DEFAULT '' NOT NULL, inventory_link integer DEFAULT '0' NOT NULL, lifetime varchar(255) DEFAULT '7d' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, jmx_endpoint varchar(255) DEFAULT '' NOT NULL, master_itemid bigint NULL, timeout varchar(255) DEFAULT '' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, query_fields text DEFAULT '' NOT NULL, posts text DEFAULT '' NOT NULL, status_codes varchar(255) DEFAULT '200' NOT NULL, follow_redirects integer DEFAULT '1' NOT NULL, post_type integer DEFAULT '0' NOT NULL, http_proxy varchar(255) DEFAULT '' NOT NULL, headers text DEFAULT '' NOT NULL, retrieve_mode integer DEFAULT '0' NOT NULL, request_method integer DEFAULT '0' NOT NULL, output_format integer DEFAULT '0' NOT NULL, ssl_cert_file varchar(255) DEFAULT '' NOT NULL, ssl_key_file varchar(255) DEFAULT '' NOT NULL, ssl_key_password varchar(64) DEFAULT '' NOT NULL, verify_peer integer DEFAULT '0' NOT NULL, verify_host integer DEFAULT '0' NOT NULL, allow_traps integer DEFAULT '0' NOT NULL, discover integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, lifetime_type integer DEFAULT '0' NOT NULL, enabled_lifetime_type integer DEFAULT '2' NOT NULL, enabled_lifetime varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (itemid) ); CREATE INDEX items_1 ON items (hostid,key_); CREATE INDEX items_3 ON items (status); CREATE INDEX items_4 ON items (templateid); CREATE INDEX items_5 ON items (valuemapid); CREATE INDEX items_6 ON items (interfaceid); CREATE INDEX items_7 ON items (master_itemid); CREATE INDEX items_8 ON items (key_); CREATE INDEX items_10 ON items (uuid); CREATE TABLE httpstepitem ( httpstepitemid bigint NOT NULL, httpstepid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httpstepitemid) ); CREATE UNIQUE INDEX httpstepitem_1 ON httpstepitem (httpstepid,itemid); CREATE INDEX httpstepitem_2 ON httpstepitem (itemid); CREATE TABLE httptestitem ( httptestitemid bigint NOT NULL, httptestid bigint NOT NULL, itemid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (httptestitemid) ); CREATE UNIQUE INDEX httptestitem_1 ON httptestitem (httptestid,itemid); CREATE INDEX httptestitem_2 ON httptestitem (itemid); CREATE TABLE media_type ( mediatypeid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name 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, username varchar(255) DEFAULT '' NOT NULL, passwd varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '1' NOT NULL, smtp_port integer DEFAULT '25' NOT NULL, smtp_security integer DEFAULT '0' NOT NULL, smtp_verify_peer integer DEFAULT '0' NOT NULL, smtp_verify_host integer DEFAULT '0' NOT NULL, smtp_authentication integer DEFAULT '0' NOT NULL, maxsessions integer DEFAULT '1' NOT NULL, maxattempts integer DEFAULT '3' NOT NULL, attempt_interval varchar(32) DEFAULT '10s' NOT NULL, message_format integer DEFAULT '1' NOT NULL, script text DEFAULT '' NOT NULL, timeout varchar(32) DEFAULT '30s' NOT NULL, process_tags integer DEFAULT '0' NOT NULL, show_event_menu integer DEFAULT '0' NOT NULL, event_menu_url varchar(2048) DEFAULT '' NOT NULL, event_menu_name varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, provider integer DEFAULT '0' NOT NULL, PRIMARY KEY (mediatypeid) ); CREATE UNIQUE INDEX media_type_1 ON media_type (name); CREATE TABLE media_type_oauth ( mediatypeid bigint NOT NULL, redirection_url varchar(2048) DEFAULT '' NOT NULL, client_id varchar(255) DEFAULT '' NOT NULL, client_secret varchar(255) DEFAULT '' NOT NULL, authorization_url varchar(2048) DEFAULT '' NOT NULL, tokens_status integer DEFAULT '0' NOT NULL, access_token text DEFAULT '' NOT NULL, access_token_updated integer DEFAULT '0' NOT NULL, access_expires_in integer DEFAULT '0' NOT NULL, refresh_token text DEFAULT '' NOT NULL, token_url varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (mediatypeid) ); CREATE TABLE media_type_param ( mediatype_paramid bigint NOT NULL, mediatypeid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (mediatype_paramid) ); CREATE INDEX media_type_param_1 ON media_type_param (mediatypeid); CREATE TABLE media_type_message ( mediatype_messageid bigint NOT NULL, mediatypeid bigint NOT NULL, eventsource integer NOT NULL, recovery integer NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, PRIMARY KEY (mediatype_messageid) ); CREATE UNIQUE INDEX media_type_message_1 ON media_type_message (mediatypeid,eventsource,recovery); CREATE TABLE usrgrp ( usrgrpid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, gui_access integer DEFAULT '0' NOT NULL, users_status integer DEFAULT '0' NOT NULL, debug_mode integer DEFAULT '0' NOT NULL, userdirectoryid bigint DEFAULT NULL NULL, mfa_status integer DEFAULT '0' NOT NULL, mfaid bigint NULL, PRIMARY KEY (usrgrpid) ); CREATE UNIQUE INDEX usrgrp_1 ON usrgrp (name); CREATE INDEX usrgrp_2 ON usrgrp (userdirectoryid); CREATE INDEX usrgrp_3 ON usrgrp (mfaid); CREATE TABLE users_groups ( id bigint NOT NULL, usrgrpid bigint NOT NULL, userid bigint NOT NULL, PRIMARY KEY (id) ); CREATE UNIQUE INDEX users_groups_1 ON users_groups (usrgrpid,userid); CREATE INDEX users_groups_2 ON users_groups (userid); CREATE TABLE ugset_group ( ugsetid bigint NOT NULL, usrgrpid bigint NOT NULL, PRIMARY KEY (ugsetid,usrgrpid) ); CREATE INDEX ugset_group_1 ON ugset_group (usrgrpid); CREATE TABLE user_ugset ( userid bigint NOT NULL, ugsetid bigint NOT NULL, PRIMARY KEY (userid) ); CREATE INDEX user_ugset_1 ON user_ugset (ugsetid); CREATE TABLE scripts ( scriptid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, command text DEFAULT '' NOT NULL, host_access integer DEFAULT '2' NOT NULL, usrgrpid bigint NULL, groupid bigint NULL, description text DEFAULT '' NOT NULL, confirmation varchar(255) DEFAULT '' NOT NULL, type integer DEFAULT '5' NOT NULL, execute_on integer DEFAULT '2' NOT NULL, timeout varchar(32) DEFAULT '30s' NOT NULL, scope integer DEFAULT '1' NOT NULL, port varchar(64) DEFAULT '' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(64) DEFAULT '' NOT NULL, password varchar(64) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, menu_path varchar(255) DEFAULT '' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, new_window integer DEFAULT '1' NOT NULL, manualinput integer DEFAULT '0' NOT NULL, manualinput_prompt varchar(255) DEFAULT '' NOT NULL, manualinput_validator varchar(2048) DEFAULT '' NOT NULL, manualinput_validator_type integer DEFAULT '0' NOT NULL, manualinput_default_value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (scriptid) ); CREATE INDEX scripts_1 ON scripts (usrgrpid); CREATE INDEX scripts_2 ON scripts (groupid); CREATE UNIQUE INDEX scripts_3 ON scripts (name,menu_path); CREATE TABLE script_param ( script_paramid bigint NOT NULL, scriptid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (script_paramid) ); CREATE UNIQUE INDEX script_param_1 ON script_param (scriptid,name); CREATE TABLE actions ( actionid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, eventsource integer DEFAULT '0' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, esc_period varchar(255) DEFAULT '1h' NOT NULL, formula varchar(1024) DEFAULT '' NOT NULL, pause_suppressed integer DEFAULT '1' NOT NULL, notify_if_canceled integer DEFAULT '1' NOT NULL, pause_symptoms integer DEFAULT '1' NOT NULL, PRIMARY KEY (actionid) ); CREATE INDEX actions_1 ON actions (eventsource,status); CREATE UNIQUE INDEX actions_2 ON actions (name); CREATE TABLE operations ( operationid bigint NOT NULL, actionid bigint NOT NULL, operationtype integer DEFAULT '0' NOT NULL, esc_period varchar(255) DEFAULT '0' NOT NULL, esc_step_from integer DEFAULT '1' NOT NULL, esc_step_to integer DEFAULT '1' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, recovery integer DEFAULT '0' NOT NULL, PRIMARY KEY (operationid) ); CREATE INDEX operations_1 ON operations (actionid); CREATE TABLE optag ( optagid bigint NOT NULL, operationid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (optagid) ); CREATE INDEX optag_1 ON optag (operationid); CREATE TABLE opmessage ( operationid bigint NOT NULL, default_msg integer DEFAULT '1' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, mediatypeid bigint NULL, PRIMARY KEY (operationid) ); CREATE INDEX opmessage_1 ON opmessage (mediatypeid); CREATE TABLE opmessage_grp ( opmessage_grpid bigint NOT NULL, operationid bigint NOT NULL, usrgrpid bigint NOT NULL, PRIMARY KEY (opmessage_grpid) ); CREATE UNIQUE INDEX opmessage_grp_1 ON opmessage_grp (operationid,usrgrpid); CREATE INDEX opmessage_grp_2 ON opmessage_grp (usrgrpid); CREATE TABLE opmessage_usr ( opmessage_usrid bigint NOT NULL, operationid bigint NOT NULL, userid bigint NOT NULL, PRIMARY KEY (opmessage_usrid) ); CREATE UNIQUE INDEX opmessage_usr_1 ON opmessage_usr (operationid,userid); CREATE INDEX opmessage_usr_2 ON opmessage_usr (userid); CREATE TABLE opcommand ( operationid bigint NOT NULL, scriptid bigint NOT NULL, PRIMARY KEY (operationid) ); CREATE INDEX opcommand_1 ON opcommand (scriptid); CREATE TABLE opcommand_hst ( opcommand_hstid bigint NOT NULL, operationid bigint NOT NULL, hostid bigint NULL, PRIMARY KEY (opcommand_hstid) ); CREATE INDEX opcommand_hst_1 ON opcommand_hst (operationid); CREATE INDEX opcommand_hst_2 ON opcommand_hst (hostid); CREATE TABLE opcommand_grp ( opcommand_grpid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (opcommand_grpid) ); CREATE INDEX opcommand_grp_1 ON opcommand_grp (operationid); CREATE INDEX opcommand_grp_2 ON opcommand_grp (groupid); CREATE TABLE opgroup ( opgroupid bigint NOT NULL, operationid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (opgroupid) ); CREATE UNIQUE INDEX opgroup_1 ON opgroup (operationid,groupid); CREATE INDEX opgroup_2 ON opgroup (groupid); CREATE TABLE optemplate ( optemplateid bigint NOT NULL, operationid bigint NOT NULL, templateid bigint NOT NULL, PRIMARY KEY (optemplateid) ); CREATE UNIQUE INDEX optemplate_1 ON optemplate (operationid,templateid); CREATE INDEX optemplate_2 ON optemplate (templateid); CREATE TABLE opconditions ( opconditionid bigint NOT NULL, operationid bigint NOT NULL, conditiontype integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (opconditionid) ); CREATE INDEX opconditions_1 ON opconditions (operationid); CREATE TABLE conditions ( conditionid bigint NOT NULL, actionid bigint NOT NULL, conditiontype integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, value2 varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (conditionid) ); CREATE INDEX conditions_1 ON conditions (actionid); CREATE TABLE triggers ( triggerid bigint NOT NULL, expression varchar(2048) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, url varchar(2048) 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, comments text DEFAULT '' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, templateid bigint NULL, type integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, flags integer DEFAULT '0' NOT NULL, recovery_mode integer DEFAULT '0' NOT NULL, recovery_expression varchar(2048) DEFAULT '' NOT NULL, correlation_mode integer DEFAULT '0' NOT NULL, correlation_tag varchar(255) DEFAULT '' NOT NULL, manual_close integer DEFAULT '0' NOT NULL, opdata varchar(255) DEFAULT '' NOT NULL, discover integer DEFAULT '0' NOT NULL, event_name varchar(2048) DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, url_name varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (triggerid) ); CREATE INDEX triggers_1 ON triggers (status); CREATE INDEX triggers_2 ON triggers (value,lastchange); CREATE INDEX triggers_3 ON triggers (templateid); CREATE INDEX triggers_4 ON triggers (uuid); CREATE TABLE trigger_depends ( triggerdepid bigint NOT NULL, triggerid_down bigint NOT NULL, triggerid_up bigint NOT NULL, PRIMARY KEY (triggerdepid) ); CREATE UNIQUE INDEX trigger_depends_1 ON trigger_depends (triggerid_down,triggerid_up); CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up); CREATE TABLE functions ( functionid bigint NOT NULL, itemid bigint NOT NULL, triggerid bigint NOT NULL, name varchar(12) DEFAULT '' NOT NULL, parameter varchar(255) DEFAULT '0' NOT NULL, PRIMARY KEY (functionid) ); CREATE INDEX functions_1 ON functions (triggerid); CREATE INDEX functions_2 ON functions (itemid,name,parameter); CREATE TABLE graphs ( graphid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, width integer DEFAULT '900' NOT NULL, height integer DEFAULT '200' NOT NULL, yaxismin DOUBLE PRECISION DEFAULT '0' NOT NULL, yaxismax DOUBLE PRECISION DEFAULT '100' NOT NULL, templateid bigint NULL, show_work_period integer DEFAULT '1' NOT NULL, show_triggers integer DEFAULT '1' NOT NULL, graphtype integer DEFAULT '0' NOT NULL, show_legend integer DEFAULT '1' NOT NULL, show_3d integer DEFAULT '0' NOT NULL, percent_left DOUBLE PRECISION DEFAULT '0' NOT NULL, percent_right DOUBLE PRECISION DEFAULT '0' NOT NULL, ymin_type integer DEFAULT '0' NOT NULL, ymax_type integer DEFAULT '0' NOT NULL, ymin_itemid bigint NULL, ymax_itemid bigint NULL, flags integer DEFAULT '0' NOT NULL, discover integer DEFAULT '0' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (graphid) ); CREATE INDEX graphs_1 ON graphs (name); CREATE INDEX graphs_2 ON graphs (templateid); CREATE INDEX graphs_3 ON graphs (ymin_itemid); CREATE INDEX graphs_4 ON graphs (ymax_itemid); CREATE INDEX graphs_5 ON graphs (uuid); CREATE TABLE graphs_items ( gitemid bigint NOT NULL, graphid bigint NOT NULL, itemid bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '009600' NOT NULL, yaxisside integer DEFAULT '0' NOT NULL, calc_fnc integer DEFAULT '2' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (gitemid) ); CREATE INDEX graphs_items_1 ON graphs_items (itemid); CREATE INDEX graphs_items_2 ON graphs_items (graphid); CREATE TABLE graph_theme ( graphthemeid bigint NOT NULL, theme varchar(64) DEFAULT '' NOT NULL, backgroundcolor varchar(6) DEFAULT '' NOT NULL, graphcolor varchar(6) DEFAULT '' NOT NULL, gridcolor varchar(6) DEFAULT '' NOT NULL, maingridcolor varchar(6) DEFAULT '' NOT NULL, gridbordercolor varchar(6) DEFAULT '' NOT NULL, textcolor varchar(6) DEFAULT '' NOT NULL, highlightcolor varchar(6) DEFAULT '' NOT NULL, leftpercentilecolor varchar(6) DEFAULT '' NOT NULL, rightpercentilecolor varchar(6) DEFAULT '' NOT NULL, nonworktimecolor varchar(6) DEFAULT '' NOT NULL, colorpalette varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (graphthemeid) ); CREATE UNIQUE INDEX graph_theme_1 ON graph_theme (theme); CREATE TABLE globalmacro ( globalmacroid bigint NOT NULL, macro varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (globalmacroid) ); CREATE UNIQUE INDEX globalmacro_1 ON globalmacro (macro); CREATE TABLE hostmacro ( hostmacroid bigint NOT NULL, hostid bigint NOT NULL, macro varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, automatic integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostmacroid) ); CREATE UNIQUE INDEX hostmacro_1 ON hostmacro (hostid,macro); CREATE TABLE hostmacro_config ( hostmacroid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, priority integer DEFAULT '0' NOT NULL, section_name varchar(255) DEFAULT '' NOT NULL, label varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, required integer DEFAULT '0' NOT NULL, regex varchar(255) DEFAULT '' NOT NULL, options text DEFAULT '' NOT NULL, PRIMARY KEY (hostmacroid) ); CREATE TABLE hosts_groups ( hostgroupid bigint NOT NULL, hostid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (hostgroupid) ); CREATE UNIQUE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid); CREATE INDEX hosts_groups_2 ON hosts_groups (groupid); CREATE TABLE hosts_templates ( hosttemplateid bigint NOT NULL, hostid bigint NOT NULL, templateid bigint NOT NULL, link_type integer DEFAULT '0' NOT NULL, PRIMARY KEY (hosttemplateid) ); CREATE UNIQUE INDEX hosts_templates_1 ON hosts_templates (hostid,templateid); CREATE INDEX hosts_templates_2 ON hosts_templates (templateid); CREATE TABLE valuemap_mapping ( valuemap_mappingid bigint NOT NULL, valuemapid bigint NOT NULL, value varchar(64) DEFAULT '' NOT NULL, newvalue varchar(64) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (valuemap_mappingid) ); CREATE UNIQUE INDEX valuemap_mapping_1 ON valuemap_mapping (valuemapid,value,type); CREATE TABLE media ( mediaid bigint NOT NULL, userid bigint NOT NULL, mediatypeid bigint NOT NULL, sendto varchar(1024) DEFAULT '' NOT NULL, active integer DEFAULT '0' NOT NULL, severity integer DEFAULT '63' NOT NULL, period varchar(1024) DEFAULT '1-7,00:00-24:00' NOT NULL, userdirectory_mediaid bigint DEFAULT NULL NULL, PRIMARY KEY (mediaid) ); CREATE INDEX media_1 ON media (userid); CREATE INDEX media_2 ON media (mediatypeid); CREATE INDEX media_3 ON media (userdirectory_mediaid); CREATE TABLE rights ( rightid bigint NOT NULL, groupid bigint NOT NULL, permission integer DEFAULT '0' NOT NULL, id bigint NOT NULL, PRIMARY KEY (rightid) ); CREATE INDEX rights_1 ON rights (groupid); CREATE INDEX rights_2 ON rights (id); CREATE TABLE permission ( ugsetid bigint NOT NULL, hgsetid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (ugsetid,hgsetid) ); CREATE INDEX permission_1 ON permission (hgsetid); CREATE TABLE services ( serviceid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, status integer DEFAULT '-1' NOT NULL, algorithm integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, weight integer DEFAULT '0' NOT NULL, propagation_rule integer DEFAULT '0' NOT NULL, propagation_value integer DEFAULT '0' NOT NULL, description text DEFAULT '' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, created_at integer DEFAULT '0' NOT NULL, PRIMARY KEY (serviceid) ); CREATE INDEX services_1 ON services (uuid); CREATE TABLE services_links ( linkid bigint NOT NULL, serviceupid bigint NOT NULL, servicedownid bigint NOT NULL, PRIMARY KEY (linkid) ); CREATE INDEX services_links_1 ON services_links (servicedownid); CREATE UNIQUE INDEX services_links_2 ON services_links (serviceupid,servicedownid); CREATE TABLE icon_map ( iconmapid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, default_iconid bigint NOT NULL, PRIMARY KEY (iconmapid) ); CREATE UNIQUE INDEX icon_map_1 ON icon_map (name); CREATE INDEX icon_map_2 ON icon_map (default_iconid); CREATE TABLE icon_mapping ( iconmappingid bigint NOT NULL, iconmapid bigint NOT NULL, iconid bigint NOT NULL, inventory_link integer DEFAULT '0' NOT NULL, expression varchar(64) DEFAULT '' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (iconmappingid) ); CREATE INDEX icon_mapping_1 ON icon_mapping (iconmapid); CREATE INDEX icon_mapping_2 ON icon_mapping (iconid); CREATE TABLE sysmaps ( sysmapid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, width integer DEFAULT '600' NOT NULL, height integer DEFAULT '400' NOT NULL, backgroundid bigint NULL, label_type integer DEFAULT '2' NOT NULL, label_location integer DEFAULT '0' NOT NULL, highlight integer DEFAULT '1' NOT NULL, expandproblem integer DEFAULT '1' NOT NULL, markelements integer DEFAULT '0' NOT NULL, show_unack integer DEFAULT '0' NOT NULL, grid_size integer DEFAULT '50' NOT NULL, grid_show integer DEFAULT '1' NOT NULL, grid_align integer DEFAULT '1' NOT NULL, label_format integer DEFAULT '0' NOT NULL, label_type_host integer DEFAULT '2' NOT NULL, label_type_hostgroup integer DEFAULT '2' NOT NULL, label_type_trigger integer DEFAULT '2' NOT NULL, label_type_map integer DEFAULT '2' NOT NULL, label_type_image integer DEFAULT '2' NOT NULL, label_string_host varchar(255) DEFAULT '' NOT NULL, label_string_hostgroup varchar(255) DEFAULT '' NOT NULL, label_string_trigger varchar(255) DEFAULT '' NOT NULL, label_string_map varchar(255) DEFAULT '' NOT NULL, label_string_image varchar(255) DEFAULT '' NOT NULL, iconmapid bigint NULL, expand_macros integer DEFAULT '0' NOT NULL, severity_min integer DEFAULT '0' NOT NULL, userid bigint NOT NULL, private integer DEFAULT '1' NOT NULL, show_suppressed integer DEFAULT '0' NOT NULL, background_scale integer DEFAULT '1' NOT NULL, show_element_label integer DEFAULT '1' NOT NULL, show_link_label integer DEFAULT '1' NOT NULL, PRIMARY KEY (sysmapid) ); CREATE UNIQUE INDEX sysmaps_1 ON sysmaps (name); CREATE INDEX sysmaps_2 ON sysmaps (backgroundid); CREATE INDEX sysmaps_3 ON sysmaps (iconmapid); CREATE INDEX sysmaps_4 ON sysmaps (userid); CREATE TABLE sysmaps_elements ( selementid bigint NOT NULL, sysmapid bigint NOT NULL, elementid bigint DEFAULT '0' NOT NULL, elementtype integer DEFAULT '0' NOT NULL, iconid_off bigint NULL, iconid_on bigint NULL, label varchar(2048) DEFAULT '' NOT NULL, label_location integer DEFAULT '-1' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, iconid_disabled bigint NULL, iconid_maintenance bigint NULL, elementsubtype integer DEFAULT '0' NOT NULL, areatype integer DEFAULT '0' NOT NULL, width integer DEFAULT '200' NOT NULL, height integer DEFAULT '200' NOT NULL, viewtype integer DEFAULT '0' NOT NULL, use_iconmap integer DEFAULT '1' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, show_label integer DEFAULT '-1' NOT NULL, zindex integer DEFAULT '0' NOT NULL, PRIMARY KEY (selementid) ); CREATE INDEX sysmaps_elements_1 ON sysmaps_elements (sysmapid); CREATE INDEX sysmaps_elements_2 ON sysmaps_elements (iconid_off); CREATE INDEX sysmaps_elements_3 ON sysmaps_elements (iconid_on); CREATE INDEX sysmaps_elements_4 ON sysmaps_elements (iconid_disabled); CREATE INDEX sysmaps_elements_5 ON sysmaps_elements (iconid_maintenance); CREATE TABLE sysmaps_links ( linkid bigint NOT NULL, sysmapid bigint NOT NULL, selementid1 bigint NOT NULL, selementid2 bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '000000' NOT NULL, label varchar(2048) DEFAULT '' NOT NULL, show_label integer DEFAULT '-1' NOT NULL, indicator_type integer DEFAULT '0' NOT NULL, itemid bigint NULL, PRIMARY KEY (linkid) ); CREATE INDEX sysmaps_links_1 ON sysmaps_links (sysmapid); CREATE INDEX sysmaps_links_2 ON sysmaps_links (selementid1); CREATE INDEX sysmaps_links_3 ON sysmaps_links (selementid2); CREATE INDEX sysmaps_links_4 ON sysmaps_links (itemid); CREATE TABLE sysmaps_link_triggers ( linktriggerid bigint NOT NULL, linkid bigint NOT NULL, triggerid bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '000000' NOT NULL, PRIMARY KEY (linktriggerid) ); CREATE UNIQUE INDEX sysmaps_link_triggers_1 ON sysmaps_link_triggers (linkid,triggerid); CREATE INDEX sysmaps_link_triggers_2 ON sysmaps_link_triggers (triggerid); CREATE TABLE sysmap_link_threshold ( linkthresholdid bigint NOT NULL, linkid bigint NOT NULL, drawtype integer DEFAULT '0' NOT NULL, color varchar(6) DEFAULT '000000' NOT NULL, type integer DEFAULT '0' NOT NULL, threshold varchar(255) DEFAULT '' NOT NULL, pattern varchar(255) DEFAULT '' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (linkthresholdid) ); CREATE INDEX sysmap_link_threshold_1 ON sysmap_link_threshold (linkid); CREATE TABLE sysmap_element_url ( sysmapelementurlid bigint NOT NULL, selementid bigint NOT NULL, name varchar(255) NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (sysmapelementurlid) ); CREATE UNIQUE INDEX sysmap_element_url_1 ON sysmap_element_url (selementid,name); CREATE TABLE sysmap_url ( sysmapurlid bigint NOT NULL, sysmapid bigint NOT NULL, name varchar(255) NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, elementtype integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmapurlid) ); CREATE UNIQUE INDEX sysmap_url_1 ON sysmap_url (sysmapid,name); CREATE TABLE sysmap_user ( sysmapuserid bigint NOT NULL, sysmapid bigint NOT NULL, userid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (sysmapuserid) ); CREATE UNIQUE INDEX sysmap_user_1 ON sysmap_user (sysmapid,userid); CREATE INDEX sysmap_user_2 ON sysmap_user (userid); CREATE TABLE sysmap_usrgrp ( sysmapusrgrpid bigint NOT NULL, sysmapid bigint NOT NULL, usrgrpid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (sysmapusrgrpid) ); CREATE UNIQUE INDEX sysmap_usrgrp_1 ON sysmap_usrgrp (sysmapid,usrgrpid); CREATE INDEX sysmap_usrgrp_2 ON sysmap_usrgrp (usrgrpid); CREATE TABLE maintenances_hosts ( maintenance_hostid bigint NOT NULL, maintenanceid bigint NOT NULL, hostid bigint NOT NULL, PRIMARY KEY (maintenance_hostid) ); CREATE UNIQUE INDEX maintenances_hosts_1 ON maintenances_hosts (maintenanceid,hostid); CREATE INDEX maintenances_hosts_2 ON maintenances_hosts (hostid); CREATE TABLE maintenances_groups ( maintenance_groupid bigint NOT NULL, maintenanceid bigint NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (maintenance_groupid) ); CREATE UNIQUE INDEX maintenances_groups_1 ON maintenances_groups (maintenanceid,groupid); CREATE INDEX maintenances_groups_2 ON maintenances_groups (groupid); CREATE TABLE timeperiods ( timeperiodid bigint NOT NULL, timeperiod_type integer DEFAULT '0' NOT NULL, every integer DEFAULT '1' NOT NULL, month integer DEFAULT '0' NOT NULL, dayofweek integer DEFAULT '0' NOT NULL, day integer DEFAULT '0' NOT NULL, start_time integer DEFAULT '0' NOT NULL, period integer DEFAULT '0' NOT NULL, start_date integer DEFAULT '0' NOT NULL, PRIMARY KEY (timeperiodid) ); CREATE TABLE maintenances_windows ( maintenance_timeperiodid bigint NOT NULL, maintenanceid bigint NOT NULL, timeperiodid bigint NOT NULL, PRIMARY KEY (maintenance_timeperiodid) ); CREATE UNIQUE INDEX maintenances_windows_1 ON maintenances_windows (maintenanceid,timeperiodid); CREATE INDEX maintenances_windows_2 ON maintenances_windows (timeperiodid); CREATE TABLE regexps ( regexpid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, test_string text DEFAULT '' NOT NULL, PRIMARY KEY (regexpid) ); CREATE UNIQUE INDEX regexps_1 ON regexps (name); CREATE TABLE expressions ( expressionid bigint NOT NULL, regexpid bigint NOT NULL, expression varchar(255) DEFAULT '' NOT NULL, expression_type integer DEFAULT '0' NOT NULL, exp_delimiter varchar(1) DEFAULT '' NOT NULL, case_sensitive integer DEFAULT '0' NOT NULL, PRIMARY KEY (expressionid) ); CREATE INDEX expressions_1 ON expressions (regexpid); CREATE TABLE ids ( table_name varchar(64) DEFAULT '' NOT NULL, field_name varchar(64) DEFAULT '' NOT NULL, nextid bigint NOT NULL, PRIMARY KEY (table_name,field_name) ); CREATE TABLE alerts ( alertid bigint NOT NULL, actionid bigint NOT NULL, eventid bigint NOT NULL, userid bigint NULL, clock integer DEFAULT '0' NOT NULL, mediatypeid bigint NULL, sendto varchar(1024) DEFAULT '' NOT NULL, subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, retries integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, esc_step integer DEFAULT '0' NOT NULL, alerttype integer DEFAULT '0' NOT NULL, p_eventid bigint NULL, acknowledgeid bigint NULL, parameters text DEFAULT '{}' NOT NULL, PRIMARY KEY (alertid) ); CREATE INDEX alerts_1 ON alerts (actionid); CREATE INDEX alerts_2 ON alerts (clock); CREATE INDEX alerts_3 ON alerts (eventid); CREATE INDEX alerts_4 ON alerts (status); CREATE INDEX alerts_5 ON alerts (mediatypeid); CREATE INDEX alerts_6 ON alerts (userid); CREATE INDEX alerts_7 ON alerts (p_eventid); CREATE INDEX alerts_8 ON alerts (acknowledgeid); CREATE TABLE history ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE history_uint ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value numeric(20) DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE history_str ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE history_log ( itemid bigint 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, logeventid integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE history_text ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value text DEFAULT '' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE history_bin ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, value bytea DEFAULT '' NOT NULL, PRIMARY KEY (itemid,clock,ns) ); CREATE TABLE proxy_history ( id bigint NOT NULL, itemid bigint 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, logeventid integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, lastlogsize numeric(20) DEFAULT '0' NOT NULL, mtime integer DEFAULT '0' NOT NULL, flags integer DEFAULT '0' NOT NULL, write_clock integer DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); CREATE INDEX proxy_history_2 ON proxy_history (write_clock); CREATE TABLE proxy_dhistory ( id bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, druleid bigint NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, port integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, dcheckid bigint NULL, dns varchar(255) DEFAULT '' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (id) ); CREATE INDEX proxy_dhistory_1 ON proxy_dhistory (clock); CREATE INDEX proxy_dhistory_2 ON proxy_dhistory (druleid); CREATE TABLE events ( eventid bigint NOT NULL, source integer DEFAULT '0' NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, value integer DEFAULT '0' NOT NULL, acknowledged integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, name varchar(2048) DEFAULT '' NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (eventid) ); CREATE INDEX events_1 ON events (source,object,objectid,clock); CREATE INDEX events_2 ON events (source,object,clock); CREATE TABLE event_symptom ( eventid bigint NOT NULL, cause_eventid bigint NOT NULL, PRIMARY KEY (eventid) ); CREATE INDEX event_symptom_1 ON event_symptom (cause_eventid); CREATE TABLE trends ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, num integer DEFAULT '0' NOT NULL, value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL, PRIMARY KEY (itemid,clock) ); CREATE TABLE trends_uint ( itemid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, num integer DEFAULT '0' NOT NULL, value_min numeric(20) DEFAULT '0' NOT NULL, value_avg numeric(20) DEFAULT '0' NOT NULL, value_max numeric(20) DEFAULT '0' NOT NULL, PRIMARY KEY (itemid,clock) ); CREATE TABLE acknowledges ( acknowledgeid bigint NOT NULL, userid bigint NOT NULL, eventid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, message varchar(2048) DEFAULT '' NOT NULL, action integer DEFAULT '0' NOT NULL, old_severity integer DEFAULT '0' NOT NULL, new_severity integer DEFAULT '0' NOT NULL, suppress_until integer DEFAULT '0' NOT NULL, taskid bigint NULL, PRIMARY KEY (acknowledgeid) ); CREATE INDEX acknowledges_1 ON acknowledges (userid); CREATE INDEX acknowledges_2 ON acknowledges (eventid); CREATE INDEX acknowledges_3 ON acknowledges (clock); CREATE TABLE auditlog ( auditid varchar(25) NOT NULL, userid bigint NULL, username varchar(100) DEFAULT '' NOT NULL, clock integer DEFAULT '0' NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, action integer DEFAULT '0' NOT NULL, resourcetype integer DEFAULT '0' NOT NULL, resourceid bigint NULL, resource_cuid varchar(25) NULL, resourcename varchar(255) DEFAULT '' NOT NULL, recordsetid varchar(25) NOT NULL, details text DEFAULT '' NOT NULL, PRIMARY KEY (auditid) ); CREATE INDEX auditlog_1 ON auditlog (userid,clock); CREATE INDEX auditlog_2 ON auditlog (clock); CREATE INDEX auditlog_3 ON auditlog (resourcetype,resourceid); CREATE INDEX auditlog_4 ON auditlog (recordsetid); CREATE INDEX auditlog_5 ON auditlog (ip); CREATE TABLE service_alarms ( servicealarmid bigint NOT NULL, serviceid bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, value integer DEFAULT '-1' NOT NULL, PRIMARY KEY (servicealarmid) ); CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock); CREATE INDEX service_alarms_2 ON service_alarms (clock); CREATE TABLE autoreg_host ( autoreg_hostid bigint NOT NULL, proxyid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, listen_ip varchar(39) DEFAULT '' NOT NULL, listen_port integer DEFAULT '0' NOT NULL, listen_dns varchar(255) DEFAULT '' NOT NULL, host_metadata text DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, tls_accepted integer DEFAULT '1' NOT NULL, PRIMARY KEY (autoreg_hostid) ); CREATE INDEX autoreg_host_1 ON autoreg_host (host); CREATE INDEX autoreg_host_2 ON autoreg_host (proxyid); CREATE TABLE proxy_autoreg_host ( id bigint NOT NULL, clock integer DEFAULT '0' NOT NULL, host varchar(128) DEFAULT '' NOT NULL, listen_ip varchar(39) DEFAULT '' NOT NULL, listen_port integer DEFAULT '0' NOT NULL, listen_dns varchar(255) DEFAULT '' NOT NULL, host_metadata text DEFAULT '' NOT NULL, flags integer DEFAULT '0' NOT NULL, tls_accepted integer DEFAULT '1' NOT NULL, PRIMARY KEY (id) ); CREATE INDEX proxy_autoreg_host_1 ON proxy_autoreg_host (clock); CREATE TABLE dhosts ( dhostid bigint NOT NULL, druleid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, lastdown integer DEFAULT '0' NOT NULL, PRIMARY KEY (dhostid) ); CREATE INDEX dhosts_1 ON dhosts (druleid); CREATE TABLE dservices ( dserviceid bigint NOT NULL, dhostid bigint NOT NULL, value varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, lastup integer DEFAULT '0' NOT NULL, lastdown integer DEFAULT '0' NOT NULL, dcheckid bigint NOT NULL, ip varchar(39) DEFAULT '' NOT NULL, dns varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (dserviceid) ); CREATE UNIQUE INDEX dservices_1 ON dservices (dcheckid,ip,port); CREATE INDEX dservices_2 ON dservices (dhostid); CREATE TABLE escalations ( escalationid bigint NOT NULL, actionid bigint NOT NULL, triggerid bigint NULL, eventid bigint NULL, r_eventid bigint NULL, nextcheck integer DEFAULT '0' NOT NULL, esc_step integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, itemid bigint NULL, acknowledgeid bigint NULL, servicealarmid bigint NULL, serviceid bigint NULL, PRIMARY KEY (escalationid) ); CREATE UNIQUE INDEX escalations_1 ON escalations (triggerid,itemid,serviceid,escalationid); CREATE INDEX escalations_2 ON escalations (eventid); CREATE INDEX escalations_3 ON escalations (nextcheck); CREATE TABLE globalvars ( name varchar(64) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (name) ); CREATE TABLE graph_discovery ( graphid bigint NOT NULL, parent_graphid bigint NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (graphid) ); CREATE INDEX graph_discovery_1 ON graph_discovery (parent_graphid); CREATE TABLE host_inventory ( hostid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, type varchar(64) DEFAULT '' NOT NULL, type_full varchar(64) DEFAULT '' NOT NULL, name varchar(128) DEFAULT '' NOT NULL, alias varchar(128) DEFAULT '' NOT NULL, os varchar(128) DEFAULT '' NOT NULL, os_full varchar(255) DEFAULT '' NOT NULL, os_short varchar(128) DEFAULT '' NOT NULL, serialno_a varchar(64) DEFAULT '' NOT NULL, serialno_b varchar(64) DEFAULT '' NOT NULL, tag varchar(64) DEFAULT '' NOT NULL, asset_tag varchar(64) DEFAULT '' NOT NULL, macaddress_a varchar(64) DEFAULT '' NOT NULL, macaddress_b varchar(64) DEFAULT '' NOT NULL, hardware varchar(255) DEFAULT '' NOT NULL, hardware_full text DEFAULT '' NOT NULL, software varchar(255) DEFAULT '' NOT NULL, software_full text DEFAULT '' NOT NULL, software_app_a varchar(64) DEFAULT '' NOT NULL, software_app_b varchar(64) DEFAULT '' NOT NULL, software_app_c varchar(64) DEFAULT '' NOT NULL, software_app_d varchar(64) DEFAULT '' NOT NULL, software_app_e varchar(64) DEFAULT '' NOT NULL, contact text DEFAULT '' NOT NULL, location text DEFAULT '' NOT NULL, location_lat varchar(16) DEFAULT '' NOT NULL, location_lon varchar(16) DEFAULT '' NOT NULL, notes text DEFAULT '' NOT NULL, chassis varchar(64) DEFAULT '' NOT NULL, model varchar(64) DEFAULT '' NOT NULL, hw_arch varchar(32) DEFAULT '' NOT NULL, vendor varchar(64) DEFAULT '' NOT NULL, contract_number varchar(64) DEFAULT '' NOT NULL, installer_name varchar(64) DEFAULT '' NOT NULL, deployment_status varchar(64) DEFAULT '' NOT NULL, url_a varchar(2048) DEFAULT '' NOT NULL, url_b varchar(2048) DEFAULT '' NOT NULL, url_c varchar(2048) DEFAULT '' NOT NULL, host_networks text DEFAULT '' NOT NULL, host_netmask varchar(39) DEFAULT '' NOT NULL, host_router varchar(39) DEFAULT '' NOT NULL, oob_ip varchar(39) DEFAULT '' NOT NULL, oob_netmask varchar(39) DEFAULT '' NOT NULL, oob_router varchar(39) DEFAULT '' NOT NULL, date_hw_purchase varchar(64) DEFAULT '' NOT NULL, date_hw_install varchar(64) DEFAULT '' NOT NULL, date_hw_expiry varchar(64) DEFAULT '' NOT NULL, date_hw_decomm varchar(64) DEFAULT '' NOT NULL, site_address_a varchar(128) DEFAULT '' NOT NULL, site_address_b varchar(128) DEFAULT '' NOT NULL, site_address_c varchar(128) DEFAULT '' NOT NULL, site_city varchar(128) DEFAULT '' NOT NULL, site_state varchar(64) DEFAULT '' NOT NULL, site_country varchar(64) DEFAULT '' NOT NULL, site_zip varchar(64) DEFAULT '' NOT NULL, site_rack varchar(128) DEFAULT '' NOT NULL, site_notes text DEFAULT '' NOT NULL, poc_1_name varchar(128) DEFAULT '' NOT NULL, poc_1_email varchar(128) DEFAULT '' NOT NULL, poc_1_phone_a varchar(64) DEFAULT '' NOT NULL, poc_1_phone_b varchar(64) DEFAULT '' NOT NULL, poc_1_cell varchar(64) DEFAULT '' NOT NULL, poc_1_screen varchar(64) DEFAULT '' NOT NULL, poc_1_notes text DEFAULT '' NOT NULL, poc_2_name varchar(128) DEFAULT '' NOT NULL, poc_2_email varchar(128) DEFAULT '' NOT NULL, poc_2_phone_a varchar(64) DEFAULT '' NOT NULL, poc_2_phone_b varchar(64) DEFAULT '' NOT NULL, poc_2_cell varchar(64) DEFAULT '' NOT NULL, poc_2_screen varchar(64) DEFAULT '' NOT NULL, poc_2_notes text DEFAULT '' NOT NULL, PRIMARY KEY (hostid) ); CREATE TABLE housekeeper ( housekeeperid bigint NOT NULL, tablename varchar(64) DEFAULT '' NOT NULL, field varchar(64) DEFAULT '' NOT NULL, value bigint NOT NULL, PRIMARY KEY (housekeeperid) ); CREATE TABLE images ( imageid bigint NOT NULL, imagetype integer DEFAULT '0' NOT NULL, name varchar(64) DEFAULT '0' NOT NULL, image bytea DEFAULT '' NOT NULL, PRIMARY KEY (imageid) ); CREATE UNIQUE INDEX images_1 ON images (name); CREATE TABLE item_discovery ( itemdiscoveryid bigint NOT NULL, itemid bigint NOT NULL, parent_itemid bigint NULL, key_ varchar(2048) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, disable_source integer DEFAULT '0' NOT NULL, ts_disable integer DEFAULT '0' NOT NULL, lldruleid bigint NULL, PRIMARY KEY (itemdiscoveryid) ); CREATE UNIQUE INDEX item_discovery_1 ON item_discovery (itemid,parent_itemid); CREATE INDEX item_discovery_2 ON item_discovery (parent_itemid); CREATE INDEX item_discovery_3 ON item_discovery (lldruleid); CREATE TABLE host_discovery ( hostid bigint NOT NULL, parent_hostid bigint NULL, lldruleid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, disable_source integer DEFAULT '0' NOT NULL, ts_disable integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); CREATE INDEX host_discovery_1 ON host_discovery (parent_hostid); CREATE INDEX host_discovery_2 ON host_discovery (lldruleid); CREATE TABLE interface_discovery ( interfaceid bigint NOT NULL, parent_interfaceid bigint NOT NULL, PRIMARY KEY (interfaceid) ); CREATE INDEX interface_discovery_1 ON interface_discovery (parent_interfaceid); CREATE TABLE profiles ( profileid bigint NOT NULL, userid bigint NOT NULL, idx varchar(96) DEFAULT '' NOT NULL, idx2 bigint DEFAULT '0' NOT NULL, value_id bigint DEFAULT '0' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str text DEFAULT '' NOT NULL, source varchar(96) DEFAULT '' NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (profileid) ); CREATE INDEX profiles_1 ON profiles (userid,idx,idx2); CREATE INDEX profiles_2 ON profiles (userid,profileid); CREATE TABLE sessions ( sessionid varchar(32) DEFAULT '' NOT NULL, userid bigint NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, secret varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (sessionid) ); CREATE INDEX sessions_1 ON sessions (userid,status,lastaccess); CREATE TABLE trigger_discovery ( triggerid bigint NOT NULL, parent_triggerid bigint NOT NULL, lastcheck integer DEFAULT '0' NOT NULL, ts_delete integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, disable_source integer DEFAULT '0' NOT NULL, ts_disable integer DEFAULT '0' NOT NULL, PRIMARY KEY (triggerid) ); CREATE INDEX trigger_discovery_1 ON trigger_discovery (parent_triggerid); CREATE TABLE item_condition ( item_conditionid bigint NOT NULL, itemid bigint NOT NULL, operator integer DEFAULT '8' NOT NULL, macro varchar(64) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (item_conditionid) ); CREATE INDEX item_condition_1 ON item_condition (itemid); CREATE TABLE item_rtdata ( itemid bigint NOT NULL, lastlogsize numeric(20) DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, mtime integer DEFAULT '0' NOT NULL, error varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (itemid) ); CREATE TABLE item_rtname ( itemid bigint NOT NULL, name_resolved varchar(2048) DEFAULT '' NOT NULL, name_resolved_upper varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (itemid) ); CREATE TABLE opinventory ( operationid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, PRIMARY KEY (operationid) ); CREATE TABLE trigger_tag ( triggertagid bigint NOT NULL, triggerid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (triggertagid) ); CREATE INDEX trigger_tag_1 ON trigger_tag (triggerid); CREATE TABLE event_tag ( eventtagid bigint NOT NULL, eventid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (eventtagid) ); CREATE INDEX event_tag_1 ON event_tag (eventid); CREATE TABLE problem ( eventid bigint NOT NULL, source integer DEFAULT '0' NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, r_eventid bigint NULL, r_clock integer DEFAULT '0' NOT NULL, r_ns integer DEFAULT '0' NOT NULL, correlationid bigint NULL, userid bigint NULL, name varchar(2048) DEFAULT '' NOT NULL, acknowledged integer DEFAULT '0' NOT NULL, severity integer DEFAULT '0' NOT NULL, cause_eventid bigint NULL, PRIMARY KEY (eventid) ); CREATE INDEX problem_1 ON problem (source,object,objectid); CREATE INDEX problem_2 ON problem (r_clock); CREATE INDEX problem_3 ON problem (r_eventid); CREATE INDEX problem_4 ON problem (cause_eventid); CREATE TABLE problem_tag ( problemtagid bigint NOT NULL, eventid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (problemtagid) ); CREATE INDEX problem_tag_1 ON problem_tag (eventid,tag,value); CREATE TABLE tag_filter ( tag_filterid bigint NOT NULL, usrgrpid bigint NOT NULL, groupid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (tag_filterid) ); CREATE INDEX tag_filter_1 ON tag_filter (usrgrpid); CREATE INDEX tag_filter_2 ON tag_filter (groupid); CREATE TABLE event_recovery ( eventid bigint NOT NULL, r_eventid bigint NOT NULL, c_eventid bigint NULL, correlationid bigint NULL, userid bigint NULL, PRIMARY KEY (eventid) ); CREATE INDEX event_recovery_1 ON event_recovery (r_eventid); CREATE INDEX event_recovery_2 ON event_recovery (c_eventid); CREATE TABLE correlation ( correlationid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (correlationid) ); CREATE INDEX correlation_1 ON correlation (status); CREATE UNIQUE INDEX correlation_2 ON correlation (name); CREATE TABLE corr_condition ( corr_conditionid bigint NOT NULL, correlationid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (corr_conditionid) ); CREATE INDEX corr_condition_1 ON corr_condition (correlationid); CREATE TABLE corr_condition_tag ( corr_conditionid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); CREATE TABLE corr_condition_group ( corr_conditionid bigint NOT NULL, operator integer DEFAULT '0' NOT NULL, groupid bigint NOT NULL, PRIMARY KEY (corr_conditionid) ); CREATE INDEX corr_condition_group_1 ON corr_condition_group (groupid); CREATE TABLE corr_condition_tagpair ( corr_conditionid bigint NOT NULL, oldtag varchar(255) DEFAULT '' NOT NULL, newtag varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); CREATE TABLE corr_condition_tagvalue ( corr_conditionid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (corr_conditionid) ); CREATE TABLE corr_operation ( corr_operationid bigint NOT NULL, correlationid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, PRIMARY KEY (corr_operationid) ); CREATE INDEX corr_operation_1 ON corr_operation (correlationid); CREATE TABLE task ( taskid bigint NOT NULL, type integer NOT NULL, status integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ttl integer DEFAULT '0' NOT NULL, proxyid bigint NULL, PRIMARY KEY (taskid) ); CREATE INDEX task_1 ON task (status,proxyid); CREATE INDEX task_2 ON task (proxyid); CREATE TABLE task_close_problem ( taskid bigint NOT NULL, acknowledgeid bigint NOT NULL, PRIMARY KEY (taskid) ); CREATE TABLE item_preproc ( item_preprocid bigint NOT NULL, itemid bigint NOT NULL, step integer DEFAULT '0' NOT NULL, type integer DEFAULT '0' NOT NULL, params text DEFAULT '' NOT NULL, error_handler integer DEFAULT '0' NOT NULL, error_handler_params varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (item_preprocid) ); CREATE INDEX item_preproc_1 ON item_preproc (itemid,step); CREATE TABLE task_remote_command ( taskid bigint NOT NULL, command_type integer DEFAULT '0' NOT NULL, execute_on integer DEFAULT '0' NOT NULL, port integer DEFAULT '0' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(64) DEFAULT '' NOT NULL, password varchar(64) DEFAULT '' NOT NULL, publickey varchar(64) DEFAULT '' NOT NULL, privatekey varchar(64) DEFAULT '' NOT NULL, command text DEFAULT '' NOT NULL, alertid bigint NULL, parent_taskid bigint NOT NULL, hostid bigint NOT NULL, PRIMARY KEY (taskid) ); CREATE TABLE task_remote_command_result ( taskid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, parent_taskid bigint NOT NULL, info text DEFAULT '' NOT NULL, PRIMARY KEY (taskid) ); CREATE TABLE task_data ( taskid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, data text DEFAULT '' NOT NULL, parent_taskid bigint NULL, PRIMARY KEY (taskid) ); CREATE TABLE task_result ( taskid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, parent_taskid bigint NOT NULL, info text DEFAULT '' NOT NULL, PRIMARY KEY (taskid) ); CREATE INDEX task_result_1 ON task_result (parent_taskid); CREATE TABLE task_acknowledge ( taskid bigint NOT NULL, acknowledgeid bigint NOT NULL, PRIMARY KEY (taskid) ); CREATE TABLE sysmap_shape ( sysmap_shapeid bigint NOT NULL, sysmapid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, width integer DEFAULT '200' NOT NULL, height integer DEFAULT '200' NOT NULL, text text DEFAULT '' NOT NULL, font integer DEFAULT '9' NOT NULL, font_size integer DEFAULT '11' NOT NULL, font_color varchar(6) DEFAULT '000000' NOT NULL, text_halign integer DEFAULT '0' NOT NULL, text_valign integer DEFAULT '0' NOT NULL, border_type integer DEFAULT '0' NOT NULL, border_width integer DEFAULT '1' NOT NULL, border_color varchar(6) DEFAULT '000000' NOT NULL, background_color varchar(6) DEFAULT '' NOT NULL, zindex integer DEFAULT '0' NOT NULL, PRIMARY KEY (sysmap_shapeid) ); CREATE INDEX sysmap_shape_1 ON sysmap_shape (sysmapid); CREATE TABLE sysmap_element_trigger ( selement_triggerid bigint NOT NULL, selementid bigint NOT NULL, triggerid bigint NOT NULL, PRIMARY KEY (selement_triggerid) ); CREATE UNIQUE INDEX sysmap_element_trigger_1 ON sysmap_element_trigger (selementid,triggerid); CREATE INDEX sysmap_element_trigger_2 ON sysmap_element_trigger (triggerid); CREATE TABLE httptest_field ( httptest_fieldid bigint NOT NULL, httptestid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (httptest_fieldid) ); CREATE INDEX httptest_field_1 ON httptest_field (httptestid); CREATE TABLE httpstep_field ( httpstep_fieldid bigint NOT NULL, httpstepid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (httpstep_fieldid) ); CREATE INDEX httpstep_field_1 ON httpstep_field (httpstepid); CREATE TABLE dashboard ( dashboardid bigint NOT NULL, name varchar(255) NOT NULL, userid bigint NULL, private integer DEFAULT '1' NOT NULL, templateid bigint NULL, display_period integer DEFAULT '30' NOT NULL, auto_start integer DEFAULT '1' NOT NULL, uuid varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (dashboardid) ); CREATE INDEX dashboard_1 ON dashboard (userid); CREATE INDEX dashboard_2 ON dashboard (templateid); CREATE INDEX dashboard_3 ON dashboard (uuid); CREATE TABLE dashboard_user ( dashboard_userid bigint NOT NULL, dashboardid bigint NOT NULL, userid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (dashboard_userid) ); CREATE UNIQUE INDEX dashboard_user_1 ON dashboard_user (dashboardid,userid); CREATE INDEX dashboard_user_2 ON dashboard_user (userid); CREATE TABLE dashboard_usrgrp ( dashboard_usrgrpid bigint NOT NULL, dashboardid bigint NOT NULL, usrgrpid bigint NOT NULL, permission integer DEFAULT '2' NOT NULL, PRIMARY KEY (dashboard_usrgrpid) ); CREATE UNIQUE INDEX dashboard_usrgrp_1 ON dashboard_usrgrp (dashboardid,usrgrpid); CREATE INDEX dashboard_usrgrp_2 ON dashboard_usrgrp (usrgrpid); CREATE TABLE dashboard_page ( dashboard_pageid bigint NOT NULL, dashboardid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, display_period integer DEFAULT '0' NOT NULL, sortorder integer DEFAULT '0' NOT NULL, PRIMARY KEY (dashboard_pageid) ); CREATE INDEX dashboard_page_1 ON dashboard_page (dashboardid); CREATE TABLE widget ( widgetid bigint NOT NULL, type varchar(255) DEFAULT '' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, x integer DEFAULT '0' NOT NULL, y integer DEFAULT '0' NOT NULL, width integer DEFAULT '1' NOT NULL, height integer DEFAULT '2' NOT NULL, view_mode integer DEFAULT '0' NOT NULL, dashboard_pageid bigint NOT NULL, PRIMARY KEY (widgetid) ); CREATE INDEX widget_1 ON widget (dashboard_pageid); CREATE TABLE widget_field ( widget_fieldid bigint NOT NULL, widgetid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str varchar(2048) DEFAULT '' NOT NULL, value_groupid bigint NULL, value_hostid bigint NULL, value_itemid bigint NULL, value_graphid bigint NULL, value_sysmapid bigint NULL, value_serviceid bigint NULL, value_slaid bigint NULL, value_userid bigint NULL, value_actionid bigint NULL, value_mediatypeid bigint NULL, PRIMARY KEY (widget_fieldid) ); CREATE INDEX widget_field_1 ON widget_field (widgetid); CREATE INDEX widget_field_2 ON widget_field (value_groupid); CREATE INDEX widget_field_3 ON widget_field (value_hostid); CREATE INDEX widget_field_4 ON widget_field (value_itemid); CREATE INDEX widget_field_5 ON widget_field (value_graphid); CREATE INDEX widget_field_6 ON widget_field (value_sysmapid); CREATE INDEX widget_field_7 ON widget_field (value_serviceid); CREATE INDEX widget_field_8 ON widget_field (value_slaid); CREATE INDEX widget_field_9 ON widget_field (value_userid); CREATE INDEX widget_field_10 ON widget_field (value_actionid); CREATE INDEX widget_field_11 ON widget_field (value_mediatypeid); CREATE TABLE task_check_now ( taskid bigint NOT NULL, itemid bigint NOT NULL, PRIMARY KEY (taskid) ); CREATE TABLE event_suppress ( event_suppressid bigint NOT NULL, eventid bigint NOT NULL, maintenanceid bigint NULL, suppress_until integer DEFAULT '0' NOT NULL, userid bigint NULL, PRIMARY KEY (event_suppressid) ); CREATE UNIQUE INDEX event_suppress_1 ON event_suppress (eventid,maintenanceid); CREATE INDEX event_suppress_2 ON event_suppress (suppress_until); CREATE INDEX event_suppress_3 ON event_suppress (maintenanceid); CREATE INDEX event_suppress_4 ON event_suppress (userid); CREATE TABLE maintenance_tag ( maintenancetagid bigint NOT NULL, maintenanceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '2' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (maintenancetagid) ); CREATE INDEX maintenance_tag_1 ON maintenance_tag (maintenanceid); CREATE TABLE lld_macro_path ( lld_macro_pathid bigint NOT NULL, itemid bigint NOT NULL, lld_macro varchar(255) DEFAULT '' NOT NULL, path varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_macro_pathid) ); CREATE UNIQUE INDEX lld_macro_path_1 ON lld_macro_path (itemid,lld_macro); CREATE TABLE host_tag ( hosttagid bigint NOT NULL, hostid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, automatic integer DEFAULT '0' NOT NULL, PRIMARY KEY (hosttagid) ); CREATE INDEX host_tag_1 ON host_tag (hostid); CREATE TABLE config_autoreg_tls ( autoreg_tlsid bigint NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, PRIMARY KEY (autoreg_tlsid) ); CREATE UNIQUE INDEX config_autoreg_tls_1 ON config_autoreg_tls (tls_psk_identity); CREATE TABLE module ( moduleid bigint NOT NULL, id varchar(255) DEFAULT '' NOT NULL, relative_path varchar(255) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, config text DEFAULT '' NOT NULL, PRIMARY KEY (moduleid) ); CREATE TABLE interface_snmp ( interfaceid bigint NOT NULL, version integer DEFAULT '2' NOT NULL, bulk integer DEFAULT '1' NOT NULL, community varchar(64) DEFAULT '' NOT NULL, securityname varchar(64) DEFAULT '' NOT NULL, securitylevel integer DEFAULT '0' NOT NULL, authpassphrase varchar(64) DEFAULT '' NOT NULL, privpassphrase varchar(64) DEFAULT '' NOT NULL, authprotocol integer DEFAULT '0' NOT NULL, privprotocol integer DEFAULT '0' NOT NULL, contextname varchar(255) DEFAULT '' NOT NULL, max_repetitions integer DEFAULT '10' NOT NULL, PRIMARY KEY (interfaceid) ); CREATE TABLE lld_override ( lld_overrideid bigint NOT NULL, itemid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, step integer DEFAULT '0' NOT NULL, evaltype integer DEFAULT '0' NOT NULL, formula varchar(255) DEFAULT '' NOT NULL, stop integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_overrideid) ); CREATE UNIQUE INDEX lld_override_1 ON lld_override (itemid,name); CREATE TABLE lld_override_condition ( lld_override_conditionid bigint NOT NULL, lld_overrideid bigint NOT NULL, operator integer DEFAULT '8' NOT NULL, macro varchar(64) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_conditionid) ); CREATE INDEX lld_override_condition_1 ON lld_override_condition (lld_overrideid); CREATE TABLE lld_override_operation ( lld_override_operationid bigint NOT NULL, lld_overrideid bigint NOT NULL, operationobject integer DEFAULT '0' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE INDEX lld_override_operation_1 ON lld_override_operation (lld_overrideid); CREATE TABLE lld_override_opstatus ( lld_override_operationid bigint NOT NULL, status integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_opdiscover ( lld_override_operationid bigint NOT NULL, discover integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_opperiod ( lld_override_operationid bigint NOT NULL, delay varchar(1024) DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_ophistory ( lld_override_operationid bigint NOT NULL, history varchar(255) DEFAULT '31d' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_optrends ( lld_override_operationid bigint NOT NULL, trends varchar(255) DEFAULT '365d' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_opseverity ( lld_override_operationid bigint NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE lld_override_optag ( lld_override_optagid bigint NOT NULL, lld_override_operationid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (lld_override_optagid) ); CREATE INDEX lld_override_optag_1 ON lld_override_optag (lld_override_operationid); CREATE TABLE lld_override_optemplate ( lld_override_optemplateid bigint NOT NULL, lld_override_operationid bigint NOT NULL, templateid bigint NOT NULL, PRIMARY KEY (lld_override_optemplateid) ); CREATE UNIQUE INDEX lld_override_optemplate_1 ON lld_override_optemplate (lld_override_operationid,templateid); CREATE INDEX lld_override_optemplate_2 ON lld_override_optemplate (templateid); CREATE TABLE lld_override_opinventory ( lld_override_operationid bigint NOT NULL, inventory_mode integer DEFAULT '0' NOT NULL, PRIMARY KEY (lld_override_operationid) ); CREATE TABLE trigger_queue ( trigger_queueid bigint NOT NULL, objectid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, ns integer DEFAULT '0' NOT NULL, PRIMARY KEY (trigger_queueid) ); CREATE TABLE item_parameter ( item_parameterid bigint NOT NULL, itemid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (item_parameterid) ); CREATE INDEX item_parameter_1 ON item_parameter (itemid); CREATE TABLE role_rule ( role_ruleid bigint NOT NULL, roleid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_str varchar(255) DEFAULT '' NOT NULL, value_moduleid bigint NULL, value_serviceid bigint NULL, PRIMARY KEY (role_ruleid) ); CREATE INDEX role_rule_1 ON role_rule (roleid); CREATE INDEX role_rule_2 ON role_rule (value_moduleid); CREATE INDEX role_rule_3 ON role_rule (value_serviceid); CREATE TABLE token ( tokenid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, userid bigint NOT NULL, token varchar(128) NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, expires_at integer DEFAULT '0' NOT NULL, created_at integer DEFAULT '0' NOT NULL, creator_userid bigint NULL, PRIMARY KEY (tokenid) ); CREATE INDEX token_1 ON token (name); CREATE UNIQUE INDEX token_2 ON token (userid,name); CREATE UNIQUE INDEX token_3 ON token (token); CREATE INDEX token_4 ON token (creator_userid); CREATE TABLE item_tag ( itemtagid bigint NOT NULL, itemid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (itemtagid) ); CREATE INDEX item_tag_1 ON item_tag (itemid); CREATE TABLE httptest_tag ( httptesttagid bigint NOT NULL, httptestid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (httptesttagid) ); CREATE INDEX httptest_tag_1 ON httptest_tag (httptestid); CREATE TABLE sysmaps_element_tag ( selementtagid bigint NOT NULL, selementid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, PRIMARY KEY (selementtagid) ); CREATE INDEX sysmaps_element_tag_1 ON sysmaps_element_tag (selementid); CREATE TABLE report ( reportid bigint NOT NULL, userid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description varchar(2048) DEFAULT '' NOT NULL, status integer DEFAULT '0' NOT NULL, dashboardid bigint NOT NULL, period integer DEFAULT '0' NOT NULL, cycle integer DEFAULT '0' NOT NULL, weekdays integer DEFAULT '0' NOT NULL, start_time integer DEFAULT '0' NOT NULL, active_since integer DEFAULT '0' NOT NULL, active_till integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, lastsent integer DEFAULT '0' NOT NULL, info varchar(2048) DEFAULT '' NOT NULL, PRIMARY KEY (reportid) ); CREATE UNIQUE INDEX report_1 ON report (name); CREATE INDEX report_2 ON report (userid); CREATE INDEX report_3 ON report (dashboardid); CREATE TABLE report_param ( reportparamid bigint NOT NULL, reportid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (reportparamid) ); CREATE INDEX report_param_1 ON report_param (reportid); CREATE TABLE report_user ( reportuserid bigint NOT NULL, reportid bigint NOT NULL, userid bigint NOT NULL, exclude integer DEFAULT '0' NOT NULL, access_userid bigint NULL, PRIMARY KEY (reportuserid) ); CREATE INDEX report_user_1 ON report_user (reportid); CREATE INDEX report_user_2 ON report_user (userid); CREATE INDEX report_user_3 ON report_user (access_userid); CREATE TABLE report_usrgrp ( reportusrgrpid bigint NOT NULL, reportid bigint NOT NULL, usrgrpid bigint NOT NULL, access_userid bigint NULL, PRIMARY KEY (reportusrgrpid) ); CREATE INDEX report_usrgrp_1 ON report_usrgrp (reportid); CREATE INDEX report_usrgrp_2 ON report_usrgrp (usrgrpid); CREATE INDEX report_usrgrp_3 ON report_usrgrp (access_userid); CREATE TABLE service_problem_tag ( service_problem_tagid bigint NOT NULL, serviceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (service_problem_tagid) ); CREATE INDEX service_problem_tag_1 ON service_problem_tag (serviceid); CREATE TABLE service_problem ( service_problemid bigint NOT NULL, eventid bigint NOT NULL, serviceid bigint NOT NULL, severity integer DEFAULT '0' NOT NULL, PRIMARY KEY (service_problemid) ); CREATE INDEX service_problem_1 ON service_problem (eventid); CREATE INDEX service_problem_2 ON service_problem (serviceid); CREATE TABLE service_tag ( servicetagid bigint NOT NULL, serviceid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (servicetagid) ); CREATE INDEX service_tag_1 ON service_tag (serviceid); CREATE TABLE service_status_rule ( service_status_ruleid bigint NOT NULL, serviceid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, limit_value integer DEFAULT '0' NOT NULL, limit_status integer DEFAULT '0' NOT NULL, new_status integer DEFAULT '0' NOT NULL, PRIMARY KEY (service_status_ruleid) ); CREATE INDEX service_status_rule_1 ON service_status_rule (serviceid); CREATE TABLE ha_node ( ha_nodeid varchar(25) NOT NULL, name varchar(255) DEFAULT '' NOT NULL, address varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '10051' NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, status integer DEFAULT '0' NOT NULL, ha_sessionid varchar(25) DEFAULT '' NOT NULL, PRIMARY KEY (ha_nodeid) ); CREATE UNIQUE INDEX ha_node_1 ON ha_node (name); CREATE INDEX ha_node_2 ON ha_node (status,lastaccess); CREATE TABLE sla ( slaid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, period integer DEFAULT '0' NOT NULL, slo DOUBLE PRECISION DEFAULT '99.9' NOT NULL, effective_date integer DEFAULT '0' NOT NULL, timezone varchar(50) DEFAULT 'UTC' NOT NULL, status integer DEFAULT '1' NOT NULL, description text DEFAULT '' NOT NULL, PRIMARY KEY (slaid) ); CREATE UNIQUE INDEX sla_1 ON sla (name); CREATE TABLE sla_schedule ( sla_scheduleid bigint NOT NULL, slaid bigint NOT NULL, period_from integer DEFAULT '0' NOT NULL, period_to integer DEFAULT '0' NOT NULL, PRIMARY KEY (sla_scheduleid) ); CREATE INDEX sla_schedule_1 ON sla_schedule (slaid); CREATE TABLE sla_excluded_downtime ( sla_excluded_downtimeid bigint NOT NULL, slaid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, period_from integer DEFAULT '0' NOT NULL, period_to integer DEFAULT '0' NOT NULL, PRIMARY KEY (sla_excluded_downtimeid) ); CREATE INDEX sla_excluded_downtime_1 ON sla_excluded_downtime (slaid); CREATE TABLE sla_service_tag ( sla_service_tagid bigint NOT NULL, slaid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (sla_service_tagid) ); CREATE INDEX sla_service_tag_1 ON sla_service_tag (slaid); CREATE TABLE host_rtdata ( hostid bigint NOT NULL, active_available integer DEFAULT '0' NOT NULL, PRIMARY KEY (hostid) ); CREATE TABLE userdirectory ( userdirectoryid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, idp_type integer DEFAULT '1' NOT NULL, provision_status integer DEFAULT '0' NOT NULL, PRIMARY KEY (userdirectoryid) ); CREATE INDEX userdirectory_1 ON userdirectory (idp_type); CREATE TABLE userdirectory_ldap ( userdirectoryid bigint NOT NULL, host varchar(255) DEFAULT '' NOT NULL, port integer DEFAULT '389' NOT NULL, base_dn varchar(255) DEFAULT '' NOT NULL, search_attribute varchar(128) DEFAULT '' NOT NULL, bind_dn varchar(255) DEFAULT '' NOT NULL, bind_password varchar(128) DEFAULT '' NOT NULL, start_tls integer DEFAULT '0' NOT NULL, search_filter varchar(255) DEFAULT '' NOT NULL, group_basedn varchar(255) DEFAULT '' NOT NULL, group_name varchar(255) DEFAULT '' NOT NULL, group_member varchar(255) DEFAULT '' NOT NULL, user_ref_attr varchar(255) DEFAULT '' NOT NULL, group_filter varchar(255) DEFAULT '' NOT NULL, group_membership varchar(255) DEFAULT '' NOT NULL, user_username varchar(255) DEFAULT '' NOT NULL, user_lastname varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (userdirectoryid) ); CREATE TABLE userdirectory_saml ( userdirectoryid bigint NOT NULL, idp_entityid varchar(1024) DEFAULT '' NOT NULL, sso_url varchar(2048) DEFAULT '' NOT NULL, slo_url varchar(2048) DEFAULT '' NOT NULL, username_attribute varchar(128) DEFAULT '' NOT NULL, sp_entityid varchar(1024) DEFAULT '' NOT NULL, nameid_format varchar(2048) DEFAULT '' NOT NULL, sign_messages integer DEFAULT '0' NOT NULL, sign_assertions integer DEFAULT '0' NOT NULL, sign_authn_requests integer DEFAULT '0' NOT NULL, sign_logout_requests integer DEFAULT '0' NOT NULL, sign_logout_responses integer DEFAULT '0' NOT NULL, encrypt_nameid integer DEFAULT '0' NOT NULL, encrypt_assertions integer DEFAULT '0' NOT NULL, group_name varchar(255) DEFAULT '' NOT NULL, user_username varchar(255) DEFAULT '' NOT NULL, user_lastname varchar(255) DEFAULT '' NOT NULL, scim_status integer DEFAULT '0' NOT NULL, PRIMARY KEY (userdirectoryid) ); CREATE TABLE userdirectory_media ( userdirectory_mediaid bigint NOT NULL, userdirectoryid bigint NOT NULL, mediatypeid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, attribute varchar(255) DEFAULT '' NOT NULL, active integer DEFAULT '0' NOT NULL, severity integer DEFAULT '63' NOT NULL, period varchar(1024) DEFAULT '1-7,00:00-24:00' NOT NULL, PRIMARY KEY (userdirectory_mediaid) ); CREATE INDEX userdirectory_media_1 ON userdirectory_media (userdirectoryid); CREATE INDEX userdirectory_media_2 ON userdirectory_media (mediatypeid); CREATE TABLE userdirectory_usrgrp ( userdirectory_usrgrpid bigint NOT NULL, userdirectory_idpgroupid bigint NOT NULL, usrgrpid bigint NOT NULL, PRIMARY KEY (userdirectory_usrgrpid) ); CREATE UNIQUE INDEX userdirectory_usrgrp_1 ON userdirectory_usrgrp (userdirectory_idpgroupid,usrgrpid); CREATE INDEX userdirectory_usrgrp_2 ON userdirectory_usrgrp (usrgrpid); CREATE TABLE userdirectory_idpgroup ( userdirectory_idpgroupid bigint NOT NULL, userdirectoryid bigint NOT NULL, roleid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (userdirectory_idpgroupid) ); CREATE INDEX userdirectory_idpgroup_1 ON userdirectory_idpgroup (userdirectoryid); CREATE INDEX userdirectory_idpgroup_2 ON userdirectory_idpgroup (roleid); CREATE TABLE changelog ( changelogid bigserial NOT NULL, object integer DEFAULT '0' NOT NULL, objectid bigint NOT NULL, operation integer DEFAULT '0' NOT NULL, clock integer DEFAULT '0' NOT NULL, PRIMARY KEY (changelogid) ); CREATE INDEX changelog_1 ON changelog (clock); CREATE TABLE scim_group ( scim_groupid bigint NOT NULL, name varchar(64) DEFAULT '' NOT NULL, PRIMARY KEY (scim_groupid) ); CREATE UNIQUE INDEX scim_group_1 ON scim_group (name); CREATE TABLE user_scim_group ( user_scim_groupid bigint NOT NULL, userid bigint NOT NULL, scim_groupid bigint NOT NULL, PRIMARY KEY (user_scim_groupid) ); CREATE INDEX user_scim_group_1 ON user_scim_group (userid); CREATE INDEX user_scim_group_2 ON user_scim_group (scim_groupid); CREATE TABLE connector ( connectorid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, protocol integer DEFAULT '0' NOT NULL, data_type integer DEFAULT '0' NOT NULL, url varchar(2048) DEFAULT '' NOT NULL, max_records integer DEFAULT '0' NOT NULL, max_senders integer DEFAULT '1' NOT NULL, max_attempts integer DEFAULT '1' NOT NULL, timeout varchar(255) DEFAULT '5s' NOT NULL, http_proxy varchar(255) DEFAULT '' NOT NULL, authtype integer DEFAULT '0' NOT NULL, username varchar(255) DEFAULT '' NOT NULL, password varchar(255) DEFAULT '' NOT NULL, token varchar(128) DEFAULT '' NOT NULL, verify_peer integer DEFAULT '1' NOT NULL, verify_host integer DEFAULT '1' NOT NULL, ssl_cert_file varchar(255) DEFAULT '' NOT NULL, ssl_key_file varchar(255) DEFAULT '' NOT NULL, ssl_key_password varchar(64) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, status integer DEFAULT '1' NOT NULL, tags_evaltype integer DEFAULT '0' NOT NULL, item_value_type integer DEFAULT '31' NOT NULL, attempt_interval varchar(32) DEFAULT '5s' NOT NULL, PRIMARY KEY (connectorid) ); CREATE UNIQUE INDEX connector_1 ON connector (name); CREATE TABLE connector_tag ( connector_tagid bigint NOT NULL, connectorid bigint NOT NULL, tag varchar(255) DEFAULT '' NOT NULL, operator integer DEFAULT '0' NOT NULL, value varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (connector_tagid) ); CREATE INDEX connector_tag_1 ON connector_tag (connectorid); CREATE TABLE proxy ( proxyid bigint NOT NULL, name varchar(128) DEFAULT '' NOT NULL, operating_mode integer DEFAULT '0' NOT NULL, description text DEFAULT '' NOT NULL, tls_connect integer DEFAULT '1' NOT NULL, tls_accept integer DEFAULT '1' NOT NULL, tls_issuer varchar(1024) DEFAULT '' NOT NULL, tls_subject varchar(1024) DEFAULT '' NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, allowed_addresses varchar(255) DEFAULT '' NOT NULL, address varchar(255) DEFAULT '127.0.0.1' NOT NULL, port varchar(64) DEFAULT '10051' NOT NULL, custom_timeouts integer DEFAULT '0' NOT NULL, timeout_zabbix_agent varchar(255) DEFAULT '' NOT NULL, timeout_simple_check varchar(255) DEFAULT '' NOT NULL, timeout_snmp_agent varchar(255) DEFAULT '' NOT NULL, timeout_external_check varchar(255) DEFAULT '' NOT NULL, timeout_db_monitor varchar(255) DEFAULT '' NOT NULL, timeout_http_agent varchar(255) DEFAULT '' NOT NULL, timeout_ssh_agent varchar(255) DEFAULT '' NOT NULL, timeout_telnet_agent varchar(255) DEFAULT '' NOT NULL, timeout_script varchar(255) DEFAULT '' NOT NULL, local_address varchar(255) DEFAULT '' NOT NULL, local_port varchar(64) DEFAULT '10051' NOT NULL, proxy_groupid bigint NULL, timeout_browser varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (proxyid) ); CREATE UNIQUE INDEX proxy_1 ON proxy (name); CREATE INDEX proxy_2 ON proxy (proxy_groupid); CREATE TABLE proxy_rtdata ( proxyid bigint NOT NULL, lastaccess integer DEFAULT '0' NOT NULL, version integer DEFAULT '0' NOT NULL, compatibility integer DEFAULT '0' NOT NULL, state integer DEFAULT '0' NOT NULL, PRIMARY KEY (proxyid) ); CREATE TABLE proxy_group ( proxy_groupid bigint NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description text DEFAULT '' NOT NULL, failover_delay varchar(255) DEFAULT '1m' NOT NULL, min_online varchar(255) DEFAULT '1' NOT NULL, PRIMARY KEY (proxy_groupid) ); CREATE TABLE proxy_group_rtdata ( proxy_groupid bigint NOT NULL, state integer DEFAULT '0' NOT NULL, PRIMARY KEY (proxy_groupid) ); CREATE TABLE host_proxy ( hostproxyid bigint NOT NULL, hostid bigint NULL, host varchar(128) DEFAULT '' NOT NULL, proxyid bigint NULL, revision numeric(20) DEFAULT '0' NOT NULL, tls_accept integer DEFAULT '1' NOT NULL, tls_issuer varchar(1024) DEFAULT '' NOT NULL, tls_subject varchar(1024) DEFAULT '' NOT NULL, tls_psk_identity varchar(128) DEFAULT '' NOT NULL, tls_psk varchar(512) DEFAULT '' NOT NULL, PRIMARY KEY (hostproxyid) ); CREATE UNIQUE INDEX host_proxy_1 ON host_proxy (hostid); CREATE INDEX host_proxy_2 ON host_proxy (proxyid); CREATE INDEX host_proxy_3 ON host_proxy (revision); CREATE TABLE mfa ( mfaid bigint NOT NULL, type integer DEFAULT '0' NOT NULL, name varchar(128) DEFAULT '' NOT NULL, hash_function integer DEFAULT '1' NULL, code_length integer DEFAULT '6' NULL, api_hostname varchar(1024) DEFAULT '' NULL, clientid varchar(32) DEFAULT '' NULL, client_secret varchar(64) DEFAULT '' NULL, PRIMARY KEY (mfaid) ); CREATE UNIQUE INDEX mfa_1 ON mfa (name); CREATE TABLE mfa_totp_secret ( mfa_totp_secretid bigint NOT NULL, mfaid bigint NOT NULL, userid bigint NOT NULL, totp_secret varchar(32) DEFAULT '' NULL, status integer DEFAULT '0' NOT NULL, used_codes varchar(32) DEFAULT '' NOT NULL, PRIMARY KEY (mfa_totp_secretid) ); CREATE INDEX mfa_totp_secret_1 ON mfa_totp_secret (mfaid); CREATE INDEX mfa_totp_secret_2 ON mfa_totp_secret (userid); CREATE TABLE settings ( name varchar(255) NOT NULL, type integer NOT NULL, value_str text DEFAULT '' NOT NULL, value_int integer DEFAULT '0' NOT NULL, value_usrgrpid bigint NULL, value_hostgroupid bigint NULL, value_userdirectoryid bigint NULL, value_mfaid bigint NULL, PRIMARY KEY (name) ); CREATE INDEX settings_2 ON settings (value_usrgrpid); CREATE INDEX settings_3 ON settings (value_hostgroupid); CREATE INDEX settings_4 ON settings (value_userdirectoryid); CREATE INDEX settings_5 ON settings (value_mfaid); CREATE TABLE lld_macro_export ( lld_macro_exportid bigint NOT NULL, itemid bigint NOT NULL, lld_macro varchar(255) DEFAULT '' NOT NULL, value text DEFAULT '' NOT NULL, PRIMARY KEY (lld_macro_exportid) ); CREATE INDEX lld_macro_export_1 ON lld_macro_export (itemid); CREATE TABLE dbversion ( dbversionid bigint NOT NULL, mandatory integer DEFAULT '0' NOT NULL, optional integer DEFAULT '0' NOT NULL, PRIMARY KEY (dbversionid) ); INSERT INTO dbversion VALUES ('1','7040000','7040009'); create or replace function changelog_hosts_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (1,new.hostid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger hosts_insert after insert on hosts for each row execute procedure changelog_hosts_insert(); create or replace function changelog_hosts_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (1,old.hostid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger hosts_update after update on hosts for each row execute procedure changelog_hosts_update(); create or replace function changelog_hosts_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (1,old.hostid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger hosts_delete before delete on hosts for each row execute procedure changelog_hosts_delete(); create or replace function hosts_name_upper_upper() returns trigger language plpgsql as $func$ begin update hosts set name_upper=upper(name) where hostid=new.hostid; return null; end $func$; create trigger hosts_name_upper_insert after insert on hosts for each row execute function hosts_name_upper_upper(); create trigger hosts_name_upper_update after update of name on hosts for each row execute function hosts_name_upper_upper(); create or replace function changelog_drules_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (9,new.druleid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger drules_insert after insert on drules for each row execute procedure changelog_drules_insert(); create or replace function changelog_drules_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (9,old.druleid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger drules_update after update on drules for each row execute procedure changelog_drules_update(); create or replace function changelog_drules_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (9,old.druleid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger drules_delete before delete on drules for each row execute procedure changelog_drules_delete(); create or replace function changelog_dchecks_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (10,new.dcheckid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger dchecks_insert after insert on dchecks for each row execute procedure changelog_dchecks_insert(); create or replace function changelog_dchecks_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (10,old.dcheckid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger dchecks_update after update on dchecks for each row execute procedure changelog_dchecks_update(); create or replace function changelog_dchecks_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (10,old.dcheckid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger dchecks_delete before delete on dchecks for each row execute procedure changelog_dchecks_delete(); create or replace function changelog_httptest_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (11,new.httptestid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptest_insert after insert on httptest for each row execute procedure changelog_httptest_insert(); create or replace function changelog_httptest_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (11,old.httptestid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptest_update after update on httptest for each row execute procedure changelog_httptest_update(); create or replace function changelog_httptest_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (11,old.httptestid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httptest_delete before delete on httptest for each row execute procedure changelog_httptest_delete(); create or replace function changelog_httpstep_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (14,new.httpstepid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstep_insert after insert on httpstep for each row execute procedure changelog_httpstep_insert(); create or replace function changelog_httpstep_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (14,old.httpstepid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstep_update after update on httpstep for each row execute procedure changelog_httpstep_update(); create or replace function changelog_httpstep_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (14,old.httpstepid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httpstep_delete before delete on httpstep for each row execute procedure changelog_httpstep_delete(); create or replace function changelog_items_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (3,new.itemid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger items_insert after insert on items for each row execute procedure changelog_items_insert(); create or replace function changelog_items_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (3,old.itemid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger items_update after update on items for each row execute procedure changelog_items_update(); create or replace function changelog_items_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (3,old.itemid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger items_delete before delete on items for each row execute procedure changelog_items_delete(); create or replace function changelog_httpstepitem_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (16,new.httpstepitemid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstepitem_insert after insert on httpstepitem for each row execute procedure changelog_httpstepitem_insert(); create or replace function changelog_httpstepitem_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (16,old.httpstepitemid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstepitem_update after update on httpstepitem for each row execute procedure changelog_httpstepitem_update(); create or replace function changelog_httpstepitem_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (16,old.httpstepitemid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httpstepitem_delete before delete on httpstepitem for each row execute procedure changelog_httpstepitem_delete(); create or replace function changelog_httptestitem_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (13,new.httptestitemid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptestitem_insert after insert on httptestitem for each row execute procedure changelog_httptestitem_insert(); create or replace function changelog_httptestitem_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (13,old.httptestitemid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptestitem_update after update on httptestitem for each row execute procedure changelog_httptestitem_update(); create or replace function changelog_httptestitem_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (13,old.httptestitemid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httptestitem_delete before delete on httptestitem for each row execute procedure changelog_httptestitem_delete(); create or replace function changelog_triggers_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (5,new.triggerid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger triggers_insert after insert on triggers for each row execute procedure changelog_triggers_insert(); create or replace function changelog_triggers_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (5,old.triggerid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger triggers_update after update on triggers for each row execute procedure changelog_triggers_update(); create or replace function changelog_triggers_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (5,old.triggerid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger triggers_delete before delete on triggers for each row execute procedure changelog_triggers_delete(); create or replace function changelog_functions_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (7,new.functionid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger functions_insert after insert on functions for each row execute procedure changelog_functions_insert(); create or replace function changelog_functions_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (7,old.functionid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger functions_update after update on functions for each row execute procedure changelog_functions_update(); create or replace function changelog_functions_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (7,old.functionid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger functions_delete before delete on functions for each row execute procedure changelog_functions_delete(); create or replace function changelog_trigger_tag_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (6,new.triggertagid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger trigger_tag_insert after insert on trigger_tag for each row execute procedure changelog_trigger_tag_insert(); create or replace function changelog_trigger_tag_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (6,old.triggertagid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger trigger_tag_update after update on trigger_tag for each row execute procedure changelog_trigger_tag_update(); create or replace function changelog_trigger_tag_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (6,old.triggertagid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger trigger_tag_delete before delete on trigger_tag for each row execute procedure changelog_trigger_tag_delete(); create or replace function changelog_item_preproc_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (8,new.item_preprocid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger item_preproc_insert after insert on item_preproc for each row execute procedure changelog_item_preproc_insert(); create or replace function changelog_item_preproc_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (8,old.item_preprocid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger item_preproc_update after update on item_preproc for each row execute procedure changelog_item_preproc_update(); create or replace function changelog_item_preproc_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (8,old.item_preprocid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger item_preproc_delete before delete on item_preproc for each row execute procedure changelog_item_preproc_delete(); create or replace function changelog_httptest_field_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (12,new.httptest_fieldid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptest_field_insert after insert on httptest_field for each row execute procedure changelog_httptest_field_insert(); create or replace function changelog_httptest_field_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (12,old.httptest_fieldid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httptest_field_update after update on httptest_field for each row execute procedure changelog_httptest_field_update(); create or replace function changelog_httptest_field_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (12,old.httptest_fieldid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httptest_field_delete before delete on httptest_field for each row execute procedure changelog_httptest_field_delete(); create or replace function changelog_httpstep_field_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (15,new.httpstep_fieldid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstep_field_insert after insert on httpstep_field for each row execute procedure changelog_httpstep_field_insert(); create or replace function changelog_httpstep_field_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (15,old.httpstep_fieldid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger httpstep_field_update after update on httpstep_field for each row execute procedure changelog_httpstep_field_update(); create or replace function changelog_httpstep_field_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (15,old.httpstep_fieldid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger httpstep_field_delete before delete on httpstep_field for each row execute procedure changelog_httpstep_field_delete(); create or replace function changelog_host_tag_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (2,new.hosttagid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger host_tag_insert after insert on host_tag for each row execute procedure changelog_host_tag_insert(); create or replace function changelog_host_tag_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (2,old.hosttagid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger host_tag_update after update on host_tag for each row execute procedure changelog_host_tag_update(); create or replace function changelog_host_tag_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (2,old.hosttagid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger host_tag_delete before delete on host_tag for each row execute procedure changelog_host_tag_delete(); create or replace function changelog_item_tag_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (4,new.itemtagid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger item_tag_insert after insert on item_tag for each row execute procedure changelog_item_tag_insert(); create or replace function changelog_item_tag_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (4,old.itemtagid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger item_tag_update after update on item_tag for each row execute procedure changelog_item_tag_update(); create or replace function changelog_item_tag_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (4,old.itemtagid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger item_tag_delete before delete on item_tag for each row execute procedure changelog_item_tag_delete(); create or replace function changelog_connector_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (17,new.connectorid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger connector_insert after insert on connector for each row execute procedure changelog_connector_insert(); create or replace function changelog_connector_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (17,old.connectorid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger connector_update after update on connector for each row execute procedure changelog_connector_update(); create or replace function changelog_connector_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (17,old.connectorid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger connector_delete before delete on connector for each row execute procedure changelog_connector_delete(); create or replace function changelog_connector_tag_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (18,new.connector_tagid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger connector_tag_insert after insert on connector_tag for each row execute procedure changelog_connector_tag_insert(); create or replace function changelog_connector_tag_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (18,old.connector_tagid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger connector_tag_update after update on connector_tag for each row execute procedure changelog_connector_tag_update(); create or replace function changelog_connector_tag_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (18,old.connector_tagid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger connector_tag_delete before delete on connector_tag for each row execute procedure changelog_connector_tag_delete(); create or replace function changelog_proxy_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (19,new.proxyid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger proxy_insert after insert on proxy for each row execute procedure changelog_proxy_insert(); create or replace function changelog_proxy_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (19,old.proxyid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger proxy_update after update on proxy for each row execute procedure changelog_proxy_update(); create or replace function changelog_proxy_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (19,old.proxyid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger proxy_delete before delete on proxy for each row execute procedure changelog_proxy_delete(); create or replace function changelog_proxy_group_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (20,new.proxy_groupid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger proxy_group_insert after insert on proxy_group for each row execute procedure changelog_proxy_group_insert(); create or replace function changelog_proxy_group_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (20,old.proxy_groupid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger proxy_group_update after update on proxy_group for each row execute procedure changelog_proxy_group_update(); create or replace function changelog_proxy_group_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (20,old.proxy_groupid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger proxy_group_delete before delete on proxy_group for each row execute procedure changelog_proxy_group_delete(); create or replace function changelog_host_proxy_insert() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (21,new.hostproxyid,1,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger host_proxy_insert after insert on host_proxy for each row execute procedure changelog_host_proxy_insert(); create or replace function changelog_host_proxy_update() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (21,old.hostproxyid,2,cast(extract(epoch from now()) as int)); return new; end; $$ language plpgsql; create trigger host_proxy_update after update on host_proxy for each row execute procedure changelog_host_proxy_update(); create or replace function changelog_host_proxy_delete() returns trigger as $$ begin insert into changelog (object,objectid,operation,clock) values (21,old.hostproxyid,3,cast(extract(epoch from now()) as int)); return old; end; $$ language plpgsql; create trigger host_proxy_delete before delete on host_proxy for each row execute procedure changelog_host_proxy_delete(); ALTER TABLE ONLY users ADD CONSTRAINT c_users_1 FOREIGN KEY (roleid) REFERENCES role (roleid) ON DELETE CASCADE; ALTER TABLE ONLY users ADD CONSTRAINT c_users_2 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid); ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_1 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid); ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_2 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid); ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_3 FOREIGN KEY (templateid) REFERENCES hosts (hostid); ALTER TABLE ONLY hosts ADD CONSTRAINT c_hosts_4 FOREIGN KEY (proxy_groupid) REFERENCES proxy_group (proxy_groupid); ALTER TABLE ONLY hgset_group ADD CONSTRAINT c_hgset_group_1 FOREIGN KEY (hgsetid) REFERENCES hgset (hgsetid) ON DELETE CASCADE; ALTER TABLE ONLY hgset_group ADD CONSTRAINT c_hgset_group_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY host_hgset ADD CONSTRAINT c_host_hgset_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY host_hgset ADD CONSTRAINT c_host_hgset_2 FOREIGN KEY (hgsetid) REFERENCES hgset (hgsetid); ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY group_prototype ADD CONSTRAINT c_group_prototype_3 FOREIGN KEY (templateid) REFERENCES group_prototype (group_prototypeid) ON DELETE CASCADE; ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_1 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY group_discovery ADD CONSTRAINT c_group_discovery_2 FOREIGN KEY (parent_group_prototypeid) REFERENCES group_prototype (group_prototypeid); ALTER TABLE ONLY drules ADD CONSTRAINT c_drules_1 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid); ALTER TABLE ONLY dchecks ADD CONSTRAINT c_dchecks_1 FOREIGN KEY (druleid) REFERENCES drules (druleid); ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY httptest ADD CONSTRAINT c_httptest_3 FOREIGN KEY (templateid) REFERENCES httptest (httptestid); ALTER TABLE ONLY httpstep ADD CONSTRAINT c_httpstep_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid); ALTER TABLE ONLY interface ADD CONSTRAINT c_interface_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY valuemap ADD CONSTRAINT c_valuemap_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY items ADD CONSTRAINT c_items_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY items ADD CONSTRAINT c_items_2 FOREIGN KEY (templateid) REFERENCES items (itemid); ALTER TABLE ONLY items ADD CONSTRAINT c_items_3 FOREIGN KEY (valuemapid) REFERENCES valuemap (valuemapid); ALTER TABLE ONLY items ADD CONSTRAINT c_items_4 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid); ALTER TABLE ONLY items ADD CONSTRAINT c_items_5 FOREIGN KEY (master_itemid) REFERENCES items (itemid); ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_1 FOREIGN KEY (httpstepid) REFERENCES httpstep (httpstepid); ALTER TABLE ONLY httpstepitem ADD CONSTRAINT c_httpstepitem_2 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid); ALTER TABLE ONLY httptestitem ADD CONSTRAINT c_httptestitem_2 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY media_type_oauth ADD CONSTRAINT c_media_type_oauth_1 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY media_type_param ADD CONSTRAINT c_media_type_param_1 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY media_type_message ADD CONSTRAINT c_media_type_message_1 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY usrgrp ADD CONSTRAINT c_usrgrp_2 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid); ALTER TABLE ONLY usrgrp ADD CONSTRAINT c_usrgrp_3 FOREIGN KEY (mfaid) REFERENCES mfa (mfaid); ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY users_groups ADD CONSTRAINT c_users_groups_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY ugset_group ADD CONSTRAINT c_ugset_group_1 FOREIGN KEY (ugsetid) REFERENCES ugset (ugsetid) ON DELETE CASCADE; ALTER TABLE ONLY ugset_group ADD CONSTRAINT c_ugset_group_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid); ALTER TABLE ONLY user_ugset ADD CONSTRAINT c_user_ugset_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY user_ugset ADD CONSTRAINT c_user_ugset_2 FOREIGN KEY (ugsetid) REFERENCES ugset (ugsetid); ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid); ALTER TABLE ONLY scripts ADD CONSTRAINT c_scripts_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY script_param ADD CONSTRAINT c_script_param_1 FOREIGN KEY (scriptid) REFERENCES scripts (scriptid) ON DELETE CASCADE; ALTER TABLE ONLY operations ADD CONSTRAINT c_operations_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; ALTER TABLE ONLY optag ADD CONSTRAINT c_optag_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opmessage ADD CONSTRAINT c_opmessage_2 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid); ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opmessage_grp ADD CONSTRAINT c_opmessage_grp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid); ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opmessage_usr ADD CONSTRAINT c_opmessage_usr_2 FOREIGN KEY (userid) REFERENCES users (userid); ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opcommand ADD CONSTRAINT c_opcommand_2 FOREIGN KEY (scriptid) REFERENCES scripts (scriptid); ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opcommand_hst ADD CONSTRAINT c_opcommand_hst_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opcommand_grp ADD CONSTRAINT c_opcommand_grp_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY opgroup ADD CONSTRAINT c_opgroup_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY optemplate ADD CONSTRAINT c_optemplate_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid); ALTER TABLE ONLY opconditions ADD CONSTRAINT c_opconditions_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY conditions ADD CONSTRAINT c_conditions_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; ALTER TABLE ONLY triggers ADD CONSTRAINT c_triggers_1 FOREIGN KEY (templateid) REFERENCES triggers (triggerid); ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_1 FOREIGN KEY (triggerid_down) REFERENCES triggers (triggerid) ON DELETE CASCADE; ALTER TABLE ONLY trigger_depends ADD CONSTRAINT c_trigger_depends_2 FOREIGN KEY (triggerid_up) REFERENCES triggers (triggerid) ON DELETE CASCADE; ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_1 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY functions ADD CONSTRAINT c_functions_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid); ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_1 FOREIGN KEY (templateid) REFERENCES graphs (graphid) ON DELETE CASCADE; ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_2 FOREIGN KEY (ymin_itemid) REFERENCES items (itemid); ALTER TABLE ONLY graphs ADD CONSTRAINT c_graphs_3 FOREIGN KEY (ymax_itemid) REFERENCES items (itemid); ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_1 FOREIGN KEY (graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; ALTER TABLE ONLY graphs_items ADD CONSTRAINT c_graphs_items_2 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY hostmacro ADD CONSTRAINT c_hostmacro_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY hostmacro_config ADD CONSTRAINT c_hostmacro_config_1 FOREIGN KEY (hostmacroid) REFERENCES hostmacro (hostmacroid) ON DELETE CASCADE; ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY hosts_groups ADD CONSTRAINT c_hosts_groups_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY hosts_templates ADD CONSTRAINT c_hosts_templates_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY valuemap_mapping ADD CONSTRAINT c_valuemap_mapping_1 FOREIGN KEY (valuemapid) REFERENCES valuemap (valuemapid) ON DELETE CASCADE; ALTER TABLE ONLY media ADD CONSTRAINT c_media_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY media ADD CONSTRAINT c_media_2 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY media ADD CONSTRAINT c_media_3 FOREIGN KEY (userdirectory_mediaid) REFERENCES userdirectory_media (userdirectory_mediaid) ON DELETE CASCADE; ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_1 FOREIGN KEY (groupid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY rights ADD CONSTRAINT c_rights_2 FOREIGN KEY (id) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY permission ADD CONSTRAINT c_permission_1 FOREIGN KEY (ugsetid) REFERENCES ugset (ugsetid) ON DELETE CASCADE; ALTER TABLE ONLY permission ADD CONSTRAINT c_permission_2 FOREIGN KEY (hgsetid) REFERENCES hgset (hgsetid) ON DELETE CASCADE; ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_1 FOREIGN KEY (serviceupid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY services_links ADD CONSTRAINT c_services_links_2 FOREIGN KEY (servicedownid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY icon_map ADD CONSTRAINT c_icon_map_1 FOREIGN KEY (default_iconid) REFERENCES images (imageid); ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_1 FOREIGN KEY (iconmapid) REFERENCES icon_map (iconmapid) ON DELETE CASCADE; ALTER TABLE ONLY icon_mapping ADD CONSTRAINT c_icon_mapping_2 FOREIGN KEY (iconid) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_1 FOREIGN KEY (backgroundid) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_2 FOREIGN KEY (iconmapid) REFERENCES icon_map (iconmapid); ALTER TABLE ONLY sysmaps ADD CONSTRAINT c_sysmaps_3 FOREIGN KEY (userid) REFERENCES users (userid); ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_2 FOREIGN KEY (iconid_off) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_3 FOREIGN KEY (iconid_on) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_4 FOREIGN KEY (iconid_disabled) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps_elements ADD CONSTRAINT c_sysmaps_elements_5 FOREIGN KEY (iconid_maintenance) REFERENCES images (imageid); ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_2 FOREIGN KEY (selementid1) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_3 FOREIGN KEY (selementid2) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_links ADD CONSTRAINT c_sysmaps_links_4 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_1 FOREIGN KEY (linkid) REFERENCES sysmaps_links (linkid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_link_triggers ADD CONSTRAINT c_sysmaps_link_triggers_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_link_threshold ADD CONSTRAINT c_sysmap_link_threshold_1 FOREIGN KEY (linkid) REFERENCES sysmaps_links (linkid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_element_url ADD CONSTRAINT c_sysmap_element_url_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_url ADD CONSTRAINT c_sysmap_url_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_user ADD CONSTRAINT c_sysmap_user_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_user ADD CONSTRAINT c_sysmap_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_usrgrp ADD CONSTRAINT c_sysmap_usrgrp_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_usrgrp ADD CONSTRAINT c_sysmap_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_hosts ADD CONSTRAINT c_maintenances_hosts_2 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_groups ADD CONSTRAINT c_maintenances_groups_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; ALTER TABLE ONLY maintenances_windows ADD CONSTRAINT c_maintenances_windows_2 FOREIGN KEY (timeperiodid) REFERENCES timeperiods (timeperiodid) ON DELETE CASCADE; ALTER TABLE ONLY expressions ADD CONSTRAINT c_expressions_1 FOREIGN KEY (regexpid) REFERENCES regexps (regexpid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_1 FOREIGN KEY (actionid) REFERENCES actions (actionid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_2 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_3 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_4 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_5 FOREIGN KEY (p_eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY alerts ADD CONSTRAINT c_alerts_6 FOREIGN KEY (acknowledgeid) REFERENCES acknowledges (acknowledgeid) ON DELETE CASCADE; ALTER TABLE ONLY event_symptom ADD CONSTRAINT c_event_symptom_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY event_symptom ADD CONSTRAINT c_event_symptom_2 FOREIGN KEY (cause_eventid) REFERENCES events (eventid); ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY acknowledges ADD CONSTRAINT c_acknowledges_2 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY service_alarms ADD CONSTRAINT c_service_alarms_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY autoreg_host ADD CONSTRAINT c_autoreg_host_1 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid) ON DELETE CASCADE; ALTER TABLE ONLY dhosts ADD CONSTRAINT c_dhosts_1 FOREIGN KEY (druleid) REFERENCES drules (druleid) ON DELETE CASCADE; ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_1 FOREIGN KEY (dhostid) REFERENCES dhosts (dhostid) ON DELETE CASCADE; ALTER TABLE ONLY dservices ADD CONSTRAINT c_dservices_2 FOREIGN KEY (dcheckid) REFERENCES dchecks (dcheckid) ON DELETE CASCADE; ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_1 FOREIGN KEY (graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; ALTER TABLE ONLY graph_discovery ADD CONSTRAINT c_graph_discovery_2 FOREIGN KEY (parent_graphid) REFERENCES graphs (graphid); ALTER TABLE ONLY host_inventory ADD CONSTRAINT c_host_inventory_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_2 FOREIGN KEY (parent_itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY item_discovery ADD CONSTRAINT c_item_discovery_3 FOREIGN KEY (lldruleid) REFERENCES items (itemid); ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_2 FOREIGN KEY (parent_hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY host_discovery ADD CONSTRAINT c_host_discovery_3 FOREIGN KEY (lldruleid) REFERENCES items (itemid); ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_1 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; ALTER TABLE ONLY interface_discovery ADD CONSTRAINT c_interface_discovery_2 FOREIGN KEY (parent_interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; ALTER TABLE ONLY profiles ADD CONSTRAINT c_profiles_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY sessions ADD CONSTRAINT c_sessions_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_1 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; ALTER TABLE ONLY trigger_discovery ADD CONSTRAINT c_trigger_discovery_2 FOREIGN KEY (parent_triggerid) REFERENCES triggers (triggerid); ALTER TABLE ONLY item_condition ADD CONSTRAINT c_item_condition_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY item_rtdata ADD CONSTRAINT c_item_rtdata_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY item_rtname ADD CONSTRAINT c_item_rtname_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY opinventory ADD CONSTRAINT c_opinventory_1 FOREIGN KEY (operationid) REFERENCES operations (operationid) ON DELETE CASCADE; ALTER TABLE ONLY trigger_tag ADD CONSTRAINT c_trigger_tag_1 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid); ALTER TABLE ONLY event_tag ADD CONSTRAINT c_event_tag_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY problem ADD CONSTRAINT c_problem_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY problem ADD CONSTRAINT c_problem_2 FOREIGN KEY (r_eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY problem ADD CONSTRAINT c_problem_3 FOREIGN KEY (cause_eventid) REFERENCES events (eventid); ALTER TABLE ONLY problem_tag ADD CONSTRAINT c_problem_tag_1 FOREIGN KEY (eventid) REFERENCES problem (eventid) ON DELETE CASCADE; ALTER TABLE ONLY tag_filter ADD CONSTRAINT c_tag_filter_1 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY tag_filter ADD CONSTRAINT c_tag_filter_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_2 FOREIGN KEY (r_eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY event_recovery ADD CONSTRAINT c_event_recovery_3 FOREIGN KEY (c_eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY corr_condition ADD CONSTRAINT c_corr_condition_1 FOREIGN KEY (correlationid) REFERENCES correlation (correlationid) ON DELETE CASCADE; ALTER TABLE ONLY corr_condition_tag ADD CONSTRAINT c_corr_condition_tag_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; ALTER TABLE ONLY corr_condition_group ADD CONSTRAINT c_corr_condition_group_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; ALTER TABLE ONLY corr_condition_group ADD CONSTRAINT c_corr_condition_group_2 FOREIGN KEY (groupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY corr_condition_tagpair ADD CONSTRAINT c_corr_condition_tagpair_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; ALTER TABLE ONLY corr_condition_tagvalue ADD CONSTRAINT c_corr_condition_tagvalue_1 FOREIGN KEY (corr_conditionid) REFERENCES corr_condition (corr_conditionid) ON DELETE CASCADE; ALTER TABLE ONLY corr_operation ADD CONSTRAINT c_corr_operation_1 FOREIGN KEY (correlationid) REFERENCES correlation (correlationid) ON DELETE CASCADE; ALTER TABLE ONLY task ADD CONSTRAINT c_task_1 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid) ON DELETE CASCADE; ALTER TABLE ONLY task_close_problem ADD CONSTRAINT c_task_close_problem_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY item_preproc ADD CONSTRAINT c_item_preproc_1 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY task_remote_command ADD CONSTRAINT c_task_remote_command_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY task_remote_command_result ADD CONSTRAINT c_task_remote_command_result_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY task_data ADD CONSTRAINT c_task_data_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY task_result ADD CONSTRAINT c_task_result_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY task_acknowledge ADD CONSTRAINT c_task_acknowledge_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_shape ADD CONSTRAINT c_sysmap_shape_1 FOREIGN KEY (sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_element_trigger ADD CONSTRAINT c_sysmap_element_trigger_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; ALTER TABLE ONLY sysmap_element_trigger ADD CONSTRAINT c_sysmap_element_trigger_2 FOREIGN KEY (triggerid) REFERENCES triggers (triggerid) ON DELETE CASCADE; ALTER TABLE ONLY httptest_field ADD CONSTRAINT c_httptest_field_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid); ALTER TABLE ONLY httpstep_field ADD CONSTRAINT c_httpstep_field_1 FOREIGN KEY (httpstepid) REFERENCES httpstep (httpstepid); ALTER TABLE ONLY dashboard ADD CONSTRAINT c_dashboard_1 FOREIGN KEY (userid) REFERENCES users (userid); ALTER TABLE ONLY dashboard ADD CONSTRAINT c_dashboard_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY dashboard_user ADD CONSTRAINT c_dashboard_user_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; ALTER TABLE ONLY dashboard_user ADD CONSTRAINT c_dashboard_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY dashboard_usrgrp ADD CONSTRAINT c_dashboard_usrgrp_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; ALTER TABLE ONLY dashboard_usrgrp ADD CONSTRAINT c_dashboard_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY dashboard_page ADD CONSTRAINT c_dashboard_page_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; ALTER TABLE ONLY widget ADD CONSTRAINT c_widget_1 FOREIGN KEY (dashboard_pageid) REFERENCES dashboard_page (dashboard_pageid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_1 FOREIGN KEY (widgetid) REFERENCES widget (widgetid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_2 FOREIGN KEY (value_groupid) REFERENCES hstgrp (groupid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_3 FOREIGN KEY (value_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_4 FOREIGN KEY (value_itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_5 FOREIGN KEY (value_graphid) REFERENCES graphs (graphid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_6 FOREIGN KEY (value_sysmapid) REFERENCES sysmaps (sysmapid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_7 FOREIGN KEY (value_serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_8 FOREIGN KEY (value_slaid) REFERENCES sla (slaid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_9 FOREIGN KEY (value_userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_10 FOREIGN KEY (value_actionid) REFERENCES actions (actionid) ON DELETE CASCADE; ALTER TABLE ONLY widget_field ADD CONSTRAINT c_widget_field_11 FOREIGN KEY (value_mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY task_check_now ADD CONSTRAINT c_task_check_now_1 FOREIGN KEY (taskid) REFERENCES task (taskid) ON DELETE CASCADE; ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_1 FOREIGN KEY (eventid) REFERENCES events (eventid) ON DELETE CASCADE; ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_2 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; ALTER TABLE ONLY event_suppress ADD CONSTRAINT c_event_suppress_3 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY maintenance_tag ADD CONSTRAINT c_maintenance_tag_1 FOREIGN KEY (maintenanceid) REFERENCES maintenances (maintenanceid) ON DELETE CASCADE; ALTER TABLE ONLY lld_macro_path ADD CONSTRAINT c_lld_macro_path_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY host_tag ADD CONSTRAINT c_host_tag_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY interface_snmp ADD CONSTRAINT c_interface_snmp_1 FOREIGN KEY (interfaceid) REFERENCES interface (interfaceid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override ADD CONSTRAINT c_lld_override_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_condition ADD CONSTRAINT c_lld_override_condition_1 FOREIGN KEY (lld_overrideid) REFERENCES lld_override (lld_overrideid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_operation ADD CONSTRAINT c_lld_override_operation_1 FOREIGN KEY (lld_overrideid) REFERENCES lld_override (lld_overrideid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_opstatus ADD CONSTRAINT c_lld_override_opstatus_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_opdiscover ADD CONSTRAINT c_lld_override_opdiscover_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_opperiod ADD CONSTRAINT c_lld_override_opperiod_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_ophistory ADD CONSTRAINT c_lld_override_ophistory_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_optrends ADD CONSTRAINT c_lld_override_optrends_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_opseverity ADD CONSTRAINT c_lld_override_opseverity_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_optag ADD CONSTRAINT c_lld_override_optag_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_optemplate ADD CONSTRAINT c_lld_override_optemplate_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY lld_override_optemplate ADD CONSTRAINT c_lld_override_optemplate_2 FOREIGN KEY (templateid) REFERENCES hosts (hostid); ALTER TABLE ONLY lld_override_opinventory ADD CONSTRAINT c_lld_override_opinventory_1 FOREIGN KEY (lld_override_operationid) REFERENCES lld_override_operation (lld_override_operationid) ON DELETE CASCADE; ALTER TABLE ONLY item_parameter ADD CONSTRAINT c_item_parameter_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE; ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_1 FOREIGN KEY (roleid) REFERENCES role (roleid) ON DELETE CASCADE; ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_2 FOREIGN KEY (value_moduleid) REFERENCES module (moduleid) ON DELETE CASCADE; ALTER TABLE ONLY role_rule ADD CONSTRAINT c_role_rule_3 FOREIGN KEY (value_serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY token ADD CONSTRAINT c_token_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY token ADD CONSTRAINT c_token_2 FOREIGN KEY (creator_userid) REFERENCES users (userid); ALTER TABLE ONLY item_tag ADD CONSTRAINT c_item_tag_1 FOREIGN KEY (itemid) REFERENCES items (itemid); ALTER TABLE ONLY httptest_tag ADD CONSTRAINT c_httptest_tag_1 FOREIGN KEY (httptestid) REFERENCES httptest (httptestid) ON DELETE CASCADE; ALTER TABLE ONLY sysmaps_element_tag ADD CONSTRAINT c_sysmaps_element_tag_1 FOREIGN KEY (selementid) REFERENCES sysmaps_elements (selementid) ON DELETE CASCADE; ALTER TABLE ONLY report ADD CONSTRAINT c_report_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY report ADD CONSTRAINT c_report_2 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE; ALTER TABLE ONLY report_param ADD CONSTRAINT c_report_param_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY report_user ADD CONSTRAINT c_report_user_3 FOREIGN KEY (access_userid) REFERENCES users (userid); ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_1 FOREIGN KEY (reportid) REFERENCES report (reportid) ON DELETE CASCADE; ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY report_usrgrp ADD CONSTRAINT c_report_usrgrp_3 FOREIGN KEY (access_userid) REFERENCES users (userid); ALTER TABLE ONLY service_problem_tag ADD CONSTRAINT c_service_problem_tag_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY service_problem ADD CONSTRAINT c_service_problem_1 FOREIGN KEY (eventid) REFERENCES problem (eventid) ON DELETE CASCADE; ALTER TABLE ONLY service_problem ADD CONSTRAINT c_service_problem_2 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY service_tag ADD CONSTRAINT c_service_tag_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY service_status_rule ADD CONSTRAINT c_service_status_rule_1 FOREIGN KEY (serviceid) REFERENCES services (serviceid) ON DELETE CASCADE; ALTER TABLE ONLY sla_schedule ADD CONSTRAINT c_sla_schedule_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; ALTER TABLE ONLY sla_excluded_downtime ADD CONSTRAINT c_sla_excluded_downtime_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; ALTER TABLE ONLY sla_service_tag ADD CONSTRAINT c_sla_service_tag_1 FOREIGN KEY (slaid) REFERENCES sla (slaid) ON DELETE CASCADE; ALTER TABLE ONLY host_rtdata ADD CONSTRAINT c_host_rtdata_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_ldap ADD CONSTRAINT c_userdirectory_ldap_1 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_saml ADD CONSTRAINT c_userdirectory_saml_1 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_media ADD CONSTRAINT c_userdirectory_media_1 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_media ADD CONSTRAINT c_userdirectory_media_2 FOREIGN KEY (mediatypeid) REFERENCES media_type (mediatypeid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_usrgrp ADD CONSTRAINT c_userdirectory_usrgrp_1 FOREIGN KEY (userdirectory_idpgroupid) REFERENCES userdirectory_idpgroup (userdirectory_idpgroupid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_usrgrp ADD CONSTRAINT c_userdirectory_usrgrp_2 FOREIGN KEY (usrgrpid) REFERENCES usrgrp (usrgrpid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_idpgroup ADD CONSTRAINT c_userdirectory_idpgroup_1 FOREIGN KEY (userdirectoryid) REFERENCES userdirectory (userdirectoryid) ON DELETE CASCADE; ALTER TABLE ONLY userdirectory_idpgroup ADD CONSTRAINT c_userdirectory_idpgroup_2 FOREIGN KEY (roleid) REFERENCES role (roleid) ON DELETE CASCADE; ALTER TABLE ONLY user_scim_group ADD CONSTRAINT c_user_scim_group_1 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY user_scim_group ADD CONSTRAINT c_user_scim_group_2 FOREIGN KEY (scim_groupid) REFERENCES scim_group (scim_groupid) ON DELETE CASCADE; ALTER TABLE ONLY connector_tag ADD CONSTRAINT c_connector_tag_1 FOREIGN KEY (connectorid) REFERENCES connector (connectorid); ALTER TABLE ONLY proxy ADD CONSTRAINT c_proxy_1 FOREIGN KEY (proxy_groupid) REFERENCES proxy_group (proxy_groupid); ALTER TABLE ONLY proxy_rtdata ADD CONSTRAINT c_proxy_rtdata_1 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid) ON DELETE CASCADE; ALTER TABLE ONLY proxy_group_rtdata ADD CONSTRAINT c_proxy_group_rtdata_1 FOREIGN KEY (proxy_groupid) REFERENCES proxy_group (proxy_groupid) ON DELETE CASCADE; ALTER TABLE ONLY host_proxy ADD CONSTRAINT c_host_proxy_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid); ALTER TABLE ONLY host_proxy ADD CONSTRAINT c_host_proxy_2 FOREIGN KEY (proxyid) REFERENCES proxy (proxyid); ALTER TABLE ONLY mfa_totp_secret ADD CONSTRAINT c_mfa_totp_secret_1 FOREIGN KEY (mfaid) REFERENCES mfa (mfaid) ON DELETE CASCADE; ALTER TABLE ONLY mfa_totp_secret ADD CONSTRAINT c_mfa_totp_secret_2 FOREIGN KEY (userid) REFERENCES users (userid) ON DELETE CASCADE; ALTER TABLE ONLY settings ADD CONSTRAINT c_settings_2 FOREIGN KEY (value_usrgrpid) REFERENCES usrgrp (usrgrpid); ALTER TABLE ONLY settings ADD CONSTRAINT c_settings_3 FOREIGN KEY (value_hostgroupid) REFERENCES hstgrp (groupid); ALTER TABLE ONLY settings ADD CONSTRAINT c_settings_4 FOREIGN KEY (value_userdirectoryid) REFERENCES userdirectory (userdirectoryid); ALTER TABLE ONLY settings ADD CONSTRAINT c_settings_5 FOREIGN KEY (value_mfaid) REFERENCES mfa (mfaid); ALTER TABLE ONLY lld_macro_export ADD CONSTRAINT c_lld_macro_export_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE;