Upgrade Log Table Schema (upgrade_log)


Upgrade logging

upgrade_log table columns

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

type: 0==info, 1==notice, 2==error

plugin VARCHAR 100 null
version VARCHAR 100 null

plugin or main version if known

targetversion VARCHAR 100 null

version of plugin or core specified in version.php at the time of upgrade loggging

info VARCHAR 255
details LONGTEXT 2147483647 null
backtrace LONGTEXT 2147483647 null
userid BIGINT 19 null
user.id upgrlog_use2_fk R
timemodified BIGINT 19 null

Table contained -1 rows

upgrade_log table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
upgrlog_tim_ix Performance Asc timemodified
upgrlog_typtim_ix Performance Asc/Asc type + timemodified
upgrlog_use_ix Performance Asc userid

upgrade_log table relationships