db/migrate/20231213182102_add_canonical_user_index.rb

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