Network System Laboratory - Diff of OpenSim/DB/0.9.0/hg_traveling_data

View the source.
Go to OpenSim/DB/0.9.0/hg_traveling_data.

--- 2: 2016-05-16 (Mon) 18:59:19 iseki
+++ Cur: 2016-05-17 (Tue) 17:54:12 iseki
@@ Line 1: / Line 1: @@
 - 自グリッドのアバターがどこへ移動したか？
+#br
+*** Columns [#x45b23de]
  MariaDB [jogrid_db]> show columns from hg_traveling_data;
  +------------------+--------------+------+-----+-------------------+-----------------------------+
@@ Line 14: / Line 15: @@
  +------------------+--------------+------+-----+-------------------+-----------------------------+
 rows in set (0.00 sec)
+#br
+*** Select [#u616e4ac]
+ 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 |
+ .....
+ +--------------------------------------+---------------------------------+-----------------+---------------------+
+rows in set (0.00 sec)
+#br