Regions (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
Line 38: Line 38:
 
<br>
 
<br>
 
'''uuid'''<br>
 
'''uuid'''<br>
 +
The region's unique identifier
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionHandle'''<br>
 
'''regionHandle'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionName'''<br>
 
'''regionName'''<br>
 +
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
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionSendKey'''<br>
 
'''regionSendKey'''<br>
 +
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
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionDataURI'''<br>
 
'''regionDataURI'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''serverIP'''<br>
 
'''serverIP'''<br>
 +
IP address of region server
 
<br>
 
<br>
 
<br>
 
<br>
 
'''serverPort'''<br>
 
'''serverPort'''<br>
 +
connection port for region server
 
<br>
 
<br>
 
<br>
 
<br>
 
'''serverURI'''<br>
 
'''serverURI'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''locX'''<br>
 
'''locX'''<br>
 +
X coordinate of region on the grid
 
<br>
 
<br>
 
<br>
 
<br>
 
'''locY'''<br>
 
'''locY'''<br>
 +
Y coordinate of region on the grid
 
<br>
 
<br>
 
<br>
 
<br>
 
'''locZ'''<br>
 
'''locZ'''<br>
 +
Z coordinate of region on the grid *grinz*
 
<br>
 
<br>
 
<br>
 
<br>
 
'''eastOverrideHandle'''<br>
 
'''eastOverrideHandle'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''westOverrideHandle'''<br>
 
'''westOverrideHandle'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''southOverrideHandle'''<br>
 
'''southOverrideHandle'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''northOverrideHandle'''<br>
 
'''northOverrideHandle'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionAssetURI'''<br>
 
'''regionAssetURI'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionAssetRecvKey'''<br>
 
'''regionAssetRecvKey'''<br>
 +
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
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionUserURI'''<br>
 
'''regionUserURI'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionUserRecvKey'''<br>
 
'''regionUserRecvKey'''<br>
 +
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
 
<br>
 
<br>
 
<br>
 
<br>
 
'''regionMapTexture'''<br>
 
'''regionMapTexture'''<br>
 +
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
 
<br>
 
<br>
 
<br>
 
<br>
 
'''serverRemotingPort'''<br>
 
'''serverRemotingPort'''<br>
 +
more detail req'd
 
<br>
 
<br>
 
<br>
 
<br>
 
'''owner_uuid'''<br>
 
'''owner_uuid'''<br>
 +
UUID of the avatar/account which owns the region
 
<br>
 
<br>
 
<br>
 
<br>
 
'''originUUID'''<br>
 
'''originUUID'''<br>
 +
more detail req'd

Revision as of 10:40, 7 August 2008

The regions table contains information concerning all the regions authorized to connect to the grid.

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



uuid
The region's unique identifier

regionHandle
more detail req'd

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
more detail req'd

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
more detail req'd

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

Personal tools
General
About This Wiki