proc-gen equipment drops from monsters can be picked up

[sketchy-heroes.git] / prisma / migrations / 20220325174002_add_worldrops / migration.sql

diff --git a/prisma/migrations/20220325174002_add_worldrops/migration.sql b/prisma/migrations/20220325174002_add_worldrops/migration.sql
new file mode 100644 (file)
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;