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 mnet_session_erd_useridR

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