No OneTemporary
Actions

Authored By

Unknown

Size

596 B

Referenced Files

None

Subscribers

None

View Options

	diff --git a/priv/repo/migrations/20170916090107_add_fts_index_to_activities.exs b/priv/repo/migrations/20170916090107_add_fts_index_to_activities.exs
	new file mode 100644
	index 000000000..c17da8309
	--- /dev/null
	+++ b/priv/repo/migrations/20170916090107_add_fts_index_to_activities.exs
	@@ -0,0 +1,8 @@
	+defmodule Pleroma.Repo.Migrations.AddFTSIndexToActivities do
	+ use Ecto.Migration
	+ @disable_ddl_transaction true
	+
	+ def change do
	+ create index(:activities, ["(to_tsvector('english', data->'object'->>'content'))"], concurrently: true, using: :gin, name: :activities_fts)
	+ end
	+end