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.

Primary key.

E.g. "edit-thank".

Unused, always null

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.

IP address of the user who triggered the event.

page.page_namespace of page affected by the event.

page.page_title of page affected by the event.

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

page.page_id of page affected by the event.

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.

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

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

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

• Wikimedia extension database tables
• Echo