exploring/fighting is functional

[sketchy-heroes.git] / prisma / migrations / 20220314195228_add_monsters / migration.sql

diff --git a/prisma/migrations/20220314195228_add_monsters/migration.sql b/prisma/migrations/20220314195228_add_monsters/migration.sql
new file mode 100644 (file)
index 0000000..6ce6980
--- /dev/null
+++ b/prisma/migrations/20220314195228_add_monsters/migration.sql
@@ -0,0 +1,14 @@
+/*
+  Warnings:
+
+  - The values [CANINE] on the enum `MonsterType` will be removed. If these variants are still used in the database, this will fail.
+
+*/
+-- AlterEnum
+BEGIN;
+CREATE TYPE "MonsterType_new" AS ENUM ('BEAST', 'FLYING', 'HUMANOID', 'GIANT', 'INSECT', 'UNDEAD');
+ALTER TABLE "Monster" ALTER COLUMN "monsterType" TYPE "MonsterType_new"[] USING ("monsterType"::text::"MonsterType_new"[]);
+ALTER TYPE "MonsterType" RENAME TO "MonsterType_old";
+ALTER TYPE "MonsterType_new" RENAME TO "MonsterType";
+DROP TYPE "MonsterType_old";
+COMMIT;