Database:Inventoryfolders

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Robot: Replacing 'OpenSim' to 'OpenSimulator', which is the precise name)
m (Fixed a typo)
(13 intermediate revisions by 3 users not shown)
Line 2: Line 2:
 
{{Quicklinks}}
 
{{Quicklinks}}
 
<br />
 
<br />
'''inventoryfolders''' ''Records details concerning the avatar's inventory organisation,''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
+
 
specifically the folders. No information about contents of the folders is in this table.
+
The '''inventoryfolders''' table records details concerning the avatar's inventory organisation, specifically the folders. No information about contents of the folders is in this table.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
<br /><br />
+
The current structure of the avatar appearance table is as follows:<br />
+
 
<br />
 
<br />
<table>
 
<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>folderName</td><td>varchar(64)</td><td>YES</td><td>&nbsp;</td><td>NULL</td><td>&nbsp;</td></tr>
 
<tr><td>type</td><td>smallint(6)</td><td>NO</td><td></td><td>0</td><td></td></tr>
 
<tr><td>version</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
 
<tr><td>folderID</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td><tr>
 
<tr><td>agentID</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><td></td></tr>
 
<tr><td>parentFolderID</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><td></td></tr>
 
</table>
 
 
<br />
 
<br />
 +
 +
== inventoryitems Table Structure ==
 +
 +
The structure of the inventoryitems table is as follows:
 
