X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/10d65cc8571d38bb6af6d9022edb98a294ad2f2d..9387df91414616b9668185b72a9457e53937523d:/db/structure.sql?ds=inline diff --git a/db/structure.sql b/db/structure.sql index 0563417cd..c9fdebbc8 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -2922,6 +2922,13 @@ CREATE INDEX user_tokens_user_id_idx ON public.user_tokens USING btree (user_id) CREATE UNIQUE INDEX users_auth_idx ON public.users USING btree (auth_provider, auth_uid); +-- +-- Name: users_display_name_canonical_idx; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX users_display_name_canonical_idx ON public.users USING btree (lower(NORMALIZE(display_name, NFKC))); + + -- -- Name: users_display_name_idx; Type: INDEX; Schema: public; Owner: - -- @@ -3581,6 +3588,7 @@ INSERT INTO "schema_migrations" (version) VALUES ('23'), ('22'), ('21'), +('20231213182102'), ('20231206141457'), ('20231117170422'), ('20231101222146'),