Make username reusable
When I delete an profile from a user, it would be great if the profile name was reusable afterwards. The scenario I have in mind is that a user create an account on a Mobilizon instance and then realizes that a group would be a better fit for their use case, but now the name is already taken by the account, even if the account deletes the profile with that name.
PS: I guess the problem is that after deletion of the profile, there is still an actor in the actors table using that profile name in preferred_username
and other fields. With access to the DB I could remove that row by hand, but are there any side effects when manually deleting that row?