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

diff --git a/prisma/migrations/20220317154129_rework_items/migration.sql b/prisma/migrations/20220317154129_rework_items/migration.sql
new file mode 100644
index 0000000..a60f81b
--- /dev/null
+++ b/prisma/migrations/20220317154129_rework_items/migration.sql
@@ -0,0 +1,14 @@
+/*
+  Warnings:
+
+  - You are about to drop the column `availableRarity` on the `Item` table. All the data in the column will be lost.
+  - Added the required column `rarity` to the `Inventory` table without a default value. This is not possible if the table is not empty.
+  - Added the required column `rarityDropRates` to the `Item` table without a default value. This is not possible if the table is not empty.
+
+*/
+-- AlterTable
+ALTER TABLE "Inventory" ADD COLUMN     "rarity" "Rarity" NOT NULL;
+
+-- AlterTable
+ALTER TABLE "Item" DROP COLUMN "availableRarity",
+ADD COLUMN     "rarityDropRates" JSONB NOT NULL;