Database:Inventoryitems
From OpenSimulator
(Difference between revisions)
(Added links from table structure to field descriptions) |
JeffKelley (Talk | contribs) m (Changed inventoryDescription to VARCHAR(128), creatorID to VARCHAR(255)) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 27: | Line 27: | ||
| '''[[#invName|inventoryName]]''' || varchar(64) || YES || || NULL || | | '''[[#invName|inventoryName]]''' || varchar(64) || YES || || NULL || | ||
|- style="background:#eee;" | |- style="background:#eee;" | ||
| − | | '''[[#invDescription|inventoryDescription]]''' || varchar( | + | | '''[[#invDescription|inventoryDescription]]''' || varchar(128) || YES || || NULL || |
|- | |- | ||
| '''[[#invNextPerms|inventoryNextPermissions]]''' || int(10) unsigned || YES || || NULL || | | '''[[#invNextPerms|inventoryNextPermissions]]''' || int(10) unsigned || YES || || NULL || | ||
| Line 35: | Line 35: | ||
| '''[[#invType|invType]]''' || int(11) || YES || || NULL || | | '''[[#invType|invType]]''' || int(11) || YES || || NULL || | ||
|- style="background:#eee;" | |- style="background:#eee;" | ||
| − | | '''[[#creatorID|creatorID]]''' || varchar( | + | | '''[[#creatorID|creatorID]]''' || varchar(255) || YES || || NULL || |
|- | |- | ||
| '''[[#invBasePerms|inventoryBasePermissions]]''' || int(10) unsigned || NO || || 0 || | | '''[[#invBasePerms|inventoryBasePermissions]]''' || int(10) unsigned || NO || || 0 || | ||
| Line 57: | Line 57: | ||
| '''[[#avatarID|avatarID]]''' || char(36) || YES || MUL || NULL || | | '''[[#avatarID|avatarID]]''' || char(36) || YES || MUL || NULL || | ||
|- | |- | ||
| − | | '''[[# | + | | '''[[#parentFolderID|parentFolderID]]''' || char(36) || YES || MUL || NULL || |
|- style="background:#eee;" | |- style="background:#eee;" | ||
| '''[[#invGroupPerms|inventoryGroupPermissions]]''' || int(10) unsigned || NO || || 0 || | | '''[[#invGroupPerms|inventoryGroupPermissions]]''' || int(10) unsigned || NO || || 0 || | ||
|} | |} | ||
| − | |||
<br /> | <br /> | ||
| − | |||
| − | |||
(back to [[Database Documentation]]) | (back to [[Database Documentation]]) | ||
| − | |||
| − | |||
| − | |||
| − | |||
== inventoryitems Fields == | == inventoryitems Fields == | ||
| Line 82: | Line 75: | ||
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 /> | ||
| + | |||
| + | When '''assetType''' is 24, the item is a <u>link</u> to an inventory item. '''assetID''' if then the '''inventoryID''' of the target item.<br /> | ||
| + | When '''assetType''' is 25, the item is a <u>link</u> to an inventory folder. '''assetID''' if then the '''folderID''' of the target folder.<br /> | ||
<div id="invName">'''inventoryName'''</div> | <div id="invName">'''inventoryName'''</div> | ||
| Line 92: | Line 88: | ||
<div id="invNextPerms">'''inventoryNextPermissions'''</div> | <div id="invNextPerms">'''inventoryNextPermissions'''</div> | ||
| − | Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at [[ | + | Permissions that will be applied to the item if/when it is transferred to another avatar. Permission values can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
<div id="invCurrentPerms">'''inventoryCurrentPermissions'''</div> | <div id="invCurrentPerms">'''inventoryCurrentPermissions'''</div> | ||
| − | Permissions on the the item for the current posessor of the item. Permission values can be found at [[ | + | Permissions on the the item for the current posessor of the item. Permission values can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
| Line 119: | Line 115: | ||
<tr><td>20</td><td>http://www.pescadoo.net/oswiki/inv_item_gesture.png</td><td>Gesture (asset 21)</td></tr> | <tr><td>20</td><td>http://www.pescadoo.net/oswiki/inv_item_gesture.png</td><td>Gesture (asset 21)</td></tr> | ||
<tr><td>22</td><td>http://www.pescadoo.net/oswiki/inv_item_mesh.png</td><td>Mesh (asset 49)</td></tr> | <tr><td>22</td><td>http://www.pescadoo.net/oswiki/inv_item_mesh.png</td><td>Mesh (asset 49)</td></tr> | ||
| + | <tr><td>25</td><td></td><td>Settings (asset 56)</td></tr> | ||
| + | <tr><td>26</td><td></td><td>Material (asset 57)</td></tr> | ||
</table> | </table> | ||
<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. | + | The subtype is contained inside the asset data (LLSD format). <s>It does not appear in the table.</s> |
| + | <br />It is encoded in the lower part of the 'flags' column'. | ||
<br /> | <br /> | ||
| Line 151: | Line 150: | ||
<div id="invBasePerms">'''inventoryBasePermissions'''</div> | <div id="invBasePerms">'''inventoryBasePermissions'''</div> | ||
| − | Base permissions of the object. Permission values can be found at [[ | + | Base permissions of the object. Permission values can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
<div id="invEveryOnePerms">'''inventoryEveryOnePermissions'''</div> | <div id="invEveryOnePerms">'''inventoryEveryOnePermissions'''</div> | ||
| − | Permissions with respect to everyone but the owner of the item. Permission values can be found at [[ | + | Permissions with respect to everyone but the owner of the item. Permission values can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
| Line 179: | Line 178: | ||
<div id="flags">'''flags'''</div> | <div id="flags">'''flags'''</div> | ||
| − | + | <table> | |
| + | <tr><td>None</td><td>0</td></tr> | ||
| + | <tr><td>ObjectSlamPerm</td><td>1<<8 (256)</td></tr> | ||
| + | <tr><td>ObjectSlamSale</td><td>1<<12 (4096)</td></tr> | ||
| + | <tr><td>ObjectOverwriteBase</td><td>1<<16 (65536)</td></tr> | ||
| + | <tr><td>ObjectOverwriteOwner</td><td>1<<17 (131072)</td></tr> | ||
| + | <tr><td>ObjectOverwriteGroup</td><td>1<<18 (262144)</td></tr> | ||
| + | <tr><td>ObjectOverwriteEveryone</td><td>1<<19 (524288)</td></tr> | ||
| + | <tr><td>ObjectOverwriteNextOwner</td><td>1<<20 (1048576)</td></tr> | ||
| + | <tr><td>ObjectHasMultipleItems</td><td>1<<21 (2097152)</td></tr> | ||
| + | <tr><td>SharedSingleReference</td><td>1<<30 (1073741824)</td></tr> | ||
| + | </table> | ||
<br /> | <br /> | ||
| Line 190: | Line 200: | ||
<br /> | <br /> | ||
| − | <div id=" | + | <div id="parentFolderID">'''parentFolderID'''</div> |
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 /> | ||
<div id="invGroupPerms">'''inventoryGroupPermissions'''</div> | <div id="invGroupPerms">'''inventoryGroupPermissions'''</div> | ||
| − | Permissions with respect to the owner group of the item. Permission values can be found at [[ | + | Permissions with respect to the owner group of the item. Permission values can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
Latest revision as of 03:16, 13 February 2024
 |
Languages: |
|
The inventoryitems records details with respect to the avatar's personal property (assets) (back to Database Documentation)
[edit] inventoryitems Table Structure
The 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(128) | YES | NULL | ||
| inventoryNextPermissions | int(10) unsigned | YES | NULL | ||
| inventoryCurrentPermissions | int(10) unsigned | YES | NULL | ||
| invType | int(11) | YES | NULL | ||
| creatorID | varchar(255) | 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 |
(back to Database Documentation)
[edit] 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)
When assetType is 24, the item is a link to an inventory item. assetID if then the inventoryID of the target item.
When assetType is 25, the item is a link to an inventory folder. assetID if then the folderID of the target folder.
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 OpenSimulator:Permissions
inventoryCurrentPermissions
Permissions on the the item for the current posessor of the item. Permission values can be found at OpenSimulator: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) |
| 25 | Settings (asset 56) | |
| 26 | Material (asset 57) |
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.
It is encoded in the lower part of the 'flags' column'.
| 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 OpenSimulator:Permissions
inventoryEveryOnePermissions
Permissions with respect to everyone but the owner of the item. Permission values can be found at OpenSimulator: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
| None | 0 |
| ObjectSlamPerm | 1<<8 (256) |
| ObjectSlamSale | 1<<12 (4096) |
| ObjectOverwriteBase | 1<<16 (65536) |
| ObjectOverwriteOwner | 1<<17 (131072) |
| ObjectOverwriteGroup | 1<<18 (262144) |
| ObjectOverwriteEveryone | 1<<19 (524288) |
| ObjectOverwriteNextOwner | 1<<20 (1048576) |
| ObjectHasMultipleItems | 1<<21 (2097152) |
| SharedSingleReference | 1<<30 (1073741824) |
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 OpenSimulator:Permissions
(back to Database Documentation)
