Database:Inventoryfolders

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Wikified table structure)
m (updated folder types)
Line 38: Line 38:
 
<br />
 
<br />
 
'''type'''<br />
 
'''type'''<br />
Numerically encoded inventory folder type:
+
Type of inventory folder. This is a subset of enum InventoryType for folders only.
 
<br />
 
<br />
 
<table>
 
<table>
 
<tr><td>Value</td><td>&nbsp;</td><td>Meaning</td></tr>
 
<tr><td>Value</td><td>&nbsp;</td><td>Meaning</td></tr>
 
<tr><td>-1</td><td>&nbsp;</td><td>User Defined</td></tr>
 
<tr><td>-1</td><td>&nbsp;</td><td>User Defined</td></tr>
<tr><td>0</td><td>&nbsp;</td><td>Texture</td></tr>
+
<tr><td>0</td><td>&nbsp;</td><td>Textures</td></tr>
 
<tr><td>1</td><td>&nbsp;</td><td>Sounds</td></tr>
 
<tr><td>1</td><td>&nbsp;</td><td>Sounds</td></tr>
 
<tr><td>2</td><td>&nbsp;</td><td>Calling Cards</td></tr>
 
<tr><td>2</td><td>&nbsp;</td><td>Calling Cards</td></tr>
 
<tr><td>3</td><td>&nbsp;</td><td>Landmarks</td></tr>
 
<tr><td>3</td><td>&nbsp;</td><td>Landmarks</td></tr>
 
<tr><td>5</td><td>&nbsp;</td><td>Clothing</td></tr>
 
<tr><td>5</td><td>&nbsp;</td><td>Clothing</td></tr>
<tr><td>6</td><td>&nbsp;</td><td>Object</td></tr>
+
<tr><td>6</td><td>&nbsp;</td><td>Objects</td></tr>
<tr><td>7</td><td>&nbsp;</td><td>Notecard</td></tr>
+
<tr><td>7</td><td>&nbsp;</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>&nbsp;</td><td>My Inventory (In OpenSimulator 0.6.x)</td></tr>
<tr><td>9</td><td>&nbsp;</td><td>Top Level (In OpenSimulator 0.7.x)</td></tr>
+
<tr><td>9</td><td>&nbsp;</td><td>My Inventory (In OpenSimulator 0.7.x)</td></tr>
<tr><td>10</td><td>&nbsp;</td><td>Script</td></tr>
+
<tr><td>10</td><td>&nbsp;</td><td>Scripts</td></tr>
<tr><td>13</td><td>&nbsp;</td><td>Body Part</td></tr>
+
<tr><td>13</td><td>&nbsp;</td><td>Body Parts</td></tr>
 
<tr><td>14</td><td>&nbsp;</td><td>Trash</td></tr>
 
<tr><td>14</td><td>&nbsp;</td><td>Trash</td></tr>
<tr><td>15</td><td>&nbsp;</td><td>Snapshot</td></tr>
+
<tr><td>15</td><td>&nbsp;</td><td>Photo Album</td></tr>
 
<tr><td>16</td><td>&nbsp;</td><td>Lost and Found</td></tr>
 
<tr><td>16</td><td>&nbsp;</td><td>Lost and Found</td></tr>
<tr><td>20</td><td>&nbsp;</td><td>Animation</td></tr>
+
<tr><td>20</td><td>&nbsp;</td><td>Animations</td></tr>
<tr><td>21</td><td>&nbsp;</td><td>Gesture</td></tr>
+
<tr><td>21</td><td>&nbsp;</td><td>Gestures</td></tr>
 +
<tr><td>100</td><td>&nbsp;</td><td>My Suitcase</td></tr>
 
</table>
 
</table>
 
<br />
 
<br />

Revision as of 09:50, 18 January 2014


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

The current structure of the avatar appearance 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)


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 Meaning
-1 User Defined
0 Textures
1 Sounds
2 Calling Cards
3 Landmarks
5 Clothing
6 Objects
7 Notecards
8 My Inventory (In OpenSimulator 0.6.x)
9 My Inventory (In OpenSimulator 0.7.x)
10 Scripts
13 Body Parts
14 Trash
15 Photo Album
16 Lost and Found
20 Animations
21 Gestures
100 My 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