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 _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
