GITGUD

neiam /gitgud

Git Gud

public · Issues · Pulls · Labels · Forks · Compare · Actions success · Packages

⭐

Log in to mark this repository.

802 B · text History 6280797 
defmodule GitGud.Repo.Migrations.CreateRepositorySyms do

  use Ecto.Migration



  # One row per (user, repo, symbol): a user may mark a repo with

  # several different symbols, but each only once.

  def change do

    create table(:repository_syms) do

      add :user_id, references(:users, on_delete: :delete_all), null: false

      add :repository_id, references(:repositories, on_delete: :delete_all), null: false

      add :symbol, :string, null: false



      timestamps(type: :utc_datetime, updated_at: false)

    end



    create unique_index(:repository_syms, [:user_id, :repository_id, :symbol])

    # Counting a repo's marks, and listing a user's marks of one symbol.

    create index(:repository_syms, [:repository_id, :symbol])

    create index(:repository_syms, [:user_id, :symbol])

  end

end