Database:Documentation
From OpenSimulator
(Difference between revisions)
(→OpenSim 0.7.2) |
m (Robot: Cosmetic changes) |
||
| Line 3: | Line 3: | ||
This page documents the databases tables used in OpenSimulator. | This page documents the databases tables used in OpenSimulator. | ||
| − | Tables are split up into Common, Services and Simulator. | + | Tables are split up into Common, Services and Simulator. |
On a grid, the grid services will contain the Services and Common tables, whilst each simulator instance will access the Simulator tables. | On a grid, the grid services will contain the Services and Common tables, whilst each simulator instance will access the Simulator tables. | ||
| Line 13: | Line 13: | ||
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 onwards== | + | == OpenSim 0.7.2 onwards == |
| − | ===Common=== | + | === Common === |
<table> | <table> | ||
<tr> | <tr> | ||
| Line 22: | Line 22: | ||
</table> | </table> | ||
| − | ===Services=== | + | === Services === |
<table> | <table> | ||
<tr> | <tr> | ||
| − | <td>Avatars<br></td><td>Persistence of the visual appearance of avatars between logins and attached objects</td> | + | <td>Avatars<br /></td><td>Persistence of the visual appearance of avatars between logins and attached objects</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 31: | Line 31: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>GridUser<br></td><td>Information about a user in this particular grid. This is distinct from auth information</td> | + | <td>GridUser<br /></td><td>Information about a user in this particular grid. This is distinct from auth information</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>UserAccounts<br></td><td>User account information, such as name, user level and e-mail</td> | + | <td>UserAccounts<br /></td><td>User account information, such as name, user level and e-mail</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[assets]]<br></td><td>Grid assets including such things as textures and sounds</td> | + | <td>[[assets]]<br /></td><td>Grid assets including such things as textures and sounds</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>auth<br></td><td>User authentication information</td> | + | <td>auth<br /></td><td>User authentication information</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[inventoryfolders]]<br></td><td>Inventory folder-related details *excepting contents*</td> | + | <td>[[inventoryfolders]]<br /></td><td>Inventory folder-related details *excepting contents*</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 49: | Line 49: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[inventoryitems]]<br></td><td>All inventory item details (including folder associations) except contents - contents are referenced in the [[assets]] table</td> | + | <td>[[inventoryitems]]<br /></td><td>All inventory item details (including folder associations) except contents - contents are referenced in the [[assets]] table</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[regions]]<br></td><td>Regions known to the grid</td> | + | <td>[[regions]]<br /></td><td>Regions known to the grid</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 59: | Line 59: | ||
</table> | </table> | ||
| − | ===Simulator=== | + | === Simulator === |
<table> | <table> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate groups]]<br /></td><td>Narrowly purposed at present. Appears to associate UUIDs under an Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate managers]]<br /></td><td>Associates UUIDs with Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate map]]<br /></td><td>Associates Regions with Estates By Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate settings]]<br /></td><td>Settings for Estates</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate users]]<br /></td><td>Users allowed on the Estate</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[estateban]]<br></td><td>Users banned from the Estate</td> | + | <td>[[estateban]]<br /></td><td>Users banned from the Estate</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[land]]<br></td><td>Parcel Properties</td> | + | <td>[[land]]<br /></td><td>Parcel Properties</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[landaccesslist]]<br></td><td>Parcel Access List</td> | + | <td>[[landaccesslist]]<br /></td><td>Parcel Access List</td> |
</tr> | </tr> | ||
<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> | + | <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> | ||
<tr> | <tr> | ||
| − | <td>[[prims]]<br></td><td>All rezzed prim details *excepting shape and contents*</td> | + | <td>[[prims]]<br /></td><td>All rezzed prim details *excepting shape and contents*</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>primshapes<br></td><td>Properties of all rezzed prims</td> | + | <td>primshapes<br /></td><td>Properties of all rezzed prims</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>regionban<br></td><td>Per-Region ban list</td> | + | <td>regionban<br /></td><td>Per-Region ban list</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>regionsettings<br></td><td>Per-Region settings</td> | + | <td>regionsettings<br /></td><td>Per-Region settings</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>regionwindlight<br></td><td>Windlight region settings</td> | + | <td>regionwindlight<br /></td><td>Windlight region settings</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[terrain]]<br></td><td>Terrain mesh revision history</td> | + | <td>[[terrain]]<br /></td><td>Terrain mesh revision history</td> |
</tr> | </tr> | ||
</table> | </table> | ||
| − | ==Older information== | + | == Older information == |
This mainly pertains to OpenSim 0.6.9. | This mainly pertains to OpenSim 0.6.9. | ||
| Line 119: | Line 119: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[agents]]<br></td><td>Records agent (Avatar/User) login details</td> | + | <td>[[agents]]<br /></td><td>Records agent (Avatar/User) login details</td> |
<tr> | <tr> | ||
| − | <td>[[assets]]<br></td><td>Comprehensive grid assets including textures and avatar inventories</td> | + | <td>[[assets]]<br /></td><td>Comprehensive grid assets including textures and avatar inventories</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[avatarappearance]]<br></td><td>Persistence of the visual appearance of avatars between logins</td> | + | <td>[[avatarappearance]]<br /></td><td>Persistence of the visual appearance of avatars between logins</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[avatarattachments]]<br></td><td>Items attached to avatars</td> | + | <td>[[avatarattachments]]<br /></td><td>Items attached to avatars</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[inventoryfolders]]<br></td><td>Inventory folder-related details *excepting contents*</td> | + | <td>[[inventoryfolders]]<br /></td><td>Inventory folder-related details *excepting contents*</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 136: | Line 136: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[inventoryitems]]<br></td><td>All inventory item details (including folder associations) except contents - contents are referenced</td> | + | <td>[[inventoryitems]]<br /></td><td>All inventory item details (including folder associations) except contents - contents are referenced</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> </td><td>in the [[assets]] table<br><br></td> | + | <td> </td><td>in the [[assets]] table<br /><br /></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> </td><td>*** it would appear neither of these log tables is currently used ***<br><br></td> | + | <td> </td><td>*** it would appear neither of these log tables is currently used ***<br /><br /></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| Line 157: | Line 157: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| − | <br><br> | + | <br /><br /> |
<table> | <table> | ||
<tr> | <tr> | ||
| Line 165: | Line 165: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate groups]]<br /></td><td>Narrowly purposed at present. Appears to associate UUIDs under an Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate managers]]<br /></td><td>Associates UUIDs with Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate map]]<br /></td><td>Associates Regions with Estates By Estate ID</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate settings]]<br /></td><td>Settings for Estates</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[ | + | <td>[[estate users]]<br /></td><td>Users allowed on the Estate</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[estateban]]<br></td><td>Users banned from the Estate</td> | + | <td>[[estateban]]<br /></td><td>Users banned from the Estate</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[land]]<br></td><td>Parcel Properties</td> | + | <td>[[land]]<br /></td><td>Parcel Properties</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[landaccesslist]]<br></td><td>Parcel Access List</td> | + | <td>[[landaccesslist]]<br /></td><td>Parcel Access List</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[migrations]]<br></td><td>Supports 'automagic' upgrade to new database formats</td> | + | <td>[[migrations]]<br /></td><td>Supports 'automagic' upgrade to new database formats</td> |
</tr> | </tr> | ||
<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> | + | <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> | ||
<tr> | <tr> | ||
| − | <td>[[prims]]<br></td><td>All rezzed prim details *excepting shape and contents*</td> | + | <td>[[prims]]<br /></td><td>All rezzed prim details *excepting shape and contents*</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[primshapes]]<br></td><td>Properties of all rezzed prims</td> | + | <td>[[primshapes]]<br /></td><td>Properties of all rezzed prims</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[regionban]]<br></td><td>Per-Region ban list</td> | + | <td>[[regionban]]<br /></td><td>Per-Region ban list</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[regionsettings]]<br></td><td>Per-Region settings</td> | + | <td>[[regionsettings]]<br /></td><td>Per-Region settings</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td>[[terrain]]<br></td><td>Terrain mesh revision history</td> | + | <td>[[terrain]]<br /></td><td>Terrain mesh revision history</td> |
</tr> | </tr> | ||
</table> | </table> | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 19:55, 3 March 2012
 |
