![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T04:37:05+00:00","default:iseki","iseki") *** regions [#a3e46818] - 現時点での 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) #br **** 0.7.0 [#ya77f79f] 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 | | +---------------------+---------------------+------+-----+--------------------------------------+-------+
