git.squeep.com Git - akkoma/blob - priv/repo/migrations/20190118074940_fix_user_trigram_index.exs

   1 defmodule Pleroma.Repo.Migrations.FixUserTrigramIndex do
   2   use Ecto.Migration
   3
   4   def up do
   5     drop_if_exists(index(:users, [], name: :users_trigram_index))
   6
   7     create_if_not_exists(
   8       index(:users, ["(trim(nickname || ' ' || coalesce(name, ''))) gist_trgm_ops"],
   9         name: :users_trigram_index,
  10         using: :gist
  11       )
  12     )
  13   end
  14
  15   def down do
  16     drop_if_exists(index(:users, [], name: :users_trigram_index))
  17
  18     create_if_not_exists(
  19       index(:users, ["(nickname || name) gist_trgm_ops"], name: :users_trigram_index, using: :gist)
  20     )
  21   end
  22 end