Regions (database table)
From OpenSimulator
m (Regions moved to Database:Regions: tidy up namespace per sdague) |
Revision as of 15:25, 6 October 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
