defmodule Dexi.Repo.Migrations.AddUserSearchIndexes do
  use Ecto.Migration

  def change do
    execute("CREATE EXTENSION IF NOT EXISTS pg_trgm")

    execute(
      "CREATE INDEX users_pubkey_search_index ON users (lower(pubkey) text_pattern_ops)",
      "DROP INDEX users_pubkey_search_index"
    )

    execute(
      "CREATE INDEX users_name_search_index ON users USING gin (lower(coalesce(name, '')) gin_trgm_ops)",
      "DROP INDEX users_name_search_index"
    )

    execute(
      "CREATE INDEX users_email_search_index ON users USING gin (lower(coalesce(email, '')) gin_trgm_ops)",
      "DROP INDEX users_email_search_index"
    )
  end
end