diff options
| author | GitLab Bot <gitlab-bot@gitlab.com> | 2023-12-14 03:08:01 +0300 |
|---|---|---|
| committer | GitLab Bot <gitlab-bot@gitlab.com> | 2023-12-14 03:08:01 +0300 |
| commit | c4fad7502e407e6d744206fe1b235bc2e3a44d98 (patch) | |
| tree | f869522e2eec3ea5fe30d548d51c7ed5db9d751c /db/structure.sql | |
| parent | 0fea036ba7c8d26ffeecc7f52bf770ea3a88689e (diff) | |
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'db/structure.sql')
| -rw-r--r-- | db/structure.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/structure.sql b/db/structure.sql index 32b212e9d73..9fb23cc0cc4 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -34502,12 +34502,12 @@ CREATE INDEX index_sbom_occurrences_on_component_id_and_id ON sbom_occurrences U CREATE INDEX index_sbom_occurrences_on_component_version_id ON sbom_occurrences USING btree (component_version_id); +CREATE INDEX index_sbom_occurrences_on_highest_severity ON sbom_occurrences USING btree (project_id, highest_severity DESC NULLS LAST); + CREATE INDEX index_sbom_occurrences_on_licenses_spdx_identifier ON sbom_occurrences USING btree (project_id, ((licenses #> '{0,spdx_identifier}'::text[])), ((licenses #> '{1,spdx_identifier}'::text[]))); CREATE INDEX index_sbom_occurrences_on_pipeline_id ON sbom_occurrences USING btree (pipeline_id); -CREATE INDEX index_sbom_occurrences_on_project_id ON sbom_occurrences USING btree (project_id); - CREATE INDEX index_sbom_occurrences_on_project_id_and_component_id_and_id ON sbom_occurrences USING btree (project_id, component_id, id); CREATE INDEX index_sbom_occurrences_on_project_id_and_id ON sbom_occurrences USING btree (project_id, id); |