<br />
 
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
+
 
 +
{| style="border:1px solid #ccc;"
 +
|- style="background:#cce;"
 +
! Field
 +
! Type
 +
! Null
 +
! Key
 +
! Default
 +
! Extra
 +
|-
 +
| [[#folderName|folderName]] || varchar(64) || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| [[#type|type]] || smallint(6) || NO ||  || 0 ||
 +
|-
 +
| [[#version|version]] || int(11) || NO ||  || 0 ||
 +
|- style="background:#eee;"
 +
| [[#folderID|folderID]] || char(36) || NO || PRI || 00000000-0000-0000-0000-000000000000 ||
 +
|-
 +
| [[#agentID|agentID]] || char(36) || YES || MUL || NULL ||
 +
|- style="background:#eee;"
 +
| [[#parentFolderID|parentFolderID]] || char(36) || YES || MUL || NULL ||
 +
|}
 +
<br />
 +
 
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 +
<br />
 +
 
 
----
 
----
 +
<br />
  
'''folderName'''<br />
+
== inventoryitems Fields ==
 +
 
 +
;<div id="folderName">'''folderName'''</div>
 
Text of the folder's name as it appears in the client inventory interface
 
Text of the folder's name as it appears in the client inventory interface
 
<br />
 
<br />
 +
 +
<div id="type">'''type'''</div>
 +
Type of inventory folder. This is a subset of enum InventoryType for folders only.
 
<br />
 
<br />
'''type'''<br />
+
 
Numerically encoded inventory folder type:
+
<br />
+
 
<table>
 
<table>
<tr><td>Value</td><td>&nbsp;</td><td>Meaning</td></tr>
+
<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>-1</td><td>http://www.pescadoo.net/oswiki/inv_folder_plain_closed.png</td><td>User Defined</td></tr>
<tr><td>0</td><td>&nbsp;</td><td>Texture</td></tr>
+
<tr><td>0</td><td>http://www.pescadoo.net/oswiki/inv_folder_texture.png</td><td>Textures</td></tr>
<tr><td>1</td><td>&nbsp;</td><td>Sounds</td></tr>
+
<tr><td>1</td><td>http://www.pescadoo.net/oswiki/inv_folder_sound.png</td><td>Sounds</td></tr>
<tr><td>2</td><td>&nbsp;</td><td>Calling Cards</td></tr>
+
<tr><td>2</td><td>http://www.pescadoo.net/oswiki/inv_folder_callingcard.png</td><td>Calling Cards</td></tr>
<tr><td>3</td><td>&nbsp;</td><td>Landmarks</td></tr>
+
<tr><td>3</td><td>http://www.pescadoo.net/oswiki/inv_folder_landmark.png</td><td>Landmarks</td></tr>
<tr><td>5</td><td>&nbsp;</td><td>Clothing</td></tr>
+
<tr><td>5</td><td>http://www.pescadoo.net/oswiki/inv_folder_clothing.png</td><td>Clothing</td></tr>
<tr><td>6</td><td>&nbsp;</td><td>Object</td></tr>
+
<tr><td>6</td><td>http://www.pescadoo.net/oswiki/inv_folder_object.png</td><td>Objects</td></tr>
<tr><td>7</td><td>&nbsp;</td><td>Notecard</td></tr>
+
<tr><td>7</td><td>http://www.pescadoo.net/oswiki/inv_folder_notecard.png</td><td>Notecards</td></tr>
<tr><td>8</td><td>&nbsp;</td><td>Top Level (In OpenSimulator 0.6.x)</td></tr>
+
<tr><td>8</td><td>http://www.pescadoo.net/oswiki/inv_folder_plain_closed.png</td><td>My Inventory</td></tr>
<tr><td>9</td><td>&nbsp;</td><td>Top Level (In OpenSimulator 0.7.x)</td></tr>
+
<tr><td>9</td><td>http://www.pescadoo.net/oswiki/inv_folder_plain_closed.png</td><td><strike>My Inventory</strike> (from OpenSimulator 0.7.x and up, now obsolete)</td></tr>
<tr><td>10</td><td>&nbsp;</td><td>Script</td></tr>
+
<tr><td>10</td><td>http://www.pescadoo.net/oswiki/inv_folder_script.png</td><td>Scripts</td></tr>
<tr><td>13</td><td>&nbsp;</td><td>Body Part</td></tr>
+
<tr><td>13</td><td>http://www.pescadoo.net/oswiki/inv_folder_bodypart.png</td><td>Body Parts</td></tr>
<tr><td>14</td><td>&nbsp;</td><td>Trash</td></tr>
+
<tr><td>14</td><td>http://www.pescadoo.net/oswiki/inv_folder_trash.png</td><td>Trash</td></tr>
<tr><td>15</td><td>&nbsp;</td><td>Snapshot</td></tr>
+
<tr><td>15</td><td>http://www.pescadoo.net/oswiki/inv_folder_snapshot.png</td><td>Photo Album</td></tr>
<tr><td>16</td><td>&nbsp;</td><td>Lost and Found</td></tr>
+
<tr><td>16</td><td>http://www.pescadoo.net/oswiki/inv_folder_lostandfound.png</td><td>Lost and Found</td></tr>
<tr><td>20</td><td>&nbsp;</td><td>Animation</td></tr>
+
<tr><td>20</td><td>http://www.pescadoo.net/oswiki/inv_folder_animation.png</td><td>Animations</td></tr>
<tr><td>21</td><td>&nbsp;</td><td>Gesture</td></tr>
+
<tr><td>21</td><td>http://www.pescadoo.net/oswiki/inv_folder_gesture.png</td><td>Gestures</td></tr>
 +
<tr><td>23</td><td>http://www.pescadoo.net/oswiki/inv_folder_favorite.png</td><td>Favorites</td></tr>
 +
<tr><td>46</td><td>http://www.pescadoo.net/oswiki/inv_folder_outfit.png</td><td>Current Outfit</td></tr>
 +
<tr><td>47</td><td>http://www.pescadoo.net/oswiki/inv_folder_outfit.png</td><td>Outfits</td></tr>
 +
<tr><td>49</td><td>http://www.pescadoo.net/oswiki/inv_folder_mesh.png</td><td>Meshes</td></tr><tr><td>100</td><td>http://www.pescadoo.net/oswiki/inv_folder_plain_closed.png</td><td>My Suitcase</td></tr>
 
</table>
 
</table>
 
<br />
 
<br />
<br />
 
'''version'''<br />
 
This item is incremented when an item is added to the folder.
 
  
 +
<div id="version">'''version'''</div>
 +
This item is incremented when an item is added to the folder.
 
NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified.
 
NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified.
 
<br />
 
<br />
<br />
+
 
'''folderID'''<br />
+
<div id="folderID">'''folderID'''</div>
 
Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder.
 
Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder.
 
<br />
 
<br />
<br />
+
 
'''agentID'''<br />
+
<div id="agentID">'''agentID'''</div>
 
Unique agent identifier - identifies the agent which owns the folder.
 
Unique agent identifier - identifies the agent which owns the folder.
 
<br />
 
<br />
 +
 +
<div id="parentFolderID">'''parentFolderID'''</div>
 +
This identifies the parent folder that contains this folder.  Hence, it must match another inventory folders table entry which has that folderID.
 +
 
<br />
 
<br />
'''parentFolderID'''<br />
+
 
Unique folder identifier 'claims' the folder which is said to 'contain' this one in the same fashion as things in the inventoryitems table 'claim' the folder said to 'contain' them
+
 
----
 
----
&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 09:37, 12 April 2016


The inventoryfolders table records details concerning the avatar's inventory organisation, specifically the folders. No information about contents of the folders is in this table.       (back to Database Documentation)

inventoryitems Table Structure

The structure of the inventoryitems table is as follows:

Field Type Null Key Default Extra
folderName varchar(64) YES NULL
type smallint(6) NO 0
version int(11) NO 0
folderID char(36) NO PRI 00000000-0000-0000-0000-000000000000
agentID char(36) YES MUL NULL
parentFolderID char(36) YES MUL NULL


      (back to Database Documentation)



inventoryitems Fields

folderName

Text of the folder's name as it appears in the client inventory interface

type

Type of inventory folder. This is a subset of enum InventoryType for folders only.

ValueIconMeaning
-1inv_folder_plain_closed.pngUser Defined
0inv_folder_texture.pngTextures
1inv_folder_sound.pngSounds
2inv_folder_callingcard.pngCalling Cards
3inv_folder_landmark.pngLandmarks
5inv_folder_clothing.pngClothing
6inv_folder_object.pngObjects
7inv_folder_notecard.pngNotecards
8inv_folder_plain_closed.pngMy Inventory
9inv_folder_plain_closed.pngMy Inventory (from OpenSimulator 0.7.x and up, now obsolete)
10inv_folder_script.pngScripts
13inv_folder_bodypart.pngBody Parts
14inv_folder_trash.pngTrash
15inv_folder_snapshot.pngPhoto Album
16inv_folder_lostandfound.pngLost and Found
20inv_folder_animation.pngAnimations
21inv_folder_gesture.pngGestures
23inv_folder_favorite.pngFavorites
46inv_folder_outfit.pngCurrent Outfit
47inv_folder_outfit.pngOutfits
49inv_folder_mesh.pngMeshes
100inv_folder_plain_closed.pngMy Suitcase


version

This item is incremented when an item is added to the folder. NOTE: This appears to be a form of serial number that is updated when the contents of the folder is changed. A change in the number informs the viewer that it should refresh its copy of the folder contents. This needs to be verified.

folderID

Uniquely identifies the folder. This facilitates the folder being claimed as a logical container by other folders, or the things in the inventoryitems table that are said to be 'in' the folder.

agentID

Unique agent identifier - identifies the agent which owns the folder.

parentFolderID

This identifies the parent folder that contains this folder. Hence, it must match another inventory folders table entry which has that folderID.



      (back to Database Documentation)

Personal tools
General
About This Wiki