Extension:Echo/echo_event table
The echo_event table holds data concerning echo events.
For every notified user, there is a corresponding row in the echo_notification
table.
FieldsEdit
event_idEdit
Primary key.
event_typeEdit
E.g. "edit-thank".
event_variantEdit
Unused, always null
event_agent_idEdit
user.user_id of the user who triggered the event, if any.
If the agent is a logged-in user, event_agent_id
contains their user ID and event_agent_ip
is null.
If the agent is an anonymous user, event_agent_ip
contains their IP address and event_agent_id
is null.
If the event doesn't have an agent, both fields are null.
event_agent_ipEdit
IP address of the user who triggered the event.
event_page_namespaceEdit
page.page_namespace of page affected by the event.
event_page_titleEdit
page.page_title of page affected by the event.
event_extraEdit
JSON blob concerning event (e.g. revision.rev_id and thanked user's user_id).
event_page_idEdit
page.page_id of page affected by the event.
event_deletedEdit
Whether the event pertains to a deleted page and should be hidden. Events are marked as deleted when the related page is deleted, and unmarked as deleted when the related page is undeleted.
Schema summaryEdit
MediaWiki version: | ≥ 1.28 |
mysql> describe echo_event; +----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | event_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | event_type | varbinary(64) | NO | MUL | NULL | | | event_variant | varbinary(64) | YES | | NULL | | | event_agent_id | int(10) unsigned | YES | | NULL | | | event_agent_ip | varbinary(39) | YES | | NULL | | | event_page_namespace | int(10) unsigned | YES | | NULL | | | event_page_title | varbinary(255) | YES | | NULL | | | event_extra | blob | YES | | NULL | | | event_page_id | int(10) unsigned | YES | MUL | NULL | | | event_deleted | tinyint(3) unsigned | NO | | 0 | | +----------------------+---------------------+------+-----+---------+----------------+
MediaWiki versions: | 1.22 – 1.27 |
mysql> describe echo_event; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | event_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | event_type | varbinary(64) | NO | MUL | NULL | | | event_variant | varbinary(64) | YES | | NULL | | | event_agent_id | int(10) unsigned | YES | | NULL | | | event_agent_ip | varbinary(39) | YES | | NULL | | | event_page_namespace | int(10) unsigned | YES | | NULL | | | event_page_title | varbinary(255) | YES | | NULL | | | event_extra | blob | YES | | NULL | | | event_page_id | int(10) unsigned | YES | | NULL | | +----------------------+------------------+------+-----+---------+----------------+
MediaWiki versions: | 1.20 – 1.21 |
mysql> describe echo_event; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | event_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | event_timestamp | binary(14) | NO | | NULL | | | event_type | varbinary(64) | NO | MUL | NULL | | | event_variant | varbinary(64) | YES | | NULL | | | event_agent_id | int(10) unsigned | YES | | NULL | | | event_agent_ip | varbinary(255) | YES | | NULL | | | event_page_namespace | int(10) unsigned | YES | | NULL | | | event_page_title | varbinary(255) | YES | | NULL | | | event_extra | blob | YES | | NULL | | +----------------------+------------------+------+-----+---------+----------------+