{"table_name":"bwf_contact","full_table_name":"wp_bwf_contact","description":"Stores bwf contact data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_bwf_contact` ( `id` int(12) unsigned NOT NULL AUTO_INCREMENT, `wpid` int(12) NOT NULL, `uid` varchar(35) NOT NULL DEFAULT '', `email` varchar(100) NOT NULL, `f_name` varchar(100), `l_name` varchar(100), `contact_no` varchar(20), `country` char(2), `state` varchar(100), `timezone` varchar(50) DEFAULT '', `type` varchar(20) DEFAULT 'lead', `source` varchar(100) DEFAULT '', `points` bigint(20) unsigned NOT NULL DEFAULT '0', `tags` longtext, `lists` longtext, `last_modified` DateTime NOT NULL, `creation_date` DateTime NOT NULL, `status` int(2) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `wpid` (`wpid`), KEY `uid` (`uid`), UNIQUE KEY (`email`) )$collate;\"; } public static function create_bwf_contact_meta() { global $wpdb; $collate = self::get_collation();","columns":[{"name":"id","type":"int(12) unsigned","nullable":false,"primary_key":true},{"name":"wpid","type":"int(12)","nullable":false,"primary_key":false},{"name":"uid","type":"varchar(35)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"f_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"l_name","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"contact_no","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"country","type":"char(2)","nullable":true,"primary_key":false},{"name":"state","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"timezone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"source","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"points","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"tags","type":"longtext","nullable":true,"primary_key":false},{"name":"lists","type":"longtext","nullable":true,"primary_key":false},{"name":"last_modified","type":"DateTime","nullable":false,"primary_key":false},{"name":"creation_date","type":"DateTime","nullable":false,"primary_key":false},{"name":"status","type":"int(2)","nullable":false,"primary_key":false}],"plugin":{"slug":"wp-marketing-automations","name":"FunnelKit Automations – Email Marketing Automation and CRM for WordPress & WooCommerce","active_installs":20000,"version":"3.8.0","wp_org_url":"https://wordpress.org/plugins/wp-marketing-automations/"}}