diff options
| author | Simponic <loganhunt@simponic.xyz> | 2022-12-30 05:46:35 -0700 |
|---|---|---|
| committer | Simponic <loganhunt@simponic.xyz> | 2022-12-30 05:46:35 -0700 |
| commit | 42425b02260d279cd9c12fb3e625282979b9e308 (patch) | |
| tree | 0412bf9f39d44266cff94082c499e44e5f6e60f5 /priv/repo/migrations/20221229225559_add_user_session.exs | |
| parent | 60eea1b4ed65bc7cfce1e383dac6de9d004540eb (diff) | |
| download | chessh-42425b02260d279cd9c12fb3e625282979b9e308.tar.gz chessh-42425b02260d279cd9c12fb3e625282979b9e308.zip | |
Add scalable session thresholds
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 |