diff options
Diffstat (limited to 'db/structure.sql')
-rw-r--r-- | db/structure.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/db/structure.sql b/db/structure.sql index 7f3d91aa782..13e48ceffa6 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -26875,6 +26875,8 @@ CREATE UNIQUE INDEX idx_on_external_status_checks_project_id_external_url ON ext CREATE UNIQUE INDEX idx_on_external_status_checks_project_id_name ON external_status_checks USING btree (project_id, name); +CREATE INDEX idx_open_issues_on_project_id_and_confidential ON issues USING btree (project_id, confidential) WHERE (state_id = 1); + CREATE INDEX idx_packages_debian_group_component_files_on_architecture_id ON packages_debian_group_component_files USING btree (architecture_id); CREATE INDEX idx_packages_debian_project_component_files_on_architecture_id ON packages_debian_project_component_files USING btree (architecture_id); |