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

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
mnet_session_erd_userid Performance Asc userid
mnetsess_tok2_uix Must be unique Asc token