1 defmodule Pleroma.Repo.Migrations.CreateSubscriptionNotifications do
5 create_if_not_exists table(:subscription_notifications) do
6 add(:user_id, references(:users, type: :uuid, on_delete: :delete_all))
7 add(:activity_id, references(:activities, type: :uuid, on_delete: :delete_all))
12 create_if_not_exists(index(:subscription_notifications, [:user_id]))
13 create_if_not_exists(index(:subscription_notifications, ["id desc nulls last"]))