blob: 36facc5a0eda75b73e6f820f587a0c3748dd83ed (
plain)
| 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 | defmodule Pleroma.Repo.Migrations.CreateNotifications do
  use Ecto.Migration
  def change do
    create_if_not_exists table(:notifications) do
      add(:user_id, references(:users, on_delete: :delete_all))
      add(:activity_id, references(:activities, on_delete: :delete_all))
      add(:seen, :boolean, default: false)
      timestamps()
    end
    create_if_not_exists(index(:notifications, [:user_id]))
  end
end
 |