# mnet_session

0 rows

### Description

Store session data from users migrating to other sites

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |  |  | Required ID field
userid | BIGINT | 19 |  |  | 0 |  |
user.id | mnetsess_use2_fkR
| Unique user ID
username | VARCHAR | 100 |  |  |  |  |  | Unique username
token | VARCHAR | 40 |  |  |  |  |  | Unique SHA1 Token
mnethostid | BIGINT | 19 |  |  | 0 |  |
mnet_host.id | mnetsess_mne2_fkR
| 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

### Relationships