portfolio_tempdata

0 rows


Description

stores temporary data for portfolio exports. the id of this table is used for the itemid for the temporary files area. cron can clean up stale records (and associated file data) after expirytime.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
portfolio_log.tempdataid portlog_tem2_fkR
portfolio_mahara_queue.transferid portmahaqueu_tra2_fkR
data LONGTEXT 2147483647 null

dumping ground for portfolio callers to store their data in.

expirytime BIGINT 19 null

time this record will expire (used for cron cleanups) - the start of export + 24 hours

userid BIGINT 19 null
user.id porttemp_use2_fkR

psuedo fk to user. this is stored in the serialised data structure in the data field, but added here for ease of lookups.

instance BIGINT 19 0
portfolio_instance.id porttemp_ins2_fkR

which portfolio plugin instance is being used

queued BIT 1 0

Value 1 means the entry should be processed in cron.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
porttemp_ins_ix Performance Asc instance
porttemp_use_ix Performance Asc userid

Relationships