4: 2010-05-24 (月) 10:25:28 iseki  |
現: 2013-01-20 (日) 12:33:22 iseki |
| - | *** regions (0.7)[#f7651dd7] | + | *** regions [#a3e46818] |
| | - 現時点での Regionの情報 | | - 現時点での Regionの情報 |
| | - Regionが起動する毎に書き換えられる | | - Regionが起動する毎に書き換えられる |
| - | - 0.7 から4項目が追加 （lags, last_seen, PrincipalID, Token) | + | - 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) |
| | + | #br |
| | + | |
| | + | **** 0.7.0 [#ya77f79f] |
| | mysql> show columns from regions; | | mysql> show columns from regions; |
| | +---------------------+---------------------+------+-----+--------------------------------------+-------+ | | +---------------------+---------------------+------+-----+--------------------------------------+-------+ |
