Mnet Log Table Schema (mnet_log)


Description

Store session data from users migrating to other sites

mnet_log table columns

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

Unique host ID

remoteid bigint 10 0
time bigint 10 0
userid bigint 10 0
user.id Implied Constraint R
ip varchar 45
course bigint 10 0
coursename varchar 40
module varchar 20
cmid bigint 10 0
action varchar 40
url varchar 100
info varchar 255

Table contained -1 rows

mnet_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
mnetlog_hosusecou_ix Performance Asc/Asc/Asc hostid + userid + course

mnet_log table relationships