Regions (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Minor formatting changes to match other database documentation pages)
(Added links from table structure to field descriptions)
Line 19: Line 19:
 
! Extra
 
! Extra
 
|-  
 
|-  
−
| uuid || varchar(36) || NO || PRI || NULL ||  
+
| '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL ||  
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionHandle || bigint(20) unsigned || NO || MUL || NULL ||
+
| '''[[#regionHandle|regionHandle]]''' || bigint(20) unsigned || NO || MUL || NULL ||
−
|-  
+
|-
−
| regionName || varchar(32) || YES || MUL || NULL ||  
+
| '''[[#regionName|regionName]]''' || varchar(32) || YES || MUL || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionRecvKey || varchar(128) || YES ||  || NULL ||  
+
| '''[[#regionRecvKey|regionRecvKey]]''' || varchar(128) || YES ||  || NULL ||
−
|-  
+
|-
−
| regionSendKey || varchar(128) || YES ||  || NULL ||
+
| '''[[#regionSendKey|regionSendKey]]''' || varchar(128) || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionSecret || varchar(128) || YES ||  || NULL ||
+
| '''[[#regionSecret|regionSecret]]''' || varchar(128) || YES ||  || NULL ||
−
|-  
+
|-
−
| regionDataURI || varchar(255) || YES ||  || NULL ||
+
| '''[[#regionDataURI|regionDataURI]]''' || varchar(255) || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| serverIP || varchar(64) || YES ||  || NULL ||
+
| '''[[#serverIP|serverIP]]''' || varchar(64) || YES ||  || NULL ||
−
|-  
+
|-
−
| serverPort || int(10) unsigned || YES ||  || NULL ||
+
| '''[[#serverPort|serverPort]]''' || int(10) unsigned || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| serverURI || varchar(255) || YES ||  || NULL ||
+
| '''[[#serverURI|serverURI]]''' || varchar(255) || YES ||  || NULL ||
−
|-  
+
|-
−
| locX || int(10) unsigned || YES ||  || NULL ||
+
| '''[[#locX|locX]]''' || int(10) unsigned || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| locY || int(10) unsigned || YES ||  || NULL ||
+
| '''[[#locY|locY]]''' || int(10) unsigned || YES ||  || NULL ||
−
|-  
+
|-
−
| locZ || int(10) unsigned || YES ||  || NULL ||  
+
| '''[[#locZ|locZ]]''' || int(10) unsigned || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| eastOverrideHandle || bigint(20) unsigned || YES || MUL || NULL ||
+
| '''[[#eastOverrideHandle|eastOverrideHandle]]''' || bigint(20) unsigned || YES || MUL || NULL ||
−
|-  
+
|-
−
| westOverrideHandle || bigint(20) unsigned || YES ||  || NULL ||  
+
| '''[[#westOverrideHandle|westOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| southOverrideHandle || bigint(20) unsigned || YES ||  || NULL ||
+
| '''[[#southOverrideHandle|southOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
−
|-  
+
|-
−
| northOverrideHandle || bigint(20) unsigned || YES ||  || NULL ||  
+
| '''[[#northOverrideHandle|northOverrideHandle]]''' || bigint(20) unsigned || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionAssetURI || varchar(255) || YES ||  || NULL ||  
+
| '''[[#regionAssetURI|regionAssetURI]]''' || varchar(255) || YES ||  || NULL ||
−
|-  
+
|-
−
| regionAssetRecvKey || varchar(128) || YES || PRI || NULL ||  
+
| '''[[#regionAssetRecvKey|regionAssetRecvKey]]''' || varchar(128) || YES || PRI || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionAssetSendKey || varchar(128) || YES || PRI || NULL ||  
+
| '''[[#regionAssetSendKey|regionAssetSendKey]]''' || varchar(128) || YES || PRI || NULL ||
−
|-  
+
|-
−
| regionUserURI || varchar(255) || YES ||  || NULL ||
+
| '''[[#regionUserURI|regionUserURI]]''' || varchar(255) || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionUserRecvKey || varchar(128) || YES ||  || NULL ||  
+
| '''[[#regionUserRecvKey|regionUserRecvKey]]''' || varchar(128) || YES ||  || NULL ||
−
|-  
+
|-
−
| regionUserSendKey || varchar(128) || YES ||  || NULL ||  
+
| '''[[#regionUserSendKey|regionUserSendKey]]''' || varchar(128) || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| regionMapTexture || varchar(36) || YES ||  || NULL ||  
+
| '''[[#regionMapTexture|regionMapTexture]]''' || varchar(36) || YES ||  || NULL ||
−
|-  
+
|-
−
| serverHttpPort || int(10) || YES ||  || NULL ||  
+
| '''[[#serverHttpPort|serverHttpPort]]''' || int(10) || YES ||  || NULL ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| serverRemotingPort || int(10) || YES ||  || NULL ||  
+
| '''[[#serverRemotingPort|serverRemotingPort]]''' || int(10) || YES ||  || NULL ||
−
|-  
+
|-
−
| owner_uuid || varchar(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||  
+
| '''[[#owner_uuid|owner_uuid]]''' || varchar(36) || NO ||  || 00000000-0000-0000-0000-000000000000 ||
 
|- style="background:#eee;"
 
|- style="background:#eee;"
−
| originUUID || varchar(36) || YES ||  || NULL ||  
+
| '''[[#originUUID|originUUID]]''' || varchar(36) || YES ||  || NULL ||
 
|-  
 
|-  
 
|}
 
|}
Line 86: Line 86:
 
== regions Fields ==
 
== regions Fields ==
  
−
'''uuid'''<br />
+
<div id="uuid">'''uuid'''</div>
−
The region's unique identifier
+
:The region's unique identifier
−
<br />
+
  
−
'''regionHandle'''<br />
+
<div id="regionHandle">'''regionHandle'''</div>
−
The absolute address of the origin coordinates, specified in metres, of the region calculated from LocX and LocY as<br />
+
: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).
−
<br />
+
  
