Regions (database table)
From OpenSimulator
(Difference between revisions)
CodyCooper (Talk | contribs) (→regions Fields) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
{{Quicklinks}} | {{Quicklinks}} | ||
| − | |||
| − | The '''regions''' table contains information concerning all the regions currently connected to the grid. | + | |
| + | The '''regions''' table contains information concerning all the regions currently connected to the grid. (back to [[Database Documentation]]) | ||
== regions Table Structure == | == regions Table Structure == | ||
The structure of the regions table is as follows: | The structure of the regions table is as follows: | ||
| − | + | ||
{| style="border:1px solid #ccc;" | {| style="border:1px solid #ccc;" | ||
| Line 19: | Line 19: | ||
! Extra | ! Extra | ||
|- | |- | ||
| − | | '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL || | + | | '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL || |
|- style="background:#eee;" | |- style="background:#eee;" | ||
| '''[[#regionHandle|regionHandle]]''' || bigint(20) unsigned || NO || MUL || NULL || | | '''[[#regionHandle|regionHandle]]''' || bigint(20) unsigned || NO || MUL || NULL || | ||
| Line 94: | Line 94: | ||
|- style="background:#eee;" | |- style="background:#eee;" | ||
|} | |} | ||
| − | |||
| − | + | ||
| − | + | (back to [[Database Documentation]]) | |
| + | |||
---- | ---- | ||
| − | + | ||
== regions Fields == | == regions Fields == | ||
| Line 132: | Line 132: | ||
'''serverPort''' | '''serverPort''' | ||
| − | :connection port for region | + | :connection port for a specific region(this can be but need not be the same as http, each region should have its own port) |
'''serverURI''' | '''serverURI''' | ||
| − | : | + | :http representation of serverIP and main http port |
'''locX''' | '''locX''' | ||
| − | :X coordinate of region on the grid | + | :X coordinate of region on the grid in absolute meters locX/256 is equal to coordinate in Regions.ini |
'''locY''' | '''locY''' | ||
| − | :Y coordinate of region on the grid | + | :Y coordinate of region on the grid in absolute meters locY/256 is equal to coordinate in Regions.ini |
'''locZ''' | '''locZ''' | ||
| Line 192: | Line 192: | ||
'''access''' | '''access''' | ||
| − | : | + | :PG=13 Region is set to PG |
| + | :Moderate=21 Region is set to Moderate | ||
| + | :Adult=42 Region is set to Adult | ||
'''ScopeID''' | '''ScopeID''' | ||
Latest revision as of 08:38, 24 April 2024
 |
