Jump to content

Extension:Echo/echo_event table

From mediawiki.org

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