diff options
Diffstat (limited to 'priv/repo/migrations/20221229225559_add_user_session.exs')
| -rw-r--r-- | priv/repo/migrations/20221229225559_add_user_session.exs | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/priv/repo/migrations/20221229225559_add_user_session.exs b/priv/repo/migrations/20221229225559_add_user_session.exs index 6f7a599..330fe2c 100644 --- a/priv/repo/migrations/20221229225559_add_user_session.exs +++ b/priv/repo/migrations/20221229225559_add_user_session.exs @@ -3,9 +3,13 @@ defmodule Chessh.Repo.Migrations.AddUserSession do def change do create table(:player_sessions) do - add(:login, :utc_datetime) + add(:process, :string) + add(:login, :utc_datetime_usec) + add(:player_id, references(:players)) add(:node_id, references(:nodes, type: :string)) end + + create(unique_index(:player_sessions, [:process, :node_id])) end end |