Merge pull request 'Add dark and light theme mode to docs, detection, and button...
[akkoma] / priv / repo / migrations / 20200804180322_remove_nonlocal_expirations.exs
1 defmodule Pleroma.Repo.Migrations.RemoveNonlocalExpirations do
2 use Ecto.Migration
3
4 def up do
5 statement = """
6 DELETE FROM
7 activity_expirations A USING activities B
8 WHERE
9 A.activity_id = B.id
10 AND B.local = false;
11 """
12
13 execute(statement)
14 end
15
16 def down do
17 :ok
18 end
19 end