commit: e8d10237da47f81bcb3837ac8b5d1b7cc7bf540c
parent: bd157b7369fc5aaff1ec7ed66fb1bb41fdfd1491
Author: lain <lain@soykaf.club>
Date: Wed, 5 Aug 2020 08:55:39 +0000
Merge branch 'fix/incorrect-expirations' into 'develop'
Add a migration to clean up activity_expirations table
See merge request pleroma/pleroma!2848
Diffstat:
1 file changed, 19 insertions(+), 0 deletions(-)
diff --git a/priv/repo/migrations/20200804180322_remove_nonlocal_expirations.exs b/priv/repo/migrations/20200804180322_remove_nonlocal_expirations.exs
@@ -0,0 +1,19 @@
+defmodule Pleroma.Repo.Migrations.RemoveNonlocalExpirations do
+ use Ecto.Migration
+
+ def up do
+ statement = """
+ DELETE FROM
+ activity_expirations A USING activities B
+ WHERE
+ A.activity_id = B.id
+ AND B.local = false;
+ """
+
+ execute(statement)
+ end
+
+ def down do
+ :ok
+ end
+end