Extension:Echo/echo_notification table

A notification is a user being notified about a certain event. Multiple users can be notified about the same event.

Fields

notification_event

Key to echo_event.event_id

notification_user

Key to user.user_id

notification_timestamp

Timestamp when the notification was created

notification_read_timestamp

Timestamp when the user read the notification, or null if unread

notification_bundle_hash

Hash for bundling together similar notifications. Notifications that can be bundled together will have the same hash

Schema summary

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.33

<translate> MediaWiki version:</translate>

mysql> describe echo_notification;
+----------------------------------+------------------+------+-----+---------+-------+
| Field                            | Type             | Null | Key | Default | Extra |
+----------------------------------+------------------+------+-----+---------+-------+
| notification_event               | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_user                | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_timestamp           | binary(14)       | NO   |     | NULL    |       |
| notification_read_timestamp      | binary(14)       | YES  |     | NULL    |       |
| notification_bundle_hash         | varbinary(32)    | NO   |     | NULL    |       |
+----------------------------------+------------------+------+-----+---------+-------+

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">

1.22 – 1.32

<translate> MediaWiki versions:</translate>

mysql> describe echo_notification;
+----------------------------------+------------------+------+-----+---------+-------+
| Field                            | Type             | Null | Key | Default | Extra |
+----------------------------------+------------------+------+-----+---------+-------+
| notification_event               | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_user                | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_timestamp           | binary(14)       | NO   |     | NULL    |       |
| notification_read_timestamp      | binary(14)       | YES  |     | NULL    |       |
| notification_bundle_base         | tinyint(1)       | NO   |     | 1       |       |
| notification_bundle_hash         | varbinary(32)    | NO   |     | NULL    |       |
| notification_bundle_display_hash | varbinary(32)    | NO   |     | NULL    |       |
+----------------------------------+------------------+------+-----+---------+-------+

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.21</tvar> is unsupported version</translate>">

1.20 – 1.21

<translate> MediaWiki versions:</translate>

mysql> describe echo_notification;
+-----------------------------+------------------+------+-----+---------+-------+
| Field                       | Type             | Null | Key | Default | Extra |
+-----------------------------+------------------+------+-----+---------+-------+
| notification_event          | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_user           | int(10) unsigned | NO   | PRI | NULL    |       |
| notification_timestamp      | binary(14)       | NO   |     | NULL    |       |
| notification_read_timestamp | binary(14)       | YES  |     | NULL    |       |
+-----------------------------+------------------+------+-----+---------+-------+