Missing indexes on mantis database
List of DDL to create missing indexes on foreign keys.
| Table | Missing index |
|---|---|
| mantis_bug_file_table | CREATE INDEX idx_mantis_bug_file_table_id ON mantis_bug_file_table (id) |
| mantis_bug_history_table | CREATE INDEX idx_mantis_bug_history_table_id ON mantis_bug_history_table (id) |
| mantis_bug_monitor_table | CREATE INDEX idx_mantis_bug_monitor_table_user_id_bug_id ON mantis_bug_monitor_table (user_id.bug_id) |
| mantis_bug_relationship_table | CREATE INDEX idx_mantis_bug_relationship_table_id ON mantis_bug_relationship_table (id) |
| mantis_bug_revision_table | CREATE INDEX idx_mantis_bug_revision_table_id ON mantis_bug_revision_table (id) |
| mantis_bug_tag_table | CREATE INDEX idx_mantis_bug_tag_table_bug_id_tag_id ON mantis_bug_tag_table (bug_id.tag_id) |
| mantis_bug_table | CREATE INDEX idx_mantis_bug_table_id ON mantis_bug_table (id) |
| mantis_bug_text_table | CREATE INDEX idx_mantis_bug_text_table_id ON mantis_bug_text_table (id) |
| mantis_bugnote_table | CREATE INDEX idx_mantis_bugnote_table_id ON mantis_bugnote_table (id) |
| mantis_bugnote_text_table | CREATE INDEX idx_mantis_bugnote_text_table_id ON mantis_bugnote_text_table (id) |
| mantis_category_table | CREATE INDEX idx_mantis_category_table_id ON mantis_category_table (id) |
| mantis_config_table | CREATE INDEX idx_mantis_config_table_config_id_project_id_user_id ON mantis_config_table (config_id.project_id.user_id) |
| mantis_custom_field_project_table | CREATE INDEX idx_mantis_custom_field_project_table_field_id_project_id ON mantis_custom_field_project_table (field_id.project_id) |
| mantis_custom_field_string_table | CREATE INDEX idx_mantis_custom_field_string_table_field_id_bug_id ON mantis_custom_field_string_table (field_id.bug_id) |
| mantis_email_table | CREATE INDEX idx_mantis_email_table_email_id ON mantis_email_table (email_id) |
| mantis_plugin_table | CREATE INDEX idx_mantis_plugin_table_basename ON mantis_plugin_table (basename) |
| mantis_project_file_table | CREATE INDEX idx_mantis_project_file_table_id ON mantis_project_file_table (id) |
| mantis_project_user_list_table | CREATE INDEX idx_mantis_project_user_list_table_project_id_user_id ON mantis_project_user_list_table (project_id.user_id) |
| mantis_user_profile_table | CREATE INDEX idx_mantis_user_profile_table_id ON mantis_user_profile_table (id) |
| mantis_tag_table | CREATE INDEX idx_mantis_tag_table_id_name ON mantis_tag_table (id.name) |
| mantis_tokens_table | CREATE INDEX idx_mantis_tokens_table_id ON mantis_tokens_table (id) |
| mantis_user_print_pref_table | CREATE INDEX idx_mantis_user_print_pref_table_user_id ON mantis_user_print_pref_table (user_id) |
| mantis_custom_field_table | CREATE INDEX idx_mantis_custom_field_table_id ON mantis_custom_field_table (id) |
| mantis_news_table | CREATE INDEX idx_mantis_news_table_id ON mantis_news_table (id) |
| mantis_project_table | CREATE INDEX idx_mantis_project_table_id ON mantis_project_table (id) |
| mantis_project_version_table | CREATE INDEX idx_mantis_project_version_table_id ON mantis_project_version_table (id) |
| mantis_sponsorship_table | CREATE INDEX idx_mantis_sponsorship_table_id ON mantis_sponsorship_table (id) |
| mantis_user_pref_table | CREATE INDEX idx_mantis_user_pref_table_id ON mantis_user_pref_table (id) |
| mantis_user_table | CREATE INDEX idx_mantis_user_table_id ON mantis_user_table (id) |
| mantis_filters_table | CREATE INDEX idx_mantis_filters_table_id ON mantis_filters_table (id) |