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 |