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.
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 | |
+----------------------+------------------+------+-----+---------+----------------+
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|