Languages: |
|
The regions table contains information concerning all the regions currently connected to the grid. (back to Database Documentation)
[edit] regions Table Structure
The structure of the regions table is as follows:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| uuid | varchar(36) | NO | PRI | NULL | |
| regionHandle | bigint(20) unsigned | NO | MUL | NULL | |
| regionName | varchar(32) | YES | MUL | NULL | |
| regionRecvKey | varchar(128) | YES | NULL | ||
| regionSendKey | varchar(128) | YES | NULL | ||
| regionSecret | varchar(128) | YES | NULL | ||
| regionDataURI | varchar(255) | YES | NULL | ||
| serverIP | varchar(64) | YES | NULL | ||
| serverPort | int(10) unsigned | YES | NULL | ||
| serverURI | varchar(255) | YES | NULL | ||
| locX | int(10) unsigned | YES | NULL | ||
| locY | int(10) unsigned | YES | NULL | ||
| locZ | int(10) unsigned | YES | NULL | ||
| eastOverrideHandle | bigint(20) unsigned | YES | MUL | NULL | |
| westOverrideHandle | bigint(20) unsigned | YES | NULL | ||
| southOverrideHandle | bigint(20) unsigned | YES | NULL | ||
| northOverrideHandle | bigint(20) unsigned | YES | NULL | ||
| regionAssetURI | varchar(255) | YES | NULL | ||
| regionAssetRecvKey | varchar(128) | YES | PRI | NULL | |
| regionAssetSendKey | varchar(128) | YES | PRI | NULL | |
| regionUserURI | varchar(255) | YES | NULL | ||
| regionUserRecvKey | varchar(128) | YES | NULL | ||
| regionUserSendKey | varchar(128) | YES | NULL | ||
| regionMapTexture | varchar(36) | YES | NULL | ||
| serverHttpPort | int(10) | YES | NULL | ||
| serverRemotingPort | int(10) | YES | NULL | ||
| owner_uuid | varchar(36) | NO | 00000000-0000-0000-0000-000000000000 | ||
| originUUID | varchar(36) | YES | NULL | ||
| access | int(10) unsigned | YES | 1 | ||
| ScopeID | char(36) | NO | 00000000-0000-0000-0000-000000000000 | ||
| sizeX | int(11) | NO | 0 | ||
| sizeY | int(11) | NO | 0 | ||
| flags | int(11) | NO | 0 | ||
| last_seen | int(11) | NO | 0 | ||
| PrincipalID | char(36) | NO | 00000000-0000-0000-0000-000000000000 | ||
| Token | varchar(255) | NO | None | ||
| parcelMapTexture | varchar(36) | YES | NULL |
(back to Database Documentation)
[edit] regions Fields
[edit] regions Fields
uuid
- The region's unique identifier
regionHandle
- The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as
- (LocX*256*65536)+(LocY*256).
regionName
- The region's name as it appears on maps - not necesarily unique
regionRecvKey
- The key used by the region server to verify authenticity of communications from other regions
regionSendKey
- The key used by the region server when verifying its identity in communications with other regions
regionSecret
- more detail req'd
regionDataURI
- more detail req'd
serverIP
- IP address of region server
serverPort
- connection port for a specific region(this can be but need not be the same as http, each region should have its own port)
serverURI
- http representation of serverIP and main http port
locX
- X coordinate of region on the grid in absolute meters locX/256 is equal to coordinate in Regions.ini
locY
- Y coordinate of region on the grid in absolute meters locY/256 is equal to coordinate in Regions.ini
locZ
- Z coordinate of region on the grid *grinz*
eastOverrideHandle
- more detail req'd
westOverrideHandle
- more detail req'd
southOverrideHandle
- more detail req'd
northOverrideHandle
- more detail req'd
regionAssetURI
- The URL and port number of the Asset Server for the grid
regionAssetRecvKey
- Key used to verify the authenticity of communications received from the asset server
regionAssetSendKey
- Key used to verify the authenticity of communications sent to the asset server
regionUserURI
- The URL and port number of the User Server for the grid
regionUserRecvKey
- Key used to verify the authenticity of communications received from the user server
regionUserSendKey
- Key used to verify the authenticity of communications sent to the user server
regionMapTexture
- Texture for the map as displayed in the client minimap
serverHttpPort
- Port the region will answer on for HTTP requests
serverRemotingPort
- more detail req'd
owner_uuid
- UUID of the avatar/account which owns the region
originUUID
- more detail req'd, currently seems to contain the current UUID of the region.
access
- PG=13 Region is set to PG
- Moderate=21 Region is set to Moderate
- Adult=42 Region is set to Adult
ScopeID
- more detail req'd
sizeX
- X size of region (in m)
sizeY
- Y size of region (in m)
flags
- DefaultRegion=1 Default region for new avatars. Region is randomly selected if multiple regions have fallback flag set.
- FallbackRegion=2 Regions we redirect to when the destination is down
- RegionOnline=4 Set when a region comes online, unset when it unregisters and DeleteOnUnregister is false
- NoDirectLogin=8 Region unavailable for direct logins (by name)
- Persistent=16 Don't remove on unregister
- LockedOut=32 Don't allow registration
- NoMove=64 Don't allow moving this region
- Reservation=128 This is an inactive reservation
- Authenticate=256 Require authentication
- Hyperlink=512 Record represents a HG link
- DefaultHGRegion=1024 Record represents a default region for hypergrid teleports only.
last_seen
- more detail req'd
PrincipalID
- more detail req'd
Token
- more detail req'd
(back to Database Documentation)
