OpenSim/DB/0.9.0/Presence の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/0.9.0/Presence へ行く。
• OpenSim/DB/0.9.0/Presence の差分を削除

#author("2024-09-02T04:55:51+00:00","default:iseki","iseki")
*** Columns [#u8d79ef6]
 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 [#ua56b8f2]
 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)