DROP TABLE IF EXISTS `{#}activity`;
CREATE TABLE `{#}activity` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type_id` int(11) unsigned DEFAULT NULL,
`user_id` int(11) unsigned DEFAULT NULL,
`group_id` int(11) unsigned DEFAULT NULL,
`subject_title` varchar(140) DEFAULT NULL,
`subject_id` int(11) unsigned DEFAULT NULL,
`subject_url` varchar(250) DEFAULT NULL,
`reply_url` varchar(250) DEFAULT NULL,
`images` text,
`images_count` int(11) unsigned DEFAULT NULL,
`date_pub` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
`is_parent_hidden` tinyint(1) unsigned DEFAULT NULL,
`is_pub` tinyint(1) unsigned DEFAULT '1',
PRIMARY KEY (`id`),
KEY `type_id` (`type_id`),
KEY `user_id` (`user_id`),
KEY `date_pub` (`date_pub`),
KEY `is_private` (`is_private`),
KEY `group_id` (`group_id`),
KEY `is_parent_hidden` (`is_parent_hidden`),
KEY `is_pub` (`is_pub`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Activity feed';
DROP TABLE IF EXISTS `{#}activity_types`;
CREATE TABLE `{#}activity_types` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`is_enabled` tinyint(1) unsigned DEFAULT '1',
`controller` varchar(32) NOT NULL,
`name` varchar(32) NOT NULL,
`title` varchar(100) NOT NULL,
`description` varchar(200) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `is_enabled` (`is_enabled`),
KEY `controller` (`controller`),
KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Activity feed types';
INSERT INTO `{#}activity_types` (`id`, `is_enabled`, `controller`, `name`, `title`, `description`) VALUES
(1, 1, 'content', 'add.pages', 'Adding pages', 'added the page %s'),
(7, 1, 'users', 'friendship', 'Friendship', 'and %s became friends'),
(8, 1, 'users', 'signup', 'New users', 'registered. Welcome!'),
(12, 1, 'users', 'status', 'Status changing', '→ %s'),
(19, 1, 'users', 'avatar', 'Avatar changing', 'changed avatar');
INSERT INTO `{#}controllers` (`title`, `name`, `is_enabled`, `options`, `author`, `url`, `version`, `is_backend`) VALUES
('Activity Feed', 'activity', 1, '---\ntypes:\n - 10\n - 11\n - 17\n - 16\n - 14\n - 13\n - 18\n - 7\n - 19\n - 12\n - 8\n', 'InstantCMS Team', 'https://instantcms.ru', '2.0', 1);
INSERT INTO `{#}events` (`event`, `listener`, `ordering`, `is_enabled`) VALUES
('content_after_add_approve', 'activity', 1, 1),
('content_after_update_approve', 'activity', 2, 1),
('publish_delayed_content', 'activity', 3, 1),
('user_delete', 'activity', 4, 1),
('user_tab_info', 'activity', 5, 1),
('user_tab_show', 'activity', 6, 1),
('subscribe', 'activity', 125, 1),
('unsubscribe', 'activity', 126, 1),
('admin_dashboard_block', 'activity', 168, 1),
('admin_inline_save_subscriptions', 'activity', 175, 1),
('user_add_status_after', 'activity', 181, 1),
('users_add_friendship_mutual', 'activity', 188, 1),
('user_registered', 'activity', 189, 1),
('users_after_update', 'activity', 193, 1),
('ctype_labels_after_update', 'activity', 195, 1),
('ctype_after_delete', 'activity', 196, 1),
('comments_rate_after', 'activity', 197, 1),
('content_albums_after_delete', 'activity', 198, 1),
('content_photos_after_add', 'activity', 199, 1),
('comments_after_delete_list', 'activity', 200, 1),
('content_after_delete', 'activity', 201, 1),
('content_after_restore', 'activity', 205, 1),
('content_after_trash_put', 'activity', 206, 1),
('content_groups_after_delete', 'activity', 209, 1),
('group_after_join', 'activity', 210, 1),
('group_after_leave', 'activity', 211, 1),
('groups_after_accept_request', 'activity', 212, 1),
('groups_after_update', 'activity', 213, 1),
('languages_forms', 'activity', 227, 1);
INSERT INTO `{#}menu_items` (`menu_id`, `parent_id`, `title`, `url`, `ordering`, `options`, `groups_view`, `groups_hide`) VALUES
(1, 0, 'Activity', 'activity', 7, '---\nclass:', '---\n- 0\n', NULL);
INSERT INTO `{#}perms_rules` (`controller`, `name`, `type`, `options`) VALUES
('activity', 'delete', 'flag', NULL);
INSERT INTO `{#}users_tabs` (`title`, `controller`, `name`, `is_active`, `ordering`) VALUES
('Feed', 'activity', 'activity', 1, 1);
INSERT INTO `{#}widgets` (`controller`, `name`, `title`, `author`, `url`, `version`, `is_external`) VALUES
('activity', 'list', 'Activity feed', 'InstantCMS Team', 'https://instantcms.ru', '2.0', NULL);