Database:Inventoryitems
From OpenSimulator
JeffKelley (Talk | contribs) m (Added wearable subtype 15 (Physics)) |
m (Formatting changes to match other database documentation pages) |
||
| Line 55: | Line 55: | ||
| inventoryGroupPermissions || int(10) unsigned || NO || || 0 || | | inventoryGroupPermissions || int(10) unsigned || NO || || 0 || | ||
|} | |} | ||
| + | <br /> | ||
| + | |||
Note: When <u>assetType</u> is 24, the item is a '''link'''. In this case, <u>assetID</u> is not the id of the asset. <br />It is instead the <u>inventoryID</u> of another inventory item, whose <u>assetID</u> points to the target asset. | Note: When <u>assetType</u> is 24, the item is a '''link'''. In this case, <u>assetID</u> is not the id of the asset. <br />It is instead the <u>inventoryID</u> of another inventory item, whose <u>assetID</u> points to the target asset. | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
| − | + | ||
| − | + | == inventoryitems Fields == | |
| + | |||
'''assetID'''<br /> | '''assetID'''<br /> | ||
Refers to the related row in the assets table.<br /> | Refers to the related row in the assets table.<br /> | ||
Calling Cards do not create assets so if assetType=2 (see next field) this field should be "00000000-0000-0000-0000-000000000000". | Calling Cards do not create assets so if assetType=2 (see next field) this field should be "00000000-0000-0000-0000-000000000000". | ||
| − | <br /> | + | <br /> |
| + | |||
'''assetType'''<br /> | '''assetType'''<br /> | ||
Type of asset (e.g., script, texture, or shape - [http://wiki.secondlife.com/wiki/AssetType asset type list]) | Type of asset (e.g., script, texture, or shape - [http://wiki.secondlife.com/wiki/AssetType asset type list]) | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryName'''<br /> | '''inventoryName'''<br /> | ||
Text of the name of the inventory item as it appears in the client inventory interface. | Text of the name of the inventory item as it appears in the client inventory interface. | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryDescription'''<br /> | '''inventoryDescription'''<br /> | ||
Text of the description of the inventory item as it appears in the client inventory interface. | Text of the description of the inventory item as it appears in the client inventory interface. | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryNextPermissions'''<br /> | '''inventoryNextPermissions'''<br /> | ||
Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at [[OpenSim:Permissions]] | Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at [[OpenSim:Permissions]] | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryCurrentPermissions'''<br /> | '''inventoryCurrentPermissions'''<br /> | ||
Permissions on the the item for the current posessor of the item. Permission values can be found at [[OpenSim:Permissions]] | Permissions on the the item for the current posessor of the item. Permission values can be found at [[OpenSim:Permissions]] | ||
| − | <br /> | + | <br /> |
| + | |||
'''invType'''<br /> | '''invType'''<br /> | ||
Type of inventory item. This is a subset of enum InventoryType for items only. | Type of inventory item. This is a subset of enum InventoryType for items only. | ||
<br /> | <br /> | ||
| + | |||
<table> | <table> | ||
<tr><td>Value</td><td>Icon</td><td>Meaning</td></tr> | <tr><td>Value</td><td>Icon</td><td>Meaning</td></tr> | ||
| Line 101: | Line 111: | ||
<br /> | <br /> | ||
Subtype for wearable (assets type 5 and 13).<br /> | Subtype for wearable (assets type 5 and 13).<br /> | ||
| − | The subtype is contained inside the asset data (LLSD format). It does not appear in the table.<br /> | + | The subtype is contained inside the asset data (LLSD format). It does not appear in the table. |
| + | <br /> | ||
| + | |||
<table> | <table> | ||
<tr><td>0</td><td>http://www.pescadoo.net/oswiki/inv_item_shape.png</td><td>Shape (asset type 13) | <tr><td>0</td><td>http://www.pescadoo.net/oswiki/inv_item_shape.png</td><td>Shape (asset type 13) | ||
| Line 120: | Line 132: | ||
<tr><td>15</td><td>http://www.pescadoo.net/oswiki/inv_item_physics.png</td><td>Physics (asset type 5) | <tr><td>15</td><td>http://www.pescadoo.net/oswiki/inv_item_physics.png</td><td>Physics (asset type 5) | ||
</table> | </table> | ||
| − | <br /> | + | <br /> |
| + | |||
'''creatorID'''<br /> | '''creatorID'''<br /> | ||
UUID of the item's original creator. | UUID of the item's original creator. | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryBasePermissions'''<br /> | '''inventoryBasePermissions'''<br /> | ||
Base permissions of the object. Permission values can be found at [[OpenSim:Permissions]] | Base permissions of the object. Permission values can be found at [[OpenSim:Permissions]] | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryEveryOnePermissions'''<br /> | '''inventoryEveryOnePermissions'''<br /> | ||
Permissions with respect to everyone but the owner of the item. Permission values can be found at [[OpenSim:Permissions]] | Permissions with respect to everyone but the owner of the item. Permission values can be found at [[OpenSim:Permissions]] | ||
| − | <br /> | + | <br /> |
| + | |||
'''salePrice'''<br /> | '''salePrice'''<br /> | ||
Sale price of the item. | Sale price of the item. | ||
| − | <br /> | + | <br /> |
| + | |||
'''saleType'''<br /> | '''saleType'''<br /> | ||
''presently unknown'' | ''presently unknown'' | ||
| − | <br /> | + | <br /> |
| + | |||
'''creationDate'''<br /> | '''creationDate'''<br /> | ||
Date the item was created | Date the item was created | ||
| − | <br /> | + | <br /> |
| + | |||
'''groupID'''<br /> | '''groupID'''<br /> | ||
UUID of the group that the items is 'deeded' to | UUID of the group that the items is 'deeded' to | ||
| − | <br /> | + | <br /> |
| + | |||
'''groupOwned'''<br /> | '''groupOwned'''<br /> | ||
group ownership flags | group ownership flags | ||
| − | <br /> | + | <br /> |
| + | |||
'''flags'''<br /> | '''flags'''<br /> | ||
A definition of Flag values can be found at [[OpenSim:Permissions#ObjectFlags_.28F.29]] | A definition of Flag values can be found at [[OpenSim:Permissions#ObjectFlags_.28F.29]] | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryID'''<br /> | '''inventoryID'''<br /> | ||
UUID of inventory item | UUID of inventory item | ||
| − | <br /> | + | <br /> |
| + | |||
'''avatarID'''<br /> | '''avatarID'''<br /> | ||
UUID of item's owner | UUID of item's owner | ||
| − | <br /> | + | <br /> |
| + | |||
'''parentFolderID'''<br /> | '''parentFolderID'''<br /> | ||
UUID of the folder that contains the item. This must match the folderID of an inventory folders table entry. | UUID of the folder that contains the item. This must match the folderID of an inventory folders table entry. | ||
| − | <br /> | + | <br /> |
| + | |||
'''inventoryGroupPermissions'''<br /> | '''inventoryGroupPermissions'''<br /> | ||
Permissions with respect to the owner group of the item. Permission values can be found at [[OpenSim:Permissions]] | Permissions with respect to the owner group of the item. Permission values can be found at [[OpenSim:Permissions]] | ||
| − | + | <br /> | |
| − | (back to [[Database Documentation]])<br /> | + | |
| + | ---- | ||
| + | |||
| + | (back to [[Database Documentation]]) | ||
| + | |||
| + | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 17:06, 11 April 2016
 |
Languages: |
|
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 | |
| inventoryGroupPermissions | int(10) unsigned | NO | 0 |
Note: When assetType is 24, the item is a link. In this case, assetID is not the id of the asset.
It is instead the inventoryID of another inventory item, whose assetID points to the target asset.
inventoryitems Fields
assetID
Refers to the related row in the assets table.
Calling Cards do not create assets so if assetType=2 (see next field) this field should be "00000000-0000-0000-0000-000000000000".
assetType
Type of asset (e.g., script, texture, or shape - asset type list)
inventoryName
Text of the name of the inventory item as it appears in the client inventory interface.
inventoryDescription
Text of the description of the inventory item as it appears in the client inventory interface.
inventoryNextPermissions
Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at OpenSim:Permissions
inventoryCurrentPermissions
Permissions on the the item for the current posessor of the item. Permission values can be found at OpenSim:Permissions
invType
Type of inventory item. This is a subset of enum InventoryType for items only.
| Value | Icon | Meaning |
| -1 | User Defined | |
| 0 |  | Texture |
| 1 |  | Sound |
| 2 |  | Calling Card |
| 3 |  | Landmark |
| 6 |  | Object |
| 7 |  | Notecard |
| 10 |  | Script |
| 15 |  | Snapshot |
| 17 |  | Attachment |
| 18 |  | Wearable (assets 5 and 13, see below) |
| 19 |  | Animation (assets 20) |
| 20 |  | Gesture (asset 21) |
| 22 |  | Mesh (asset 49) |
Subtype for wearable (assets type 5 and 13).
The subtype is contained inside the asset data (LLSD format). It does not appear in the table.
| 0 |  | Shape (asset type 13) |
| 1 |  | Skin (asset type 13) |
| 2 |  | Hair (asset type 13) |
| 3 |  | Eyes (asset type 13) |
| 4 |  | Shirt (asset type 5) |
| 5 |  | Pants (asset type 5) |
| 6 |  | Shoes (asset type 5) |
| 7 |  | Socks (asset type 5) |
| 8 |  | Jacket (asset type 5) |
| 9 |  | Gloves (asset type 5) |
| 10 |  | Undershirt (asset type 5) |
| 11 |  | Underpants (asset type 5) |
| 12 |  | Skirt (asset type 5) |
| 13 |  | Alpha (asset type 5) |
| 14 |  | Tattoo (asset type 5) |
| 15 |  | Physics (asset type 5) |
creatorID
UUID of the item's original creator.
inventoryBasePermissions
Base permissions of the object. Permission values can be found at OpenSim:Permissions
inventoryEveryOnePermissions
Permissions with respect to everyone but the owner of the item. Permission values can be found at OpenSim:Permissions
salePrice
Sale price of the item.
saleType
presently unknown
creationDate
Date the item was created
groupID
UUID of the group that the items is 'deeded' to
groupOwned
group ownership flags
flags
A definition of Flag values can be found at OpenSim:Permissions#ObjectFlags_.28F.29
inventoryID
UUID of inventory item
avatarID
UUID of item's owner
parentFolderID
UUID of the folder that contains the item. This must match the folderID of an inventory folders table entry.
inventoryGroupPermissions
Permissions with respect to the owner group of the item. Permission values can be found at OpenSim:Permissions
(back to Database Documentation)
