Database structure

[pablo.rosciani]

Alexei, look at this..

CHECK TABLE `actions` , `alarms` , `alerts` , `audit` , `config` , `escalations` , `functions` , `graphs` , `graphs_items` , `groups` , `history` , `history_str` , `hosts` , `hosts_groups` , `hosts_templates` , `images` , `items` , `media` , `media_type` , `profiles` , `rights` , `screens` , `screens_items` , `service_alarms` , `services` , `services_links` , `sessions` , `stats` , `sysmaps` , `sysmaps_hosts` , `sysmaps_links` , `trends` , `trigger_depends` , `triggers` , `users` , `users_groups` , `usrgrp`;


Problems with indexes of table `items`
UNIQUE and INDEX keys should not both be set for column `hostid`

Problems with indexes of table `profiles`
UNIQUE and INDEX keys should not both be set for column `userid`

Problems with indexes of table `services_links`
UNIQUE and INDEX keys should not both be set for column `serviceupid`

Problems with indexes of table `trigger_depends`
PRIMARY and INDEX keys should not both be set for column `triggerid_down`

Bye!

[Alexei]

Thanks for you comment. I dropped unnecessary indexes.