IP_notifs

gistfile1.txt

CREATE TABLE `phpbb_notifications` (
  notification_id INT NOT NULL AUTO_INCREMENT,
  notification_type INT NOT NULL,
  notification_user_id INT NOT NULL COMMENT 'user id receiving notification',
  notification_date DATE COMMENT 'when happened the notification',
  notification_data TEXT COMMENT 'JSON of the data (title of post, or whatever)',
  notification_trigger_user INT COMMENT '(May be) the user who triggered the notification',
  notification_read TINYINT COMMENT 'Was the notification read?'
);