wp_b2s_user_contact
StaticStores b2s user contact data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(5) | NO |
| blog_user_id | int(11) | NO |
| name_mandant | varchar(100) | NO |
| created | datetime | NO |
| name_presse | varchar(100) | NO |
| anrede_presse | enum('0','1','2') | NO |
| vorname_presse | varchar(50) | NO |
| nachname_presse | varchar(50) | NO |
| strasse_presse | varchar(100) | NO |
| nummer_presse | varchar(5) | NO |
| plz_presse | varchar(10) | NO |
| ort_presse | varchar(75) | NO |
| land_presse | varchar(3) | NO |
| email_presse | varchar(75) | NO |
| telefon_presse | varchar(30) | NO |
| fax_presse | varchar(30) | NO |
| url_presse | varchar(150) | NO |
CREATE TABLE Statement
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);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_user_contact`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Blog2Social: Social Media Auto Post & Scheduler