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
editevent_id
editPrimary key.
event_type
editE.g. "edit-thank".
event_variant
editUnused, always null
event_agent_id
edituser.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
editIP address of the user who triggered the event.
event_page_namespace
editpage.page_namespace of page affected by the event.
event_page_title
editpage.page_title of page affected by the event.
event_extra
editJSON blob concerning event (e.g. revision.rev_id and thanked user's user_id).
event_page_id
editpage.page_id of page affected by the event.
event_deleted
editWhether 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
editMediaWiki 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 | | +----------------------+------------------+------+-----+---------+----------------+