Erweiterung:Echo/echo_notification-Tabelle
Appearance
A notification is a user being notified about a certain event. Multiple users can be notified about the same event.
Felder
notification_event
Schlüssel zu echo_event.event_id
notification_user
Schlüssel zu 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
Schematische Übersicht
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 Versions: | 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 Versions: | 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 | | +-----------------------------+------------------+------+-----+---------+-------+