proc-gen equipment drops from monsters can be picked up
[sketchy-heroes.git] / prisma / migrations / 20220315163648_fight_table / migration.sql
1 -- CreateTable
2 CREATE TABLE "Fight" (
3     "id" UUID NOT NULL,
4     "playerId" UUID,
5     "monsterId" UUID NOT NULL,
6     "name" TEXT NOT NULL,
7     "type" "MonsterType"[],
8     "level" INTEGER NOT NULL,
9     "currency" INTEGER NOT NULL,
10     "pow" INTEGER NOT NULL,
11     "zest" INTEGER NOT NULL,
12     "woosh" INTEGER NOT NULL,
13     "luck" INTEGER NOT NULL,
14     "aha" INTEGER NOT NULL,
15     "wow" INTEGER NOT NULL,
16     "stamina" INTEGER NOT NULL,
17     "hp" INTEGER NOT NULL,
18     "exp" INTEGER NOT NULL,
19
20     CONSTRAINT "Fight_pkey" PRIMARY KEY ("id")
21 );