{"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","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);","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}],"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/"}}