UserSpice 4.3 Dev - Notifications SQL

CREATE TABLE IF NOT EXISTS `notifications` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `message` mediumtext NOT NULL,
  `is_read` tinyint(4) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_read` datetime NOT NULL,
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2;

INSERT INTO `notifications` (`id`, `user_id`, `message`, `is_read`, `date_created`, `date_read`, `last_updated`) VALUES
(1, 1, 'This is a test notification.', 0, '2017-09-01 12:42:14', '2017-09-01 12:46:50', '2017-09-02 17:16:22');