X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;ds=sidebyside;f=priv%2Frepo%2Fmigrations%2F20200808173046_only_expire_creates.exs;h=9df52956f044ab9ec3654e78571882f95d5f2cf5;hb=735ceb2115809037006d870ce8f8fb27c444bb56;hp=42fb7337539665944123317defb29b8fd39a00f2;hpb=0589e9156ac4f77bf158ed65bd352b4725f0ad1c;p=akkoma

diff --git a/priv/repo/migrations/20200808173046_only_expire_creates.exs b/priv/repo/migrations/20200808173046_only_expire_creates.exs
index 42fb73375..9df52956f 100644
--- a/priv/repo/migrations/20200808173046_only_expire_creates.exs
+++ b/priv/repo/migrations/20200808173046_only_expire_creates.exs
@@ -4,10 +4,10 @@ defmodule Pleroma.Repo.Migrations.OnlyExpireCreates do
   def up do
     statement = """
     DELETE FROM
-      activity_expirations A USING activities B
+      activity_expirations a_exp USING activities a, objects o
     WHERE
-      A.activity_id = B.id
-      AND B.data->>'type' != 'Create';
+      a_exp.activity_id = a.id AND (o.data->>'id') = COALESCE(a.data->'object'->>'id', a.data->>'object')
+      AND (a.data->>'type' != 'Create' OR o.data->>'type' != 'Note');
     """
 
     execute(statement)