From 4f589998ee2500504de1fcd3c1b5c00a12f6253d Mon Sep 17 00:00:00 2001 From: William Pitcock Date: Mon, 18 Jun 2018 03:18:39 +0000 Subject: activitypub: support filtering activities by whether or not they are a reply (closes #109) --- .../20180617221540_create_activities_in_reply_to_index.exs | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 priv/repo/migrations/20180617221540_create_activities_in_reply_to_index.exs (limited to 'priv') diff --git a/priv/repo/migrations/20180617221540_create_activities_in_reply_to_index.exs b/priv/repo/migrations/20180617221540_create_activities_in_reply_to_index.exs new file mode 100644 index 000000000..1fee6fd7a --- /dev/null +++ b/priv/repo/migrations/20180617221540_create_activities_in_reply_to_index.exs @@ -0,0 +1,8 @@ +defmodule Pleroma.Repo.Migrations.CreateActivitiesInReplyToIndex do + use Ecto.Migration + @disable_ddl_transaction true + + def change do + create index(:activities, ["(data->'object'->>'inReplyTo')"], concurrently: true, name: :activities_in_reply_to) + end +end -- cgit v1.2.3