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.

notification_event
Key to

notification_user
Key to

notification_timestamp
Timestamp when the notification was created

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

notification_bundle_base
No longer used, should be removed (T143763)

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

notification_bundle_display_hash
No longer used, should be removed (T143763)

Schema summary
mysql> describe echo_notification; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+ 7 rows in set (0.00 sec)
 * 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    |       |