diff options
Diffstat (limited to 'priv/repo/migrations')
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 |