2 files changed, 9 insertions, 7 deletions
diff --git a/priv/repo/migrations/20221219082326_create_player.exs b/priv/repo/migrations/20221219082326_create_player.exs
index b99bb5e..4c0c553 100644
--- a/priv/repo/migrations/20221219082326_create_player.exs
+++ b/priv/repo/migrations/20221219082326_create_player.exs
@@ -2,14 +2,14 @@ defmodule Chessh.Repo.Migrations.CreatePlayer do
   use Ecto.Migration
 
   def change do
-    execute "CREATE EXTENSION IF NOT EXISTS citext", ""
+    execute("CREATE EXTENSION IF NOT EXISTS citext", "")
 
     create table(:players) do
-      add :username, :citext, null: false
-      add :hashed_password, :string, null: false
+      add(:username, :citext, null: false)
+      add(:hashed_password, :string, null: false)
       timestamps()
     end
 
-    create unique_index(:players, [:username])
+    create(unique_index(:players, [:username]))
   end
 end
diff --git a/priv/repo/migrations/20221219215005_add_keys.exs b/priv/repo/migrations/20221219215005_add_keys.exs
index 15163dc..06ea2c5 100644
--- a/priv/repo/migrations/20221219215005_add_keys.exs
+++ b/priv/repo/migrations/20221219215005_add_keys.exs
@@ -3,12 +3,14 @@ defmodule Chessh.Repo.Migrations.AddKeys do
 
   def change do
     create table(:keys) do
-      add :key, :string, null: false
-      add :name, :string, null: false
+      add(:key, :text, null: false)
+      add(:name, :string, null: false)
 
-      add :player_id, references(:players)
+      add(:player_id, references(:players))
 
       timestamps()
     end
+
+    create(unique_index(:keys, [:player_id, :key]))
   end
 end