Database:Inventoryitems

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Changed inventoryDescription to VARCHAR(128), creatorID to VARCHAR(255))
 
(29 intermediate revisions by 9 users not shown)
Line 1: Line 1:
−
'''inventoryitems''' ''Records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
__NOTOC__
−
<br><br>
+
{{Quicklinks}}
−
The current structure of the inventoryitems table is as follows:<br>
+
<br />
−
<br>
+
 
−
<table>
+
The '''inventoryitems''' records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
−
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
<br />
−
<tr><td>&nbsp;</td></tr>
+
<br />
−
<tr><td>assetID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td>&nbsp;</td></tr>
+
 
−
<tr><td>assetType</td><td>int(11) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
+
== inventoryitems Table Structure ==
−
<tr><td>inventoryName</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
+
 
−
<tr><td>inventoryDescription</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td><tr>
+
The structure of the inventoryitems table is as follows:
−
<tr><td>inventoryNextPermissions</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
<br />
−
<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>
+
{| style="border:1px solid #ccc;"
−
<tr><td>CreatorID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
+
|- style="background:#cce;"
−
<tr><td>inventoryBasePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
+
! Field
−
<tr><td>inventoryEveryOnePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
+
! Type
−
<tr><td>salePrice</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+
! Null
−
<tr><td>saleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
+
! Key
−
<tr><td>creationDate</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
+
! Default
−
<tr><td>groupID</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td><br>
+
! Extra
−
<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>
+
| '''[[#assetID|assetID]]''' || varchar(36) || YES ||  || NULL ||
−
<tr><td>inventoryID</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
+
|- style="background:#eee;"
−
<tr><td>avatarID</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><tr>
+
| '''[[#assetType|assetType]]''' || int(11) unsigned || YES ||  || NULL ||
−
<tr><td>parentFolderId</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
+
|-
−
</table>
+
| '''[[#invName|inventoryName]]''' || varchar(64) || YES ||  || NULL ||     
−
<br>
+
|- style="background:#eee;"
−
<br>
+
| '''[[#invDescription|inventoryDescription]]''' || varchar(128) || YES ||  || NULL ||
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
|-
−
<hr>
+
| '''[[#invNextPerms|inventoryNextPermissions]]''' || int(10) unsigned || YES ||  || NULL ||
−
'''assetID'''<br>
+
|- style="background:#eee;"
−
Refers to the related row in the assets table.
+
| '''[[#invCurrentPerms|inventoryCurrentPermissions]]''' || int(10) unsigned || YES ||  || NULL ||
−
<br><br>
+
|-
−
'''assetType'''<br>
+
| '''[[#invType|invType]]''' || int(11) || YES ||  || NULL ||
−
Type of asset (e.g., script, texture, or shape)
+
|- style="background:#eee;"
−
<br><br>
+
| '''[[#creatorID|creatorID]]''' || varchar(255) || YES ||  || NULL ||
−
'''inventoryName'''<br>
+
|-
 +
| '''[[#invBasePerms|inventoryBasePermissions]]''' || int(10) unsigned || NO ||  || 0 ||
 +
|- style="background:#eee;"
 +
| '''[[#invEveryOnePerms|inventoryEveryOnePermissions]]''' || int(10) unsigned || NO ||  || 0 ||
 +
|-
 +
| '''[[#salePrice|salePrice]]''' || int(11) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#saleType|saleType]]''' || tinyint(4) || NO ||  || NULL ||
 +
|-
 +
| '''[[#creationDate|creationDate]]''' || int(11) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#groupID|groupID]]''' || varchar(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 +
|-
 +
| '''[[#groupOwned|groupOwned]]''' || tinyint(4) || NO ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#flags|flags]]''' || int(11) unsigned || NO ||  || 0 ||
 +
|-
 +
| '''[[#inventoryID|inventoryID]]''' || char(36) || NO || PRI || 00000000-0000-0000-0000-000000000000 ||
 +
|- style="background:#eee;"
 +
| '''[[#avatarID|avatarID]]''' || char(36) || YES || MUL || NULL ||
 +
|-
 +
| '''[[#parentFolderID|parentFolderID]]''' || char(36) || YES || MUL || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#invGroupPerms|inventoryGroupPermissions]]''' || int(10) unsigned || NO ||  || 0 ||
 +
|}
 +
 
 +
