<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">David,<div><br></div><div>As Pasan mentioned, it can be used for the query key for whatever value you're pulling. In my network, the uuid could be a trunk name if I'm storing trunk attributes, a trunk group number if I'm storing data about that group, or a phone number to hold call forwarding or other information about that phone number...</div><div><br></div><div>There are several ways in the AVP environment to key values. I use uuid rather than username or username/domain.</div><div><br></div><div><br></div><div>- Jeff</div><div><br><div><div>On Aug 13, 2010, at 8:08 AM, David J. wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">
<div text="#000000" bgcolor="#ffffff">
Thx...<br>
<br>
Any idea what the purpose of the field is?<br>
<br>
<br>
<br>
On 8/13/10 6:39 AM, Pasan Meemaduma wrote:
<blockquote cite="mid:662878.11553.qm@web45202.mail.sp1.yahoo.com" type="cite">
<style type="text/css"><!-- DIV {margin:0px;} --></style>
<div style="font-family: times new roman,new york,times,serif;
font-size: 12pt;">
<div>Hi David,<br>
<br>
UUID field is not mandatory. you can just insert other fields
without UUID.<br>
<br>
It could use as a reference key if you want.<br>
<br>
+-------+------+------------+-----------+-----------+------+-------+---------------------+<br>
| id | uuid | username | domain | attribute | type |
value | last_modified |<br>
+-------+------+------------+-----------+-----------+------+-------+---------------------+<br>
| 14497 | | xxx | xxxx | timeout | 0 | 50 |
2000-03-02 16:21:59 | <br>
<br>
</div>
<div style="font-family: times new roman,new york,times,serif;
font-size: 12pt;"><br>
<div style="font-family: arial,helvetica,sans-serif;
font-size: 13px;"><font face="Tahoma" size="2">
<hr size="1"><b><span style="font-weight: bold;">From:</span></b>
David J. <a class="moz-txt-link-rfc2396E" href="mailto:david@styleflare.com"><david@styleflare.com></a><br>
<b><span style="font-weight: bold;">To:</span></b>
OpenSIPS users mailling list
<a class="moz-txt-link-rfc2396E" href="mailto:users@lists.opensips.org"><users@lists.opensips.org></a><br>
<b><span style="font-weight: bold;">Sent:</span></b>
Friday, August 13, 2010 15:57:28<br>
<b><span style="font-weight: bold;">Subject:</span></b>
[OpenSIPS-Users] UUID value in usr_preferences<br>
</font><br>
List,<br>
<br>
what value should I be using in the UUID field in the
usr_preferences table?<br>
<br>
I was trying to manually insert into the table, and got
stumbled by this <br>
field, the rest seem to make sense.<br>
<br>
Thx.<br>
<br>
<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true" ymailto="mailto:Users@lists.opensips.org" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</div>
</div>
</div>
<br>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>http://lists.opensips.org/cgi-bin/mailman/listinfo/users<br></blockquote></div><br></div></body></html>