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

diff --git a/prisma/migrations/20220314194645_add_monsters/migration.sql b/prisma/migrations/20220314194645_add_monsters/migration.sql
new file mode 100644
index 0000000..a45fe57
--- /dev/null
+++ b/prisma/migrations/20220314194645_add_monsters/migration.sql
@@ -0,0 +1,27 @@
+-- CreateEnum
+CREATE TYPE "MonsterType" AS ENUM ('BEAST', 'FLYING', 'HUMANOID', 'CANINE');
+
+-- CreateTable
+CREATE TABLE "Monster" (
+    "id" UUID NOT NULL,
+    "name" TEXT NOT NULL,
+    "monsterType" "MonsterType"[],
+
+    CONSTRAINT "Monster_pkey" PRIMARY KEY ("id")
+);
+
+-- CreateTable
+CREATE TABLE "MonsterBiome" (
+    "monsterId" UUID NOT NULL,
+    "biome" "Biome" NOT NULL,
+    "weight" DECIMAL(65,30) NOT NULL,
+    "time" JSONB NOT NULL,
+
+    CONSTRAINT "MonsterBiome_pkey" PRIMARY KEY ("monsterId","biome")
+);
+
+-- CreateIndex
+CREATE UNIQUE INDEX "Monster_name_key" ON "Monster"("name");
+
+-- AddForeignKey
+ALTER TABLE "MonsterBiome" ADD CONSTRAINT "MonsterBiome_monsterId_fkey" FOREIGN KEY ("monsterId") REFERENCES "Monster"("id") ON DELETE RESTRICT ON UPDATE CASCADE;