X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/8f7f02b025f59db466fdb22ea3686cb6c5adc400..227894193df8916aeda13038cae97a529eef1ad3:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index 9093c47fe..7f44938b3 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -2463,6 +2463,13 @@ CREATE INDEX index_diary_entry_subscriptions_on_diary_entry_id ON public.diary_e CREATE INDEX index_friends_on_user_id_and_created_at ON public.friends USING btree (user_id, created_at); +-- +-- Name: index_gpx_files_on_user_id_and_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_gpx_files_on_user_id_and_id ON public.gpx_files USING btree (user_id, id); + + -- -- Name: index_issue_comments_on_issue_id; Type: INDEX; Schema: public; Owner: - -- @@ -2540,6 +2547,13 @@ CREATE INDEX index_note_comments_on_created_at ON public.note_comments USING btr CREATE INDEX index_note_subscriptions_on_note_id ON public.note_subscriptions USING btree (note_id); +-- +-- Name: index_notes_on_description; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_notes_on_description ON public.notes USING gin (to_tsvector('english'::regconfig, description)); + + -- -- Name: index_oauth_access_grants_on_application_id; Type: INDEX; Schema: public; Owner: - -- @@ -3422,6 +3436,9 @@ INSERT INTO "schema_migrations" (version) VALUES ('23'), ('22'), ('21'), +('20250304172758'), +('20250212160355'), +('20250206202905'), ('20250121191749'), ('20250105154621'), ('20250104140952'),