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

diff --git a/prisma/migrations/20220325174002_add_worldrops/migration.sql b/prisma/migrations/20220325174002_add_worldrops/migration.sql
new file mode 100644
index 0000000..3e1a199
--- /dev/null
+++ b/prisma/migrations/20220325174002_add_worldrops/migration.sql
@@ -0,0 +1,19 @@
+-- AlterTable
+ALTER TABLE "Inventory" ADD COLUMN     "discovered" BOOLEAN NOT NULL DEFAULT false,
+ADD COLUMN     "usesUntilDiscovery" INTEGER NOT NULL DEFAULT 40;
+
+-- CreateTable
+CREATE TABLE "WorldDrop" (
+    "id" UUID NOT NULL,
+    "itemId" UUID NOT NULL,
+    "dropDate" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    "droppedById" UUID NOT NULL,
+
+    CONSTRAINT "WorldDrop_pkey" PRIMARY KEY ("id")
+);
+
+-- AddForeignKey
+ALTER TABLE "WorldDrop" ADD CONSTRAINT "WorldDrop_droppedById_fkey" FOREIGN KEY ("droppedById") REFERENCES "Player"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
+
+-- AddForeignKey
+ALTER TABLE "WorldDrop" ADD CONSTRAINT "WorldDrop_itemId_fkey" FOREIGN KEY ("itemId") REFERENCES "Item"("id") ON DELETE RESTRICT ON UPDATE CASCADE;