OpenSim/DB/0.9.0/Standalone/regions
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
*** regions on Standalone Mode [#vd297ba3]
- HyperGrid の情報が格納される (HyperGridの情報はずーとD...
MariaDB [opensim_db]> select uuid,regionName,serverURI,l...
+--------------------------------------+----------------...
| uuid | regionName ...
+--------------------------------------+----------------...
| 6e83eb74-2a49-48d3-b73f-3beaca1de726 | http://jogrid.n...
| d24ae9ab-ece1-4aae-a4f6-88a31ddd353b | TEST ...
+--------------------------------------+----------------...
2 rows in set (0.00 sec)
#br
*** show columns [#sb5e4adb]
MariaDB [opensim_db]> show columns from regions;
+---------------------+---------------------+------+----...
| Field | Type | Null | Key...
+---------------------+---------------------+------+----...
| uuid | varchar(36) | NO | PRI...
| regionHandle | bigint(20) unsigned | NO | MUL...
| regionName | varchar(128) | YES | MUL...
| regionRecvKey | varchar(128) | YES | ...
| regionSendKey | varchar(128) | YES | ...
| regionSecret | varchar(128) | YES | ...
| regionDataURI | varchar(255) | YES | ...
| serverIP | varchar(64) | YES | ...
| serverPort | int(10) unsigned | YES | ...
| serverURI | varchar(255) | YES | ...
| locX | int(10) unsigned | YES | ...
| locY | int(10) unsigned | YES | ...
| locZ | int(10) unsigned | YES | ...
| eastOverrideHandle | bigint(20) unsigned | YES | MUL...
| westOverrideHandle | bigint(20) unsigned | YES | ...
| southOverrideHandle | bigint(20) unsigned | YES | ...
| northOverrideHandle | bigint(20) unsigned | YES | ...
| regionAssetURI | varchar(255) | YES | ...
| regionAssetRecvKey | varchar(128) | YES | ...
| regionAssetSendKey | varchar(128) | YES | ...
| regionUserURI | varchar(255) | YES | ...
| regionUserRecvKey | varchar(128) | YES | ...
| regionUserSendKey | varchar(128) | YES | ...
| regionMapTexture | varchar(36) | YES | ...
| serverHttpPort | int(10) | YES | ...
| serverRemotingPort | int(10) | YES | ...
| owner_uuid | varchar(36) | NO | ...
| originUUID | varchar(36) | YES | ...
| access | int(10) unsigned | YES | ...
| ScopeID | char(36) | NO | MUL...
| sizeX | int(11) | NO | ...
| sizeY | int(11) | NO | ...
| flags | int(11) | NO | MUL...
| last_seen | int(11) | NO | ...
| PrincipalID | char(36) | NO | ...
| Token | varchar(255) | NO | ...
| parcelMapTexture | varchar(36) | YES | ...
+---------------------+---------------------+------+----...
37 rows in set (0.00 sec)
終了行:
*** regions on Standalone Mode [#vd297ba3]
- HyperGrid の情報が格納される (HyperGridの情報はずーとD...
MariaDB [opensim_db]> select uuid,regionName,serverURI,l...
+--------------------------------------+----------------...
| uuid | regionName ...
+--------------------------------------+----------------...
| 6e83eb74-2a49-48d3-b73f-3beaca1de726 | http://jogrid.n...
| d24ae9ab-ece1-4aae-a4f6-88a31ddd353b | TEST ...
+--------------------------------------+----------------...
2 rows in set (0.00 sec)
#br
*** show columns [#sb5e4adb]
MariaDB [opensim_db]> show columns from regions;
+---------------------+---------------------+------+----...
| Field | Type | Null | Key...
+---------------------+---------------------+------+----...
| uuid | varchar(36) | NO | PRI...
| regionHandle | bigint(20) unsigned | NO | MUL...
| regionName | varchar(128) | YES | MUL...
| regionRecvKey | varchar(128) | YES | ...
| regionSendKey | varchar(128) | YES | ...
| regionSecret | varchar(128) | YES | ...
| regionDataURI | varchar(255) | YES | ...
| serverIP | varchar(64) | YES | ...
| serverPort | int(10) unsigned | YES | ...
| serverURI | varchar(255) | YES | ...
| locX | int(10) unsigned | YES | ...
| locY | int(10) unsigned | YES | ...
| locZ | int(10) unsigned | YES | ...
| eastOverrideHandle | bigint(20) unsigned | YES | MUL...
| westOverrideHandle | bigint(20) unsigned | YES | ...
| southOverrideHandle | bigint(20) unsigned | YES | ...
| northOverrideHandle | bigint(20) unsigned | YES | ...
| regionAssetURI | varchar(255) | YES | ...
| regionAssetRecvKey | varchar(128) | YES | ...
| regionAssetSendKey | varchar(128) | YES | ...
| regionUserURI | varchar(255) | YES | ...
| regionUserRecvKey | varchar(128) | YES | ...
| regionUserSendKey | varchar(128) | YES | ...
| regionMapTexture | varchar(36) | YES | ...
| serverHttpPort | int(10) | YES | ...
| serverRemotingPort | int(10) | YES | ...
| owner_uuid | varchar(36) | NO | ...
| originUUID | varchar(36) | YES | ...
| access | int(10) unsigned | YES | ...
| ScopeID | char(36) | NO | MUL...
| sizeX | int(11) | NO | ...
| sizeY | int(11) | NO | ...
| flags | int(11) | NO | MUL...
| last_seen | int(11) | NO | ...
| PrincipalID | char(36) | NO | ...
| Token | varchar(255) | NO | ...
| parcelMapTexture | varchar(36) | YES | ...
+---------------------+---------------------+------+----...
37 rows in set (0.00 sec)
ページ名: