Database:Documentation - Revision history

Manni at 12:20, 4 December 2023

2023-12-04T12:20:49Z

Tampa: /* OpenSimulator 0.9.x onwards */

2022-05-06T23:10:09Z

‎OpenSimulator 0.9.x onwards

Acryline: /* OpenSimulator 0.9.x onwards */

2021-10-15T06:00:06Z

‎OpenSimulator 0.9.x onwards

Acryline: /* OpenSimulator 0.7.2 onwards */

2021-10-15T05:59:33Z

‎OpenSimulator 0.7.2 onwards

Acryline: /* OpenSimulator 0.7.2 onwards */

2021-10-15T05:50:43Z

‎OpenSimulator 0.7.2 onwards

Djphil: /* Pre 0.6.9 */ Add missing spaces

2019-11-17T19:13:22Z

‎Pre 0.6.9: Add missing spaces

Djphil: /* OpenSimulator 0.7.2 onwards */ Add missing spaces

2019-11-17T19:11:50Z

‎OpenSimulator 0.7.2 onwards: Add missing spaces

Djphil: /* OpenSimulator 0.7.2 onwards */ Add missing spaces

2019-11-17T19:11:08Z

‎OpenSimulator 0.7.2 onwards: Add missing spaces

Djphil: /* OpenSimulator 0.9.x onwards */ remove

2019-11-17T19:09:04Z

‎OpenSimulator 0.9.x onwards: remove </td><td>

CodyCooper: /* Pre 0.6.9 */

2019-04-26T15:10:32Z

‎Pre 0.6.9

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{Quicklinks|Database_Documentation}}
-{{Portal_Part|Quicklinks and Translations|
-{{Quicklinks}}
 }}
 {{Portal_Part|Introduction|

@@ Line 38: / Line 38: @@
 * [[auth]] - User authentication information
 * [[inventoryfolders]] - Inventory folder-related details except for the contents
-* [[inventoryitems]] - points back to [[inventoryfolders]]
+* [[inventoryitems]] - All inventory item details (including folder associations to [[inventoryfolders]]) except contents - contents are referenced in the [[assets]] table
 * [[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

@@ Line 68: / Line 68: @@
 * [[estate settings]] - Settings for Estates
 * [[estate users]] - Users allowed on the Estate
-* [[estateban]] - Users banned from the Estate{{Div col end}}
+* [[estateban]] - Users banned from the Estate
 }}

@@ Line 111: / Line 111: @@
 * regionban Per-Region ban list
 * [[Database:regionsettings|regionsettings]] Per-Region settings
-* regionwindlightWindlight region settings
+* regionwindlight - Windlight region settings
 * [[Terrain_(database_table)|terrain]] Terrain mesh revision history

@@ Line 94: / Line 94: @@
 * [[inventoryfolders]] Inventory folder-related details *except contents*
 * [[inventoryitems]] holds actual content and 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
+* [[inventoryitems]] All inventory item details (including folder associations) except contents - contents are referenced in the * [[assets]] table*
 *  tokens table is unused
 {{Div col end}}

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

@@ Line 85: / Line 85: @@
 {{Portal_Part|Robust|
 {{Div col|colwidth=12em|rules=yes|gap=1em}}
-* [[Avatars]]Persistence of the visual appearance of avatars between logins and attached objects
+* [[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
+* [[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
+* [[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.
+* [[UserAccounts]] User account information, such as name, user level and e-mail. Just local accounts.
-* [[assets]]Grid assets including such things as textures and sounds
+* [[assets]] Grid assets including such things as textures and sounds
-* [[auth]]User authentication information
+* [[auth]] User authentication information
-* [[inventoryfolders]]Inventory folder-related details *except contents*
+* [[inventoryfolders]] Inventory folder-related details *except contents*
 * [[inventoryitems]] holds actual content and 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
@@ Line 103: / Line 103: @@
 {{Portal_Part|Simulator|
 {{Div col|colwidth=12em|rules=yes|gap=1em}}
-* [[Land_(database_table)|land]]Parcel Properties
+* [[Land_(database_table)|land]] Parcel Properties
-* [[landaccesslist]]Parcel Access List
+* [[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
+* [[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*
+* [[Prims_(database_table)|prims]] All rezzed prim details *except shape and contents*
-* [[Database:Primshapes|primshapes]]Properties of all rezzed prims
+* [[Database:Primshapes|primshapes]] Properties of all rezzed prims
 * regionban Per-Region ban list
-* [[Database:regionsettings|regionsettings]]Per-Region settings
+* [[Database:regionsettings|regionsettings]] Per-Region settings
 * regionwindlightWindlight region settings
-* [[Terrain_(database_table)|terrain]]Terrain mesh revision history
+* [[Terrain_(database_table)|terrain]] Terrain mesh revision history
 {{Div col end}}

@@ Line 55: / Line 55: @@
 * [[Database:Primshapes|primshapes]] - Properties of all rezzed prims
 * [[regionban]] - Per-Region ban list
-* [[Database:regionsettings|regionsettings]]</td><td>Per-Region settings
+* [[Database:regionsettings|regionsettings]] Per-Region settings
 * [[regionwindlight]] - Windlight region settings
 * [[Terrain_(database_table)|terrain]] - Terrain mesh revision history

@@ Line 129: / Line 129: @@
 |}
-=== Pre 0.6.9 ===
+== Pre 0.6.9 ==
 {{Portal_Part|Code|This mainly pertains to OpenSimulator 0.6.9.}}
 {| width="100%" cellpadding=10 margin: 10px 10px 10px 10px;