Regions (database table) - Revision history

Tampa at 16:38, 24 April 2024

2024-04-24T16:38:45Z

Athlon Maurer at 01:41, 13 October 2021

2021-10-13T01:41:35Z

CodyCooper at 15:03, 26 April 2019

2019-04-26T15:03:46Z

CodyCooper: /* regions Fields */

2019-04-26T15:02:59Z

‎regions Fields

Kcozens: Added details about the flags field of regions table

2018-09-09T18:08:51Z

Added details about the flags field of regions table

Kcozens: Updated 'regions Fields' section of page (mostly with placeholders)

2018-09-09T17:57:59Z

Updated 'regions Fields' section of page (mostly with placeholders)

Kcozens: Updated regions table structure as of 0.9

2018-09-09T17:50:00Z

Updated regions table structure as of 0.9

Kcozens: Added links from table structure to field descriptions

2016-04-12T02:59:41Z

Added links from table structure to field descriptions

Show changes

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:33:32Z

Minor formatting changes to match other database documentation pages

JeffKelley: Wikified table structure

2014-01-16T22:09:02Z

Wikified table structure

@@ Line 132: / Line 132: @@
 '''serverPort'''
-:connection port for region server
+:connection port for a specific region(this can be but need not be the same as http, each region should have its own port)
 '''serverURI'''
-:more detail req'd
+:http representation of serverIP and main http port
 '''locX'''
-:X coordinate of region on the grid
+:X coordinate of region on the grid in absolute meters locX/256 is equal to coordinate in Regions.ini
 '''locY'''
-:Y coordinate of region on the grid
+:Y coordinate of region on the grid in absolute meters locY/256 is equal to coordinate in Regions.ini
 '''locZ'''

@@ Line 192: / Line 192: @@
 '''access'''
-:more detail req'd
+:PG=13 Region is set to PG
 '''ScopeID'''

@@ Line 1: / Line 1: @@
 __NOTOC__
 {{Quicklinks}}
-The '''regions''' table contains information concerning all the regions currently connected to the grid.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 == regions Table Structure ==
 The structure of the regions table is as follows:
-<br />
 {| style="border:1px solid #ccc;"
@@ Line 19: / Line 19: @@
 ! Extra
 |-
-| '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL || &nbsp;
+| '''[[#uuid|uuid]]''' || varchar(36) || NO || PRI || NULL ||
 |- style="background:#eee;"
 | '''[[#regionHandle|regionHandle]]''' || bigint(20) unsigned || NO || MUL || NULL ||
@@ Line 94: / Line 94: @@
 |- style="background:#eee;"
 |}
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-<br />
+      (back to [[Database Documentation]])
 ----
-<br />
 == regions Fields ==

@@ Line 104: / Line 104: @@
 == regions Fields ==
-<div id="uuid">'''uuid'''</div>
+== regions Fields ==
 :The region's unique identifier
