Extension:Echo/echo notification table/da
Appearance
A notification is a user being notified about a certain event. Multiple users can be notified about the same event.
Felter
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
MediaWiki-version: | ≥ 1.33 |
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 | | +----------------------------------+------------------+------+-----+---------+-------+
MediaWiki-versioner: | 1.22 – 1.32 |
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 | | +----------------------------------+------------------+------+-----+---------+-------+
MediaWiki-versioner: | 1.20 – 1.21 |
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 | | +-----------------------------+------------------+------+-----+---------+-------+