−
'''regionName'''<br />
+
<div id="regionName">'''regionName'''</div>
−
the region's name as it appears on maps - not necesarily unique
+
:The region's name as it appears on maps - not necesarily unique
−
<br />
+
  
−
'''regionRecvKey'''<br />
+
<div id="regionRecvKey">'''regionRecvKey'''</div>
−
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
−
<br />
+
  
−
'''regionSendKey'''<br />
+
<div id="regionSendKey">'''regionSendKey'''</div>
−
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  
−
<br />
+
  
−
'''regionSecret'''<br />
+
<div id="regionSecret">'''regionSecret'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''regionDataURI'''<br />
+
<div id="regionDataURI">'''regionDataURI'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''serverIP'''<br />
+
<div id="serverIP">'''serverIP'''</div>
−
IP address of region server
+
:IP address of region server
−
<br />
+
  
−
'''serverPort'''<br />
+
<div id="serverPort">'''serverPort'''</div>
−
connection port for region server
+
:connection port for region server
−
<br />
+
  
−
'''serverURI'''<br />
+
<div id="serverURI">'''serverURI'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''locX'''<br />
+
<div id="locX">'''locX'''</div>
−
X coordinate of region on the grid
+
:X coordinate of region on the grid
−
<br />
+
  
−
'''locY'''<br />
+
<div id="locY">'''locY'''</div>
−
Y coordinate of region on the grid
+
:Y coordinate of region on the grid
−
<br />
+
  
−
'''locZ'''<br />
+
<div id="locZ">'''locZ'''</div>
−
Z coordinate of region on the grid *grinz*
+
:Z coordinate of region on the grid *grinz*
−
<br />
+
  
−
'''eastOverrideHandle'''<br />
+
<div id="eastOverrideHandle">'''eastOverrideHandle'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''westOverrideHandle'''<br />
+
<div id="westOverrideHandle">'''westOverrideHandle'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''southOverrideHandle'''<br />
+
<div id="southOverrideHandle">'''southOverrideHandle'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''northOverrideHandle'''<br />
+
<div id="northOverrideHandle">'''northOverrideHandle'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''regionAssetURI'''<br />
+
<div id="regionAssetURI">'''regionAssetURI'''</div>
−
The URL and port number of the Asset Server for the grid
+
:The URL and port number of the Asset Server for the grid
−
<br />
+
  
−
'''regionAssetRecvKey'''<br />
+
<div id="regionAssetRecvKey">'''regionAssetRecvKey'''</div>
−
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
−
<br />
+
  
−
'''regionAssetSendKey'''<br />
+
<div id="regionAssetSendKey">'''regionAssetSendKey'''</div>
−
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
−
<br />
+
  
−
'''regionUserURI'''<br />
+
<div id="regionUserURI">'''regionUserURI'''</div>
−
The URL and port number of the User Server for the grid
+
:The URL and port number of the User Server for the grid
−
<br />
+
  
−
'''regionUserRecvKey'''<br />
+
<div id="regionUserRecvKey">'''regionUserRecvKey'''</div>
−
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
−
<br />
+
  
−
'''regionUserSendKey'''<br />
+
<div id="regionUserSendKey">'''regionUserSendKey'''</div>
−
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
−
<br />
+
  
−
'''regionMapTexture'''<br />
+
<div id="regionMapTexture">'''regionMapTexture'''</div>
−
texture for the map as displayed in the client minimap
+
:Texture for the map as displayed in the client minimap
−
<br />
+
  
−
'''serverHttpPort'''<br />
+
<div id="serverHttpPort">'''serverHttpPort'''</div>
−
port the region will answer on for HTTP requests
+
:Port the region will answer on for HTTP requests
−
<br />
+
  
−
'''serverRemotingPort'''<br />
+
<div id="serverRemotingPort">'''serverRemotingPort'''</div>
−
more detail req'd
+
:more detail req'd
−
<br />
+
  
−
'''owner_uuid'''<br />
+
<div id="owner_uuid">'''owner_uuid'''</div>
−
UUID of the avatar/account which owns the region
+
:UUID of the avatar/account which owns the region
−
<br />
+
  
−
'''originUUID'''<br />
+
<div id="originUUID">'''originUUID'''</div>
−
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.
−
<br />
+
  
 
----
 
----

Revision as of 19:59, 11 April 2016

Languages Languages: 

En.png English


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


      (back to Database Documentation)


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.

      (back to Database Documentation)

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