Database:Inventoryitems - Revision history

JeffKelley: Changed inventoryDescription to VARCHAR(128), creatorID to VARCHAR(255)

2024-02-13T11:16:38Z

Changed inventoryDescription to VARCHAR(128), creatorID to VARCHAR(255)

JeffKelley: Move links where they belong. Added folder links.

2024-01-02T19:28:29Z

Move links where they belong. Added folder links.

JeffKelley: Added Settings & Material

2023-06-01T21:14:14Z

Added Settings & Material

JeffKelley: Fixed internal links OpenSim:Permissions -> OpenSimulator:Permissions

2023-05-13T03:12:32Z

Fixed internal links OpenSim:Permissions -> OpenSimulator:Permissions

JeffKelley: /* inventoryitems Fields */ Wearable subtype encoding in table

2021-06-08T08:28:48Z

‎inventoryitems Fields: Wearable subtype encoding in table

Acryline: Replace inventoryFolderId by inventoryFolderID

2020-10-26T12:36:17Z

Replace inventoryFolderId by inventoryFolderID

Kcozens: Added details about the flags field of the inventoryitems table.

2017-02-04T20:52:19Z

Added details about the flags field of the inventoryitems table.

Kcozens: Added links from table structure to field descriptions

2016-04-12T02:39:38Z

Added links from table structure to field descriptions

Show changes

Kcozens: Updated the table description

2016-04-12T01:26:20Z

Updated the table description

Kcozens: Minor HTML formatting changes

2016-04-12T01:16:04Z

Minor HTML formatting changes

@@ Line 27: / Line 27: @@
 | '''[[#invName|inventoryName]]''' || varchar(64) || YES ||  || NULL ||
 |- style="background:#eee;"
-| '''[[#invDescription|inventoryDescription]]''' || varchar(64) || YES ||  || NULL ||
+| '''[[#invDescription|inventoryDescription]]''' || varchar(128) || YES ||  || NULL ||
 |-
 | '''[[#invNextPerms|inventoryNextPermissions]]''' || int(10) unsigned || YES ||  || NULL ||
@@ Line 35: / Line 35: @@
 | '''[[#invType|invType]]''' || int(11) || YES ||  || NULL ||
 |- style="background:#eee;"
-| '''[[#creatorID|creatorID]]''' || varchar(36) || YES ||  || NULL ||
+| '''[[#creatorID|creatorID]]''' || varchar(255) || YES ||  || NULL ||
 |-
 | '''[[#invBasePerms|inventoryBasePermissions]]''' || int(10) unsigned || NO ||  || 0 ||

@@ Line 62: / Line 62: @@
 |}
 <br />
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 == inventoryitems Fields ==
@@ Line 82: / Line 75: @@
 Type of asset (e.g., script, texture, or shape - [http://wiki.secondlife.com/wiki/AssetType asset type list])
 <br />
 <div id="invName">'''inventoryName'''</div>

@@ Line 119: / Line 119: @@
 <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>
 </table>
 <br />

@@ Line 92: / Line 92: @@
 <div id="invNextPerms">'''inventoryNextPermissions'''</div>
-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 [[OpenSimulator:Permissions]]
 <br />
 <div id="invCurrentPerms">'''inventoryCurrentPermissions'''</div>
-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 [[OpenSimulator:Permissions]]
 <br />
@@ Line 152: / Line 152: @@
 <div id="invBasePerms">'''inventoryBasePermissions'''</div>
-Base permissions of the object. Permission values can be found at [[OpenSim:Permissions]]
+Base permissions of the object. Permission values can be found at [[OpenSimulator:Permissions]]
 <br />
 <div id="invEveryOnePerms">'''inventoryEveryOnePermissions'''</div>
-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 [[OpenSimulator:Permissions]]
 <br />
@@ Line 207: / Line 207: @@
 <div id="invGroupPerms">'''inventoryGroupPermissions'''</div>
-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 [[OpenSimulator:Permissions]]
 <br />

@@ Line 123: / Line 123: @@
 Subtype for wearable (assets type 5 and 13).<br />
-The subtype is contained inside the asset data (LLSD format). It does not appear in the table.
+The subtype is contained inside the asset data (LLSD format). <s>It does not appear in the table.</s>
 <br />

@@ Line 57: / Line 57: @@
 | '''[[#avatarID|avatarID]]''' || char(36) || YES || MUL || NULL ||
 |-
-| '''[[#parentFolderId|parentFolderId]]''' || char(36) || YES || MUL || NULL ||
+| '''[[#parentFolderID|parentFolderID]]''' || char(36) || YES || MUL || NULL ||
 |- style="background:#eee;"
 | '''[[#invGroupPerms|inventoryGroupPermissions]]''' || int(10) unsigned || NO ||  || 0 ||
@@ Line 201: / Line 201: @@
 <br />
-<div id="parentFolderId">'''parentFolderId'''</div>
+<div id="parentFolderID">'''parentFolderID'''</div>
 UUID of the folder that contains the item.  This must match the folderID of an inventory folders table entry.
 <br />

@@ Line 179: / Line 179: @@
 <div id="flags">'''flags'''</div>
-A definition of Flag values can be found at [[OpenSim:Permissions#ObjectFlags_.28F.29]]
+<table>
 <br />

@@ Line 3: / Line 3: @@
 <br />
-'''inventoryitems'''	''Records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+The '''inventoryitems''' records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 <br />

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
 <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 />
+'''inventoryitems'''	''Records details with respect to the avatar's personal property (assets)''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-The current structure of the inventoryitems table is as follows:
 <br />
 {| style="border:1px solid #ccc;"
 |- style="background:#cce;"
@@ Line 55: / Line 61: @@
 | inventoryGroupPermissions || int(10) unsigned || NO ||  || 0 ||
 |}
 Note: When <u>assetType</u> is 24, the item is a '''link'''. In this case, <u>assetID</u> is not the id of the asset. <br />It is instead the <u>inventoryID</u> of another inventory item, whose <u>assetID</u> points to the target asset.
 <br />
 <br />
@@ Line 189: / Line 200: @@
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 [[Category:Database]]