-- CreateEnum
CREATE TYPE "ProgressReportDeadlineStatus" AS ENUM ('DRAFT', 'SENT');

-- AddColumn
ALTER TABLE "progress_report_deadlines"
  ADD COLUMN "status" "ProgressReportDeadlineStatus" NOT NULL DEFAULT 'DRAFT';

-- Existing active deadlines were already visible to Ministries before this
-- workflow status existed. Keep that behavior after the migration.
UPDATE "progress_report_deadlines"
   SET "status" = 'SENT'
 WHERE "deleted_at" IS NULL;

-- CreateIndex
CREATE INDEX "progress_report_deadlines_status_idx"
  ON "progress_report_deadlines"("status");
