Implement Soft Delete with Constraint Safety

Interviewer prompt: Introduce soft delete for projects while preventing duplicate active names within the same organization. Write SQL changes.

projects(project_id, org_id, name)