2 ALTER TABLE "Inventory" ADD COLUMN "discovered" BOOLEAN NOT NULL DEFAULT false,
3 ADD COLUMN "usesUntilDiscovery" INTEGER NOT NULL DEFAULT 40;
6 CREATE TABLE "WorldDrop" (
8 "itemId" UUID NOT NULL,
9 "dropDate" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
10 "droppedById" UUID NOT NULL,
12 CONSTRAINT "WorldDrop_pkey" PRIMARY KEY ("id")
16 ALTER TABLE "WorldDrop" ADD CONSTRAINT "WorldDrop_droppedById_fkey" FOREIGN KEY ("droppedById") REFERENCES "Player"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
19 ALTER TABLE "WorldDrop" ADD CONSTRAINT "WorldDrop_itemId_fkey" FOREIGN KEY ("itemId") REFERENCES "Item"("id") ON DELETE RESTRICT ON UPDATE CASCADE;