Events Queue Table Schema (events_queue)


Description

This table is for storing queued events. It stores only one copy of the eventdata here, and entries from this table are being references by the event_queue_handlers table.

events_queue table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
events_queue_handlers.queuedeventid evenqueuhand_que2_fk R
eventdata LONGTEXT 2147483647 null

serialized version of the data object passed to the event handler.
stackdump LONGTEXT 2147483647 √ null

serialized debug_backtrace showing where the event was fired from
userid BIGINT 19 √ null
user.id evenqueu_use2_fk R

$USER->id when the event was fired
timecreated BIGINT 19 null

time stamp of the first time this was added

Table contained -1 rows

events_queue table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
evenqueu_use_ix Performance Asc userid

events_queue table relationships

Close relationships within degrees of separation