mobilizon/priv/repo/migrations/20230215125801_create_application_tokens.exs

defmodule Mobilizon.Repo.Migrations.CreateApplicationTokens do
  use Ecto.Migration

  def change do
    create table(:application_tokens) do
      add(:user_id, references(:users, on_delete: :delete_all), null: false)
      add(:application_id, references(:applications, on_delete: :delete_all), null: false)
      add(:authorization_code, :string, null: true)
      add(:status, :string, default: "pending", null: false)
      add(:scope, :string)
      timestamps()
    end

    create(unique_index(:application_tokens, [:user_id, :application_id]))
  end
end