Unique email constraint
There is a unique constraint on the email of web user but indeed this constraint is only useful for active user.
On the long term, user could return after being inactivated (ex: #7169 (closed)). In this case, we can not be sure that it is still the same user.
So I think we should only require the email for active user and so let the unique constraint allow multiple NULL.