diff options
Diffstat (limited to 'priv/repo/migrations/20221219082326_create_player.exs')
| -rw-r--r-- | priv/repo/migrations/20221219082326_create_player.exs | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/priv/repo/migrations/20221219082326_create_player.exs b/priv/repo/migrations/20221219082326_create_player.exs index 4c0c553..8044344 100644 --- a/priv/repo/migrations/20221219082326_create_player.exs +++ b/priv/repo/migrations/20221219082326_create_player.exs @@ -5,11 +5,13 @@ defmodule Chessh.Repo.Migrations.CreatePlayer do execute("CREATE EXTENSION IF NOT EXISTS citext", "") create table(:players) do + add(:github_id, :integer, null: false) add(:username, :citext, null: false) - add(:hashed_password, :string, null: false) + add(:hashed_password, :string, null: true) timestamps() end create(unique_index(:players, [:username])) + create(unique_index(:players, [:github_id])) end end |