OpenSim/DB/0.9.0/Presence
をテンプレートにして作成
[
トップ
] [
タイトル一覧
|
ページ一覧
|
新規
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
*** Columns [#u8d79ef6]
MariaDB [jogrid_db]> show columns from Presence;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| UserID | varchar(255) | NO | MUL | NULL ...
| RegionID | char(36) | NO | MUL | 00000000...
| SessionID | char(36) | NO | PRI | 00000000...
| SecureSessionID | char(36) | NO | | 00000000...
| LastSeen | timestamp | NO | | CURRENT_...
+-----------------+--------------+------+-----+---------...
5 rows in set (0.00 sec)
*** Select [#ua56b8f2]
MariaDB [jogrid_db]> select UserID,RegionID,LastSeen fro...
+--------------------------------------+----------------...
| UserID | RegionID ...
+--------------------------------------+----------------...
| 926f9d30-a751-408d-a01d-f733b3d5082f | 82c38909-6b24-4...
| 03995f91-c73f-4407-9fb9-d1e369386400 | 25906268-f6bf-4...
| 0fa2fdd3-e4b7-456f-aa79-75aade09aded | d631135c-6617-4...
+--------------------------------------+----------------...
3 rows in set (0.00 sec)
終了行:
*** Columns [#u8d79ef6]
MariaDB [jogrid_db]> show columns from Presence;
+-----------------+--------------+------+-----+---------...
| Field | Type | Null | Key | Default ...
+-----------------+--------------+------+-----+---------...
| UserID | varchar(255) | NO | MUL | NULL ...
| RegionID | char(36) | NO | MUL | 00000000...
| SessionID | char(36) | NO | PRI | 00000000...
| SecureSessionID | char(36) | NO | | 00000000...
| LastSeen | timestamp | NO | | CURRENT_...
+-----------------+--------------+------+-----+---------...
5 rows in set (0.00 sec)
*** Select [#ua56b8f2]
MariaDB [jogrid_db]> select UserID,RegionID,LastSeen fro...
+--------------------------------------+----------------...
| UserID | RegionID ...
+--------------------------------------+----------------...
| 926f9d30-a751-408d-a01d-f733b3d5082f | 82c38909-6b24-4...
| 03995f91-c73f-4407-9fb9-d1e369386400 | 25906268-f6bf-4...
| 0fa2fdd3-e4b7-456f-aa79-75aade09aded | d631135c-6617-4...
+--------------------------------------+----------------...
3 rows in set (0.00 sec)
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
