__NOTOC__
{{Portal_Part|Note|
{{Thirdparty}}
}}

{| width="100%" cellpadding=10 margin: 10px 10px 10px 10px;
|-
|valign="top" |
{{Portal_Part|Statistics and Information|
* {{PAGESINCATEGORY:Vortex|pages}} pages related to Vortex
* Vortex is [[Grid List/Neverworld Grid|Neverworld Grid's]] Web Interface
}}
|valign="top" width="50%"|

{{Portal_Part|Core Features|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[Feature Matrix]] - Matrix of features currently implemented by OpenSimulator.
* [[Access Control]] - Controlling user access to OpenSimulator.
{{Div col end}}
}}
|}

[[Category:Vortex]]

Vortex

2019-04-13T00:02:49Z

CodyCooper:

__NOTOC__
{{Portal_Part|Note|
{{Thirdparty}}
}}

{| width="75%" cellpadding=10 margin: 10px 10px 10px 10px;
|-
|valign="top" |
{{Portal_Part|Statistics and Information|
* {{PAGESINCATEGORY:Vortex|pages}} pages related to Vortex
* Vortex is [[Grid List/Neverworld Grid|Neverworld Grid's]] Web Interface
}}
|valign="top" width="50%"|

{{Portal_Part|Core Features|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[Feature Matrix]] - Matrix of features currently implemented by OpenSimulator.
* [[Access Control]] - Controlling user access to OpenSimulator.
{{Div col end}}
}}
|}

{| width="25%" cellpadding=10 margin: 10px 10px 10px 10px;
|-
|valign="top" |
{{Portal_Part|Statistics and Information|
}}
|}

[[Category:Vortex]]

2019-04-12T23:52:32Z

CodyCooper:

__NOTOC__
{{Portal_Part|Note|
{{Thirdparty}}
}}

{| width="100%" cellpadding=10 margin: 10px 10px 10px 10px;
|-
|valign="top" |
{{Portal_Part|Core Features|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* {{PAGESINCATEGORY:Vortex|pages}} pages related to Vortex
{{Div col end}}
}}
|valign="top" width="50%"|

{{Portal_Part|Core Features|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[Feature Matrix]] - Matrix of features currently implemented by OpenSimulator.
* [[Access Control]] - Controlling user access to OpenSimulator.
{{Div col end}}
}}

|}
[[Category:Vortex]]

2019-04-10T13:20:06Z

CodyCooper: /* OpenSimulator 0.9.x onwards */

{{Quicklinks}}

= Introduction =

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.

= Code =
There is a common package for database code, OpenSim.Data and each database has its own package (e.g. OpenSim.Data.MySQL).

Each database package has to supply implementations for the interfaces in OpenSim.Data. For instance, IAssetData is the asset interface, used by OpenSimulator to store and retrieve asset data.

= Organization =
== OpenSimulator 0.9.x onwards ==

{| width="100%" cellpadding=10 margin: 10px 10px 10px 10px;
|-
|valign="top" |
{{Portal_Part|Robust|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[Avatars]] - Persistence of the visual appearance of avatars between logins and attached objects
* [[Friends]] - A list of an avatars friends, friendship requests, and permissions granted to friends
* [[GridUser]] - Information about a user in this particular grid, for everyone who uses the grid, local and foreign. This includes their home region, last region, online status and last login/logout. This is distinct from auth information
* [[Presence]] - Region and session information for currently logged in users. Used for IM routing amongst other things.
* [[UserAccounts]] - User account information, such as name, user level and e-mail. Just local accounts.
* [[assets]]</td><td>Grid assets including such things as textures and sounds
* [[auth]]</td><td>User authentication information</td>
* [[inventoryfolders]]</td><td>Inventory folder-related details except for the contents
* [[inventoryitems]] - points back to [[inventoryfolders]]
* [[inventoryitems]] - All inventory item details (including folder associations) except contents - contents are referenced in the [[assets]] table
* [[Regions_(database_table)|regions]] - Regions known to the grid
* [[tokens]] - unused
{{Div col end}}
}}

|valign="top" width="50%"|

{{Portal_Part|Simulator|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[Land_(database_table)|land]] - Parcel Properties
* [[landaccesslist]] - Parcel Access List
* [[primitems]] - Contains the prim's inventory, which is not at all unlike the avatars'<br />inventory with the exception of folders
* [[Prims_(database_table)|prims]] - All rezzed prim details *except shape and contents*
* [[Database:Primshapes|primshapes]] - Properties of all rezzed prims
* [[regionban]] - Per-Region ban list
* [[Database:regionsettings|regionsettings]]</td><td>Per-Region settings
* [[regionwindlight]] - Windlight region settings
* [[Terrain_(database_table)|terrain]] - Terrain mesh revision history
{{Div col end}}
}}

{{Portal_Part|Estates|
{{Div col|colwidth=12em|rules=yes|gap=1em}}
* [[estate groups]] - Narrowly purposed at present. Appears to associate UUIDs under an Estate ID
* [[estate managers]] - Associates avatar 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{{Div col end}}
}}

|}

== OpenSimulator 0.8.1 onwards ==
TODO
== OpenSimulator 0.7.2 onwards ==

=== Common ===
Migrations supports automatic upgrade to new database formats.

