diff options
Diffstat (limited to 'db/structure.sql')
-rw-r--r-- | db/structure.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/structure.sql b/db/structure.sql index 622234396a2..895afed92e6 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -9884,6 +9884,8 @@ CREATE INDEX index_projects_on_created_at_and_id ON public.projects USING btree CREATE INDEX index_projects_on_creator_id_and_created_at ON public.projects USING btree (creator_id, created_at); +CREATE INDEX index_projects_on_creator_id_and_created_at_and_id ON public.projects USING btree (creator_id, created_at, id); + CREATE INDEX index_projects_on_description_trigram ON public.projects USING gin (description public.gin_trgm_ops); CREATE INDEX index_projects_on_id_and_archived_and_pending_delete ON public.projects USING btree (id) WHERE ((archived = false) AND (pending_delete = false)); @@ -13092,5 +13094,6 @@ COPY "schema_migrations" (version) FROM STDIN; 20200407094005 20200407094923 20200408110856 +20200408175424 \. |