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

event_id

Primary key.

event_type

E.g. "edit-thank".

event_variant

Unused, always null

event_agent_id

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

IP address of the user who triggered the event.

event_page_namespace

page.page_namespace of page affected by the event.

event_page_title

page.page_title of page affected by the event.

event_extra

JSON blob concerning event (e.g. revision.rev_id and thanked user's user_id).

event_page_id

page.page_id of page affected by the event.

event_deleted

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

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    |                |
+----------------------+------------------+------+-----+---------+----------------+