{"slug":"media-activity-tracker","name":"Media Activity Tracker","description":"A plugin that adds CPD functionality with a video/podcast/reading tracker for WordPress.","author":"ActivityPress","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/media-activity-tracker/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"gp_activity","full_table_name":"wp_gp_activity","description":"Stores gp activity data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(10) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"alc_id","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"activity_time","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_gp_activity ( id int(10) unsigned NOT NULL AUTO_INCREMENT, user_id int(10) unsigned NOT NULL, alc_id int(10) unsigned NOT NULL, activity_time timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (id), KEY user_id (user_id) )\"; // Include WordPress database upgrade script require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"gp_tracking_points","full_table_name":"wp_gp_tracking_points","description":"Stores gp tracking points data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":"CREATE TABLE wp_gp_tracking_points ( id int(10) unsigned NOT NULL AUTO_INCREMENT, user_id int(10) unsigned NOT NULL, post_id int(10) unsigned DEFAULT NULL, course_id int(10) unsigned DEFAULT NULL, lesson_id int(10) unsigned DEFAULT NULL, topic_id int(10) unsigned DEFAULT NULL, activity_type enum('reading','watching','listening','completion','writing','login') COLLATE"}],"table_count":2}