[Opensim-users] Uniqueness in MySQL 'useraccounts'

[Kevin Buckley]

I hope this is not covering old ground.  I'm playing with a member system
for standalone OpenSim and I'm trying to decide the best way to deal with
the FirstName/LastName uniqueness issue (as my sign-up process allows
multiple, concurrent users).

 

I notice that the default useraccounts table has a composite key called Name
(which consists of FirstName and LastName).  But it isn't defined as a
primary key.  So duplicate name inserts are not trapped as a result of that
(I believe that is the reason, anyway).

 

Does anyone know if there is a reason 'Name' is not defined as a primary
key?  Is there a problem with making it so?

 

I have other ways I can deal with this but trapping it at the useraccounts
table insert would be the best way.

 

Thanks.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120304/1f9acbc8/attachment.html>