Regions (database table)

Revision as of 09: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	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

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

@@ Line 38: / Line 38: @@
 <br>
 '''uuid'''<br>
+The region's unique identifier
 <br>
 <br>
 '''regionHandle'''<br>
+more detail req'd
 <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>
+more detail req'd
 <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>
+more detail req'd
 <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

Views

Regions (database table)

From OpenSimulator

Revision as of 09:40, 7 August 2008

Personal tools

General

For Administrators

For Developers

For Creators

For Grid Users

Related Links

About This Wiki

Search

Tools