diff options
Diffstat (limited to 'db/structure.sql')
| -rw-r--r-- | db/structure.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/structure.sql b/db/structure.sql index 25855aeadc0..ef3319df364 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -8708,6 +8708,8 @@ CREATE INDEX index_ci_daily_report_results_on_last_pipeline_id ON public.ci_dail CREATE UNIQUE INDEX index_ci_group_variables_on_group_id_and_key ON public.ci_group_variables USING btree (group_id, key); +CREATE INDEX index_ci_job_artifacts_file_store_is_null ON public.ci_job_artifacts USING btree (id) WHERE (file_store IS NULL); + CREATE INDEX index_ci_job_artifacts_on_expire_at_and_job_id ON public.ci_job_artifacts USING btree (expire_at, job_id); CREATE INDEX index_ci_job_artifacts_on_file_store ON public.ci_job_artifacts USING btree (file_store); @@ -9328,6 +9330,8 @@ CREATE UNIQUE INDEX index_lfs_file_locks_on_project_id_and_path ON public.lfs_fi CREATE INDEX index_lfs_file_locks_on_user_id ON public.lfs_file_locks USING btree (user_id); +CREATE INDEX index_lfs_objects_file_store_is_null ON public.lfs_objects USING btree (id) WHERE (file_store IS NULL); + CREATE INDEX index_lfs_objects_on_file_store ON public.lfs_objects USING btree (file_store); CREATE UNIQUE INDEX index_lfs_objects_on_oid ON public.lfs_objects USING btree (oid); @@ -10094,6 +10098,8 @@ CREATE INDEX index_uploads_on_store ON public.uploads USING btree (store); CREATE INDEX index_uploads_on_uploader_and_path ON public.uploads USING btree (uploader, path); +CREATE INDEX index_uploads_store_is_null ON public.uploads USING btree (id) WHERE (store IS NULL); + CREATE INDEX index_user_agent_details_on_subject_id_and_subject_type ON public.user_agent_details USING btree (subject_id, subject_type); CREATE INDEX index_user_callouts_on_user_id ON public.user_callouts USING btree (user_id); @@ -12929,5 +12935,8 @@ COPY "schema_migrations" (version) FROM STDIN; 20200330123739 20200330132913 20200331220930 +20200403184110 +20200403185127 +20200403185422 \. |