Editing OpenSimulator Internals/Databases (section)

=== Avatars ===

Key-value store. One row per attribute per avatar. PrincipalID + Name form the composite key.

{| class="wikitable"
! Name pattern !! Value format !! Notes
|-
| _ap_N || UUID or comma-separated UUIDs || Attachment point N -- asset UUID of worn item. Comma-separated for multi-attach points.
|-
| Wearable N:0 || inventoryUUID:assetUUID || Worn wearable layer N. 0=shape, 1=skin, 2=shirt, 3=pants, 13=physics, etc.
|-
| AvatarHeight || float || Avatar height in metres
|-
| AvatarType || int || 0 = classic system avatar, 1 = mesh avatar
|-
| VisualParams || comma-separated bytes || 253-element appearance slider array -- body shape, skin tone, hair color etc.
|-
| Serial || int || Appearance version serial number
|}

Attachment point numbers follow the SL/OpenSim standard: 2=chest, 5=left hand, 12=hair, 40=left foot, etc. Multi-attach points store comma-separated UUIDs.

Sample data (Jagga Meredith, 13 rows): AvatarType=1 (mesh), AvatarHeight=1.6885326, 4 attachment points, 5 wearable layers (shape, skin, shirt, pants, physics).

----