CREATE INDEX users_3 ON users (roleid);
CREATE INDEX hosts_7 ON hosts (templateid);
CREATE INDEX group_prototype_2 ON group_prototype (groupid);
CREATE INDEX group_prototype_3 ON group_prototype (templateid);
CREATE INDEX group_discovery_1 ON group_discovery (parent_group_prototypeid);
CREATE INDEX sysmaps_4 ON sysmaps (userid);
CREATE INDEX sysmap_user_2 ON sysmap_user (userid);
CREATE INDEX sysmap_usrgrp_2 ON sysmap_usrgrp (usrgrpid);
CREATE INDEX host_discovery_1 ON host_discovery (parent_hostid);
CREATE INDEX host_discovery_2 ON host_discovery (parent_itemid);
CREATE INDEX interface_discovery_1 ON interface_discovery (parent_interfaceid);
CREATE INDEX tag_filter_1 ON tag_filter (usrgrpid);
CREATE INDEX tag_filter_2 ON tag_filter (groupid);
CREATE INDEX task_2 ON task (proxy_hostid);
CREATE INDEX sysmap_element_trigger_2 ON sysmap_element_trigger (triggerid);
CREATE INDEX dashboard_user_2 ON dashboard_user (userid);
CREATE INDEX dashboard_usrgrp_2 ON dashboard_usrgrp (usrgrpid);
CREATE INDEX event_suppress_4 ON event_suppress (userid);
CREATE INDEX report_2 ON report (userid);
CREATE INDEX report_3 ON report (dashboardid);
CREATE INDEX report_user_2 ON report_user (userid);
CREATE INDEX report_user_3 ON report_user (access_userid);
CREATE INDEX report_usrgrp_2 ON report_usrgrp (usrgrpid);
CREATE INDEX report_usrgrp_3 ON report_usrgrp (access_userid);
