Add changelog entry for hashtag following
[akkoma] / priv / repo / migrations / 20170916090107_add_fts_index_to_activities.exs
1 defmodule Pleroma.Repo.Migrations.AddFTSIndexToActivities do
2 use Ecto.Migration
3 @disable_ddl_transaction true
4
5 def change do
6 create(
7 index(:activities, ["(to_tsvector('english', data->'object'->>'content'))"],
8 concurrently: true,
9 using: :gin,
10 name: :activities_fts
11 )
12 )
13 end
14 end