Upgrade Log Table Schema (upgrade_log)


Description

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