From 26b0cbfd060abd6f158aa2491dc984165d0a1d37 Mon Sep 17 00:00:00 2001 From: Alex Gleason Date: Sun, 2 Jan 2022 13:13:14 -0600 Subject: ChangeObjectIdToFlake: add "on delete cascade" to deliveries fkey --- priv/repo/migrations/20211218181632_change_object_id_to_flake.exs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/priv/repo/migrations/20211218181632_change_object_id_to_flake.exs b/priv/repo/migrations/20211218181632_change_object_id_to_flake.exs index a4533b2ab..da62063f5 100644 --- a/priv/repo/migrations/20211218181632_change_object_id_to_flake.exs +++ b/priv/repo/migrations/20211218181632_change_object_id_to_flake.exs @@ -34,7 +34,7 @@ defmodule Pleroma.Repo.Migrations.ChangeObjectIdToFlake do execute(""" alter table deliveries alter column object_id set data type uuid using cast( lpad( to_hex(object_id), 32, '0') as uuid), - add constraint deliveries_object_id_fkey foreign key (object_id) references objects(id) + add constraint deliveries_object_id_fkey foreign key (object_id) references objects(id) on delete cascade """) # Update hashtag many-to-many foreign key -- cgit v1.2.3