feature request #7276
Make User.email a unique field.
50%
Description
Make User.email a unique field.
In the context of password recovery it seems also a requirement to make the email address unique in the UserAccount table.
In order to recover a password the user can usually either supply the login or email address.
NOTE: As long as #7275 is not implemented or if it is rejected it is NOT possible to implement by standard
@Column(unique = true)
as NULL values are duplicates otherwise.
Related issues
Associated revisions
fix #7276 Make User.emailAddress a unique field
ref #7276 revert "make User.email a unique field"
ref #7276 revert "make User.email a unique field"
History
#1 Updated by Andreas Müller 11 months ago
- Copied from feature request #7275: [DISCUSS] Require email address for Users added
#2 Updated by Andreas Müller 11 months ago
This only makes sense if email is an obligatory field, which currently is not the case and probably also will not be the case in future.
#3 Updated by Andreas Müller 9 months ago
- Status changed from New to Resolved
- % Done changed from 0 to 50
#4 Updated by Andreas Müller 9 months ago
- Description updated (diff)
- Status changed from Resolved to New
#5 Updated by Andreas Müller 9 months ago
- Status changed from New to Resolved
Applied in changeset cdmlib|b28a90506f2310c1ebf51dcd2b939ef92814c0be.
#6 Updated by Andreas Müller 8 months ago
- Status changed from Resolved to Feedback
- Assignee changed from Andreas Müller to Andreas Kohlbecker
For now I suggest to reject this feature request as long as NULL values are allowed (#7275).
We could only try to check programmatically if an email address already exists. Also we could try to right a validation rule NullOrUnique. But theses solutions might be new tickets. What do you think.
#7 Updated by Andreas Kohlbecker 8 months ago
- Target version changed from CDM UML 5.0 to Release 5.1
#8 Updated by Andreas Müller 8 months ago
- Target version changed from Release 5.1 to CDM UML 5.5
