Database:Inventoryfolders
From OpenSimulator
(Difference between revisions)
(→inventoryfolders Fields) |
|||
| (30 intermediate revisions by one user not shown) | |||
| Line 2: | Line 2: | ||
{{Quicklinks}} | {{Quicklinks}} | ||
<br> | <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 '''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]]) | 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]]) | ||
<br /> | <br /> | ||
| Line 52: | Line 56: | ||
<table> | <table> | ||
| − | <tr><td>Value</td><td>Icon</td><td>Meaning</td></tr> | + | <tr><td>Value</td><td>Icon on some Viewers</td><td>Meaning</td></tr> |
| − | <tr><td> | + | <tr><td>0</td><td>http://opensimulator.org/images/folderIcons/inv_folder_texture.png</td><td>Textures</td></tr> |
| − | <tr><td> | + | <tr><td>1</td><td>http://opensimulator.org/images/folderIcons/inv_folder_sound.png</td><td>Sounds</td></tr> |
| − | <tr><td> | + | <tr><td>2</td><td>http://opensimulator.org/images/folderIcons/inv_folder_callingcard.png</td><td>Calling Cards</td></tr> |
| − | <tr><td> | + | <tr><td>3</td><td>http://opensimulator.org/images/folderIcons/inv_folder_landmark.png</td><td>Landmarks</td></tr> |
| − | <tr><td> | + | <tr><td>5</td><td>http://opensimulator.org/images/folderIcons/inv_folder_clothing.png</td><td>Clothing</td></tr> |
| − | <tr><td> | + | <tr><td>6</td><td>http://opensimulator.org/images/folderIcons/inv_folder_object.png</td><td>Objects</td></tr> |
| − | <tr><td> | + | <tr><td>7</td><td>http://opensimulator.org/images/folderIcons/inv_folder_notecard.png</td><td>Notecards</td></tr> |
| − | <tr><td> | + | <tr><td>8</td><td>http://opensimulator.org/images/folderIcons/inv_folder_plain_closed.png</td><td>My Inventory</td></tr> |
| − | <tr><td> | + | <tr><td>10</td><td>http://opensimulator.org/images/folderIcons/inv_folder_script.png</td><td>Scripts</td></tr> |
| − | <tr><td> | + | <tr><td>13</td><td>http://opensimulator.org/images/folderIcons/inv_folder_bodypart.png</td><td>Body Parts</td></tr> |
| − | <tr><td> | + | <tr><td>14</td><td>http://opensimulator.org/images/folderIcons/inv_folder_trash.png</td><td>Trash</td></tr> |
| − | <tr><td> | + | <tr><td>15</td><td>http://opensimulator.org/images/folderIcons/inv_folder_snapshot.png</td><td>Photo Album</td></tr> |
| − | <tr><td> | + | <tr><td>16</td><td>http://opensimulator.org/images/folderIcons/inv_folder_lostandfound.png</td><td>Lost and Found</td></tr> |
| − | <tr><td> | + | <tr><td>20</td><td>http://opensimulator.org/images/folderIcons/inv_folder_animation.png</td><td>Animations</td></tr> |
| − | <tr><td> | + | <tr><td>21</td><td>http://opensimulator.org/images/folderIcons/inv_folder_gesture.png</td><td>Gestures</td></tr> |
| − | <tr><td> | + | <tr><td>23</td><td>http://opensimulator.org/images/folderIcons/inv_folder_favorite.png</td><td>Favorites</td></tr> |
| − | <tr><td> | + | <tr><td>46</td><td>http://opensimulator.org/images/folderIcons/inv_folder_outfit.png</td><td>Current Outfit</td></tr> |
| − | <tr><td> | + | <tr><td>47</td><td>http://opensimulator.org/images/folderIcons/inv_folder_outfit.png</td><td>Outfits</td></tr> |
| − | <tr><td> | + | <tr><td>49</td><td>http://opensimulator.org/images/folderIcons/inv_folder_mesh.png</td><td>Meshes</td></tr> |
| − | <tr><td> | + | <tr><td>56</td><td>http://opensimulator.org/images/folderIcons/inv_folder_settings.png</td><td>Settings</td></tr> |
| − | <tr><td> | + | <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> | </table> | ||
<br> | <br> | ||
Latest revision as of 08:05, 14 May 2022
 |
Languages: |
|
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 | 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)
[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)
