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.
Fields edit
event_id edit
Primary key.
event_type edit
E.g. "edit-thank".
event_variant edit
Unused, always null
event_agent_id edit
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_ip edit
IP address of the user who triggered the event.
event_page_namespace edit
page.page_namespace of page affected by the event.
event_page_title edit
page.page_title of page affected by the event.
event_extra edit
JSON blob concerning event (e.g. revision.rev_id and thanked user's user_id).
event_page_id edit
page.page_id of page affected by the event.
event_deleted edit
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 summary edit
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 | | +----------------------+------------------+------+-----+---------+----------------+