X-Git-Url: https://git.xangelo.ca/?p=sketchy-heroes.git;a=blobdiff_plain;f=prisma%2Fmigrations%2F20220317054315_add_more_types%2Fmigration.sql;fp=prisma%2Fmigrations%2F20220317054315_add_more_types%2Fmigration.sql;h=b98425685b73fab259a08b366ce3c1520444c316;hp=0000000000000000000000000000000000000000;hb=b5d3cc37fddebff8dcdf1ef0cdd3a626811f14d3;hpb=20dc560a75cfd6ddc8a66956315a30001779ec24

diff --git a/prisma/migrations/20220317054315_add_more_types/migration.sql b/prisma/migrations/20220317054315_add_more_types/migration.sql
new file mode 100644
index 0000000..b984256
--- /dev/null
+++ b/prisma/migrations/20220317054315_add_more_types/migration.sql
@@ -0,0 +1,11 @@
+-- AlterEnum
+-- This migration adds more than one value to an enum.
+-- With PostgreSQL versions 11 and earlier, this is not possible
+-- in a single migration. This can be worked around by creating
+-- multiple migrations, each migration adding only one value to
+-- the enum.
+
+
+ALTER TYPE "InventoryType" ADD VALUE 'WEAPON';
+ALTER TYPE "InventoryType" ADD VALUE 'SHIELD';
+ALTER TYPE "InventoryType" ADD VALUE 'ARMOUR';