wp_b2s_posts_insights
StaticStores b2s posts insights data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| blog_user_id | int(11) | NO |
| b2s_posts_id | int(11) | NO |
| network_post_id | varchar(50) | NO |
| b2s_posts_network_details_id | int(11) | NO |
| insight | MEDIUMTEXT | NO |
| last_update | DATETIME | NO |
| active | tinyint(4) | NO |
CREATE TABLE Statement
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
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_insights`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Blog2Social: Social Media Auto Post & Scheduler