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

diff --git a/prisma/migrations/20220314195228_add_monsters/migration.sql b/prisma/migrations/20220314195228_add_monsters/migration.sql
new file mode 100644
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;