From 42425b02260d279cd9c12fb3e625282979b9e308 Mon Sep 17 00:00:00 2001 From: Simponic Date: Fri, 30 Dec 2022 05:46:35 -0700 Subject: Add scalable session thresholds --- priv/repo/migrations/20221229225559_add_user_session.exs | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'priv/repo/migrations/20221229225559_add_user_session.exs') 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 -- cgit v1.3