regions on Standalone Mode 
- HyperGrid の情報が格納される （HyperGridの情報はずーとDBに残る）
MariaDB [opensim_db]> select uuid,regionName,serverURI,locX,locY,serverHttpPort from regions; +--------------------------------------+-------------------------+-----------------------------+---------+--------+----------------+ | uuid | regionName | serverURI | locX | locY | serverHttpPort | +--------------------------------------+-------------------------+-----------------------------+---------+--------+----------------+ | 6e83eb74-2a49-48d3-b73f-3beaca1de726 | http://jogrid.net:8002/ | http://jogrid.net:8002/ | 5897728 | 0 | 8002 | | d24ae9ab-ece1-4aae-a4f6-88a31ddd353b | TEST | http://202.26.148.201:9000/ | 256000 | 256000 | 9000 | +--------------------------------------+-------------------------+-----------------------------+---------+--------+----------------+ 2 rows in set (0.00 sec)
show columns
MariaDB [opensim_db]> 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.00 sec)
Counter: 802,
today: 1,
yesterday: 0
最終更新: 2016-07-07 (木) 17:58:20 (JST) (3175d) by iseki
