ALTER TABLE "Recipe"
ADD COLUMN "adaptedFromRecipeId" TEXT;

ALTER TABLE "Recipe"
ADD CONSTRAINT "Recipe_adaptedFromRecipeId_fkey"
FOREIGN KEY ("adaptedFromRecipeId") REFERENCES "Recipe"("id")
ON DELETE SET NULL ON UPDATE CASCADE;

CREATE INDEX "Recipe_adaptedFromRecipeId_idx" ON "Recipe"("adaptedFromRecipeId");