[Opensim-dev] User vs Avatar [WAS: Proposed additional db fields]

[Stefan Andersson]

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.
 
Maybe the cross-section would be the 'agent' - and in the simplest of instances, agentId == userId == avatarId.
 
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.
Best regards,Stefan AnderssonTribal Media AB Join the 3d web revolution : http://tribalnet.se/ 



To: opensim-dev at lists.berlios.deFrom: alan_webb at us.ibm.comDate: Mon, 3 Nov 2008 17:03:43 -0500Subject: Re: [Opensim-dev] Proposed additional db fieldsAs 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. 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. Best regardsAlan-------------------T.J. Watson Research Center, Hawthorne, NY1-914-784-7286alan_webb at us.ibm.com 



Sean Dague <sdague at gmail.com> Sent by: opensim-dev-bounces at lists.berlios.de 
11/03/2008 03:12 PM 




Please respond toopensim-dev at lists.berlios.de





To
opensim-dev at lists.berlios.de 


cc



Subject
[Opensim-dev] Proposed additional db fields




I've got a couple of proposed db fields that I think we should add in,but I want feedback before just putting it in.users:* email - this is added by a lot of the web based management stacks,and would be really handy to be in the base user definition.  I suspectthis is non controversial.assets:* create_time - the unix timestamp when the asset is created* access_time - the unix timestamp for last asset accessThe rationale for these asset additional fields was some brainstormingthis weekend on how we'd ever support asset reaping.  Why not perfect,this may help in determining what are active assets, and what areancient assets that may be suitable for reaping.  Without these bits ofinformation, we've got a hard time here.Comments welcomed,                -Sean-- Sean Dague / Neas Badesdague at gmail.comhttp://dague.net_______________________________________________Opensim-dev mailing listOpensim-dev at lists.berlios.dehttps://lists.berlios.de/mailman/listinfo/opensim-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20081104/7286f71c/attachment-0001.html>