Database:Inventoryitems

Revision as of 07:55, 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)

@@ Line 30: / Line 30: @@
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 <hr>
+'''assetID'''<br><br>
-'''Owner'''<br>
+Refers to the related row in the assets table.
-'''Serial'''<br>
+'''assetType'''<br><br>
-'''Visual_Params'''<br>
+Type of asset (e.g., script, texture, or shape)
-'''Texture'''<br>
+'''inventoryName'''<br><br>
-'''Avatar_Height'''<br>
+Text of the name of the inventory item as it appears in the client inventory interface.
-'''Body_Item'''<br>
+'''inventoryDescription'''<br><br>
-Refers to inventory item for Body<br>
+Text of the description of the inventory item as it appears in the client inventory interface.
-'''Body_Asset'''<br><br>
+'''inventoryNextPermissions'''<br><br>
-Refers to item in assets for Body<br>
+Permissions that will be applied to the item if/when it is transferred to another avatar.
-'''Skin_Item'''<br><br>
+'''inventoryCurrentPermissions'''<br><br>
-Refers to inventory item for Skin<br>
+Permissions on the the item for the current posessor of the item.
-'''Skin_Asset'''<br><br>
+'''invType'''<br><br>
-Refers to item in assets for Skin<br>
+Type of inventory item (is this redundant with assetType?)
-'''Hair_Item'''<br><br>
+'''creatorID'''<br><br>
-Refers to inventory item for Hair<br>
+UUID of the item's original creator.
-'''Hair_Asset'''<br><br>
+'''inventoryBasePermissions'''<br><br>
-Refers to item in assets for Hair<br>
+Base permissions of the object.
-'''Eyes_Item'''<br><br>
+'''inventoryEveryOnePermissions'''<br><br>
-Refers to inventory item for Eyes<br>
+Permissions with respect to everyone but the owner of the item.
-'''Eyes_Asset'''<br><br>
+'''salePrice'''<br><br>
-Refers to item in assets for Eyes<br>
+Sale price of the item.
-'''Shirt_Item'''<br><br>
+'''saleType'''<br><br>
-Refers to inventory item for Shirt<br>
+''presently unknown''
-'''Shirt_Asset'''<br><br>
+'''creationDate'''<br><br>
-Refers to item in assets for Shirt<br>
+Date the item was created
-'''Pants_Item'''<br><br>
+'''groupID'''<br><br>
-Refers to inventory item for Pants<br>
+UUID of the group that the items is 'deeded' to
-'''Pants_Asset'''<br><br>
+'''groupOwned'''<br><br>
-Refers to item in assets for Pants<br>
+group ownership flags
-'''Shoes_Item'''<br><br>
+'''flags'''<br><br>
-Refers to inventory item for Shoes<br>
+''presently unknown''
-'''Shoes_Asset'''<br><br>
+'''inventoryID'''<br><br>
-Refers to item in assets for Shoes<br>
+UUID of inventory item
-'''Socks_Item'''<br><br>
+'''avatarID'''<br><br>
-Refers to inventory item for Socks<br>
+UUID of item's owner
-'''Socks_Asset'''<br><br>
+'''parentFolderID'''<br><br>
-Refers to item in assets for Socks<br>
+UUID of the folder said to 'contain' the item
-'''Jacket_Item'''<br><br>
-Refers to inventory item for Jacket<br>
-'''Jacket_Asset'''<br><br>
-Refers to item in assets for Jacket<br>
-'''Gloves_Item'''<br><br>
-Refers to inventory item for Gloves<br>
-'''Gloves_Asset'''<br><br>
-Refers to item in assets for Gloves<br>
-'''Undershirt_Item'''<br><br>
-Refers to inventory item for Undershirt<br>
-'''Undershirt_Asset'''<br><br>
-Refers to item in assets for Undershirt<br>
-'''Underpants_Item'''<br><br>
-Refers to inventory item for Underpants<br>
-'''Underpants_Asset'''<br><br>
-Refers to item in assets for Underpants<br>
-'''Skirt_Asset'''<br><br>
-Refers to item in assets for Skirt<br>
-'''Skirt_Item'''<br><br>
-Refers to inventory item for Skirt<br>
 <hr>
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>

Views

Database:Inventoryitems

From OpenSimulator

Revision as of 07:55, 29 July 2008

Personal tools

General

For Administrators

For Developers

For Creators

For Grid Users

Related Links

About This Wiki

Search

Tools