Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
Required ID field |
|||
userid | BIGINT | 19 | 0 |
|
|
Unique user ID |
||||
username | VARCHAR | 100 |
|
|
Unique username |
|||||
token | VARCHAR | 40 |
|
|
Unique SHA1 Token |
|||||
mnethostid | BIGINT | 19 | 0 |
|
|
Unique remote host ID |
||||
useragent | VARCHAR | 40 |
|
|
SHA1 hash of User Agent |
|||||
confirm_timeout | BIGINT | 19 | 0 |
|
|
UNIX timestamp for expiry of session |
||||
session_id | VARCHAR | 40 |
|
|
The PHP Session ID |
|||||
expires | BIGINT | 19 | 0 |
|
|
Expire time of session on peer |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
mnetsess_mne_ix | Performance | Asc | mnethostid |
mnetsess_tok_uix | Must be unique | Asc | token |
mnetsess_use_ix | Performance | Asc | userid |