| Column Name |
Datatype |
Default |
Column Description |
| session_id |
char(32)
|
|
A system assigned unique ID. See includes/sessions.php for the code on how this value is generated. |
| session_user_id |
mediumint(8)
|
0 |
A foreign key to the users table, allows us to tie the session to the associated logged in user. |
| session_start |
int(11)
|
0 |
A unix_timestamp for the start of this particular session. |
| session_time |
int(11)
|
0 |
A unix_timestamp value for the last time the user session was "touched". Note that not all actions by the user cause this field to be updated; by default it is updated no more frequently than once every 60 seconds. See includes/sessions.php for code. |
| session_ip |
char(8)
|
0 |
The encoded user IP address. The address is stored in non-dotted hex notation, so 127.0.0.1 becomes 7F000001. |
| session_page |
int(11)
|
0 |
Where is the user? This value is populated based on constants defined in includes/constants.php such as PAGE_INDEX which is 0. Each page managed by the session handler should have a unique page ID assigned to it. |
| session_logged_in |
tinyint(1)
|
0 |
Bit flag to show if the session is active or not. A 0 means the user has logged off, a 1 means the user is active or has not logged off. Inactive sessions are removed on a periodic basis by sessions.php. |
| session_admin |
tinyint(2)
|
0 |
A new field added in 2.0.15 to allow the re-authentication process (the double login) for the Admin Control Panel |
Your premium source for custom modification services for phpBB
Forums