-- Metadata-only DDL: instant, holds AccessExclusiveLock on "recommendation"
-- only momentarily. The FK is added NOT VALID so no full-table validation scan
-- happens here; it is validated online by the standalone backfill script. The
-- index is created CONCURRENTLY by that script too, after the column is filled.
-- See docs/adr/0001-data-backfills-outside-drizzle.md
ALTER TABLE "recommendation" ADD COLUMN "plan_id" bigint;--> statement-breakpoint
ALTER TABLE "recommendation" ADD CONSTRAINT "recommendation_plan_id_plan_id_fk" FOREIGN KEY ("plan_id") REFERENCES "public"."plan"("id") ON DELETE cascade ON UPDATE no action NOT VALID;
