flagflag  

Columns anchor.png

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)
 
Page Top

Select anchor.png

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)
 

Front page   Freeze Diff Backup Copy Rename Reload   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)
Counter: 783, today: 1, yesterday: 0
Last-modified: 2016-07-06 (Wed) 15:24:02 (JST) (2851d) by iseki

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthApr 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
Today

Who's Online

78 user(s) are online (6 user(s) are browsing xpwiki)

Members: 0
Guests: 78

more...

Access Counter

Today : 4551455145514551
Yesterday : 1795517955179551795517955
Total : 2336352823363528233635282336352823363528233635282336352823363528
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com