Mnet Session Table Schema (mnet_session)


Store session data from users migrating to other sites

mnet_session table columns

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

Required ID field

userid BIGINT 19 0 Implied Constraint R

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

Table contained -1 rows

mnet_session table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mnetsess_tok_uix Must be unique Asc token

mnet_session table relationships