- 現時点での 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)
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 | |
+---------------------+---------------------+------+-----+--------------------------------------+-------+
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
