<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>It is my firm belief, based on numerous integrations with custom backends, that we should separate the 'user' concept from the 'avatar' concept. On all Tribal Medias productions, the user logs on with a user id, not avatar first/last. In the real world (aka non-sl-grid world) it makes sense to separate them in the db.<BR>
<BR>
Maybe the cross-section would be the 'agent' - and in the simplest of instances, agentId == userId == avatarId.<BR>
<BR>
What I mean is that an asset was uploaded and accessed by an 'agent', not a 'user' or an 'avatar'. This should be reflected in the tables as well.<BR>
<BR>Best regards,<BR>Stefan Andersson<BR>Tribal Media AB<BR> <BR>Join the 3d web revolution : <A href="http://tribalnet.se/" target=_blank>http://tribalnet.se/</A><BR> <BR><BR><BR><BR>
<HR id=EC_stopSpelling>
<BR>
To: opensim-dev@lists.berlios.de<BR>From: alan_webb@us.ibm.com<BR>Date: Mon, 3 Nov 2008 17:03:43 -0500<BR>Subject: Re: [Opensim-dev] Proposed additional db fields<BR><BR><BR><FONT face=sans-serif size=2>As you say, e-mail in user information should be non-controversial, but it does highlight the difference between users and avatars. Does the OpenSim database actually reflect users? Or avatars? I thought the latter. What purpose will the e-mail address serve? I think there maybe more reluctance to provide this information than you might think. I'm prsonally nearly as opressed by providing my e-mail as I am my telephone number.</FONT> <BR><BR><FONT face=sans-serif size=2>Create time, given its one-to-one correspondence with an asset seems OK to me, but I think there is probably room for lots of discussion on ways to determine currency.</FONT> <BR><BR><BR><FONT face=sans-serif size=2><BR>Best regards<BR>Alan<BR>-------------------<BR>T.J. Watson Research Center, Hawthorne, NY<BR>1-914-784-7286<BR>alan_webb@us.ibm.com</FONT> <BR><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD width="40%"><FONT face=sans-serif size=1><B>Sean Dague <sdague@gmail.com></B> </FONT><BR><FONT face=sans-serif size=1>Sent by: opensim-dev-bounces@lists.berlios.de</FONT>
<FONT face=sans-serif size=1>11/03/2008 03:12 PM</FONT>
<TABLE border=1>
<TBODY>
<TR vAlign=top>
<TD bgColor=white>
<DIV align=center><FONT face=sans-serif size=1>Please respond to<BR>opensim-dev@lists.berlios.de</FONT></DIV></TD></TR></TBODY></TABLE><BR><BR>
<TD width="59%">
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>To</FONT></DIV>
<TD><FONT face=sans-serif size=1>opensim-dev@lists.berlios.de</FONT>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>cc</FONT></DIV>
<TD>
<TR vAlign=top>
<TD>
<DIV align=right><FONT face=sans-serif size=1>Subject</FONT></DIV>
<TD><FONT face=sans-serif size=1>[Opensim-dev] Proposed additional db fields</FONT></TD></TR></TBODY></TABLE><BR>
<TABLE>
<TBODY>
<TR vAlign=top>
<TD>
<TD></TD></TR></TBODY></TABLE><BR></TD></TR></TBODY></TABLE><BR><BR><BR><TT><FONT face="" size=2>I've got a couple of proposed db fields that I think we should add in,<BR>but I want feedback before just putting it in.<BR><BR>users:<BR>* email - this is added by a lot of the web based management stacks,<BR>and would be really handy to be in the base user definition. I suspect<BR>this is non controversial.<BR><BR>assets:<BR>* create_time - the unix timestamp when the asset is created<BR>* access_time - the unix timestamp for last asset access<BR><BR>The rationale for these asset additional fields was some brainstorming<BR>this weekend on how we'd ever support asset reaping. Why not perfect,<BR>this may help in determining what are active assets, and what are<BR>ancient assets that may be suitable for reaping. Without these bits of<BR>information, we've got a hard time here.<BR><BR>Comments welcomed,<BR><BR> -Sean<BR><BR>-- <BR>Sean Dague / Neas Bade<BR>sdague@gmail.com<BR>http://dague.net<BR><BR><BR>_______________________________________________<BR>Opensim-dev mailing list<BR>Opensim-dev@lists.berlios.de<BR>https://lists.berlios.de/mailman/listinfo/opensim-dev<BR></FONT></TT><BR></body>
</html>