[Opensim-users] Uniqueness in MySQL 'useraccounts'

[M.E. Verhagen]

the PrincipalID field is already the primary key.

There can be only one primary key.

This uuid key is the unique identifier on wich an avatar is idenified.

When you write you own member system with direct database manipulation
than you should check if the avatar is unique or else you will end up
with more than one avatar name attached to an uuid.



2012/3/4, Kevin Buckley <kevin at buckley70.freeserve.co.uk>:
> 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.
>
>


-- 
Groningen en Hannover Opensims:   secondlife://meverhagen.nl:8002:Hannover
ZW/