prisma/migrations/20220314034840_auth_tokens/migration.sql

   1 -- CreateTable
   2 CREATE TABLE "AuthToken" (
   3     "token" UUID NOT NULL,
   4     "player_id" UUID NOT NULL,
   5
   6     CONSTRAINT "AuthToken_pkey" PRIMARY KEY ("token")
   7 );
   8
   9 -- CreateIndex
  10 CREATE UNIQUE INDEX "AuthToken_player_id_key" ON "AuthToken"("player_id");
  11
  12 -- AddForeignKey
  13 ALTER TABLE "AuthToken" ADD CONSTRAINT "AuthToken_player_id_fkey" FOREIGN KEY ("player_id") REFERENCES "Player"("id") ON DELETE RESTRICT ON UPDATE CASCADE;