{"table_name":"b2s_posts_insights","full_table_name":"wp_b2s_posts_insights","description":"Stores b2s posts insights data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts_insights` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_id` int(11) NOT NULL, `b2s_posts_id` int(11) NOT NULL, `network_post_id` varchar(50) NOT NULL, `b2s_posts_network_details_id` int(11) NOT NULL, `insight` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_update` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(4) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `b2s_posts_id` (`b2s_posts_id`) ) DEFAULT CHARSET","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"b2s_posts_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"network_post_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"b2s_posts_network_details_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"insight","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"last_update","type":"DATETIME","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(4)","nullable":false,"primary_key":false}],"plugin":{"slug":"blog2social","name":"Blog2Social: Social Media Auto Post & Scheduler","active_installs":50000,"version":"9.0.0","wp_org_url":"https://wordpress.org/plugins/blog2social/"}}