Inconsistent schema - indexes
List of indexes:
| index | MR | structure.sql (master) | Production database | Local database * |
|---|---|---|---|---|
| index_approval_rules_code_owners_rule_type | !79438 (merged) | CREATE INDEX index_approval_rules_code_owners_rule_type ON approval_merge_request_rules USING btree (merge_request_id) WHERE (rule_type = 2); | index_approval_rules_code_owners_rule_type btree (merge_request_id, rule_type) WHERE rule_type = 2 | "index_approval_rules_code_owners_rule_type" btree (merge_request_id, rule_type) WHERE rule_type = 2 |
| index_environments_on_auto_stop_at | !77754 (merged) | CREATE INDEX index_environments_on_auto_stop_at ON environments USING btree (auto_stop_at) WHERE (auto_stop_at IS NOT NULL); | does not exist | does not exist |
| index_epics_on_lock_version | !77674 (merged) | does not exist | does not exist | "index_epics_on_lock_version" btree (lock_version) WHERE lock_version IS NULL |
| index_issues_on_lock_version | !77674 (merged) | does not exis | does not exist | "index_issues_on_lock_version" btree (lock_version) WHERE lock_version IS NULL |
| index_merge_request_context_commits_on_merge_request_id | !77754 (merged) | does not exist | "index_merge_request_context_commits_on_merge_request_id" btree (merge_request_id) | "index_merge_request_context_commits_on_merge_request_id" btree (merge_request_id) |
| index_merge_requests_on_lock_version | !77674 (merged) | does not exist | does not exist | "index_merge_requests_on_lock_version" btree (lock_version) WHERE lock_version IS NULL |
| index_suggestions_on_note_id | !77769 (merged) | does not exist | does not exist | "index_suggestions_on_note_id" btree (note_id) |
| tmp_index_ci_pipelines_lock_version | !77832 (merged) | does not exist | does not exist | "tmp_index_ci_pipelines_lock_version" btree (id) WHERE lock_version IS NULL |
| index_design_management_versions_on_author_id | !77831 (merged) | CREATE INDEX index_design_management_versions_on_author_id ON design_management_versions USING btree (author_id) WHERE (author_id IS NOT NULL); | does not exist | "index_design_management_versions_on_author_id" btree (author_id) WHERE author_id IS NOT NULL |
| index_vulnerability_occurrences_deduplication | !77823 (merged) | CREATE INDEX index_vulnerability_occurrences_deduplication ON vulnerability_occurrences USING btree (project_id, report_type, project_fingerprint); | does not exist | "index_vulnerability_occurrences_deduplication" btree (project_id, report_type, project_fingerprint) |
| index_on_projects_path | !78256 (merged) | does not exist | "index_on_projects_path" btree (path) | does not exist |
Note: * After we run bundle exec rake db:drop db:create db:migrate
Related issues:
Edited by Diogo Frazão