Hi Kristina, The field artefact_internal_profile_email.email is the database column where email artefacts get stored. If there are legitimate reasons for more than one user to have the same email address, then we should *not* put a uniqueness constraint on that column.
(A note for future developers looking at this: emails are also redundantly stored in the usr.email column. The email there is the user's "primary email address", which Mahara uses when it needs to send then an email. The other email addresses are mostly just for displaying in Contact Info & Profile blocks.) Cheers, Aaron -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/903494 Title: Uniqueness of email addresses not enforced in artefact_internal_profile_email Status in Mahara ePortfolio: Triaged Bug description: The uniqueness of email addresses is not enforced by the database in the artefact_internal_profile_email table. We should consider adding a unique constraint on that column because elsewhere we prevent users from adding an email address already claimed by another user. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/903494/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
