Regions (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
 
(13 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
−
{{Template:Quicklinks}}
+
{{Quicklinks}}
−
<br />
+
 
−
The regions table contains information concerning all the regions currently connected to the grid.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+
 
 +
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 ||
 +
|- style="background:#eee;"
 +
| '''[[#locY|locY]]''' || int(10) unsigned || YES ||  || NULL ||
 +
|-
 +
| '''[[#locZ|locZ]]''' || int(10) unsigned || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#eastOverrideHandle|eastOverrideHandle]]''' || bigint(20) unsigned || YES || MUL || NULL ||
 +
|-
 +
| '''[[#westOverrideHandle|westOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#southOverrideHandle|southOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
 +
|-
 +
| '''[[#northOverrideHandle|northOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#regionAssetURI|regionAssetURI]]''' || varchar(255) || YES ||  || NULL ||
 +
|-
 +
| '''[[#regionAssetRecvKey|regionAssetRecvKey]]''' || varchar(128) || YES || PRI || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#regionAssetSendKey|regionAssetSendKey]]''' || varchar(128) || YES || PRI || NULL ||
 +
|-
 +
| '''[[#regionUserURI|regionUserURI]]''' || varchar(255) || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#regionUserRecvKey|regionUserRecvKey]]''' || varchar(128) || YES ||  || NULL ||
 +
|-
 +
| '''[[#regionUserSendKey|regionUserSendKey]]''' || varchar(128) || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#regionMapTexture|regionMapTexture]]''' || varchar(36) || YES ||  || NULL ||
 +
|-
 +
| '''[[#serverHttpPort|serverHttpPort]]''' || int(10) || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
| '''[[#serverRemotingPort|serverRemotingPort]]''' || int(10) || YES ||  || NULL ||
 +
|-
 +
| '''[[#owner_uuid|owner_uuid]]''' || varchar(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 +
|- style="background:#eee;"
 +
| '''[[#originUUID|originUUID]]''' || varchar(36) || YES ||  || NULL ||
 +
|-
 +
| '''[[#access|access]]''' || int(10) unsigned || YES ||  || 1 ||
 +
|- style="background:#eee;"
 +
| '''[[#ScopeID|ScopeID]]''' || char(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 +
|-
 +
| '''[[#sizeX|sizeX]]''' || int(11) || NO ||  || 0 ||
 +
|- style="background:#eee;"
 +
| '''[[#sizeY|sizeY]]''' || int(11) || NO ||  || 0 ||
 +
|-
 +
| '''[[#flags|flags]]''' || int(11) || NO ||  || 0 ||
 +
|- style="background:#eee;"
 +
| '''[[#last_seen|last_seen]]''' || int(11) || NO ||  || 0 ||
 +
|-
 +
| '''[[#PrincipalID|PrincipalID]]''' || char(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 +
|- style="background:#eee;"
 +
| '''[[#Token|Token]]''' || varchar(255) || NO ||  || None ||
 +
|-
 +
| '''[[#parcelMapTexture|parcelMapTexture]]''' || varchar(36) || YES ||  || NULL ||
 +
|- style="background:#eee;"
 +
|}
 +
 
 +
 
 +
      (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 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]])
 +
 
  
−
The columns are as follows:
 
−
<br>
 
−
<table>
 
−
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
 
−
<tr><td>&nbsp;</td></tr>
 
−
<tr><td>uuid</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
 
−
<tr><td>regionHandle</td><td>bigint(20) unsigned</td><td>NO</td><td>MUL</td><td>NULL</td><td>&nbsp;</td></tr>
 
−
<tr><td>regionName</td><td>varchar(32)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionRecvKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionSendKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td><tr>
 
−
<tr><td>regionSecret</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>regionDataURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>serverIP</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>serverPort</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>serverURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>locX</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>locY</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 
−
<tr><td>locZ</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>eastOverrideHandle</td><td>bigint(20) unsigned</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><tr>
 
−
<tr><td>westOverrideHandle</td><td>bigint(20) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>southOverrideHandle</td><td>bigint(20) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><br>
 
−
<tr><td>northOverrideHandle</td><td>bigint(20) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionAssetURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionAssetRecvKey</td><td>varchar(128)</td><td>YES</td><td>PRI</td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionAssetSendKey</td><td>varchar(128)</td><td>YES</td><td>PRI</td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionUserURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><tr>
 
−
<tr><td>regionUserRecvKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionUserSendKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>regionMapTexture</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>serverHttpPort</td><td>int(10)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>serverRemotingPort</td><td>int(10)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
<tr><td>owner_uuid</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
 
−
<tr><td>originUUID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
−
</table>
 
−
<br>
 
−
<br>
 
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
−
<hr>
 
−
'''uuid'''<br>
 
−
The region's unique identifier
 
−
<br>
 
−
<br>
 
−
'''regionHandle'''<br>
 
−
The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as<br>
 
−
(LocX*256*65536)+(LocY*256).
 
−
<br>
 
−
<br>
 
−
'''regionName'''<br>
 
−
the region's name as it appears on maps - not necesarily unique
 
−
<br>
 
−
<br>
 
−
'''regionRecvKey'''<br>
 
−
the key used by the region server to verify authenticity of communications from other regions
 
−
<br>
 
−
<br>
 
−
'''regionSendKey'''<br>
 
−
the key used by the region server when verifying its identity in communications with other regions
 
−
<br>
 
−
<br>
 
−
'''regionSecret'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''regionDataURI'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''serverIP'''<br>
 
−
IP address of region server
 
−
<br>
 
−
<br>
 
−
'''serverPort'''<br>
 
−
connection port for region server
 
−
<br>
 
−
<br>
 
−
'''serverURI'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''locX'''<br>
 
−
X coordinate of region on the grid
 
−
<br>
 
−
<br>
 
−
'''locY'''<br>
 
−
Y coordinate of region on the grid
 
−
<br>
 
−
<br>
 
−
'''locZ'''<br>
 
−
Z coordinate of region on the grid *grinz*
 
−
<br>
 
−
<br>
 
−
'''eastOverrideHandle'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''westOverrideHandle'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''southOverrideHandle'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''northOverrideHandle'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''regionAssetURI'''<br>
 
−
The URL and port number of the Asset Server for the grid
 
−
<br>
 
−
<br>
 
−
'''regionAssetRecvKey'''<br>
 
−
key used to verify the authenticity of communications received from the asset server
 
−
<br>
 
−
<br>
 
−
'''regionAssetSendKey'''<br>
 
−
key used to verify the authenticity of communications sent to the asset server
 
−
<br>
 
−
<br>
 
−
'''regionUserURI'''<br>
 
−
The URL and port number of the User Server for the grid
 
−
<br>
 
−
<br>
 
−
'''regionUserRecvKey'''<br>
 
−
key used to verify the authenticity of communications received from the user server
 
−
<br>
 
−
<br>
 
−
'''regionUserSendKey'''<br>
 
−
key used to verify the authenticity of communications sent to the user server
 
−
<br>
 
−
<br>
 
−
'''regionMapTexture'''<br>
 
−
texture for the map as displayed in the client minimap
 
−
<br>
 
−
<br>
 
−
'''serverHttpPort'''<br>
 
−
port the region will answer on for HTTP requests
 
−
<br>
 
−
<br>
 
−
'''serverRemotingPort'''<br>
 
−
more detail req'd
 
−
<br>
 
−
<br>
 
−
'''owner_uuid'''<br>
 
−
UUID of the avatar/account which owns the region
 
−
<br>
 
−
<br>
 
−
'''originUUID'''<br>
 
−
more detail req'd, currently seems to contain the current UUID of the region.
 
−
<br>
 
−
<br>
 
−
<hr>
 
−
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
−
<br>
 
 
[[Category:Database]]
 
[[Category:Database]]

Latest revision as of 08:38, 24 April 2024

Languages Languages: 

En.png English


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)

Retrieved from "http://opensimulator.org/index.php?title=Regions_(database_table)&oldid=54237"
Personal tools
General
About This Wiki