Database:Inventoryitems
From OpenSimulator
| Line 30: | Line 30: | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
<hr> | <hr> | ||
| − | '''assetID''' | + | '''assetID'''<br> |
Refers to the related row in the assets table. | Refers to the related row in the assets table. | ||
<br> | <br> | ||
| − | '''assetType''' | + | '''assetType'''<br> |
Type of asset (e.g., script, texture, or shape) | Type of asset (e.g., script, texture, or shape) | ||
<br> | <br> | ||
| − | '''inventoryName''' | + | '''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''' | + | '''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''' | + | '''inventoryNextPermissions'''<br> |
Permissions that will be applied to the item if/when it is transferred to another avatar. | Permissions that will be applied to the item if/when it is transferred to another avatar. | ||
<br> | <br> | ||
| − | '''inventoryCurrentPermissions''' | + | '''inventoryCurrentPermissions'''<br> |
Permissions on the the item for the current posessor of the item. | Permissions on the the item for the current posessor of the item. | ||
<br> | <br> | ||
| − | '''invType''' | + | '''invType'''<br> |
Type of inventory item (is this redundant with assetType?) | Type of inventory item (is this redundant with assetType?) | ||
<br> | <br> | ||
| − | '''creatorID''' | + | '''creatorID'''<br> |
UUID of the item's original creator. | UUID of the item's original creator. | ||
<br> | <br> | ||
| − | '''inventoryBasePermissions''' | + | '''inventoryBasePermissions'''<br> |
Base permissions of the object. | Base permissions of the object. | ||
<br> | <br> | ||
| − | '''inventoryEveryOnePermissions''' | + | '''inventoryEveryOnePermissions'''<br> |
Permissions with respect to everyone but the owner of the item. | Permissions with respect to everyone but the owner of the item. | ||
<br> | <br> | ||
| − | '''salePrice''' | + | '''salePrice'''<br> |
Sale price of the item. | Sale price of the item. | ||
<br> | <br> | ||
| − | '''saleType''' | + | '''saleType'''<br> |
''presently unknown'' | ''presently unknown'' | ||
<br> | <br> | ||
| − | '''creationDate''' | + | '''creationDate'''<br> |
Date the item was created | Date the item was created | ||
<br> | <br> | ||
| − | '''groupID''' | + | '''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''' | + | '''groupOwned'''<br> |
group ownership flags | group ownership flags | ||
<br> | <br> | ||
| − | '''flags''' | + | '''flags'''<br> |
''presently unknown'' | ''presently unknown'' | ||
<br> | <br> | ||
| − | '''inventoryID''' | + | '''inventoryID'''<br> |
UUID of inventory item | UUID of inventory item | ||
<br> | <br> | ||
| − | '''avatarID''' | + | '''avatarID'''<br> |
UUID of item's owner | UUID of item's owner | ||
<br> | <br> | ||
| − | '''parentFolderID''' | + | '''parentFolderID'''<br> |
UUID of the folder said to 'contain' the item | UUID of the folder said to 'contain' the item | ||
<hr> | <hr> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
Revision as of 08:59, 29 July 2008
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)
assetID
Refers to the related row in the assets table.
assetType
Type of asset (e.g., script, texture, or shape)
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.
inventoryCurrentPermissions
Permissions on the the item for the current posessor of the item.
invType
Type of inventory item (is this redundant with assetType?)
creatorID
UUID of the item's original creator.
inventoryBasePermissions
Base permissions of the object.
inventoryEveryOnePermissions
Permissions with respect to everyone but the owner of the item.
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
presently unknown
inventoryID
UUID of inventory item
avatarID
UUID of item's owner
parentFolderID
UUID of the folder said to 'contain' the item
(back to Database Documentation)