-<div id="regionHandle">'''regionHandle'''</div>
+'''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).
-<div id="regionName">'''regionName'''</div>
+'''regionName'''
 :The region's name as it appears on maps - not necesarily unique
-<div id="regionRecvKey">'''regionRecvKey'''</div>
+'''regionRecvKey'''
 :The key used by the region server to verify authenticity of communications from other regions
-<div id="regionSendKey">'''regionSendKey'''</div>
+'''regionSendKey'''
 :The key used by the region server when verifying its identity in communications with other regions
-<div id="regionSecret">'''regionSecret'''</div>
+'''regionSecret'''
 :more detail req'd
-<div id="regionDataURI">'''regionDataURI'''</div>
+'''regionDataURI'''
 :more detail req'd
-<div id="serverIP">'''serverIP'''</div>
+'''serverIP'''
 :IP address of region server
-<div id="serverPort">'''serverPort'''</div>
+'''serverPort'''
 :connection port for region server
-<div id="serverURI">'''serverURI'''</div>
+'''serverURI'''
 :more detail req'd
-<div id="locX">'''locX'''</div>
+'''locX'''
 :X coordinate of region on the grid
-<div id="locY">'''locY'''</div>
+'''locY'''
 :Y coordinate of region on the grid
-<div id="locZ">'''locZ'''</div>
+'''locZ'''
 :Z coordinate of region on the grid *grinz*
-<div id="eastOverrideHandle">'''eastOverrideHandle'''</div>
+'''eastOverrideHandle'''
 :more detail req'd
-<div id="westOverrideHandle">'''westOverrideHandle'''</div>
+'''westOverrideHandle'''
 :more detail req'd
-<div id="southOverrideHandle">'''southOverrideHandle'''</div>
+'''southOverrideHandle'''
 :more detail req'd
-<div id="northOverrideHandle">'''northOverrideHandle'''</div>
+'''northOverrideHandle'''
 :more detail req'd
-<div id="regionAssetURI">'''regionAssetURI'''</div>
+'''regionAssetURI'''
 :The URL and port number of the Asset Server for the grid
-<div id="regionAssetRecvKey">'''regionAssetRecvKey'''</div>
+'''regionAssetRecvKey'''
 :Key used to verify the authenticity of communications received from the asset server
-<div id="regionAssetSendKey">'''regionAssetSendKey'''</div>
+'''regionAssetSendKey'''
 :Key used to verify the authenticity of communications sent to the asset server
-<div id="regionUserURI">'''regionUserURI'''</div>
+'''regionUserURI'''
 :The URL and port number of the User Server for the grid
-<div id="regionUserRecvKey">'''regionUserRecvKey'''</div>
+'''regionUserRecvKey'''
 :Key used to verify the authenticity of communications received from the user server
-<div id="regionUserSendKey">'''regionUserSendKey'''</div>
+'''regionUserSendKey'''
 :Key used to verify the authenticity of communications sent to the user server
-<div id="regionMapTexture">'''regionMapTexture'''</div>
+'''regionMapTexture'''
 :Texture for the map as displayed in the client minimap
-<div id="serverHttpPort">'''serverHttpPort'''</div>
+'''serverHttpPort'''
 :Port the region will answer on for HTTP requests
-<div id="serverRemotingPort">'''serverRemotingPort'''</div>
+'''serverRemotingPort'''
 :more detail req'd
-<div id="owner_uuid">'''owner_uuid'''</div>
+'''owner_uuid'''
 :UUID of the avatar/account which owns the region
-<div id="originUUID">'''originUUID'''</div>
+'''originUUID'''
 :more detail req'd, currently seems to contain the current UUID of the region.
-<div id="access">'''access'''</div>
+'''access'''
 :more detail req'd
-<div id="ScopeID">'''ScopeID'''</div>
+'''ScopeID'''
 :more detail req'd
-<div id="sizeX">'''sizeX'''</div>
+'''sizeX'''
 :X size of region (in m)
-<div id="sizeY">'''sizeY'''</div>
+'''sizeY'''
 :Y size of region (in m)
-<div id="flags">'''flags'''</div>
+'''flags'''
 :DefaultRegion=1 Default region for new avatars. Region is randomly selected if multiple regions have fallback flag set.
 :FallbackRegion=2 Regions we redirect to when the destination is down
@@ Line 214: / Line 216: @@
 :DefaultHGRegion=1024 Record represents a default region for hypergrid teleports only.
-<div id="last_seen">'''last_seen'''</div>
+'''last_seen'''
 :more detail req'd
-<div id="PrincipalID">'''PrincipalID'''</div>
+'''PrincipalID'''
 :more detail req'd
-<div id="Token">'''Token'''</div>
+'''Token'''
 :more detail req'd
 ----
-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+(back to [[Database Documentation]])
-<br />
 [[Category:Database]]

@@ Line 202: / Line 202: @@
 <div id="flags">'''flags'''</div>
-:more detail req'd
+:DefaultRegion=1 Default region for new avatars. Region is randomly selected if multiple regions have fallback flag set.
 <div id="last_seen">'''last_seen'''</div>

@@ Line 75: / Line 75: @@
 | '''[[#originUUID|originUUID]]''' || varchar(36) || YES ||  || NULL ||
 |-
 |}
 <br />

@@ Line 2: / Line 2: @@
 {{Quicklinks}}
 <br />
-The columns are as follows:
+The '''regions''' table contains information concerning all the regions currently connected to the grid.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 73: / Line 77: @@
 |}
 <br />
-<br />
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-----
+<br />
 '''uuid'''<br />
 The region's unique identifier
 <br />
-<br />
 '''regionHandle'''<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).
 <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 />
 The URL and port number of the Asset Server for the grid
 <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 />
 The URL and port number of the User Server for the grid
 <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, currently seems to contain the current UUID of the region.
 <br />
-<br />
 ----
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 <br />
 [[Category:Database]]

@@ Line 16: / Line 16: @@
 |-
 | uuid || varchar(36) || NO || PRI || NULL || &nbsp;
-|-
+|- style="background:#eee;"
 | regionHandle || bigint(20) unsigned || NO || MUL || NULL ||
 |-