Languages: |
|
This page documents the databases tables used in OpenSimulator.
Tables are split up into Common, Services and Simulator.
On a grid, the grid services will contain the Services and Common tables, whilst each simulator instance will access the Simulator tables.
A standalone will contain Common, Services and Simulator tables, with the exception of the regions table, which is not currently persisted for standalones.
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
Contents |
OpenSim 0.7.2 onwards
Common
| migrations | Supports automatic upgrade to new database formats |
Services
| Avatars | Persistence of the visual appearance of avatars between logins and attached objects |
| Friends | Friends list registration |
| GridUser | Information about a user in this particular grid. This is distinct from auth information |
| UserAccounts | User account information, such as name, user level and e-mail |
| assets | Grid assets including such things as textures and sounds |
| auth | User authentication information |
| 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 |
| regions | Regions known to the grid |
| tokens | Unused. |
Simulator
| 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 |
| 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 |
| regionwindlight | Windlight region settings |
| terrain | Terrain mesh revision history |
Older information
This mainly pertains to OpenSim 0.6.9.
| Services: | |
| 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 *** |
|
| migrations | Supports 'automagic' migration to new database formats |
| regions | Regions known to the grid |
| userfriends | Friends list registration |
| users | Stored user profile |
| Simulator: | |
| 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 |
