Editing OpenSimulator Internals/Databases (section)

=== inventoryitems ===

{| class="wikitable"
! Field !! Type !! Notes
|-
| inventoryID || char(36) || Primary key
|-
| assetID || varchar(36) || Foreign key to assets.id
|-
| assetType || int || Asset type
|-
| invType || int || Inventory type (can differ from assetType)
|-
| inventoryName || varchar(64) || Display name
|-
| inventoryDescription || varchar(128) ||
|-
| avatarID || char(36) || Owner UUID
|-
| parentFolderID || char(36) || Containing folder UUID
|-
| creatorID || varchar(255) || Creator UUID or HyperGrid URI
|-
| inventoryBasePermissions || int unsigned || Base permission bitmask
|-
| inventoryCurrentPermissions || int unsigned || Current permission bitmask
|-
| inventoryNextPermissions || int unsigned || Next owner permission bitmask
|-
| inventoryEveryOnePermissions || int unsigned || Everyone permission bitmask
|-
| inventoryGroupPermissions || int unsigned || Group permission bitmask
|-
| groupID || varchar(36) || Associated group UUID
|-
| groupOwned || tinyint || 1 if group-owned
|-
| salePrice || int || Sale price in grid currency
|-
| saleType || tinyint || 0=not for sale, 1=original, 2=copy, 3=contents
|-
| creationDate || int || Unix timestamp
|-
| flags || int unsigned || Item flags
|}

creatorID is varchar(255) to accommodate HyperGrid creator URIs. Item count on osimdev after initial session and AviWorlds visit: 380 items (171 objects, 75 animations, 34 links, 28 textures, 24 body parts, 21 clothing, 15 landmarks, 6 notecards, 3 scripts, 2 sounds, 1 mesh).

----