Regions (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(New page: The regions table contains information concerning all the regions authorized to connect to the grid. The columns are as follows:)
 
Line 2: Line 2:
  
 
The columns are as follows:
 
The columns are as follows:
 +
<br>
 +
<table>
 +
<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>uuid</td><td>varchar(36)</td><td>NO</td><td>PRI</td><td>NULL</td><td>&nbsp;</td></tr>
 +
<tr><td>regionHandle</td><td>bigint(20) unsigned</td><td>NO</td><td>MUL</td><td>NULL</td><td>&nbsp;</td></tr>
 +
<tr><td>regionName</td><td>varchar(32)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
 +
<tr><td>regionRecvKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>regionSendKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td><tr>
 +
<tr><td>regionSecret</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>regionDataURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>serverIP</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>serverPort</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>serverURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>locX</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>locY</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
 +
<tr><td>locZ</td><td>int(10) unsigned</td><td>YES</td><td></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>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>regionAssetURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>regionAssetRecvKey</td><td>varchar(128)</td><td>YES</td><td>PRI</td><td>NULL</td><td></td></tr>
 +
<tr><td>regionAssetSendKey</td><td>varchar(128)</td><td>YES</td><td>PRI</td><td>NULL</td><td></td></tr>
 +
<tr><td>regionUserURI</td><td>varchar(255)</td><td>YES</td><td></td><td>NULL</td><td></td><tr>
 +
<tr><td>regionUserRecvKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>regionUserSendKey</td><td>varchar(128)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>regionMapTexture</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>serverHttpPort</td><td>int(10)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>serverRemotingPort</td><td>int(10)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
<tr><td>owner_uuid</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
 +
<tr><td>originUUID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
 +
</table>
 +
<br>
 +
<br>

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



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