3387 lines
205 KiB
PL/PgSQL
3387 lines
205 KiB
PL/PgSQL
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 history_json (
|
|
itemid bigint NOT NULL,
|
|
clock integer DEFAULT '0' NOT NULL,
|
|
ns integer DEFAULT '0' NOT NULL,
|
|
value jsonb 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,
|
|
automatic integer DEFAULT '0' 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 text 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 host_template_cache (
|
|
hostid bigint NOT NULL,
|
|
link_hostid bigint NOT NULL,
|
|
PRIMARY KEY (hostid,link_hostid)
|
|
);
|
|
CREATE INDEX host_template_cache_1 ON host_template_cache (link_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 item_template_cache (
|
|
itemid bigint NOT NULL,
|
|
link_hostid bigint NOT NULL,
|
|
PRIMARY KEY (itemid,link_hostid)
|
|
);
|
|
CREATE INDEX item_template_cache_1 ON item_template_cache (link_hostid);
|
|
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,
|
|
idp_certificate text DEFAULT '' NOT NULL,
|
|
sp_certificate text DEFAULT '' NOT NULL,
|
|
sp_private_key text DEFAULT '' 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','7050033','7050033');
|
|
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);
|
|
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);
|
|
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 host_template_cache ADD CONSTRAINT c_host_template_cache_1 FOREIGN KEY (hostid) REFERENCES hosts (hostid) ON DELETE CASCADE;
|
|
ALTER TABLE ONLY host_template_cache ADD CONSTRAINT c_host_template_cache_2 FOREIGN KEY (link_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE;
|
|
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 item_template_cache ADD CONSTRAINT c_item_template_cache_1 FOREIGN KEY (itemid) REFERENCES items (itemid) ON DELETE CASCADE;
|
|
ALTER TABLE ONLY item_template_cache ADD CONSTRAINT c_item_template_cache_2 FOREIGN KEY (link_hostid) REFERENCES hosts (hostid) ON DELETE CASCADE;
|
|
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;
|