wp_b2s_posts
StaticStores b2s posts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| post_id | int(11) | NO |
| blog_user_id | int(11) | NO |
| last_edit_blog_user_id | int(11) | NO |
| user_timezone | TINYINT | NO |
| sched_details_id | INT | NO |
| sched_type | TINYINT | NO |
| sched_date | DATETIME | NO |
| sched_date_utc | DATETIME | NO |
| publish_date | DATETIME | NO |
| publish_link | varchar(255) | NO |
| publish_error_code | varchar(100) | NO |
| network_details_id | int(11) | NO |
| post_format | TINYINT | YES |
| display_post_format | varchar(10) | NO |
| post_for_relay | TINYINT | NO |
| post_for_approve | TINYINT | NO |
| relay_primary_post_id | int(11) | NO |
| relay_delay_min | int(11) | NO |
| upload_video_token | varchar(255) | NO |
| hook_action | TINYINT | NO |
| hide | TINYINT | NO |
| v2_id | int(11) | NO |
CREATE TABLE Statement
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);
Safe to delete?
If you have uninstalled Blog2Social: Social Media Auto Post & Scheduler, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_b2s_posts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Blog2Social: Social Media Auto Post & Scheduler