23 lines
653 B
Elixir
23 lines
653 B
Elixir
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
|