simple-mail-cleaner/backend/prisma/migrations/20260123170000_rule_phase/migration.sql

-- Add rule execution phase (pre/post unsubscribe)
CREATE TYPE "RulePhase" AS ENUM ('PRE_UNSUBSCRIBE', 'POST_UNSUBSCRIBE');

ALTER TABLE "Rule"
ADD COLUMN "phase" "RulePhase" NOT NULL DEFAULT 'POST_UNSUBSCRIBE';