Database Documentation (MySQL only) - Revision history

Steevithak: redirecting an orphaned, out of date database page to the current database page

2020-09-23T15:48:08Z

redirecting an orphaned, out of date database page to the current database page

Steevithak: added delete request for duplicate, orphan page

2020-09-09T19:27:16Z

added delete request for duplicate, orphan page

MakoBot: Robot: Replacing 'OpenSim' to 'OpenSimulator', which is the precise name

2012-03-04T06:19:55Z

Robot: Replacing 'OpenSim' to 'OpenSimulator', which is the precise name

MakoBot: Robot: Cosmetic changes

2012-03-04T02:56:30Z

Robot: Cosmetic changes

MakoBot: comment: bot test - killing 'Template:' prefix from template includings

2011-06-06T11:56:45Z

comment: bot test - killing 'Template:' prefix from template includings

Makopoppo: merged Initial creation of the MySQL tables for now, but the contents need to be revised soon

2011-06-05T02:10:34Z

merged Initial creation of the MySQL tables for now, but the contents need to be revised soon

Makopoppo: Reverted edits by Makopoppo (Talk) to last version by Fritigern

2011-06-05T02:09:12Z

Reverted edits by Makopoppo (Talk) to last version by Fritigern

Makopoppo: merged to Troubleshooting - the contents was not so long

2011-06-05T02:08:44Z

merged to Troubleshooting - the contents was not so long

Fritigern at 15:14, 19 November 2010

2010-11-19T15:14:11Z

Ideia Boa at 14:37, 21 May 2009

2009-05-21T14:37:59Z

@@ Line 1: / Line 1: @@
-__NOTOC__
+#REDIRECT [[Database_Documentation]]
-{{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 />
-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:
-<table>
-<tr>
-<td align=left>Grid:</td>
-<tr>
-<td>&nbsp;</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>&nbsp;</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>&nbsp;</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]]
-−
-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
-_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
-−
-[[Category:Database]]

@@ Line 1: / Line 1: @@
 __NOTOC__
 {{Quicklinks}}
-{{obsolete}}
 <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.

@@ Line 3: / Line 3: @@
 {{obsolete}}
 <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 OpenSim 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.
 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.

@@ Line 20: / Line 20: @@
 </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>
-<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>
-<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>
-<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>
@@ Line 33: / Line 33: @@
 </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>
@@ Line 39: / Line 39: @@
 </tr>
 <tr>
-<td>[[logs]]<br></td><td>Stores a record of logged events</td>
+<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>
+<td>[[logs preTimestamp]]<br /></td><td>Old format [[logs]] table?</td>
 </tr>
 <tr>
@@ Line 57: / Line 57: @@
 </tr>
 </table>
-<br><br>
+<br /><br />
 Region:
-[[estate_groups]]
+[[estate groups]]
-[[estate_managers]]
+[[estate managers]]
-[[estate_map]]
+[[estate map]]
-[[estate_settings]]
+[[estate settings]]
-[[estate_users]]
+[[estate users]]
 [[estateban]]
 [[land]]

@@ Line 1: / Line 1: @@
 __NOTOC__
-{{Template:Quicklinks}}
+{{Quicklinks}}
 {{obsolete}}
 <br />

← Older revision		Revision as of 15:14, 19 November 2010
Line 74:		Line 74:
	[[regionsettings]]		[[regionsettings]]
	[[terrain]]		[[terrain]]
		+
		+
		+	[[Category:Database]]

← Older revision		Revision as of 14:37, 21 May 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	{{Template:Quicklinks}}
		+	<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 OpenSim 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 OpenSim grid.