{"slug":"blog2social","name":"Blog2Social: Social Media Auto Post & Scheduler","description":"Automatically share and schedule your WordPress content on top social platforms like Facebook, Instagram, LinkedIn, TikTok, and more.","author":"Adenion","active_installs":50000,"version":"9.0.0","wp_org_url":"https://wordpress.org/plugins/blog2social/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"b2s_ai_template","full_table_name":"wp_b2s_ai_template","description":"Stores b2s ai template data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"network_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"type_id","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"payload","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_ai_template` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_id` int(11) NOT NULL, `network_id` int(11) NOT NULL, `type_id` tinyint(4) NOT NULL, `payload` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `network_id` (`network_id`), INDEX `type_id` (`type_id`) ) DEFAULT CHARSET"},{"table_name":"b2s_network_insights","full_table_name":"wp_b2s_network_insights","description":"Stores b2s network insights data created by this plugin.","detection_method":"static","confidence":"high","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_network_details_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"insight","type":"MEDIUMTEXT","nullable":false,"primary_key":false},{"name":"create_date","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_network_insights` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_id` int(11) NOT NULL, `b2s_posts_network_details_id` int(11) NOT NULL, `insight` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `create_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), INDEX `b2s_posts_network_details_id` (`b2s_posts_network_details_id`) ) DEFAULT CHARSET"},{"table_name":"b2s_post_sched_settings","full_table_name":"wp_b2s_post_sched_settings","description":"Stores b2s post sched settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"b2s_posts","full_table_name":"wp_b2s_posts","description":"Stores b2s posts data created by this plugin.","detection_method":"static","confidence":"high","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}],"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);"},{"table_name":"b2s_posts_drafts","full_table_name":"wp_b2s_posts_drafts","description":"Stores b2s posts drafts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"last_save_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"save_origin","type":"tinyint(4)","nullable":false,"primary_key":false},{"name":"data","type":"MEDIUMTEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts_drafts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `last_save_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `blog_user_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `save_origin` tinyint(4) NOT NULL DEFAULT 0, `data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `post_id` (`post_id`) ) DEFAULT CHARSET"},{"table_name":"b2s_posts_favorites","full_table_name":"wp_b2s_posts_favorites","description":"Stores b2s posts favorites data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"save_date","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts_favorites` ( `id` int(11) NOT NULL AUTO_INCREMENT, `blog_user_id` int(11) NOT NULL, `post_id` int(11) NOT NULL, `save_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `post_id` (`post_id`) ) DEFAULT CHARSET"},{"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","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}],"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"},{"table_name":"b2s_posts_network_details","full_table_name":"wp_b2s_posts_network_details","description":"Stores b2s posts network details data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"owner_blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"network_id","type":"TINYINT","nullable":false,"primary_key":false},{"name":"network_type","type":"TINYINT","nullable":false,"primary_key":false},{"name":"network_auth_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"network_display_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"data","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts_network_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `owner_blog_user_id` int(11) NOT NULL, `network_id` TINYINT NOT NULL, `network_type` TINYINT NOT NULL, `network_auth_id` int(11) NOT NULL, `network_display_name` varchar(100) NOT NULL, `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1 ;\"; //No User input in statement // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query($sqlCreateUserNetworkDetails);"},{"table_name":"b2s_posts_sched_details","full_table_name":"wp_b2s_posts_sched_details","description":"Stores b2s posts sched details data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"sched_data","type":"text","nullable":false,"primary_key":false},{"name":"image_url","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_posts_sched_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sched_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `image_url` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET"},{"table_name":"b2s_user","full_table_name":"wp_b2s_user","description":"Stores b2s user data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"token","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"feature","type":"TINYINT(2)","nullable":false,"primary_key":false},{"name":"state_url","type":"TINYINT(2)","nullable":false,"primary_key":false},{"name":"register_date","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `token` varchar(255) NOT NULL, `blog_user_id` int(11) NOT NULL, `feature` TINYINT(2) NOT NULL, `state_url` TINYINT(2) NOT NULL, `register_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), INDEX `blog_user_id` (`blog_user_id`), INDEX `token` (`token`), INDEX `feature` (`feature`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1;\"; //No User input in statement // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query($sqlCreateUser);"},{"table_name":"b2s_user_contact","full_table_name":"wp_b2s_user_contact","description":"Stores b2s user contact data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(5)","nullable":false,"primary_key":true},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"name_mandant","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":false,"primary_key":false},{"name":"name_presse","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"anrede_presse","type":"enum('0','1','2')","nullable":false,"primary_key":false},{"name":"vorname_presse","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"nachname_presse","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"strasse_presse","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"nummer_presse","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"plz_presse","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"ort_presse","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"land_presse","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"email_presse","type":"varchar(75)","nullable":false,"primary_key":false},{"name":"telefon_presse","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"fax_presse","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"url_presse","type":"varchar(150)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_user_contact`( `id` int(5) NOT NULL AUTO_INCREMENT , `blog_user_id` int(11) NOT NULL , `name_mandant` varchar(100) NOT NULL , `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `name_presse` varchar(100) NOT NULL , `anrede_presse` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0=Frau,1=Herr 2=keine Angabe', `vorname_presse` varchar(50) NOT NULL , `nachname_presse` varchar(50) NOT NULL , `strasse_presse` varchar(100) NOT NULL , `nummer_presse` varchar(5) NOT NULL DEFAULT '', `plz_presse` varchar(10) NOT NULL , `ort_presse` varchar(75) NOT NULL , `land_presse` varchar(3) NOT NULL DEFAULT 'DE', `email_presse` varchar(75) NOT NULL , `telefon_presse` varchar(30) NOT NULL , `fax_presse` varchar(30) NOT NULL , `url_presse` varchar(150) NOT NULL , PRIMARY KEY (`id`) , KEY `blog_user_id`(`blog_user_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1\"; //No User input in statement // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query($sqlCreateUserContact);"},{"table_name":"b2s_user_network_settings","full_table_name":"wp_b2s_user_network_settings","description":"Stores b2s user network settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"b2s_user_tool","full_table_name":"wp_b2s_user_tool","description":"Stores b2s user tool data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"create_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"blog_user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"tool_id","type":"TINYINT","nullable":false,"primary_key":false},{"name":"access_token","type":"varchar(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_b2s_user_tool` ( `id` int(11) NOT NULL AUTO_INCREMENT, `create_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `blog_user_id` int(11) NOT NULL, `tool_id` TINYINT NOT NULL DEFAULT '1', `access_token` varchar(255) NOT NULL, PRIMARY KEY (`id`), INDEX `access_token` (`access_token`), INDEX `blog_user_id` (`blog_user_id`), INDEX `tool_id` (`tool_id`) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1;\"; //No User input in statement // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared $wpdb->query($sqlCreateUserTool);"}],"table_count":13}