[Opensim-users] Asset records for deleted inventory prims and prim groups

[Jeff Kelley]

At 1:51 AM +0200 1/1/14, George Anastassakis wrote:

>Is it ok to manually delete prim-type records in the assets table if 
>all associated prims and prim groups in the inventory have been 
>deleted? (Or, in what I hope is the same question in other words, is 
>it safe to manually delete prim-type records in the assets table if 
>those records are not referenced by the inventoryitems table?) If 
>not, please explain why.

Prim-type records, I assume they are assets type 6 aka serialized 
objects, may be referenced from inside other objects.

It is easy to check for in-world objects, quering the primitems 
table. This is the case of "boxed items".

SELECT id,name FROM assets WHERE assetType=6 AND id IN (SELECT 
assetID FROM primitems);

It is much more difficult for serialized (in inventory) objects since 
you should parse each and every object XML to find them.

Additionally, they may be referenced from notecards (although i am not sure).


-- Jeff