Database:Inventoryitems

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link)
m (Robot: Cosmetic changes)
Line 2: Line 2:
 
{{Quicklinks}}
 
{{Quicklinks}}
 
<br />
 
<br />
'''inventoryitems''' ''Records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
'''inventoryitems''' ''Records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
<br><br>
+
<br /><br />
The current structure of the inventoryitems table is as follows:<br>
+
The current structure of the inventoryitems table is as follows:<br />
<br>
+
<br />
 
<table>
 
<table>
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>&nbsp;</td></tr>
 
<tr><td>assetID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
 
<tr><td>assetID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
Line 22: Line 22:
 
<tr><td>saleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 
<tr><td>saleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
 
<tr><td>creationDate</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
<tr><td>creationDate</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>groupID</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td><br>
+
<tr><td>groupID</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td><br />
 
<tr><td>groupOwned</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
<tr><td>groupOwned</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
 
<tr><td>flags</td><td>int(11) unsigned</td><td>NO</td><td></td><td>0</td><td></td></tr>
 
<tr><td>flags</td><td>int(11) unsigned</td><td>NO</td><td></td><td>0</td><td></td></tr>
Line 30: Line 30:
 
<tr><td>inventoryGroupPermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
 
<tr><td>inventoryGroupPermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
 
</table>
 
</table>
<br>
+
<br />
<br>
+
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
<hr>
+
----
'''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>
+
<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>
+
<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>
+
<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>
+
<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>
+
<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>
+
<br /><br />
'''invType'''<br>
+
'''invType'''<br />
 
Type of inventory item (is this redundant with assetType?)
 
Type of inventory item (is this redundant with assetType?)
<br><br>
+
<br /><br />
'''creatorID'''<br>
+
'''creatorID'''<br />
 
UUID of the item's original creator.
 
UUID of the item's original creator.
<br><br>
+
<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>
+
<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>
+
<br /><br />
'''salePrice'''<br>
+
'''salePrice'''<br />
 
Sale price of the item.
 
Sale price of the item.
<br><br>
+
<br /><br />
'''saleType'''<br>
+
'''saleType'''<br />
 
''presently unknown''
 
''presently unknown''
<br><br>
+
<br /><br />
'''creationDate'''<br>
+
'''creationDate'''<br />
 
Date the item was created
 
Date the item was created
<br><br>
+
<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>
+
<br /><br />
'''groupOwned'''<br>
+
'''groupOwned'''<br />
 
group ownership flags
 
group ownership flags
<br><br>
+
<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>
+
<br /><br />
'''inventoryID'''<br>
+
'''inventoryID'''<br />
 
UUID of inventory item
 
UUID of inventory item
<br><br>
+
<br /><br />
'''avatarID'''<br>
+
'''avatarID'''<br />
 
UUID of item's owner
 
UUID of item's owner
<br><br>
+
<br /><br />
'''parentFolderID'''<br>
+
'''parentFolderID'''<br />
 
UUID of the folder said to 'contain' the item
 
UUID of the folder said to 'contain' the item
<br><br>
+
<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><br>
+
<br /><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
 
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 19:55, 3 March 2012


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
TypeNullKeyDefaultExtra
 
assetIDvarchar(36)YESNULL 
assetTypeint(11) unsignedYESNULL
inventoryNamevarchar(64)YESNULL
inventoryDescriptionvarchar(64)YESNULL
inventoryNextPermissionsint(10) unsignedYESNULL
inventoryCurrentPermissionsint(10) unsignedYESNULL
invTypeint(11)YESNULL
CreatorIDvarchar(36)YESNULL
inventoryBasePermissionsint(10) unsignedNO0
inventoryEveryOnePermissionsint(10) unsignedNO0
salePriceint(11)NONULL
saleTypetinyint(4)NONULL
creationDateint(11)NONULL
groupIDvarchar(36)NO00000000-0000-0000-0000-000000000000
groupOwnedtinyint(4)NONULL
flagsint(11) unsignedNO0
inventoryIDchar(36)NOPRI00000000-0000-0000-0000-000000000000
avatarIDchar(36)YESMULNULL
parentFolderIdchar(36)YESMULNULL
inventoryGroupPermissionsint(10) unsignedNO0



      (back to Database Documentation)


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 (is this redundant with assetType?)

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 said to 'contain' the item

inventoryGroupPermissions
Permissions with respect to the owner group of the item. Permission values can be found at OpenSim:Permissions

      (back to Database Documentation)

Personal tools
General
About This Wiki