|
Cur: 2013-01-20 (Sun) 12:03:53 iseki  |
| | + | *** regions (0.7) [#p61f5226] |
| | + | - 現時点での 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 | | |
| | + | +---------------------+---------------------+------+-----+--------------------------------------+-------+ |
