OpenSim/DB/0.9.0/Presence

Columns†[edit]

MariaDB [jogrid_db]> show columns from Presence;
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
| Field           | Type         | Null | Key | Default                              | Extra                       |
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
| UserID          | varchar(255) | NO   | MUL | NULL                                 |                             |
| RegionID        | char(36)     | NO   | MUL | 00000000-0000-0000-0000-000000000000 |                             |
| SessionID       | char(36)     | NO   | PRI | 00000000-0000-0000-0000-000000000000 |                             |
| SecureSessionID | char(36)     | NO   |     | 00000000-0000-0000-0000-000000000000 |                             |
| LastSeen        | timestamp    | NO   |     | CURRENT_TIMESTAMP                    | on update CURRENT_TIMESTAMP |
+-----------------+--------------+------+-----+--------------------------------------+-----------------------------+
5 rows in set (0.00 sec)

Select†[edit]

MariaDB [jogrid_db]> select UserID,RegionID,LastSeen from Presence;
+--------------------------------------+--------------------------------------+---------------------+
| UserID                               | RegionID                             | LastSeen            |
+--------------------------------------+--------------------------------------+---------------------+
| 926f9d30-a751-408d-a01d-f733b3d5082f | 82c38909-6b24-4d34-bce5-9051e55cb116 | 2016-05-17 14:17:09 |
| 03995f91-c73f-4407-9fb9-d1e369386400 | 25906268-f6bf-4efa-ba90-0f38e93fb503 | 2016-05-17 14:25:47 |
| 0fa2fdd3-e4b7-456f-aa79-75aade09aded | d631135c-6617-491b-a3fd-bf3c1be345e0 | 2016-05-17 11:06:46 |
+--------------------------------------+--------------------------------------+---------------------+
3 rows in set (0.00 sec)

最新の30件

[edit]