+----------------+-------------------------+--------------------+-------------------------------------------------------------------------------------------------------------+ | TRIGGER_SCHEMA | TRIGGER_NAME | EVENT_MANIPULATION | ACTION_STATEMENT | +----------------+-------------------------+--------------------+-------------------------------------------------------------------------------------------------------------+ | zabbix | functions_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (7,old.functionid,3,unix_timestamp()) | | zabbix | functions_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (7,new.functionid,1,unix_timestamp()) | | zabbix | functions_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (7,old.functionid,2,unix_timestamp()) | | zabbix | trigger_tag_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (6,old.triggertagid,3,unix_timestamp()) | | zabbix | trigger_tag_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (6,new.triggertagid,1,unix_timestamp()) | | zabbix | trigger_tag_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (6,old.triggertagid,2,unix_timestamp()) | | zabbix | item_preproc_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (8,old.item_preprocid,3,unix_timestamp()) | | zabbix | item_preproc_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (8,new.item_preprocid,1,unix_timestamp()) | | zabbix | item_preproc_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (8,old.item_preprocid,2,unix_timestamp()) | | zabbix | host_tag_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (2,old.hosttagid,3,unix_timestamp()) | | zabbix | host_tag_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (2,new.hosttagid,1,unix_timestamp()) | | zabbix | host_tag_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (2,old.hosttagid,2,unix_timestamp()) | | zabbix | item_tag_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (4,old.itemtagid,3,unix_timestamp()) | | zabbix | item_tag_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (4,new.itemtagid,1,unix_timestamp()) | | zabbix | item_tag_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (4,old.itemtagid,2,unix_timestamp()) | | zabbix | httpstep_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (14,old.httpstepid,3,unix_timestamp()) | | zabbix | httpstep_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (14,new.httpstepid,1,unix_timestamp()) | | zabbix | httpstep_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (14,old.httpstepid,2,unix_timestamp()) | | zabbix | httptestitem_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (13,old.httptestitemid,3,unix_timestamp()) | | zabbix | httptestitem_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (13,new.httptestitemid,1,unix_timestamp()) | | zabbix | httptestitem_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (13,old.httptestitemid,2,unix_timestamp()) | | zabbix | httpstepitem_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (16,old.httpstepitemid,3,unix_timestamp()) | | zabbix | httpstepitem_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (16,new.httpstepitemid,1,unix_timestamp()) | | zabbix | httpstepitem_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (16,old.httpstepitemid,2,unix_timestamp()) | | zabbix | httptest_field_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (12,old.httptest_fieldid,3,unix_timestamp()) | | zabbix | httptest_field_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (12,new.httptest_fieldid,1,unix_timestamp()) | | zabbix | httptest_field_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (12,old.httptest_fieldid,2,unix_timestamp()) | | zabbix | httpstep_field_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (15,old.httpstep_fieldid,3,unix_timestamp()) | | zabbix | httpstep_field_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (15,new.httpstep_fieldid,1,unix_timestamp()) | | zabbix | httpstep_field_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (15,old.httpstep_fieldid,2,unix_timestamp()) | | zabbix | connector_tag_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (18,new.connector_tagid,1,unix_timestamp()) | | zabbix | connector_tag_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (18,old.connector_tagid,2,unix_timestamp()) | | zabbix | connector_tag_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (18,old.connector_tagid,3,unix_timestamp()) | | zabbix | dchecks_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (10,old.dcheckid,3,unix_timestamp()) | | zabbix | dchecks_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (10,new.dcheckid,1,unix_timestamp()) | | zabbix | dchecks_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (10,old.dcheckid,2,unix_timestamp()) | | zabbix | connector_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (17,old.connectorid,3,unix_timestamp()) | | zabbix | connector_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (17,new.connectorid,1,unix_timestamp()) | | zabbix | connector_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (17,old.connectorid,2,unix_timestamp()) | | zabbix | drules_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (9,old.druleid,3,unix_timestamp()) | | zabbix | drules_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (9,new.druleid,1,unix_timestamp()) | | zabbix | drules_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (9,old.druleid,2,unix_timestamp()) | | zabbix | proxy_group_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (20,new.proxy_groupid,1,unix_timestamp()) | | zabbix | proxy_group_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (20,old.proxy_groupid,2,unix_timestamp()) | | zabbix | proxy_group_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (20,old.proxy_groupid,3,unix_timestamp()) | | zabbix | host_proxy_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (21,new.hostproxyid,1,unix_timestamp()) | | zabbix | host_proxy_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (21,old.hostproxyid,2,unix_timestamp()) | | zabbix | host_proxy_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (21,old.hostproxyid,3,unix_timestamp()) | | zabbix | proxy_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (19,old.proxyid,3,unix_timestamp()) | | zabbix | proxy_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (19,new.proxyid,1,unix_timestamp()) | | zabbix | proxy_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (19,old.proxyid,2,unix_timestamp()) | | zabbix | items_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (3,old.itemid,3,unix_timestamp()) | | zabbix | items_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (3,new.itemid,1,unix_timestamp()) | | zabbix | items_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (3,old.itemid,2,unix_timestamp()) | | zabbix | hosts_name_upper_insert | INSERT | set new.name_upper=upper(new.name) | | zabbix | hosts_name_upper_update | UPDATE | begin if new.name<>old.name then set new.name_upper=upper(new.name); end if; end | | zabbix | hosts_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (1,old.hostid,3,unix_timestamp()) | | zabbix | hosts_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (1,new.hostid,1,unix_timestamp()) | | zabbix | hosts_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (1,old.hostid,2,unix_timestamp()) | | zabbix | httptest_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (11,old.httptestid,3,unix_timestamp()) | | zabbix | httptest_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (11,new.httptestid,1,unix_timestamp()) | | zabbix | httptest_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (11,old.httptestid,2,unix_timestamp()) | | zabbix | triggers_delete | DELETE | insert into changelog (object,objectid,operation,clock) values (5,old.triggerid,3,unix_timestamp()) | | zabbix | triggers_insert | INSERT | insert into changelog (object,objectid,operation,clock) values (5,new.triggerid,1,unix_timestamp()) | | zabbix | triggers_update | UPDATE | insert into changelog (object,objectid,operation,clock) values (5,old.triggerid,2,unix_timestamp()) | +----------------+-------------------------+--------------------+-------------------------------------------------------------------------------------------------------------+ 65 rows in set (0.01 sec)