Database:Inventoryitems
From OpenSimulator
inventoryitems Records details with respect to the avatar's personal property (assets) (back to Database Documentation)
The current structure of the inventoryitems table is as follows:
| Field | Type | Null | Key | Default | Extra | |
| assetID | varchar(36) | YES | NULL | |||
| assetType | int(11) unsigned | YES | NULL | |||
| inventoryName | varchar(64) | YES | NULL | |||
| inventoryDescription | varchar(64) | YES | NULL | |||
| inventoryNextPermissions | int(10) unsigned | YES | NULL | |||
| inventoryCurrentPermissions | int(10) unsigned | YES | NULL | |||
| invType | int(11) | YES | NULL | |||
| CreatorID | varchar(36) | YES | NULL | |||
| inventoryBasePermissions | int(10) unsigned | NO | 0 | |||
| inventoryEveryOnePermissions | int(10) unsigned | NO | 0 | |||
| salePrice | int(11) | NO | NULL | |||
| saleType | tinyint(4) | NO | NULL | |||
| creationDate | int(11) | NO | NULL | |||
| groupID | varchar(36) | NO | 00000000-0000-0000-0000-000000000000 | |||
| groupOwned | tinyint(4) | NO | NULL | |||
| flags | int(11) unsigned | NO | 0 | |||
| inventoryID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | ||
| avatarID | char(36) | YES | MUL | NULL | ||
| parentFolderId | char(36) | YES | MUL | NULL |
(back to Database Documentation)
Owner
Serial
Visual_Params
Texture
Avatar_Height
Body_Item
Refers to inventory item for Body
Body_Asset
Refers to item in assets for Body
Skin_Item
Refers to inventory item for Skin
Skin_Asset
Refers to item in assets for Skin
Hair_Item
Refers to inventory item for Hair
Hair_Asset
Refers to item in assets for Hair
Eyes_Item
Refers to inventory item for Eyes
Eyes_Asset
Refers to item in assets for Eyes
Shirt_Item
Refers to inventory item for Shirt
Shirt_Asset
Refers to item in assets for Shirt
Pants_Item
Refers to inventory item for Pants
Pants_Asset
Refers to item in assets for Pants
Shoes_Item
Refers to inventory item for Shoes
Shoes_Asset
Refers to item in assets for Shoes
Socks_Item
Refers to inventory item for Socks
Socks_Asset
Refers to item in assets for Socks
Jacket_Item
Refers to inventory item for Jacket
Jacket_Asset
Refers to item in assets for Jacket
Gloves_Item
Refers to inventory item for Gloves
Gloves_Asset
Refers to item in assets for Gloves
Undershirt_Item
Refers to inventory item for Undershirt
Undershirt_Asset
Refers to item in assets for Undershirt
Underpants_Item
Refers to inventory item for Underpants
Underpants_Asset
Refers to item in assets for Underpants
Skirt_Asset
Refers to item in assets for Skirt
Skirt_Item
Refers to inventory item for Skirt
(back to Database Documentation)
