Database:Inventoryitems

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Wikified table structure)
Line 4: Line 4:
 
'''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 />
−
<table>
+
{| style="border:1px solid #ccc;"
−
<tr><td>Field<br /></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
|- style="background:#cce;"
−
<tr><td>&nbsp;</td></tr>
+
! Field
−
<tr><td>assetID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
+
! Type
−
<tr><td>assetType</td><td>int(11) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
+
! Null
−
<tr><td>inventoryName</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
+
! Key
−
<tr><td>inventoryDescription</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td><tr>
+
! Default
−
<tr><td>inventoryNextPermissions</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
! Extra
−
<tr><td>inventoryCurrentPermissions</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
|-
−
<tr><td>invType</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
| assetID || varchar(36) || YES ||  || NULL ||
−
<tr><td>CreatorID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
|- style="background:#eee;"
−
<tr><td>inventoryBasePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
+
| assetType || int(11) unsigned || YES ||  || NULL ||
−
<tr><td>inventoryEveryOnePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
+
|-
−
<tr><td>salePrice</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+
| inventoryName || varchar(64) || YES ||  || NULL ||
−
<tr><td>saleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
+
|- style="background:#eee;"
−
<tr><td>creationDate</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+
| inventoryDescription || varchar(64) || YES ||  || NULL ||
−
<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>
+
| inventoryNextPermissions || int(10) unsigned || YES ||  || NULL ||
−
<tr><td>flags</td><td>int(11) unsigned</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
−
<tr><td>inventoryID</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
+
| inventoryCurrentPermissions || int(10) unsigned || YES ||  || NULL ||
−
<tr><td>avatarID</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><tr>
+
|-
−
<tr><td>parentFolderId</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
+
| invType || int(11) || YES ||  || NULL ||
−
<tr><td>inventoryGroupPermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
+
|- style="background:#eee;"
−
</table>
+
| CreatorID || varchar(36) || YES ||  || NULL ||
 +
|-
 +
| inventoryBasePermissions || int(10) unsigned || NO ||  || 0 ||
 +
|- style="background:#eee;"
 +
| inventoryEveryOnePermissions || int(10) unsigned || NO ||  || 0 ||
 +
|-
 +
| salePrice || int(11) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| saleType || tinyint(4) || NO ||  || NULL ||
 +
|-
 +
| creationDate || int(11) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| groupID || varchar(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 +
|-
 +
| groupOwned || tinyint(4) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| flags || int(11) unsigned || NO ||  || 0 ||
 +
|-
 +
| inventoryID || char(36) || NO || PRI || 00000000-0000-0000-0000-000000000000 ||
 +
|- style="background:#eee;"
 +
| avatarID || char(36) || YES || MUL || NULL ||
 +
|-
 +
| parentFolderId || char(36) || YES || MUL || NULL ||
 +
|- style="background:#eee;"
 +
| inventoryGroupPermissions || int(10) unsigned || NO ||  || 0 ||
 +
|}
 
<br />
 
<br />
 
<br />
 
<br />

Revision as of 13:07, 16 January 2014

Languages Languages: 

En.png English


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



      (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 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)

Retrieved from "http://opensimulator.org/index.php?title=Database:Inventoryitems&oldid=38248"
Personal tools
General
About This Wiki