priv/repo/migrations/20221219215005_add_keys.exs


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

defmodule Chessh.Repo.Migrations.AddKeys do
  use Ecto.Migration

  def change do
    create table(:keys) do
      add(:key, :text, null: false)
      add(:name, :string, null: false)

      add(:player_id, references(:players), null: false)

      timestamps()
    end

    create(unique_index(:keys, [:player_id, :key]))
  end
end