Require user names to be unique after unicode normalisation

[rails.git] / db / structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index c30378c37e3bf86fc205cb09ed46a5209218ecf3..7c5233d67781fec8cf9d4a46d76f2d4e01762b0b 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -1024,7 +1024,6 @@ CREATE TABLE public.note_comments (
 --
 
 CREATE SEQUENCE public.note_comments_id_seq
 --
 
 CREATE SEQUENCE public.note_comments_id_seq

-    AS integer

     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE


@@ -1060,7 +1059,6 @@ CREATE TABLE public.notes (
 --
 
 CREATE SEQUENCE public.notes_id_seq
 --
 
 CREATE SEQUENCE public.notes_id_seq

-    AS integer

     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE


@@ -1206,7 +1204,6 @@ CREATE TABLE public.oauth_nonces (
 --
 
 CREATE SEQUENCE public.oauth_nonces_id_seq
 --
 
 CREATE SEQUENCE public.oauth_nonces_id_seq

-    AS integer

     START WITH 1
     INCREMENT BY 1
     NO MINVALUE
     START WITH 1
     INCREMENT BY 1
     NO MINVALUE


@@ -2870,6 +2867,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);
 
 
 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: -
 --
 --
 -- Name: users_display_name_idx; Type: INDEX; Schema: public; Owner: -
 --


@@ -3513,6 +3517,8 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('23'),
 ('22'),
 ('21'),
 ('23'),
 ('22'),
 ('21'),

+('20231213182102'),
+('20231206141457'),

 ('20231117170422'),
 ('20231101222146'),
 ('20231029151516'),
 ('20231117170422'),
 ('20231101222146'),
 ('20231029151516'),