Regions (database table)
From OpenSimulator
(Difference between revisions)
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link) |
|||
(11 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
{{Quicklinks}} | {{Quicklinks}} | ||
− | |||
− | |||
− | The | + | |
− | + | 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: | |
− | + | ||
− | + | ||
− | + | {| style="border:1px solid #ccc;" | |
− | + | |- style="background:#cce;" | |
− | + | ! Field | |
− | + | ! Type | |
− | + | ! Null | |
− | + | ! Key | |
− | + | ! Default | |
− | + | ! Extra | |
− | + | |- | |
− | + | | '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL || | |
− | + | |- style="background:#eee;" | |
− | + | | '''[[#regionHandle|regionHandle]]''' || bigint(20) unsigned || NO || MUL || NULL || | |
− | + | |- | |
− | + | | '''[[#regionName|regionName]]''' || varchar(32) || YES || MUL || NULL || | |
− | + | |- style="background:#eee;" | |
− | + | | '''[[#regionRecvKey|regionRecvKey]]''' || varchar(128) || YES || || NULL || | |
− | + | |- | |
− | + | | '''[[#regionSendKey|regionSendKey]]''' || varchar(128) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | + | | '''[[#regionSecret|regionSecret]]''' || varchar(128) || YES || || NULL || | |
− | + | |- | |
− | + | | '''[[#regionDataURI|regionDataURI]]''' || varchar(255) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | + | | '''[[#serverIP|serverIP]]''' || varchar(64) || YES || || NULL || | |
− | + | |- | |
− | + | | '''[[#serverPort|serverPort]]''' || int(10) unsigned || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | + | | '''[[#serverURI|serverURI]]''' || varchar(255) || YES || || NULL || | |
− | + | |- | |
− | + | | '''[[#locX|locX]]''' || int(10) unsigned || YES || || NULL || | |
− | '''uuid''' | + | |- style="background:#eee;" |
− | The region's unique identifier | + | | '''[[#locY|locY]]''' || int(10) unsigned || YES || || NULL || |
− | + | |- | |
− | + | | '''[[#locZ|locZ]]''' || int(10) unsigned || YES || || NULL || | |
− | '''regionHandle''' | + | |- style="background:#eee;" |
− | The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as | + | | '''[[#eastOverrideHandle|eastOverrideHandle]]''' || bigint(20) unsigned || YES || MUL || NULL || |
− | (LocX*256*65536)+(LocY*256). | + | |- |
− | + | | '''[[#westOverrideHandle|westOverrideHandle]]''' || bigint(20) unsigned || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''regionName''' | + | | '''[[#southOverrideHandle|southOverrideHandle]]''' || bigint(20) unsigned || YES || || NULL || |
− | + | |- | |
− | + | | '''[[#northOverrideHandle|northOverrideHandle]]''' || bigint(20) unsigned || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''regionRecvKey''' | + | | '''[[#regionAssetURI|regionAssetURI]]''' || varchar(255) || YES || || NULL || |
− | + | |- | |
− | + | | '''[[#regionAssetRecvKey|regionAssetRecvKey]]''' || varchar(128) || YES || PRI || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''regionSendKey''' | + | | '''[[#regionAssetSendKey|regionAssetSendKey]]''' || varchar(128) || YES || PRI || NULL || |
− | + | |- | |
− | + | | '''[[#regionUserURI|regionUserURI]]''' || varchar(255) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''regionSecret''' | + | | '''[[#regionUserRecvKey|regionUserRecvKey]]''' || varchar(128) || YES || || NULL || |
− | more detail req'd | + | |- |
− | + | | '''[[#regionUserSendKey|regionUserSendKey]]''' || varchar(128) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''regionDataURI''' | + | | '''[[#regionMapTexture|regionMapTexture]]''' || varchar(36) || YES || || NULL || |
− | more detail req'd | + | |- |
− | + | | '''[[#serverHttpPort|serverHttpPort]]''' || int(10) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''serverIP''' | + | | '''[[#serverRemotingPort|serverRemotingPort]]''' || int(10) || YES || || NULL || |
− | IP address of region server | + | |- |
− | + | | '''[[#owner_uuid|owner_uuid]]''' || varchar(36) || NO || || 00000000-0000-0000-0000-000000000000 || | |
− | + | |- style="background:#eee;" | |
− | '''serverPort''' | + | | '''[[#originUUID|originUUID]]''' || varchar(36) || YES || || NULL || |
− | connection port for region | + | |- |
− | + | | '''[[#access|access]]''' || int(10) unsigned || YES || || 1 || | |
− | + | |- style="background:#eee;" | |
− | '''serverURI''' | + | | '''[[#ScopeID|ScopeID]]''' || char(36) || NO || || 00000000-0000-0000-0000-000000000000 || |
− | + | |- | |
− | + | | '''[[#sizeX|sizeX]]''' || int(11) || NO || || 0 || | |
− | + | |- style="background:#eee;" | |
− | '''locX''' | + | | '''[[#sizeY|sizeY]]''' || int(11) || NO || || 0 || |
− | X coordinate of region on the grid | + | |- |
− | + | | '''[[#flags|flags]]''' || int(11) || NO || || 0 || | |
− | + | |- style="background:#eee;" | |
− | '''locY''' | + | | '''[[#last_seen|last_seen]]''' || int(11) || NO || || 0 || |
− | Y coordinate of region on the grid | + | |- |
− | + | | '''[[#PrincipalID|PrincipalID]]''' || char(36) || NO || || 00000000-0000-0000-0000-000000000000 || | |
− | + | |- style="background:#eee;" | |
− | '''locZ''' | + | | '''[[#Token|Token]]''' || varchar(255) || NO || || None || |
− | Z coordinate of region on the grid *grinz* | + | |- |
− | + | | '''[[#parcelMapTexture|parcelMapTexture]]''' || varchar(36) || YES || || NULL || | |
− | + | |- style="background:#eee;" | |
− | '''eastOverrideHandle''' | + | |} |
− | more detail req'd | + | |
− | + | ||
− | + | (back to [[Database Documentation]]) | |
− | '''westOverrideHandle''' | + | |
− | more detail req'd | + | |
− | + | ---- | |
− | + | ||
− | '''southOverrideHandle''' | + | |
− | more detail req'd | + | == regions Fields == |
− | + | ||
− | + | == regions Fields == | |
− | '''northOverrideHandle''' | + | |
− | more detail req'd | + | '''uuid''' |
− | + | :The region's unique identifier | |
− | + | ||
− | '''regionAssetURI''' | + | '''regionHandle''' |
− | The URL and port number of the Asset Server for the grid | + | :The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as |
− | + | :(LocX*256*65536)+(LocY*256). | |
− | + | ||
− | '''regionAssetRecvKey''' | + | '''regionName''' |
− | + | :The region's name as it appears on maps - not necesarily unique | |
− | + | ||
− | + | '''regionRecvKey''' | |
− | '''regionAssetSendKey''' | + | :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 | |
− | '''regionUserURI''' | + | |
− | The URL and port number of the User Server for the grid | + | '''regionSecret''' |
− | + | :more detail req'd | |
− | + | ||
− | '''regionUserRecvKey''' | + | '''regionDataURI''' |
− | + | :more detail req'd | |
− | + | ||
− | + | '''serverIP''' | |
− | '''regionUserSendKey''' | + | :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) | |
− | '''regionMapTexture''' | + | |
− | + | '''serverURI''' | |
− | + | :http representation of serverIP and main http port | |
− | + | ||
− | '''serverHttpPort''' | + | '''locX''' |
− | + | :X coordinate of region on the grid in absolute meters locX/256 is equal to coordinate in Regions.ini | |
− | + | ||
− | + | '''locY''' | |
− | '''serverRemotingPort''' | + | :Y coordinate of region on the grid in absolute meters locY/256 is equal to coordinate in Regions.ini |
− | more detail req'd | + | |
− | + | '''locZ''' | |
− | + | :Z coordinate of region on the grid *grinz* | |
− | '''owner_uuid''' | + | |
− | UUID of the avatar/account which owns the region | + | '''eastOverrideHandle''' |
− | + | :more detail req'd | |
− | + | ||
− | '''originUUID''' | + | '''westOverrideHandle''' |
− | more detail req'd, currently seems to contain the current UUID of the region. | + | :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]]) | ||
+ | |||
+ | |||
[[Category:Database]] | [[Category:Database]] |
Latest revision as of 08:38, 24 April 2024
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)