exploring/fighting is functional

[sketchy-heroes.git] / prisma / migrations / 20220315163648_fight_table / migration.sql

diff --git a/prisma/migrations/20220315163648_fight_table/migration.sql b/prisma/migrations/20220315163648_fight_table/migration.sql
new file mode 100644 (file)
index 0000000..3ad5aa1
--- /dev/null
+++ b/prisma/migrations/20220315163648_fight_table/migration.sql
@@ -0,0 +1,21 @@
+-- CreateTable
+CREATE TABLE "Fight" (
+    "id" UUID NOT NULL,
+    "playerId" UUID,
+    "monsterId" UUID NOT NULL,
+    "name" TEXT NOT NULL,
+    "type" "MonsterType"[],
+    "level" INTEGER NOT NULL,
+    "currency" INTEGER NOT NULL,
+    "pow" INTEGER NOT NULL,
+    "zest" INTEGER NOT NULL,
+    "woosh" INTEGER NOT NULL,
+    "luck" INTEGER NOT NULL,
+    "aha" INTEGER NOT NULL,
+    "wow" INTEGER NOT NULL,
+    "stamina" INTEGER NOT NULL,
+    "hp" INTEGER NOT NULL,
+    "exp" INTEGER NOT NULL,
+
+    CONSTRAINT "Fight_pkey" PRIMARY KEY ("id")
+);