Mnet Session Table Schema (mnet_session)


Description

Store session data from users migrating to other sites

mnet_session table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null

Required ID field

userid bigint 10 0
user.id Implied Constraint R

Unique user ID

username varchar 100

Unique username

token varchar 40

Unique SHA1 Token

mnethostid bigint 10 0

Unique remote host ID

useragent varchar 40

SHA1 hash of User Agent

confirm_timeout bigint 10 0

UNIX timestamp for expiry of session

session_id varchar 40

The PHP Session ID

expires bigint 10 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