{"slug":"activitytime","name":"WP Sessions Time Monitoring Full Automatic","description":"Plugin will accurately measure all activity time per page and user like working time, reading time, watching time, sessions time for specific user on  …","author":"activity-log.com","active_installs":500,"version":"1.1.5","wp_org_url":"https://wordpress.org/plugins/activitytime/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actt_report","full_table_name":"wp_actt_report","description":"Stores actt report data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actt_report` (\\n  `idreport` int NOT NULL AUTO_INCREMENT,\\n  `date` datetime DEFAULT NULL,\\n  `report_name` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `description` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  `report_email` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `scheduling_period` int DEFAULT NULL COMMENT 'days',\\n  `format` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `by_user` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `by_ip` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `request_uri` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `date_start` datetime DEFAULT NULL,\\n  `date_end` datetime DEFAULT NULL,\\n  `date_sent` datetime DEFAULT NULL,\\n  `other_data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  PRIMARY KEY (`idreport`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actt_user_sessions","full_table_name":"wp_actt_user_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actt_user_sessions` (\\n  `iduser_sessions` int NOT NULL AUTO_INCREMENT,\\n  `time_start` datetime DEFAULT NULL,\\n  `time_end` datetime DEFAULT NULL,\\n  `time_sec_total` int DEFAULT NULL,\\n  `user_id` int DEFAULT NULL,\\n  `user_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  `ip` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `is_visit_end` tinyint(1) DEFAULT NULL,\\n  `other_data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  PRIMARY KEY (`iduser_sessions`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actt_visited_pages","full_table_name":"wp_actt_visited_pages","description":"Stores actt visited pages data created by this plugin.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actt_visited_pages` (\\n  `idvisited_pages` int NOT NULL AUTO_INCREMENT,\\n  `request_uri` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  `title` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `time_start` datetime DEFAULT NULL,\\n  `time_end` datetime DEFAULT NULL,\\n  `time_sec_total` int DEFAULT NULL,\\n  `user_id` int DEFAULT NULL,\\n  `user_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  `ip` varchar(160) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,\\n  `is_visit_end` tinyint(1) DEFAULT NULL,\\n  `other_data` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,\\n  PRIMARY KEY (`idvisited_pages`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci COMMENT='Activity Time Plugin'"}],"table_count":3}