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 _______________________________________________ Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
