Regions (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link)
m (Robot: Cosmetic changes)
Line 5: Line 5:
  
 
The columns are as follows:
 
The columns are as follows:
−
<br>
+
<br />
 
<table>
 
<table>
−
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
<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>&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>uuid</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
Line 24: Line 24:
 
<tr><td>eastOverrideHandle</td><td>bigint(20) unsigned</td><td>YES</td><td>MUL</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>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>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>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>regionAssetURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
Line 38: Line 38:
 
<tr><td>originUUID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
<tr><td>originUUID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 
</table>
 
</table>
−
<br>
+
<br />
−
<br>
+
<br />
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
−
<hr>
+
----
−
'''uuid'''<br>
+
'''uuid'''<br />
 
The region's unique identifier
 
The region's unique identifier
−
<br>
+
<br />
−
<br>
+
<br />
−
'''regionHandle'''<br>
+
'''regionHandle'''<br />
−
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<br />
 
(LocX*256*65536)+(LocY*256).
 
(LocX*256*65536)+(LocY*256).
−
<br>
+
<br />
−
<br>
+
<br />
−
'''regionName'''<br>
+
'''regionName'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionRecvKey'''<br>
+
'''regionRecvKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionSendKey'''<br>
+
'''regionSendKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionSecret'''<br>
+
'''regionSecret'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''regionDataURI'''<br>
+
'''regionDataURI'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''serverIP'''<br>
+
'''serverIP'''<br />
 
IP address of region server
 
IP address of region server
−
<br>
+
<br />
−
<br>
+
<br />
−
'''serverPort'''<br>
+
'''serverPort'''<br />
 
connection port for region server
 
connection port for region server
−
<br>
+
<br />
−
<br>
+
<br />
−
'''serverURI'''<br>
+
'''serverURI'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''locX'''<br>
+
'''locX'''<br />
 
X coordinate of region on the grid
 
X coordinate of region on the grid
−
<br>
+
<br />
−
<br>
+
<br />
−
'''locY'''<br>
+
'''locY'''<br />
 
Y coordinate of region on the grid
 
Y coordinate of region on the grid
−
<br>
+
<br />
−
<br>
+
<br />
−
'''locZ'''<br>
+
'''locZ'''<br />
 
Z coordinate of region on the grid *grinz*
 
Z coordinate of region on the grid *grinz*
−
<br>
+
<br />
−
<br>
+
<br />
−
'''eastOverrideHandle'''<br>
+
'''eastOverrideHandle'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''westOverrideHandle'''<br>
+
'''westOverrideHandle'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''southOverrideHandle'''<br>
+
'''southOverrideHandle'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''northOverrideHandle'''<br>
+
'''northOverrideHandle'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''regionAssetURI'''<br>
+
'''regionAssetURI'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionAssetRecvKey'''<br>
+
'''regionAssetRecvKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionAssetSendKey'''<br>
+
'''regionAssetSendKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionUserURI'''<br>
+
'''regionUserURI'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionUserRecvKey'''<br>
+
'''regionUserRecvKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionUserSendKey'''<br>
+
'''regionUserSendKey'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
'''regionMapTexture'''<br>
+
'''regionMapTexture'''<br />
 
texture for the map as displayed in the client minimap
 
texture for the map as displayed in the client minimap
−
<br>
+
<br />
−
<br>
+
<br />
−
'''serverHttpPort'''<br>
+
'''serverHttpPort'''<br />
 
port the region will answer on for HTTP requests
 
port the region will answer on for HTTP requests
−
<br>
+
<br />
−
<br>
+
<br />
−
'''serverRemotingPort'''<br>
+
'''serverRemotingPort'''<br />
 
more detail req'd
 
more detail req'd
−
<br>
+
<br />
−
<br>
+
<br />
−
'''owner_uuid'''<br>
+
'''owner_uuid'''<br />
 
UUID of the avatar/account which owns the region
 
UUID of the avatar/account which owns the region
−
<br>
+
<br />
−
<br>
+
<br />
−
'''originUUID'''<br>
+
'''originUUID'''<br />
 
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>
+
<br />
−
<br>
+
<br />
−
<hr>
+
----
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
−
<br>
+
<br />
 +
 
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 21:03, 3 March 2012

Languages Languages: 

En.png English


The regions table contains information concerning all the regions currently connected to the grid.      (back to Database Documentation)

The columns are as follows:


Field
TypeNullKeyDefaultExtra
 
uuidvarchar(36)NOPRINULL 
regionHandlebigint(20) unsignedNOMULNULL 
regionNamevarchar(32)YESMULNULL
regionRecvKeyvarchar(128)YESNULL
regionSendKeyvarchar(128)YESNULL
regionSecretvarchar(128)YESNULL
regionDataURIvarchar(255)YESNULL
serverIPvarchar(64)YESNULL
serverPortint(10) unsignedYESNULL
serverURIvarchar(255)YESNULL
locXint(10) unsignedYESNULL
locYint(10) unsignedYESNULL
locZint(10) unsignedYESNULL
eastOverrideHandlebigint(20) unsignedYESMULNULL
westOverrideHandlebigint(20) unsignedYESNULL
southOverrideHandlebigint(20) unsignedYESNULL
northOverrideHandlebigint(20) unsignedYESNULL
regionAssetURIvarchar(255)YESNULL
regionAssetRecvKeyvarchar(128)YESPRINULL
regionAssetSendKeyvarchar(128)YESPRINULL
regionUserURIvarchar(255)YESNULL
regionUserRecvKeyvarchar(128)YESNULL
regionUserSendKeyvarchar(128)YESNULL
regionMapTexturevarchar(36)YESNULL
serverHttpPortint(10)YESNULL
serverRemotingPortint(10)YESNULL
owner_uuidvarchar(36)NO00000000-0000-0000-0000-000000000000
originUUIDvarchar(36)YESNULL



      (back to Database Documentation)

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=28440"
General
About This Wiki