-- AlterTable
ALTER TABLE "Recipt" ADD COLUMN     "lifeCycleId" TEXT;

-- CreateTable
CREATE TABLE "LifeCycle" (
    "id" TEXT NOT NULL,
    "life_cycle" INTEGER NOT NULL DEFAULT 1,
    "cans_required" INTEGER NOT NULL DEFAULT 250,
    "cans_have_low" INTEGER NOT NULL DEFAULT 0,
    "cans_have_high" INTEGER NOT NULL DEFAULT 0,
    "earnings" DOUBLE PRECISION NOT NULL DEFAULT 0,

    CONSTRAINT "LifeCycle_pkey" PRIMARY KEY ("id")
);

-- AddForeignKey
ALTER TABLE "Recipt" ADD CONSTRAINT "Recipt_lifeCycleId_fkey" FOREIGN KEY ("lifeCycleId") REFERENCES "LifeCycle"("id") ON DELETE SET NULL ON UPDATE CASCADE;