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 |
|
|
|||||
timemodified | BIGINT | 19 | null |
|
|
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 |