Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

activity_notifications

Please, help. Where can I find this migration ? There is no activity_notifications table in database shema.

Table "activity_notifications" doesn't exist on database when dumping meta-data for Phosphorum\Models\ActivityNotifications



84.5k
Accepted
answer

This is the table:

CREATE TABLE `activity_notifications` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `users_id` int(10) unsigned NOT NULL,
  `posts_id` int(10) unsigned NOT NULL,
  `posts_replies_id` int(10) unsigned DEFAULT NULL,
  `type` char(1) COLLATE utf8_unicode_ci NOT NULL,
  `users_origin_id` int(10) unsigned DEFAULT NULL,
  `created_at` int(18) unsigned DEFAULT NULL,
  `was_read` char(1) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `users_id` (`users_id`,`was_read`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I forgot to add it to schemas/forum.sql