To complete #7172 (closed), the unique constraint could be replaced by an exclude on active user only.