X-Git-Url: https://git.xangelo.ca/?p=sketchy-heroes.git;a=blobdiff_plain;f=prisma%2Fmigrations%2F20220315163648_fight_table%2Fmigration.sql;fp=prisma%2Fmigrations%2F20220315163648_fight_table%2Fmigration.sql;h=3ad5aa11d0d9d5f22d805a2c2b15351dcd179b27;hp=0000000000000000000000000000000000000000;hb=7aa7248bc4f3f59a002beb98fa889a9da3c25866;hpb=9cec2c639563092ed050716db1e7e4657f937bf5

diff --git a/prisma/migrations/20220315163648_fight_table/migration.sql b/prisma/migrations/20220315163648_fight_table/migration.sql
new file mode 100644
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")
+);