neiam /gitgud

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

  def change do
    create table(:git_commit_language_stats, primary_key: false) do
      add :repository_id, references(:repositories, on_delete: :delete_all),
        primary_key: true,
        null: false

      add :sha, :binary, primary_key: true, null: false

      # Sorted desc by bytes.
      #   [%{"language" => "Elixir", "bytes" => 12345, "files" => 12}, ...]
      add :languages, :map, null: false, default: %{}
      add :total_bytes, :bigint, null: false, default: 0
      add :file_count, :integer, null: false, default: 0

      add :computed_at, :utc_datetime, null: false
    end
  end
end