Drop lowercase index on display names

diff --git a/app/models/user.rb b/app/models/user.rb
index b04f8e2b914c274babd1d9aec55c5f85ce4705e7..8ed6d4465f8687d2c17434770a56967d1da9228f 100644 (file)
--- a/app/models/user.rb
+++ b/app/models/user.rb
@@ -37,7 +37,6 @@
 #  users_auth_idx                    (auth_provider,auth_uid) UNIQUE
 #  users_display_name_canonical_idx  (lower(NORMALIZE(display_name, NFKC)))
 #  users_display_name_idx            (display_name) UNIQUE
 #  users_auth_idx                    (auth_provider,auth_uid) UNIQUE
 #  users_display_name_canonical_idx  (lower(NORMALIZE(display_name, NFKC)))
 #  users_display_name_idx            (display_name) UNIQUE

-#  users_display_name_lower_idx      (lower((display_name)::text))

 #  users_email_idx                   (email) UNIQUE
 #  users_email_lower_idx             (lower((email)::text))
 #  users_home_idx                    (home_tile)
 #  users_email_idx                   (email) UNIQUE
 #  users_email_lower_idx             (lower((email)::text))
 #  users_home_idx                    (home_tile)

diff --git a/db/migrate/20240117185445_drop_lowercase_user_index.rb b/db/migrate/20240117185445_drop_lowercase_user_index.rb
new file mode 100644 (file)
index 0000000..82bd5ec
--- /dev/null
+++ b/db/migrate/20240117185445_drop_lowercase_user_index.rb
@@ -0,0 +1,5 @@
+class DropLowercaseUserIndex < ActiveRecord::Migration[7.1]
+  def change
+    remove_index :users, "LOWER(display_name)", :name => "users_display_name_lower_idx"
+  end
+end

diff --git a/db/structure.sql b/db/structure.sql
index c9fdebbc8a9fa5253d9341fdadf2caada58cc1d8..4998bc694a139be2e9b477e5f12137f499f6a713 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -2936,13 +2936,6 @@ CREATE INDEX users_display_name_canonical_idx ON public.users USING btree (lower
 CREATE UNIQUE INDEX users_display_name_idx ON public.users USING btree (display_name);
 
 
 CREATE UNIQUE INDEX users_display_name_idx ON public.users USING btree (display_name);
 
 

---
--- Name: users_display_name_lower_idx; Type: INDEX; Schema: public; Owner: -
---
-
-CREATE INDEX users_display_name_lower_idx ON public.users USING btree (lower((display_name)::text));
-
-

 --
 -- Name: users_email_idx; Type: INDEX; Schema: public; Owner: -
 --
 --
 -- Name: users_email_idx; Type: INDEX; Schema: public; Owner: -
 --


@@ -3588,6 +3581,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('23'),
 ('22'),
 ('21'),
 ('23'),
 ('22'),
 ('21'),

+('20240117185445'),

 ('20231213182102'),
 ('20231206141457'),
 ('20231117170422'),
 ('20231213182102'),
 ('20231206141457'),
 ('20231117170422'),