db/migrate/20231213182102_add_canonical_user_index.rb

   1 class AddCanonicalUserIndex < ActiveRecord::Migration[7.1]
   2   disable_ddl_transaction!
   3
   4   def change
   5     add_index :users, "LOWER(NORMALIZE(display_name, NFKC))", :name => "users_display_name_canonical_idx", :algorithm => :concurrently
   6   end
   7 end