-- 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;
