neiam /gitgud

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

  def change do
    create table(:repositories) do
      add :owner_id, references(:users, on_delete: :delete_all), null: false
      add :name, :string, null: false, size: 100
      add :description, :text
      add :default_branch, :string, null: false, default: "main"
      add :visibility, :string, null: false, default: "private"
      add :disk_path, :string, null: false
      add :pushed_at, :utc_datetime
      add :size_kb, :bigint, default: 0
      add :archived, :boolean, null: false, default: false

      timestamps(type: :utc_datetime)
    end

    create unique_index(:repositories, [:owner_id, :name])
    create index(:repositories, [:visibility])
  end
end