Add option to modify HTTP pool size
[akkoma] / priv / repo / migrations / 20190115085500_create_user_fts_index.exs
1 defmodule Pleroma.Repo.Migrations.CreateUserFtsIndex do
2 use Ecto.Migration
3
4 def change do
5 create_if_not_exists(
6 index(
7 :users,
8 [
9 """
10 (setweight(to_tsvector('simple', regexp_replace(nickname, '\\W', ' ', 'g')), 'A') ||
11 setweight(to_tsvector('simple', regexp_replace(coalesce(name, ''), '\\W', ' ', 'g')), 'B'))
12 """
13 ],
14 name: :users_fts_index,
15 using: :gin
16 )
17 )
18 end
19 end