=== Services ===
<table>
<tr>
<td>[[Avatars]]</td><td>Persistence of the visual appearance of avatars between logins and attached objects</td>
</tr>
<tr>
<td>[[Friends]]</td><td>A list of an avatars friends, friendship requests, and permissions granted to friends</td>
</tr>
<tr>
<td>[[GridUser]]</td><td>Information about a user in this particular grid, for everyone who uses the grid, local and foreign. This includes their home region, last region, online status and last login/logout. This is distinct from auth information</td>
</tr>
<tr>
<td>[[Presence]]</td>
<td>Region and session information for currently logged in users. Used for IM routing amongst other things.</td>
</tr>
<tr>
<td>[[UserAccounts]]</td><td>User account information, such as name, user level and e-mail. Just local accounts.</td>
</tr>
<tr>
<td>[[assets]]</td><td>Grid assets including such things as textures and sounds</td>
</tr>
<tr>
<td>[[auth]]</td><td>User authentication information</td>
</tr>
<tr>
<td>[[inventoryfolders]]</td><td>Inventory folder-related details *except contents*</td>
</tr>
<tr>
<td> </td><td>Contents are in the [[inventoryitems]] table and point back to [[inventoryfolders]]</td>
</tr>
<tr>
<td>[[inventoryitems]]</td><td>All inventory item details (including folder associations) except contents - contents are referenced in the [[assets]] table</td>
</tr>
<tr>
<td>[[Regions_(database_table)|regions]]<br /></td><td>Regions known to the grid</td>
</tr>
<tr>
<td>tokens</td><td>Unused.</td>
</tr>
</table>

=== Simulator ===
<table>
<tr>
<td>[[estate groups]]</td><td>Narrowly purposed at present. Appears to associate UUIDs under an Estate ID</td>
</tr>
<tr>
<td>[[estate managers]]</td><td>Associates avatar UUIDs with Estate ID</td>
</tr>
<tr>
<td>[[estate map]]<br /><td>Associates Regions with Estates By Estate ID</td>
</tr>
<tr>
<td>[[estate settings]]</td><td>Settings for Estates</td>
</tr>
<tr>
<td>[[estate users]]</td><td>Users allowed on the Estate</td>
</tr>
<tr>
<td>[[estateban]]</td><td>Users banned from the Estate</td>
</tr>
<tr>
<td>[[Land_(database_table)|land]]</td><td>Parcel Properties</td>
</tr>
<tr>
<td>[[landaccesslist]]</td><td>Parcel Access List</td>
</tr>
<tr>
<td>[[primitems]]</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_(database_table)|prims]]</td><td>All rezzed prim details *except shape and contents*</td>
</tr>
<tr>
<td>[[Database:Primshapes|primshapes]]</td><td>Properties of all rezzed prims</td>
</tr>
<tr>
<td>regionban</td><td>Per-Region ban list</td>
</tr>
<tr>
<td>[[Database:regionsettings|regionsettings]]</td><td>Per-Region settings</td>
</tr>
<tr>
<td>regionwindlight</td><td>Windlight region settings</td>
</tr>
<tr>
<td>[[Terrain_(database_table)|terrain]]</td><td>Terrain mesh revision history</td>
</tr>
</table>

== Older information ==

This mainly pertains to OpenSimulator 0.6.9.

<table>
<tr>
<td colspan="2">'''Services:'''</td>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>[[agents]]</td><td>Records agent (Avatar/User) login details</td>
<tr>
<td>[[assets]]</td><td>Comprehensive grid assets including textures and avatar inventories</td>
</tr>
<tr>
<td>[[avatarappearance]]</td><td>Persistence of the visual appearance of avatars between logins</td>
</tr>
<tr>
<td>[[avatarattachments]]</td><td>Items attached to avatars</td>
</tr>
<tr>
<td>[[inventoryfolders]]</td><td>Inventory folder-related details *except contents*</td>
</tr>
<tr>
<td> </td><td>Contents are in the [[inventoryitems]] table and point back to [[inventoryfolders]]</td>
</tr>
<tr>
<td>[[inventoryitems]]</td><td>All inventory item details (including folder associations) except contents</td>
</tr>
<tr>
<td> </td><td>Contents are referenced in the [[assets]] table</td>
</tr>
<tr>
<td>[[migrations]]</td><td>Supports 'automagic' migration to new database formats</td>
</tr>
<tr>
<td>[[Regions_(database_table)|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 colspan="2">'''Simulator:'''</td>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td>[[estate groups]]</td><td>Narrowly purposed at present. Appears to associate UUIDs under an Estate ID</td>
</tr>
<tr>
<td>[[estate managers]]</td><td>Associates UUIDs with Estate ID</td>
</tr>
<tr>
<td>[[estate map]]</td><td>Associates Regions with Estates By Estate ID</td>
</tr>
<tr>
<td>[[estate settings]]</td><td>Settings for Estates</td>
</tr>
<tr>
<td>[[estate users]]</td><td>Users allowed on the Estate</td>
</tr>
<tr>
<td>[[estateban]]</td><td>Users banned from the Estate</td>
</tr>
<tr>
<td>[[land]]</td><td>Parcel Properties</td>
</tr>
<tr>
<td>[[landaccesslist]]</td><td>Parcel Access List</td>
</tr>
<tr>
<td>[[migrations]]</td><td>Supports 'automagic' upgrade to new database formats</td>
</tr>
<tr>
<td>[[primitems]]</td><td>Contains the prim's inventory, which is not at all unlike the avatars</td>
</tr>
<tr>
<td> </td><td>inventory with the exception of folders</td>
</tr>
<tr>
<td>[[Prims_(database_table)|prims]]</td><td>All rezzed prim details *except shape and contents*</td>
</tr>
<tr>
<td>[[Database:Primshapes|primshapes]]</td><td>Properties of all rezzed prims</td>
</tr>
<tr>
<td>[[regionban]]</td><td>Per-Region ban list</td>
</tr>
<tr>
<td>[[regionsettings]]</td><td>Per-Region settings</td>
</tr>
<tr>
<td>[[terrain]]</td><td>Terrain mesh revision history</td>
</tr>
</table>

[[Category:Database]]