|
|
| (9 intermediate revisions by 5 users not shown) |
| Line 1: |
Line 1: |
| − | 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.
| + | #REDIRECT [[Database_Documentation]] |
| − | | + | |
| − | 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:
| + | |
| − | <table>
| + | |
| − | <tr>
| + | |
| − | <td align=left>Grid:</td>
| + | |
| − | <tr>
| + | |
| − | <td> </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>[[inventoryfolders]]<br></td><td>Inventory folder-related details *excepting contents*</td>
| + | |
| − | </tr>
| + | |
| − | <tr>
| + | |
| − | <td> </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> </td><td>in the [[assets]] table</td>
| + | |
| − | </tr>
| + | |
| − | <tr>
| + | |
| − | <td>[[logs]]<br></td><td>Stores a record of logged events</td>
| + | |
| − | </tr>
| + | |
| − | <tr>
| + | |
| − | <td>[[logs_preTimestamp]]<br></td><td>Old format [[logs]] table?</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>[[reservations]]</td><td>Region registration table. This table has no rows on OSGrid and is likely in place for future functionality</td>
| + | |
| − | </tr>
| + | |
| − | <tr>
| + | |
| − | <td>[[userfriends]]</td><td>Friends list registration</td>
| + | |
| − | </tr>
| + | |
| − | </table>
| + | |
| − | <br><br>
| + | |
| − | | + | |
| − | Region:
| + | |
| − | [[estate_groups]]
| + | |
| − | [[estate_managers]]
| + | |
| − | [[estate_map]]
| + | |
| − | [[estate_settings]]
| + | |
| − | [[estate_users]]
| + | |
| − | [[estateban]]
| + | |
| − | [[land]]
| + | |
| − | [[landaccesslist]]
| + | |
| − | [[migrations]]
| + | |
| − | [[primitems]]
| + | |
| − | [[prims]]
| + | |
| − | [[primshapes]]
| + | |
| − | [[regionban]]
| + | |
| − | [[regionsettings]]
| + | |
| − | [[terrain]]
| + | |
