Database Documentation (MySQL only)
From OpenSimulator
m (Robot: Replacing 'OpenSim' to 'OpenSimulator', which is the precise name) |
Steevithak (Talk | contribs) m (added delete request for duplicate, orphan page) |
||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
{{Quicklinks}} | {{Quicklinks}} | ||
| − | {{ | + | |
| + | {{delete|Orphaned prototype page}} | ||
| + | '''Purpose:''' Minor cleanup | ||
| + | |||
| + | '' This page was an early prototype of the current [[Database_Documentation]] page and is now an orphaned duplicate. It needs to be deleted. | ||
| + | |||
| + | |||
<br /> | <br /> | ||
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 OpenSimulator grid. | 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 OpenSimulator grid. | ||
Revision as of 11:27, 9 September 2020
 |
Languages: |
|
|
|
This article or section is scheduled for deletion The content in this page is no longer relevant and is scheduled for deletion. Reason: Orphaned prototype page |
Purpose: Minor cleanup
This page was an early prototype of the current Database_Documentation page and is now an orphaned duplicate. It needs to be deleted.
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 OpenSimulator 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 estate managers estate map estate settings estate users estateban land landaccesslist migrations primitems prims primshapes regionban regionsettings terrain
This is a brief snip from an IRC discussion that pretty much sums things up:
<daTwitch> my next question involves the use of the files in trunk/OpenSim/Data/MySQL/Resources/ <daTwitch> If I understand correctly, assuming at minimum a previously unused instance on the db, execution of CreateAssetsTable.sql on the sql server, followed by the application of the files 001_AssetStore.sql thru 004_AssetStore.sql (as it stands now) will produce a current assets backstore <daTwitch> and similarly for the other tables <daTwitch> is that a valid assumption? <justinccWork> yep <daTwitch> bitchin' dude :D <daTwitch> <3 <justinccWork> got it in one :) <daTwitch> Thanks Man :D
