mahara-contributors team mailing list archive

[Aaron Wells <903494@xxxxxxxxxxxxxxxxxx>]

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