0 rows


Store session data from users migrating to other sites


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null

Required ID field

userid BIGINT 19 0 mnet_session_erd_useridR

Unique user ID

username VARCHAR 100

Unique username

token VARCHAR 40

Unique SHA1 Token

mnethostid BIGINT 19 0 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


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