Extension:Echo/echo_event テーブル
The echo_event table holds data concerning echo events.
For every notified user, there is a corresponding row in the echo_notification
table.
フィールド
event_id
主キーです。
event_type
例: 「edit-thank」
event_variant
Unused, always null
event_agent_id
イベントを引き起こした利用者の user.user_id です (存在する場合)。
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 アドレスです。
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.
スキーマの概要
MediaWiki バージョン: | ≧ 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 バージョン: | 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 バージョン: | 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 | | +----------------------+------------------+------+-----+---------+----------------+