Fixing up deletes a bit (#327)
[akkoma] / priv / repo / migrations / 20221129112022_add_cascade_to_report_notes_on_activity_delete.exs
1 defmodule Pleroma.Repo.Migrations.AddCascadeToReportNotesOnActivityDelete do
2 use Ecto.Migration
3
4 def up do
5 drop(constraint(:report_notes, "report_notes_activity_id_fkey"))
6
7 alter table(:report_notes) do
8 modify(:activity_id, references(:activities, type: :uuid, on_delete: :delete_all))
9 end
10 end
11
12 def down do
13 drop(constraint(:report_notes, "report_notes_activity_id_fkey"))
14
15 alter table(:report_notes) do
16 modify(:activity_id, references(:activities, type: :uuid))
17 end
18 end
19 end