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 [email protected] http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
