Extension:Echo/echo event table/fr

La table echo_event contient les données concernant les événements echo.

Pour chaque utilisateur notifié, il existe une rangée correspondante dans la table.

event_id
Clé primaire.

event_type
Par exemple «  edit-thank  ».

event_variant
Non utilisé, toujours nul.

event_agent_id
de l'utilisateur qui a déclenché l'événement, s'il y en a un. Si l'utilisateur connecté est un agent,  contient l'ID de l'utilisateur et   est nul. Si l'agent est un utilisateur anonyme,  contient son adresse IP et   est nul. If the event doesn't have an agent, both fields are null.

event_agent_ip
IP address of the user who triggered the event.

event_page_namespace
of page affected by the event.

event_page_title
of page affected by the event.

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

event_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.

Résumé du schéma
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    |                |