{"table_name":"fmwp_reports","full_table_name":"wp_fmwp_reports","description":"Stores fmwp reports data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fmwp_reports ( id int(11) NOT NULL auto_increment, post_id int(11) NOT NULL, user_id int(11) NOT NULL, creation_date varchar(25) NULL, PRIMARY KEY (id) ) $charset_collate; CREATE TABLE wp_fmwp_topic_views ( id int(11) NOT NULL auto_increment, auth_id varchar(32) NOT NULL, post_id int(11) NOT NULL, KEY auth_id_post_id (auth_id, post_id), KEY auth_id (auth_id), KEY post_id (post_id), PRIMARY KEY (id) ) $charset_collate; \"; dbDelta( $tables );","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"creation_date","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"auth_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false}],"plugin":{"slug":"forumwp","name":"ForumWP – Forum & Discussion Board","active_installs":800,"version":"2.1.9","wp_org_url":"https://wordpress.org/plugins/forumwp/"}}