Add option to modify HTTP pool size
[akkoma] / priv / repo / migrations / 20220831170605_remove_local_cancelled_follows.exs
1 defmodule Pleroma.Repo.Migrations.RemoveLocalCancelledFollows do
2 use Ecto.Migration
3
4 def up do
5 statement = """
6 DELETE FROM
7 activities
8 WHERE
9 (data->>'type') = 'Follow'
10 AND
11 (data->>'state') = 'cancelled'
12 AND
13 local = true;
14 """
15
16 execute(statement)
17 end
18
19 def down do
20 :ok
21 end
22 end