Extension:Echo/echo_event table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎dansk • ‎日本語

The echo_event table holds data concerning echo events.

Fields[edit]

event_id[edit]

Primary key.

event_type[edit]

E.g. "edit-thank".

event_variant[edit]

?

event_agent_id[edit]

user.user_id of the user who triggered the event.

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]

Serialized data 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.

Schema summary[edit]

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    |                |
+----------------------+------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)