diff options
Diffstat (limited to 'priv')
-rw-r--r-- | priv/.dockerignore | 1 | ||||
-rwxr-xr-x | priv/make_keys.sh | 15 | ||||
-rw-r--r-- | priv/repo/migrations/20221219082326_create_player.exs | 4 | ||||
-rw-r--r-- | priv/repo/migrations/20221219215005_add_keys.exs | 2 |
4 files changed, 14 insertions, 8 deletions
diff --git a/priv/.dockerignore b/priv/.dockerignore new file mode 100644 index 0000000..0bdfd49 --- /dev/null +++ b/priv/.dockerignore @@ -0,0 +1 @@ +keys diff --git a/priv/make_keys.sh b/priv/make_keys.sh index bd65aec..89464a8 100755 --- a/priv/make_keys.sh +++ b/priv/make_keys.sh @@ -1,9 +1,12 @@ #!/bin/sh -mkdir keys -chmod 700 keys -cd keys +if [ ! -d "keys" ] +then + mkdir keys + chmod 700 keys + cd keys -ssh-keygen -N "" -b 256 -t ecdsa -f ssh_host_ecdsa_key -ssh-keygen -N "" -b 1024 -t dsa -f ssh_host_dsa_key -ssh-keygen -N "" -b 2048 -t rsa -f ssh_host_rsa_key
\ No newline at end of file + ssh-keygen -N "" -b 256 -t ecdsa -f ssh_host_ecdsa_key + ssh-keygen -N "" -b 1024 -t dsa -f ssh_host_dsa_key + ssh-keygen -N "" -b 2048 -t rsa -f ssh_host_rsa_key +fi diff --git a/priv/repo/migrations/20221219082326_create_player.exs b/priv/repo/migrations/20221219082326_create_player.exs index 4c0c553..8044344 100644 --- a/priv/repo/migrations/20221219082326_create_player.exs +++ b/priv/repo/migrations/20221219082326_create_player.exs @@ -5,11 +5,13 @@ defmodule Chessh.Repo.Migrations.CreatePlayer do execute("CREATE EXTENSION IF NOT EXISTS citext", "") create table(:players) do + add(:github_id, :integer, null: false) add(:username, :citext, null: false) - add(:hashed_password, :string, null: false) + add(:hashed_password, :string, null: true) timestamps() end create(unique_index(:players, [:username])) + create(unique_index(:players, [:github_id])) end end diff --git a/priv/repo/migrations/20221219215005_add_keys.exs b/priv/repo/migrations/20221219215005_add_keys.exs index 06ea2c5..cfa61a5 100644 --- a/priv/repo/migrations/20221219215005_add_keys.exs +++ b/priv/repo/migrations/20221219215005_add_keys.exs @@ -6,7 +6,7 @@ defmodule Chessh.Repo.Migrations.AddKeys do add(:key, :text, null: false) add(:name, :string, null: false) - add(:player_id, references(:players)) + add(:player_id, references(:players), null: false) timestamps() end |