Database:Inventoryfolders

Latest revision as of 08:05, 14 May 2022

Home

Download

News

Support

Admin

Dev

Screen Shots

Grid List

Bugs

Languages:

English

This is informative only and subject to changes

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)

[edit] inventoryfolders Table Structure

The structure of the inventoryfolders table is as follows:

Field	Type	Null	Key	Default
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)

[edit] inventoryfolders 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.

Value	Icon on some Viewers	Meaning
0		Textures
1		Sounds
2		Calling Cards
3		Landmarks
5		Clothing
6		Objects
7		Notecards
8		My Inventory
10		Scripts
13		Body Parts
14		Trash
15		Photo Album
16		Lost and Found
20		Animations
21		Gestures
23		Favorites
46		Current Outfit
47		Outfits
49		Meshes
56		Settings
100		My Suitcase

-1		Any other, user Defined

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 inventoryfolders table entry which has that folderID.

(back to Database Documentation)

@@ Line 1: / Line 1: @@
-'''inventoryfolders'''	''Records details concerning the avatar's inventory organisation,''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+__NOTOC__
-specifically the folders. No information about contents of the folders is in this table.
+{{Quicklinks}}
+<br>
+<div style="background-color:#FFA500; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">
+This is informative only and subject to changes
+</div>
 <br><br>
-The current structure of the avatar appearance table is as follows:<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]])
-<table>
+<br />
-<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>
-<tr><td>folderName</td><td>varchar(64)</td><td>YES</td><td>&nbsp;</td><td>NULL</td><td>&nbsp;</td></tr>
+== inventoryfolders Table Structure ==
-<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>
+The structure of the inventoryfolders table is as follows:
-<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>
+<br />
-<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>
+{| style="border:1px solid #ccc;"
-</table>
+|- 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>
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
-<hr>
-'''folderName'''<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>
-'''type'''<br>
+<table>
+<tr><td>Value</td><td>Icon on some Viewers</td><td>Meaning</td></tr>
+<tr><td>0</td><td>http://opensimulator.org/images/folderIcons/inv_folder_texture.png</td><td>Textures</td></tr>
+<tr><td>1</td><td>http://opensimulator.org/images/folderIcons/inv_folder_sound.png</td><td>Sounds</td></tr>
+<tr><td>2</td><td>http://opensimulator.org/images/folderIcons/inv_folder_callingcard.png</td><td>Calling Cards</td></tr>
+<tr><td>3</td><td>http://opensimulator.org/images/folderIcons/inv_folder_landmark.png</td><td>Landmarks</td></tr>
+<tr><td>5</td><td>http://opensimulator.org/images/folderIcons/inv_folder_clothing.png</td><td>Clothing</td></tr>
+<tr><td>6</td><td>http://opensimulator.org/images/folderIcons/inv_folder_object.png</td><td>Objects</td></tr>
+<tr><td>7</td><td>http://opensimulator.org/images/folderIcons/inv_folder_notecard.png</td><td>Notecards</td></tr>
+<tr><td>8</td><td>http://opensimulator.org/images/folderIcons/inv_folder_plain_closed.png</td><td>My Inventory</td></tr>
+<tr><td>10</td><td>http://opensimulator.org/images/folderIcons/inv_folder_script.png</td><td>Scripts</td></tr>
+<tr><td>13</td><td>http://opensimulator.org/images/folderIcons/inv_folder_bodypart.png</td><td>Body Parts</td></tr>
+<tr><td>14</td><td>http://opensimulator.org/images/folderIcons/inv_folder_trash.png</td><td>Trash</td></tr>
+<tr><td>15</td><td>http://opensimulator.org/images/folderIcons/inv_folder_snapshot.png</td><td>Photo Album</td></tr>
+<tr><td>16</td><td>http://opensimulator.org/images/folderIcons/inv_folder_lostandfound.png</td><td>Lost and Found</td></tr>
+<tr><td>20</td><td>http://opensimulator.org/images/folderIcons/inv_folder_animation.png</td><td>Animations</td></tr>
+<tr><td>21</td><td>http://opensimulator.org/images/folderIcons/inv_folder_gesture.png</td><td>Gestures</td></tr>
+<tr><td>23</td><td>http://opensimulator.org/images/folderIcons/inv_folder_favorite.png</td><td>Favorites</td></tr>
+<tr><td>46</td><td>http://opensimulator.org/images/folderIcons/inv_folder_outfit.png</td><td>Current Outfit</td></tr>
+<tr><td>47</td><td>http://opensimulator.org/images/folderIcons/inv_folder_outfit.png</td><td>Outfits</td></tr>
+<tr><td>49</td><td>http://opensimulator.org/images/folderIcons/inv_folder_mesh.png</td><td>Meshes</td></tr>
+<tr><td>56</td><td>http://opensimulator.org/images/folderIcons/inv_folder_settings.png</td><td>Settings</td></tr>
+<tr><td>100</td><td>http://opensimulator.org/images/folderIcons/inv_folder_plain_closed.png</td><td>My Suitcase</td></tr>
+<tr><td></td><td></td><td> </td></tr>
+<tr><td>-1</td><td>http://opensimulator.org/images/folderIcons/inv_folder_plain_closed.png</td><td>Any other, user Defined</td></tr>
+</table>
 <br>
-numerically encoded inventory folder type (e.g., 'Textures', 'Scripts', or 'Objects')
-<br>
+<div id="version">'''version'''</div>
-<br>
+This item is incremented when an item is added to the folder.
-'''version'''<br>
+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.
-''unknown at present''
-<br>
-<br>
-'''folderID'''<br>
 <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>
-<br>
-'''agentID'''<br>
+<div id="agentID">'''agentID'''</div>
-<br>
 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>
-'''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
+----
-<hr>
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+<br>
 [[Category:Database]]

Views

Database:Inventoryfolders

From OpenSimulator

Latest revision as of 08:05, 14 May 2022

[edit] inventoryfolders Table Structure

[edit] inventoryfolders Fields

Personal tools

General

For Administrators

For Developers

For Creators

For Grid Users

Related Links

About This Wiki

Search

Tools