Editing OpenSimulator Internals/Databases (section)

=== assets ===

{| class="wikitable"
! Field !! Type !! Notes
|-
| id || char(36) || Primary key -- asset UUID
|-
| name || varchar(64) || Display name
|-
| description || varchar(64) || Description -- HG landmarks store grid URI here
|-
| assetType || tinyint || Asset type number (see below)
|-
| data || longblob || Raw binary asset data
|-
| local || tinyint(1) || 1 = local-only, not transferred to other grids
|-
| temporary || tinyint(1) || 1 = temporary, may be discarded
|-
| asset_flags || int || Bitmask of asset flags
|-
| CreatorID || varchar(128) || Creator UUID or HyperGrid URI
|-
| create_time || int || Unix timestamp of creation
|-
| access_time || int || Unix timestamp of last access
|}

Asset types observed on osimdev:

{| class="wikitable"
! assetType !! Name
|-
| 0 || Texture
|-
| 3 || Landmark -- HG landmarks store grid URI in description field
|-
| 6 || Object -- serialized prim/linkset XML
|-
| 7 || Notecard
|-
| 10 || Script
|-
| 20 || Animation
|}

Library/system assets use non-random UUID patterns and CreatorID 11111111-1111-0000-0000-000100bba000. On osimdev after initial setup and one user session: 2602 total assets, 85 user-created (1 texture, 4 landmarks, 79 objects, 1 notecard).

----