Database:Documentation

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Fixed some spelling errors and punctuation)
(interim)
Line 11: Line 11:
 
Note that some of these tables may be relics, some may be planned for future use, and some may see heavy use but have columns which are relics, not yet properly updated or not yet used at all. Alpha code FTW!! :D
 
Note that some of these tables may be relics, some may be planned for future use, and some may see heavy use but have columns which are relics, not yet properly updated or not yet used at all. Alpha code FTW!! :D
  
 +
==OpenSim 0.7.2==
  
 +
Simulators:
 +
<table>
 +
<tr>
 +
<td align=left>Grid:</td>
 +
<tr>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td>[[agents]]<br></td><td>Records agent (Avatar/User) login details</td>
 +
<tr>
 +
<td>[[assets]]<br></td><td>Comprehensive grid assets including textures and avatar inventories</td>
 +
</tr>
 +
<tr>
 +
<td>[[avatarappearance]]<br></td><td>Persistence of the visual appearance of avatars between logins</td>
 +
</tr>
 +
<tr>
 +
<td>[[avatarattachments]]<br></td><td>Items attached to avatars</td>
 +
</tr>
 +
<tr>
 +
<td>[[inventoryfolders]]<br></td><td>Inventory folder-related details *excepting contents*</td>
 +
</tr>
 +
<tr>
 +
<td>&nbsp;</td><td>Contents are in the [[inventoryitems]] table and point back to [[inventoryfolders]]</td>
 +
</tr>
 +
<tr>
 +
<td>[[inventoryitems]]<br></td><td>All inventory item details (including folder associations) except contents - contents are referenced</td>
 +
</tr>
 +
<tr>
 +
<td>&nbsp;</td><td>in the [[assets]] table<br><br></td>
 +
</tr>
 +
<tr>
 +
<td>&nbsp;</td><td>*** it would appear neither of these log tables is currently used ***<br><br></td>
 +
</tr>
 +
<tr>
 +
<td>[[migrations]]</td><td>Supports 'automagic' migration to new database formats</td>
 +
</tr>
 +
<tr>
 +
<td>[[regions]]</td><td>Regions known to the grid</td>
 +
</tr>
 +
<tr>
 +
<td>[[userfriends]]</td><td>Friends list registration</td>
 +
</tr>
 +
<tr>
 +
<td>[[users]]</td><td>Stored user profile</td>
 +
</tr>
 +
</table>
 +
<br><br>
 +
<table>
 +
<tr>
 +
<td align=left>Region:</td>
 +
<tr>
 +
<td>&nbsp;</td>
 +
</tr>
 +
<tr>
 +
<td>[[estate_groups]]<br></td><td>Narrowly purposed at present. Appears to associate UUIDs under an Estate ID</td>
 +
</tr>
 +
<tr>
 +
<td>[[estate_managers]]<br></td><td>Associates UUIDs with Estate ID</td>
 +
</tr>
 +
<tr>
 +
<td>[[estate_map]]<br></td><td>Associates Regions with Estates By Estate ID</td>
 +
</tr>
 +
<tr>
 +
<td>[[estate_settings]]<br></td><td>Settings for Estates</td>
 +
</tr>
 +
<tr>
 +
<td>[[estate_users]]<br></td><td>Users allowed on the Estate</td>
 +
</tr>
 +
<tr>
 +
<td>[[estateban]]<br></td><td>Users banned from the Estate</td>
 +
</tr>
 +
<tr>
 +
<td>[[land]]<br></td><td>Parcel Properties</td>
 +
</tr>
 +
<tr>
 +
<td>[[landaccesslist]]<br></td><td>Parcel Access List</td>
 +
</tr>
 +
<tr>
 +
<td>[[migrations]]<br></td><td>Supports 'automagic' upgrade to new database formats</td>
 +
</tr>
 +
<tr>
 +
<td>[[primitems]]<br></td><td>contains the prim's inventory, which is not at all unlike the avatars'<br>inventory with the exception of folders</td>
 +
</tr>
 +
<tr>
 +
<td>[[prims]]<br></td><td>All rezzed prim details *excepting shape and contents*</td>
 +
</tr>
 +
<tr>
 +
<td>[[primshapes]]<br></td><td>Properties of all rezzed prims</td>
 +
</tr>
 +
<tr>
 +
<td>[[regionban]]<br></td><td>Per-Region ban list</td>
 +
</tr>
 +
<tr>
 +
<td>[[regionsettings]]<br></td><td>Per-Region settings</td>
 +
</tr>
 +
<tr>
 +
