Add scalable session thresholds

3 files changed, 15 insertions, 2 deletions

diff --git a/priv/repo/migrations/20221229225556_add_node.exs b/priv/repo/migrations/20221229225556_add_node.exs
index f8eace8..11731d9 100644
--- a/priv/repo/migrations/20221229225556_add_node.exs
+++ b/priv/repo/migrations/20221229225556_add_node.exs
@@ -4,7 +4,7 @@ defmodule Chessh.Repo.Migrations.AddNode do
   def change do
     create table(:nodes, primary_key: false) do
       add(:id, :string, primary_key: true)
-      add(:last_start, :utc_datetime)
+      add(:last_start, :utc_datetime_usec)
     end
   end
 end
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
diff --git a/priv/repo/migrations/20221230102253_add_authenticating_column_to_player.exs b/priv/repo/migrations/20221230102253_add_authenticating_column_to_player.exs
new file mode 100644
index 0000000..315aeb6
--- /dev/null
+++ b/priv/repo/migrations/20221230102253_add_authenticating_column_to_player.exs
@@ -0,0 +1,9 @@
+defmodule Chessh.Repo.Migrations.AddAuthenticatingColumnToPlayer do
+  use Ecto.Migration
+
+  def change do
+    alter table(:players) do
+      add(:authentications, :integer, default: 0)
+    end
+  end
+end