[Kamailio-Users] UUID column in usr_preferences - How unique does it need to be?

Graham Wooden graham at g-rock.net
Wed Oct 22 17:58:20 CEST 2008


Thanks Daniel. That clears it up.

-graham

> Hello,
>
> On 10/20/08 15:06, Graham Wooden wrote:
>> Hi,
>>
>> By looking at the indexes set for the table usr_preferences, it   
>> appears that UUID is going to be unique against the attribute column.
>> So if user A has a attribute of custom_parameter_Z and user B has   
>> the same attribute, then both UUIDs need to be different, right?
>> UUID can really be anything right? Its set to VARCHAR(64), so heck   
>> - a MD5 checksum against say a epoch timestamp would be fine.
>> I just want to confirm how unique each row (in respects to the   
>> UUID) it needs to be.
>>
> the idea behind uuid is to offer a way to store attributes per an
> arbitrary ID.
>
> There are two options to store the attributes:
> - per username (and domain)
> - per ID
>
> A constraint of unique (uuid,attribute) is not right, as there could be
> many values for same attribute belonging to same UUID.
>
> Cheers,
> Daniel
>
> -- 
> Daniel-Constantin Mierla
> http://www.asipto.com






More information about the Users mailing list