#Updating Zabbix from version 6.0.XX to 7.0.XX
#For those who accidentally imported schema.sql from the postgres user!
ALTER FUNCTION changelog_hosts_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_hosts_update() OWNER TO zabbix;
ALTER FUNCTION changelog_hosts_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_drules_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_drules_update() OWNER TO zabbix;
ALTER FUNCTION changelog_drules_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_dchecks_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_dchecks_update() OWNER TO zabbix;
ALTER FUNCTION changelog_dchecks_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_items_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_items_update() OWNER TO zabbix;
ALTER FUNCTION changelog_items_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstepitem_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstepitem_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstepitem_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httptestitem_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httptestitem_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httptestitem_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_triggers_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_triggers_update() OWNER TO zabbix;
ALTER FUNCTION changelog_triggers_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_functions_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_functions_update() OWNER TO zabbix;
ALTER FUNCTION changelog_functions_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_trigger_tag_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_trigger_tag_update() OWNER TO zabbix;
ALTER FUNCTION changelog_trigger_tag_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_item_preproc_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_item_preproc_update() OWNER TO zabbix;
ALTER FUNCTION changelog_item_preproc_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_field_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_field_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httptest_field_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_field_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_field_update() OWNER TO zabbix;
ALTER FUNCTION changelog_httpstep_field_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_host_tag_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_host_tag_update() OWNER TO zabbix;
ALTER FUNCTION changelog_host_tag_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_item_tag_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_item_tag_update() OWNER TO zabbix;
ALTER FUNCTION changelog_item_tag_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_update() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_tag_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_tag_update() OWNER TO zabbix;
ALTER FUNCTION changelog_connector_tag_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_update() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_group_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_group_update() OWNER TO zabbix;
ALTER FUNCTION changelog_proxy_group_delete() OWNER TO zabbix;
ALTER FUNCTION changelog_host_proxy_insert() OWNER TO zabbix;
ALTER FUNCTION changelog_host_proxy_update() OWNER TO zabbix;
ALTER FUNCTION changelog_host_proxy_delete() OWNER TO zabbix;
DROP TRIGGER hosts_insert ON hosts;
DROP TRIGGER hosts_update ON hosts;
DROP TRIGGER hosts_delete ON hosts;
DROP TRIGGER hosts_name_upper_insert ON insert;
DROP TRIGGER hosts_name_upper_update ON update;
DROP TRIGGER drules_insert ON drules;
DROP TRIGGER drules_update ON drules;
DROP TRIGGER drules_delete ON drules;
DROP TRIGGER dchecks_insert ON dchecks;
DROP TRIGGER dchecks_update ON dchecks;
DROP TRIGGER dchecks_delete ON dchecks;
DROP TRIGGER httptest_insert ON httptest;
DROP TRIGGER httptest_update ON httptest;
DROP TRIGGER httptest_delete ON httptest;
DROP TRIGGER httpstep_insert ON httpstep;
DROP TRIGGER httpstep_update ON httpstep;
DROP TRIGGER httpstep_delete ON httpstep;
DROP TRIGGER items_insert ON items;
DROP TRIGGER items_update ON items;
DROP TRIGGER items_delete ON items;
DROP TRIGGER httpstepitem_insert ON httpstepitem;
DROP TRIGGER httpstepitem_update ON httpstepitem;
DROP TRIGGER httpstepitem_delete ON httpstepitem;
DROP TRIGGER httptestitem_insert ON httptestitem;
DROP TRIGGER httptestitem_update ON httptestitem;
DROP TRIGGER httptestitem_delete ON httptestitem;
DROP TRIGGER triggers_insert ON triggers;
DROP TRIGGER triggers_update ON triggers;
DROP TRIGGER triggers_delete ON triggers;
DROP TRIGGER functions_insert ON functions;
DROP TRIGGER functions_update ON functions;
DROP TRIGGER functions_delete ON functions;
DROP TRIGGER trigger_tag_insert ON trigger_tag;
DROP TRIGGER trigger_tag_update ON trigger_tag;
DROP TRIGGER trigger_tag_delete ON trigger_tag;
DROP TRIGGER item_preproc_insert ON item_preproc;
DROP TRIGGER item_preproc_update ON item_preproc;
DROP TRIGGER item_preproc_delete ON item_preproc;
DROP TRIGGER httptest_field_insert ON httptest_field;
DROP TRIGGER httptest_field_update ON httptest_field;
DROP TRIGGER httptest_field_delete ON httptest_field;
DROP TRIGGER httpstep_field_insert ON httpstep_field;
DROP TRIGGER httpstep_field_update ON httpstep_field;
DROP TRIGGER httpstep_field_delete ON httpstep_field;
DROP TRIGGER host_tag_insert ON host_tag;
DROP TRIGGER host_tag_update ON host_tag;
DROP TRIGGER host_tag_delete ON host_tag;
DROP TRIGGER item_tag_insert ON item_tag;
DROP TRIGGER item_tag_update ON item_tag;
DROP TRIGGER item_tag_delete ON item_tag;
DROP TRIGGER connector_insert ON connector;
DROP TRIGGER connector_update ON connector;
DROP TRIGGER connector_delete ON connector;
DROP TRIGGER connector_tag_insert ON connector_tag;
DROP TRIGGER connector_tag_update ON connector_tag;
DROP TRIGGER connector_tag_delete ON connector_tag;
DROP TRIGGER proxy_insert ON proxy;
DROP TRIGGER proxy_update ON proxy;
DROP TRIGGER proxy_delete ON proxy;
DROP TRIGGER proxy_group_insert ON proxy_group;
DROP TRIGGER proxy_group_update ON proxy_group;
DROP TRIGGER proxy_group_delete ON proxy_group;
DROP TRIGGER host_proxy_insert ON host_proxy;
DROP TRIGGER host_proxy_update ON host_proxy;
DROP TRIGGER host_proxy_delete ON host_proxy;
DROP TABLE scim_group;
DROP TABLE user_scim_group;
DROP TABLE userdirectory_saml;
DROP TABLE userdirectory_ldap;
DROP TABLE userdirectory_media;
DROP TABLE userdirectory_idpgroup CASCADE;
DROP TABLE userdirectory_usrgrp;
DROP TABLE event_symptom;
DROP TABLE connector CASCADE;
DROP TABLE connector_tag;
DROP TABLE history_bin;
DROP TABLE optag;
DROP TABLE proxy CASCADE;
DROP TABLE proxy_rtdata;
DROP TABLE item_rtname;
DROP TABLE ugset CASCADE;
DROP TABLE ugset_group;
DROP TABLE user_ugset;
DROP TABLE hgset CASCADE;
DROP TABLE hgset_group;
DROP TABLE host_hgset;
DROP TABLE permission;
DROP TABLE mfa CASCADE;
DROP TABLE mfa_totp_secret;
DROP TABLE proxy_group CASCADE;
DROP TABLE host_proxy;
DROP TABLE proxy_group_rtdata;