OpenSim​/DB​/0.7.0​/regions

regions (0.7)

• 現時点での Regionの情報
• Regionが起動する毎に書き換えられる
• 0.7 から4項目が追加　（lags, last_seen, PrincipalID, Token)

  mysql> show columns from regions;
  +---------------------+---------------------+------+-----+--------------------------------------+-------+
  | 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  |     | NULL                                 |       | 
  | regionAssetSendKey  | varchar(128)        | YES  |     | 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                                 |       | 
  | access              | int(10) unsigned    | YES  |     | 1                                    |       | 
  | ScopeID             | char(36)            | NO   | MUL | 00000000-0000-0000-0000-000000000000 |       | 
  | sizeX               | int(11)             | NO   |     | 0                                    |       | 
  | sizeY               | int(11)             | NO   |     | 0                                    |       | 
  | flags               | int(11)             | NO   | MUL | 0                                    |       | 
  | last_seen           | int(11)             | NO   |     | 0                                    |       | 
  | PrincipalID         | char(36)            | NO   |     | 00000000-0000-0000-0000-000000000000 |       | 
  | Token               | varchar(255)        | NO   |     | NULL                                 |       | 
  +---------------------+---------------------+------+-----+--------------------------------------+-------+