Log Table Schema (log)


Description

Every action is logged as far as possible

log table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
time bigint 10 0
userid bigint 10 0
user.id Implied Constraint R
ip varchar 45
course bigint 10 0
module varchar 20
cmid bigint 10 0
action varchar 40
url varchar 100
info varchar 255

Table contained -1 rows

log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
log_act_ix Performance Asc action
log_cmi_ix Performance Asc cmid
log_coumodact_ix Performance Asc/Asc/Asc course + module + action
log_tim_ix Performance Asc time
log_usecou_ix Performance Asc/Asc userid + course

log table relationships