<td>[[terrain]]<br></td><td>Terrain mesh revision history</td>
 +
</tr>
 +
</table>
 +
 +
 +
==Older information==
  
 +
This mainly pertains to OpenSim 0.6.9.
  
−
The instances:
+
Simulators:
 
<table>
 
<table>
 
<tr>
 
<tr>
Line 116: Line 220:
 
<br><br>
 
<br><br>
 
Here is a note concerning the [[initial creation of the MySQL tables]]<br><br>
 
Here is a note concerning the [[initial creation of the MySQL tables]]<br><br>
−
 
−
Questions about this documentation can be directed to daTwitch on #opensim-dev or #osgrid FreeNode IRC or Hiro Protagonist on OSGrid.<br>
 
−
For further clarification of the content ask on #opensim-dev look for sdague, JustinCC, or DrSco.
 
  
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 10:06, 29 September 2011

Languages Languages: 

En.png English


Imbox content.png

This article or section contains incomplete information.
Please help us by completing the content on this page.

Please note, a large amount of the information is now out of date for OpenSim 0.7 and later. All this needs updating.

This is a running start at documenting the tables in the MySQL instances used on both grid and regions, and describing how they relate to each other in the context of an OpenSim grid.

SQLite is generally not considered appropriate for this use case and will not be covered here; however the table structures are very similar and most of what is here will be useful in that context as well.

Note that some of these tables may be relics, some may be planned for future use, and some may see heavy use but have columns which are relics, not yet properly updated or not yet used at all. Alpha code FTW!! :D

OpenSim 0.7.2

Simulators:

Grid:
 
agents
Records agent (Avatar/User) login details
assets
Comprehensive grid assets including textures and avatar inventories
avatarappearance
Persistence of the visual appearance of avatars between logins
avatarattachments
Items attached to avatars
inventoryfolders
Inventory folder-related details *excepting contents*
 Contents are in the inventoryitems table and point back to inventoryfolders
inventoryitems
All inventory item details (including folder associations) except contents - contents are referenced
 in the assets table
 *** it would appear neither of these log tables is currently used ***
migrationsSupports 'automagic' migration to new database formats
regionsRegions known to the grid
userfriendsFriends list registration
usersStored user profile



Region:
 
estate_groups
Narrowly purposed at present. Appears to associate UUIDs under an Estate ID
estate_managers
Associates UUIDs with Estate ID
estate_map
Associates Regions with Estates By Estate ID
estate_settings
Settings for Estates
estate_users
Users allowed on the Estate
estateban
Users banned from the Estate
land
Parcel Properties
landaccesslist
Parcel Access List
migrations
Supports 'automagic' upgrade to new database formats
primitems
contains the prim's inventory, which is not at all unlike the avatars'
inventory with the exception of folders
prims
All rezzed prim details *excepting shape and contents*
primshapes
Properties of all rezzed prims
regionban
Per-Region ban list
regionsettings
Per-Region settings
terrain
Terrain mesh revision history


Older information

This mainly pertains to OpenSim 0.6.9.

Simulators:

Grid:
 
agents
Records agent (Avatar/User) login details
assets
Comprehensive grid assets including textures and avatar inventories
avatarappearance
Persistence of the visual appearance of avatars between logins
avatarattachments
Items attached to avatars
inventoryfolders
Inventory folder-related details *excepting contents*
 Contents are in the inventoryitems table and point back to inventoryfolders
inventoryitems
All inventory item details (including folder associations) except contents - contents are referenced
 in the assets table
 *** it would appear neither of these log tables is currently used ***
migrationsSupports 'automagic' migration to new database formats
regionsRegions known to the grid
userfriendsFriends list registration
usersStored user profile



Region:
 
estate_groups
Narrowly purposed at present. Appears to associate UUIDs under an Estate ID
estate_managers
Associates UUIDs with Estate ID
estate_map
Associates Regions with Estates By Estate ID
estate_settings
Settings for Estates
estate_users
Users allowed on the Estate
estateban
Users banned from the Estate
land
Parcel Properties
landaccesslist
Parcel Access List
migrations
Supports 'automagic' upgrade to new database formats
primitems
contains the prim's inventory, which is not at all unlike the avatars'
inventory with the exception of folders
prims
All rezzed prim details *excepting shape and contents*
primshapes
Properties of all rezzed prims
regionban
Per-Region ban list
regionsettings
Per-Region settings
terrain
Terrain mesh revision history



Here is a note concerning the initial creation of the MySQL tables

Retrieved from "http://opensimulator.org/index.php?title=Database:Documentation&oldid=25836"
Personal tools
General
About This Wiki