When deleting a snippet repository, we need to consider
three scenarios:
- Project deletions
- User deletions
- Direct snippet deletions

We need to update `Projects::DestroyService` and
`Users::DestroyServices` to handle this new type of
repository.