neiam /gitgud

defmodule GitGud.Repo.Migrations.CreateDeployKeys do
  use Ecto.Migration

  def change do
    create table(:deploy_keys) do
      add :repository_id, references(:repositories, on_delete: :delete_all), null: false
      add :title, :string, null: false, size: 100
      add :key, :text, null: false
      add :fingerprint, :string, null: false, size: 100
      # If true, can also push. Defaults to read-only.
      add :read_write, :boolean, null: false, default: false
      add :last_used_at, :utc_datetime

      timestamps(type: :utc_datetime)
    end

    create unique_index(:deploy_keys, [:fingerprint])
    create index(:deploy_keys, [:repository_id])
  end
end