[Opensim-dev] Proposed additional db fields

[Hurliman, John]

Currently, http://forge.opensimulator.org/gf/project/assetserver/ is computing the asset hash value for every row during asset synchronization. That would be the only immediate use case I know of. Although if the value was there it would make the auditing authorization plugin much easier to implement.

John

-----Original Message-----
From: opensim-dev-bounces at lists.berlios.de [mailto:opensim-dev-bounces at lists.berlios.de] On Behalf Of Sean Dague
Sent: Wednesday, November 05, 2008 7:24 AM
To: opensim-dev at lists.berlios.de
Subject: Re: [Opensim-dev] Proposed additional db fields

Sean Dague wrote:
> Hurliman, John wrote:
>> This sounds great, as create_time is one of the missing metadata fields that the distributed asset server uses. Would you also consider adding a SHA-1 hash field for assets? It makes asset synchronization between two servers easier and simple auditing possible.
> 
> Good call, that can be done.  I just merged in the email changes 
> yesterday, so hopefully can do the asset changes today.

Actually, before I add this, is there an immediate use case?  Also, I'm wondering if we really want to create a database column for a value that is computed from a single operation on another column in the same table.
 While slightly more efficient, it seems bade on the data duplication front unless it is going to be actively used in joins.

	-Sean

--
Sean Dague / Neas Bade
sdague at gmail.com
http://dague.net