Upgrade Log table / upgrade_log - Moodle LMS 3.9 Database schema / Zoola Analytics

upgrade_log table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 10 entries

Table contained -1 rows

upgrade_log table indexes

Search:

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

Showing 1 to 4 of 4 entries

Upgrade Log Table Schema (upgrade_log)

Description

upgrade_log table columns

upgrade_log table indexes

upgrade_log table relationships

Close relationships within degrees of separation