{"table_name":"gp_activity","full_table_name":"wp_gp_activity","description":"Stores gp activity data created by this plugin.","detection_method":"static","confidence":"medium","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');","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}],"plugin":{"slug":"media-activity-tracker","name":"Media Activity Tracker","active_installs":0,"version":"1.0.2","wp_org_url":"https://wordpress.org/plugins/media-activity-tracker/"}}