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 |