{"table_name":"b2s_posts","full_table_name":"wp_b2s_posts","description":"Stores b2s posts data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `post_id` int(11) NOT NULL, `blog_user_id` int(11) NOT NULL, `last_edit_blog_user_id` int(11) NOT NULL, `user_timezone` TINYINT NOT NULL DEFAULT '0', `sched_details_id` INT NOT NULL, `sched_type` TINYINT NOT NULL DEFAULT '0', `sched_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `sched_date_utc` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_link` varchar(255) NOT NULL, `publish_error_code` varchar(100) NOT NULL, `network_details_id` int(11) NOT NULL, `post_format` TINYINT DEFAULT NULL, `display_post_format` varchar(10) NOT NULL DEFAULT 'wp', `post_for_relay` TINYINT NOT NULL DEFAULT '0', `post_for_approve` TINYINT NOT NULL DEFAULT '0', `relay_primary_post_id` int(11) NOT NULL DEFAULT '0', `relay_delay_min` int(11) NOT NULL DEFAULT '0', `upload_video_token` varchar(255) NOT NULL, `hook_action` TINYINT NOT NULL DEFAULT '0', `hide` TINYINT NOT NULL DEFAULT '0', `v2_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), INDEX `post_id` (`post_id`), INDEX `blog_user_id` (`blog_user_id`) , INDEX `sched_details_id` (`sched_details_id`), INDEX `sched_date` (`sched_date`), INDEX `sched_date_utc` (`sched_date_utc`), INDEX `publish_date` (`publish_date`) , INDEX `relay_primary_post_id` (`relay_primary_post_id`) , INDEX `hook_action` (`hook_action`), INDEX `hide` (`hide`), INDEX `post_format` (`post_format`), INDEX `upload_video_token` (`upload_video_token`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1 ;\"; //No User input in statement // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query($sqlCreateUserPosts);","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"last_edit_blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_timezone","type":"TINYINT","nullable":false,"primary_key":false},{"name":"sched_details_id","type":"INT","nullable":false,"primary_key":false},{"name":"sched_type","type":"TINYINT","nullable":false,"primary_key":false},{"name":"sched_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"sched_date_utc","type":"DATETIME","nullable":false,"primary_key":false},{"name":"publish_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"publish_link","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"publish_error_code","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"network_details_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_format","type":"TINYINT","nullable":true,"primary_key":false},{"name":"display_post_format","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"post_for_relay","type":"TINYINT","nullable":false,"primary_key":false},{"name":"post_for_approve","type":"TINYINT","nullable":false,"primary_key":false},{"name":"relay_primary_post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"relay_delay_min","type":"int(11)","nullable":false,"primary_key":false},{"name":"upload_video_token","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"hook_action","type":"TINYINT","nullable":false,"primary_key":false},{"name":"hide","type":"TINYINT","nullable":false,"primary_key":false},{"name":"v2_id","type":"int(11)","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/"}}