regions 
- 現時点での Regionの情報
- Regionが起動する毎に書き換えられる
- parcelMapTexture が追加
MariaDB [opensim]> 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(128) | 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 | | | parcelMapTexture | varchar(36) | YES | | NULL | | +---------------------+---------------------+------+-----+--------------------------------------+-------+ 37 rows in set (0.02 sec)
0.7.0 
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 | | +---------------------+---------------------+------+-----+--------------------------------------+-------+
Counter: 1558,
today: 1,
yesterday: 1
最終更新: 2013-01-20 (日) 12:33:22 (JST) (4406d) by iseki