View source for Database:Inventoryfolders

__NOTOC__
{{Quicklinks}}
<br>
{{Warning This is informative only and subject to changes}} <br><br>
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 />

== inventoryfolders Table Structure ==

The structure of the inventoryfolders table is as follows:
<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>

== inventoryfolders Fields ==

;<div id="folderName">'''folderName'''</div>
Text of the folder's name as it appears in the client inventory interface
<br>

<div id="type">'''type'''</div>
Type of inventory folder. This is a subset of enum InventoryType for folders only. 
<br>

<table>
<tr><td>Value</td><td>Icon</td><td>Meaning</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>http://www.pescadoo.net/oswiki/inv_folder_texture.png</td><td>Textures</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>http://www.pescadoo.net/oswiki/inv_folder_callingcard.png</td><td>Calling Cards</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>http://www.pescadoo.net/oswiki/inv_folder_clothing.png</td><td>Clothing</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>http://www.pescadoo.net/oswiki/inv_folder_notecard.png</td><td>Notecards</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>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>http://www.pescadoo.net/oswiki/inv_folder_script.png</td><td>Scripts</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>http://www.pescadoo.net/oswiki/inv_folder_trash.png</td><td>Trash</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>http://www.pescadoo.net/oswiki/inv_folder_lostandfound.png</td><td>Lost and Found</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>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>
<br>

<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.
<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.
<br>

<div id="agentID">'''agentID'''</div>
Unique agent identifier - identifies the agent which owns the folder.
<br>

<div id="parentFolderID">'''parentFolderID'''</div>
This identifies the parent folder that contains this folder.  Hence, it must match another inventoryfolders table entry which has that folderID.

<br>

----

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
<br>

[[Category:Database]]