Kenneth; Name should also be unique , else how would 'someuser' login with their password? As far as I know if a user created via email , then the Name will be the email address which should also be unique across the internet.
Regards; Roy Kenneth Marshall wrote: > Dear RT developers, > > I have been investigating a problem with the automatic account > creation process. I have been getting "could not load user" > errors when internal users where trying to test from their > external E-mail accounts to verify functionality. The upshot > of my investigation is that the schemas all define a unique > index on Name in the Users table. This is doomed to fail for > most people who are sending from their Gmail/Hotmail/AOL > accounts instead of their internal E-mail addresses. > > I was under the impression that the unique identifier for > RT users was the EmailAddress and not the Name. In that > case, the unique index should be on EmailAddress, instead > of Name or alternatively the unique index should be on a > composite key such as Name+EmailAddress. > > Would there be a problem with making that schema change > and which is the preferred direction. > > Regards, > Ken Marshall > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [email protected] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
