/*
  Warnings:

  - A unique constraint covering the columns `[can_id]` on the table `Report` will be added. If there are existing duplicate values, this will fail.
  - A unique constraint covering the columns `[can_id]` on the table `Review` will be added. If there are existing duplicate values, this will fail.

*/
-- AlterTable
ALTER TABLE "Report" ADD COLUMN     "can_id" TEXT;

-- AlterTable
ALTER TABLE "Review" ADD COLUMN     "can_id" TEXT;

-- CreateIndex
CREATE UNIQUE INDEX "Report_can_id_key" ON "Report"("can_id");

-- CreateIndex
CREATE UNIQUE INDEX "Review_can_id_key" ON "Review"("can_id");

-- AddForeignKey
ALTER TABLE "Review" ADD CONSTRAINT "Review_can_id_fkey" FOREIGN KEY ("can_id") REFERENCES "Cans"("id") ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "Report" ADD CONSTRAINT "Report_can_id_fkey" FOREIGN KEY ("can_id") REFERENCES "Cans"("id") ON DELETE SET NULL ON UPDATE CASCADE;