<br />
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 +
 
 +
== inventoryitems Fields ==
 +
 
 +
<div id="assetID">'''assetID'''</div>
 +
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".
 +
<br />
 +
 
 +
<div id="assetType">'''assetType'''</div>
 +
Type of asset (e.g., script, texture, or shape - [http://wiki.secondlife.com/wiki/AssetType asset type list])
 +
<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>
 
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 />
−
'''inventoryDescription'''<br>
+
 
 +
<div id="invDescription">'''inventoryDescription'''</div>
 
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 />
−
'''inventoryNextPermissions'''<br>
+
 
−
Permissions that will be applied to the item if/when it is transferred to another avatar.
+
<div id="invNextPerms">'''inventoryNextPermissions'''</div>
−
<br><br>
+
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'''<br>
+
<br />
−
Permissions on the the item for the current posessor of the item.
+
 
−
<br><br>
+
<div id="invCurrentPerms">'''inventoryCurrentPermissions'''</div>
−
'''invType'''<br>
+
Permissions on the the item for the current posessor of the item. Permission values can be found at [[OpenSimulator:Permissions]]
−
Type of inventory item (is this redundant with assetType?)
+
<br />
−
<br><br>
+
 
−
'''creatorID'''<br>
+
<div id="invType">'''invType'''</div>
 +
Type of inventory item. This is a subset of enum InventoryType for items only.
 +
<br />
 +
 
 +
<table>
 +
<tr><td>Value</td><td>Icon</td><td>Meaning</td></tr>
 +
<tr><td>-1</td><td>&nbsp;</td><td>User Defined</td></tr>
 +
<tr><td>0</td><td>http://www.pescadoo.net/oswiki/inv_item_texture.png</td><td>Texture</td></tr>
 +
<tr><td>1</td><td>http://www.pescadoo.net/oswiki/inv_item_sound.png</td><td>Sound</td></tr>
 +
<tr><td>2</td><td>http://www.pescadoo.net/oswiki/inv_item_callingcard_online.png</td><td>Calling Card</td></tr>
 +
<tr><td>3</td><td>http://www.pescadoo.net/oswiki/inv_item_landmark.png</td><td>Landmark</td></tr>
 +
<tr><td>6</td><td>http://www.pescadoo.net/oswiki/inv_item_object.png</td><td>Object</td></tr>
 +
<tr><td>7</td><td>http://www.pescadoo.net/oswiki/inv_item_notecard.png</td><td>Notecard</td></tr>
 +
<tr><td>10</td><td>http://www.pescadoo.net/oswiki/inv_item_script.png</td><td>Script</td></tr>
 +
<tr><td>15</td><td>http://www.pescadoo.net/oswiki/inv_item_snapshot.png</td><td>Snapshot</td></tr>
 +
<tr><td>17</td><td>http://www.pescadoo.net/oswiki/inv_item_attach.png</td><td>Attachment</td></tr>
 +
<tr><td>18</td><td>http://www.pescadoo.net/oswiki/inv_item_clothing.png</td><td>Wearable (assets 5 and 13, see below)</td></tr>
 +
<tr><td>19</td><td>http://www.pescadoo.net/oswiki/inv_item_animation.png</td><td>Animation (assets 20)</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>25</td><td></td><td>Settings (asset 56)</td></tr>
 +
<tr><td>26</td><td></td><td>Material (asset 57)</td></tr>
 +
</table>
 +
<br />
 +
 
 +
Subtype for wearable (assets type 5 and 13).<br />
 +
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 />
 +
 
 +
<table>
 +
<tr><td>0</td><td>http://www.pescadoo.net/oswiki/inv_item_shape.png</td><td>Shape (asset type 13)
 +
<tr><td>1</td><td>http://www.pescadoo.net/oswiki/inv_item_skin.png</td><td>Skin (asset type 13)
 +
<tr><td>2</td><td>http://www.pescadoo.net/oswiki/inv_item_hair.png</td><td>Hair (asset type 13)
 +
<tr><td>3</td><td>http://www.pescadoo.net/oswiki/inv_item_eyes.png</td><td>Eyes (asset type 13)
 +
<tr><td>4</td><td>http://www.pescadoo.net/oswiki/inv_item_shirt.png</td><td>Shirt (asset type 5)
 +
<tr><td>5</td><td>http://www.pescadoo.net/oswiki/inv_item_pants.png</td><td>Pants (asset type 5)
 +
<tr><td>6</td><td>http://www.pescadoo.net/oswiki/inv_item_shoes.png</td><td>Shoes (asset type 5)
 +
<tr><td>7</td><td>http://www.pescadoo.net/oswiki/inv_item_socks.png</td><td>Socks (asset type 5)
 +
<tr><td>8</td><td>http://www.pescadoo.net/oswiki/inv_item_jacket.png</td><td>Jacket (asset type 5)
 +
<tr><td>9</td><td>http://www.pescadoo.net/oswiki/inv_item_gloves.png</td><td>Gloves (asset type 5)
 +
<tr><td>10</td><td>http://www.pescadoo.net/oswiki/inv_item_undershirt.png</td><td>Undershirt (asset type 5)
 +
<tr><td>11</td><td>http://www.pescadoo.net/oswiki/inv_item_underpants.png</td><td>Underpants (asset type 5)
 +
<tr><td>12</td><td>http://www.pescadoo.net/oswiki/inv_item_skirt.png</td><td>Skirt (asset type 5)
 +
<tr><td>13</td><td>http://www.pescadoo.net/oswiki/inv_item_alpha.png</td><td>Alpha (asset type 5)
 +
<tr><td>14</td><td>http://www.pescadoo.net/oswiki/inv_item_tattoo.png</td><td>Tattoo (asset type 5)
 +
<tr><td>15</td><td>http://www.pescadoo.net/oswiki/inv_item_physics.png</td><td>Physics (asset type 5)
 +
</table>
 +
<br />
 +
 
 +
<div id="creatorID">'''creatorID'''</div>
 
UUID of the item's original creator.
 
UUID of the item's original creator.
−
<br><br>
+
<br />
−
'''inventoryBasePermissions'''<br>
+
 
−
Base permissions of the object.
+
<div id="invBasePerms">'''inventoryBasePermissions'''</div>
−
<br><br>
+
Base permissions of the object. Permission values can be found at [[OpenSimulator:Permissions]]
−
'''inventoryEveryOnePermissions'''<br>
+
<br />
−
Permissions with respect to everyone but the owner of the item.
+
 
−
<br><br>
+
<div id="invEveryOnePerms">'''inventoryEveryOnePermissions'''</div>
−
'''salePrice'''<br>
+
Permissions with respect to everyone but the owner of the item. Permission values can be found at [[OpenSimulator:Permissions]]
 +
<br />
 +
 
 +
<div id="salePrice">'''salePrice'''</div>
 
Sale price of the item.
 
Sale price of the item.
−
<br><br>
+
<br />
−
'''saleType'''<br>
+
 
 +
<div id="saleType">'''saleType'''</div>
 
''presently unknown''
 
''presently unknown''
−
<br><br>
+
<br />
−
'''creationDate'''<br>
+
 
 +
<div id="creationDate">'''creationDate'''</div>
 
Date the item was created
 
Date the item was created
−
<br><br>
+
<br />
−
'''groupID'''<br>
+
 
 +
<div id="groupID">'''groupID'''</div>
 
UUID of the group that the items is 'deeded' to
 
UUID of the group that the items is 'deeded' to
−
<br><br>
+
<br />
−
'''groupOwned'''<br>
+
 
 +
<div id="groupOwned">'''groupOwned'''</div>
 
group ownership flags
 
group ownership flags
−
<br><br>
+
<br />
−
'''flags'''<br>
+
 
−
''presently unknown''
+
<div id="flags">'''flags'''</div>
−
<br><br>
+
<table>
−
'''inventoryID'''<br>
+
  <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 />
 +
 
 +
<div id="inventoryID">'''inventoryID'''</div>
 
UUID of inventory item
 
UUID of inventory item
−
<br><br>
+
<br />
−
'''avatarID'''<br>
+
 
 +
<div id="avatarID">'''avatarID'''</div>
 
UUID of item's owner
 
UUID of item's owner
−
<br><br>
+
<br />
−
'''parentFolderID'''<br>
+
 
−
UUID of the folder said to 'contain' the item
+
<div id="parentFolderID">'''parentFolderID'''</div>
−
<hr><br>
+
UUID of the folder that contains the item.  This must match the folderID of an inventory folders table entry.
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
<br />
 +
 
 +
<div id="invGroupPerms">'''inventoryGroupPermissions'''</div>
 +
Permissions with respect to the owner group of the item. Permission values can be found at [[OpenSimulator:Permissions]]
 +
<br />
 +
 
 +
----
 +
 
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 +
<br />
 +
 
 +
[[Category:Database]]

Latest revision as of 03:16, 13 February 2024

Languages Languages: 

En.png English


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.

ValueIconMeaning
-1 User Defined
0inv_item_texture.pngTexture
1inv_item_sound.pngSound
2inv_item_callingcard_online.pngCalling Card
3inv_item_landmark.pngLandmark
6inv_item_object.pngObject
7inv_item_notecard.pngNotecard
10inv_item_script.pngScript
15inv_item_snapshot.pngSnapshot
17inv_item_attach.pngAttachment
18inv_item_clothing.pngWearable (assets 5 and 13, see below)
19inv_item_animation.pngAnimation (assets 20)
20inv_item_gesture.pngGesture (asset 21)
22inv_item_mesh.pngMesh (asset 49)
25Settings (asset 56)
26Material (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'.

0inv_item_shape.pngShape (asset type 13)
1inv_item_skin.pngSkin (asset type 13)
2inv_item_hair.pngHair (asset type 13)
3inv_item_eyes.pngEyes (asset type 13)
4inv_item_shirt.pngShirt (asset type 5)
5inv_item_pants.pngPants (asset type 5)
6inv_item_shoes.pngShoes (asset type 5)
7inv_item_socks.pngSocks (asset type 5)
8inv_item_jacket.pngJacket (asset type 5)
9inv_item_gloves.pngGloves (asset type 5)
10inv_item_undershirt.pngUndershirt (asset type 5)
11inv_item_underpants.pngUnderpants (asset type 5)
12inv_item_skirt.pngSkirt (asset type 5)
13inv_item_alpha.pngAlpha (asset type 5)
14inv_item_tattoo.pngTattoo (asset type 5)
15inv_item_physics.pngPhysics (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
None0
ObjectSlamPerm1<<8 (256)
ObjectSlamSale1<<12 (4096)
ObjectOverwriteBase1<<16 (65536)
ObjectOverwriteOwner1<<17 (131072)
ObjectOverwriteGroup1<<18 (262144)
ObjectOverwriteEveryone1<<19 (524288)
ObjectOverwriteNextOwner1<<20 (1048576)
ObjectHasMultipleItems1<<21 (2097152)
SharedSingleReference1<<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)

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