diff options
Diffstat (limited to 'priv/repo/migrations')
| -rw-r--r-- | priv/repo/migrations/20221219082326_create_player.exs | 4 | ||||
| -rw-r--r-- | priv/repo/migrations/20221219215005_add_keys.exs | 2 |
2 files changed, 4 insertions, 2 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 diff --git a/priv/repo/migrations/20221219215005_add_keys.exs b/priv/repo/migrations/20221219215005_add_keys.exs index 06ea2c5..cfa61a5 100644 --- a/priv/repo/migrations/20221219215005_add_keys.exs +++ b/priv/repo/migrations/20221219215005_add_keys.exs @@ -6,7 +6,7 @@ defmodule Chessh.Repo.Migrations.AddKeys do add(:key, :text, null: false) add(:name, :string, null: false) - add(:player_id, references(:players)) + add(:player_id, references(:players), null: false) timestamps() end |