Database:Documentation
From OpenSimulator
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 apropriate 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 artifacts, some may be planned for use, and some may see heavy use but have columns which are artifacts, not properly updated or not yet used at all. Alpha code FTW!! :D
-daTwitch aka Hiro Protagonist
The instances:
| 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 |
| 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 | |
| logs | Stores a record of logged events |
| logs_preTimestamp | Old format logs table? |
| migrations | Supports 'automagic' migration to new database formats |
| regions | Regions known to the grid |
| reservations | Region registration table. This table has no rows on OSGrid and is likely in place for future functionality |
| userfriends | Friends list registration |
| Region: | |
| estate_groups | Narrowly purposed at present. Appears to associate UUIDs under an Estate ID |
| estate_managers | Assoicates 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 | |
| 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 |
