Network System Laboratory - OpenSim/DB/0.9.0/hg_traveling_data [Columns]

自グリッドのアバターがどこへ移動したか？

Columns

MariaDB [jogrid_db]> show columns from hg_traveling_data;
+------------------+--------------+------+-----+-------------------+-----------------------------+
| Field            | Type         | Null | Key | Default           | Extra                       |
+------------------+--------------+------+-----+-------------------+-----------------------------+
| SessionID        | varchar(36)  | NO   | PRI | NULL              |                             |
| UserID           | varchar(36)  | NO   | MUL | NULL              |                             |
| GridExternalName | varchar(255) | NO   |     |                   |                             |
| ServiceToken     | varchar(255) | NO   |     |                   |                             |
| ClientIPAddress  | varchar(16)  | NO   |     |                   |                             |
| MyIPAddress      | varchar(16)  | NO   |     |                   |                             |
| TMStamp          | timestamp    | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+------------------+--------------+------+-----+-------------------+-----------------------------+
7 rows in set (0.00 sec)

Select

MariaDB [jogrid_db]> select UserID,GridExternalName,ClientIPAddress,TMStamp from hg_traveling_data;
+--------------------------------------+---------------------------------+-----------------+---------------------+
| UserID                               | GridExternalName                | ClientIPAddress | TMStamp             |
+--------------------------------------+---------------------------------+-----------------+---------------------+
| 3c34a5a3-1068-4151-8c98-76efb7900c02 | http://jogrid.net:8002/         | 180.220.84.22   | 2016-05-11 17:43:55 |
| 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | http://opensim.tuis.ac.jp:8002/ | 172.22.1.79     | 2016-05-17 17:51:44 |  <= Fumi.Hax teleport from JOG to TUIS
| 3c34a5a3-1068-4151-8c98-76efb7900c02 | http://jogrid.net:8002/         | 180.220.84.22   | 2016-05-11 17:43:23 |
| 3fe3be10-9dca-4377-a157-c9d66b8d6add | http://jogrid.net:8002/         | 112.69.226.95   | 2016-05-13 20:03:10 |
| 3fe3be10-9dca-4377-a157-c9d66b8d6add | http://jogrid.net:8002/         | 112.69.226.95   | 2016-05-13 21:19:24 |
| 64bdf6f6-f5f3-4bea-9ca2-dd763a19b68a | http://jogrid.net:8002/         | 36.2.113.124    | 2016-05-17 02:28:38 |
| 0fa2fdd3-e4b7-456f-aa79-75aade09aded | http://jogrid.net:8002/         | 219.122.167.117 | 2016-05-17 17:26:17 |
| 3d6c1ecd-9ee3-4cf5-883f-c05950027a32 | http://jogrid.net:8002/         | 124.154.127.89  | 2016-05-15 22:50:11 |
| 03995f91-c73f-4407-9fb9-d1e369386400 | http://jogrid.net:8002/         | 121.3.1.32      | 2016-05-12 12:23:07 |
| b0d5e508-611a-44eb-82b0-70e38dfcb2a8 | http://jogrid.net:8002/         | 118.17.251.101  | 2016-05-09 21:55:02 |
.....
+--------------------------------------+---------------------------------+-----------------+---------------------+
44 rows in set (0.00 sec)