Debug: Misused Unique Constraint for Soft Delete

Interviewer prompt: This constraint blocks re-creating username after soft delete. ALTER TABLE accounts ADD CONSTRAINT uq_accounts_username UNIQUE(username); Fix for soft-delete model with deleted_at.