Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| userid | BIGINT | 19 | null |
|
|
user who exported content |
||||
| time | BIGINT | 19 | null |
|
|
time of transfer (in the case of a queued transfer this is the time the actual transfer ran, not when the user started) |
||||
| portfolio | BIGINT | 19 | null |
|
|
fk to portfolio_instance |
||||
| caller_class | VARCHAR | 150 |
|
|
the name of the class used to create the transfer |
|||||
| caller_file | VARCHAR | 255 |
|
|
path to file to include where the class definition lives. (relative to dirroot) |
|||||
| caller_component | VARCHAR | 255 | √ | null |
|
|
the component name responsible for exporting |
|||
| caller_sha1 | VARCHAR | 255 |
|
|
sha1 of exported content as far as the caller is concerned (before the portfolio plugin gets a hold of it) |
|||||
| tempdataid | BIGINT | 19 | 0 |
|
|
old id from portfolio_tempdata. This is so that we can gracefully catch a race condition between an external system requesting a file and causing the tempdata to be deleted, before the user gets the "your transfer is requested" page |
||||
| returnurl | VARCHAR | 255 |
|
|
the original "returnurl" of the export - takes us to the moodle page we started from |
|||||
| continueurl | VARCHAR | 255 |
|
|
the url the external system has set to view the transfer |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| portlog_por_ix | Performance | Asc | portfolio |
| portlog_tem_ix | Performance | Asc | tempdataid |
| portlog_use_ix | Performance | Asc | userid |