Regions (database table)
From OpenSimulator
(Difference between revisions)
m (Added details about the flags field of regions table) |
CodyCooper (Talk | contribs) (→regions Fields) |
||
| Line 104: | Line 104: | ||
== regions Fields == | == regions Fields == | ||
| − | + | == regions Fields == | |
| + | |||
| + | '''uuid''' | ||
:The region's unique identifier | :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 | :The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as | ||
:(LocX*256*65536)+(LocY*256). | :(LocX*256*65536)+(LocY*256). | ||
| − | + | '''regionName''' | |
:The region's name as it appears on maps - not necesarily unique | :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 | :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 | :The key used by the region server when verifying its identity in communications with other regions | ||
| − | + | '''regionSecret''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''regionDataURI''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''serverIP''' | |
:IP address of region server | :IP address of region server | ||
| − | + | '''serverPort''' | |
:connection port for region server | :connection port for region server | ||
| − | + | '''serverURI''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''locX''' | |
:X coordinate of region on the grid | :X coordinate of region on the grid | ||
| − | + | '''locY''' | |
:Y coordinate of region on the grid | :Y coordinate of region on the grid | ||
| − | + | '''locZ''' | |
:Z coordinate of region on the grid *grinz* | :Z coordinate of region on the grid *grinz* | ||
| − | + | '''eastOverrideHandle''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''westOverrideHandle''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''southOverrideHandle''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''northOverrideHandle''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''regionAssetURI''' | |
:The URL and port number of the Asset Server for the grid | :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 | :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 | :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 | :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 | :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 | :Key used to verify the authenticity of communications sent to the user server | ||
| − | + | '''regionMapTexture''' | |
:Texture for the map as displayed in the client minimap | :Texture for the map as displayed in the client minimap | ||
| − | + | '''serverHttpPort''' | |
:Port the region will answer on for HTTP requests | :Port the region will answer on for HTTP requests | ||
| − | + | '''serverRemotingPort''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''owner_uuid''' | |
:UUID of the avatar/account which owns the region | :UUID of the avatar/account which owns the region | ||
| − | + | '''originUUID''' | |
:more detail req'd, currently seems to contain the current UUID of the region. | :more detail req'd, currently seems to contain the current UUID of the region. | ||
| − | + | '''access''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''ScopeID''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''sizeX''' | |
:X size of region (in m) | :X size of region (in m) | ||
| − | + | '''sizeY''' | |
:Y size of region (in m) | :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. | :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 | :FallbackRegion=2 Regions we redirect to when the destination is down | ||
| Line 214: | Line 216: | ||
:DefaultHGRegion=1024 Record represents a default region for hypergrid teleports only. | :DefaultHGRegion=1024 Record represents a default region for hypergrid teleports only. | ||
| − | + | '''last_seen''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''PrincipalID''' | |
:more detail req'd | :more detail req'd | ||
| − | + | '''Token''' | |
:more detail req'd | :more detail req'd | ||
| − | |||
| − | |||
---- | ---- | ||
| − | + | (back to [[Database Documentation]]) | |
| − | + | ||
[[Category:Database]] | [[Category:Database]] | ||
Revision as of 07:02, 26 April 2019
 |
Languages: |
|
The regions table contains information concerning all the regions currently connected to the grid. (back to Database Documentation)
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)
regions Fields
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 region server
serverURI
- more detail req'd
locX
- X coordinate of region on the grid
locY
- Y coordinate of region on the grid
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
- more detail req'd
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)
