Source of schema.tmpl - Zabbix

Unified diff
Side-by-side diff
Ignore whitespace
Show whitespace characters
Hide e-diff
Color accessibility
Source viewDiff to previous
 
FIELD       |esc_step   |t_integer  |'0'    |NOT NULL   |0
FIELD       |status     |t_integer  |'0'    |NOT NULL   |0
FIELD       |itemid     |t_id       |   |NULL       |0          |-|items
FIELD       |acknowledgeid  |t_id       |   |NULL       |0          |-|acknowledges
FIELD       |servicealarmid |t_id       |   |NULL       |0          |-|service_alarms
FIELD       |serviceid  |t_id       |   |NULL       |0          |-|services
UNIQUE      |1      |triggerid,itemid,serviceid,escalationid
INDEX       |2      |eventid
INDEX       |3      |nextcheck
​
TABLE|globalvars|globalvarid|0
FIELD       |globalvarid    |t_id       |   |NOT NULL   |0
FIELD       |snmp_lastsize  |t_bigint   |'0'    |NOT NULL   |0
TABLE|globalvars|name|0
FIELD       |name   |t_varchar(64)      |'' |NOT NULL   |0
FIELD       |value  |t_varchar(2048)    |'' |NOT NULL   |0
​
TABLE|graph_discovery|graphid|0
FIELD       |graphid    |t_id       |   |NOT NULL   |0          |1|graphs
FIELD       |parent_graphid |t_id       |   |NOT NULL   |0          |2|graphs   |graphid    |RESTRICT
FIELD       |lastcheck  |t_integer  |'0'    |NOT NULL   |ZBX_NODATA
FIELD       |ts_delete  |t_time     |'0'    |NOT NULL   |ZBX_NODATA
INDEX       |1      |parent_graphid
​
TABLE|host_inventory|hostid|ZBX_TEMPLATE
FIELD       |hostid     |t_id       |   |NOT NULL   |0          |1|hosts