-- Backfill nullable rows before enforcing NOT NULL. UPDATE "deliverables" SET "start_date" = "created_at" WHERE "start_date" IS NULL; UPDATE "deliverables" SET "expected_end_date" = "start_date" + INTERVAL '7 days' WHERE "expected_end_date" IS NULL; -- AlterTable ALTER TABLE "deliverables" ALTER COLUMN "start_date" SET NOT NULL, ALTER COLUMN "expected_end_date" SET NOT NULL;