{"slug":"wp-marketing-automations","name":"FunnelKit Automations – Email Marketing Automation and CRM for WordPress & WooCommerce","description":"Recover lost revenue with Cart Abandonment Recovery for WooCommerce. Increase retention with Post Purchase Follow-Up Emails.","author":"Aman","active_installs":20000,"version":"3.8.0","wp_org_url":"https://wordpress.org/plugins/wp-marketing-automations/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"bwf_action_claim","full_table_name":"wp_bwf_action_claim","description":"Stores bwf action claim data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"date","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_bwf_action_claim` ( id bigint(20) unsigned NOT NULL auto_increment, date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), KEY date (date) ) $collate;\"; } public static function create_bwf_wc_customers() { global $wpdb; $collate = self::get_collation();"},{"table_name":"bwf_actions","full_table_name":"wp_bwf_actions","description":"Stores bwf actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"c_date","type":"datetime","nullable":false,"primary_key":false},{"name":"e_time","type":"int(12)","nullable":false,"primary_key":false},{"name":"hook","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"args","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"int(1)","nullable":false,"primary_key":false},{"name":"recurring_interval","type":"int(10)","nullable":false,"primary_key":false},{"name":"group_slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"claim_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE `wp_bwf_actions` ( id bigint(20) unsigned NOT NULL auto_increment, c_date datetime NOT NULL default '0000-00-00 00:00:00', e_time int(12) NOT NULL default 0, hook varchar(255) not null, args longtext null, status int(1) not null default 0 COMMENT '0 - Pending | 1 - Running', recurring_interval int(10) not null default 0, group_slug varchar(255) not null default 'woofunnels', claim_id bigint(20) unsigned NOT NULL default 0, PRIMARY KEY (id), KEY id (id), KEY e_time (e_time), KEY hook (hook(191)), KEY status (status), KEY group_slug (group_slug(191)), KEY claim_id (claim_id) ) $collate;\"; } public static function create_bwf_action_claim() { global $wpdb; $collate = self::get_collation();"},{"table_name":"bwf_contact","full_table_name":"wp_bwf_contact","description":"Stores bwf contact data created by this plugin.","detection_method":"static","confidence":"high","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}],"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();"},{"table_name":"bwf_contact_fields","full_table_name":"wp_bwf_contact_fields","description":"Stores bwf contact fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwf_contact_meta","full_table_name":"wp_bwf_contact_meta","description":"Stores additional metadata (key-value pairs) for bwf contact records.","detection_method":"static","confidence":"medium","columns":[{"name":"meta_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"contact_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_bwf_contact_meta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `contact_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(50) DEFAULT NULL, `meta_value` longtext, PRIMARY KEY (`meta_id`) ) $collate;\"; } public static function create_bwf_actions() { global $wpdb; $collate = self::get_collation();"},{"table_name":"bwf_contact_wlm_fields","full_table_name":"wp_bwf_contact_wlm_fields","description":"Stores bwf contact wlm fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwf_funnels","full_table_name":"wp_bwf_funnels","description":"Stores bwf funnels data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwf_optin_entries","full_table_name":"wp_bwf_optin_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwf_options","full_table_name":"wp_bwf_options","description":"Stores bwf options data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwf_wc_customers","full_table_name":"wp_bwf_wc_customers","description":"Stores bwf wc customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_abandonedcarts","full_table_name":"wp_bwfan_abandonedcarts","description":"Stores bwfan abandonedcarts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automation_complete_contact","full_table_name":"wp_bwfan_automation_complete_contact","description":"Stores bwfan automation complete contact data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automation_contact","full_table_name":"wp_bwfan_automation_contact","description":"Stores bwfan automation contact data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automation_contact_claim","full_table_name":"wp_bwfan_automation_contact_claim","description":"Stores bwfan automation contact claim data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automation_contact_trail","full_table_name":"wp_bwfan_automation_contact_trail","description":"Stores bwfan automation contact trail data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automation_step","full_table_name":"wp_bwfan_automation_step","description":"Stores bwfan automation step data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automationmeta","full_table_name":"wp_bwfan_automationmeta","description":"Stores bwfan automationmeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_automations","full_table_name":"wp_bwfan_automations","description":"Stores bwfan automations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_contact_automations","full_table_name":"wp_bwfan_contact_automations","description":"Stores bwfan contact automations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_contact_note","full_table_name":"wp_bwfan_contact_note","description":"Stores bwfan contact note data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_conversions","full_table_name":"wp_bwfan_conversions","description":"Stores bwfan conversions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_engagement_tracking","full_table_name":"wp_bwfan_engagement_tracking","description":"Stores bwfan engagement tracking data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_engagement_trackingmeta","full_table_name":"wp_bwfan_engagement_trackingmeta","description":"Stores bwfan engagement trackingmeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_fields","full_table_name":"wp_bwfan_fields","description":"Stores bwfan fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_import_export","full_table_name":"wp_bwfan_import_export","description":"Stores bwfan import export data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_logmeta","full_table_name":"wp_bwfan_logmeta","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_logs","full_table_name":"wp_bwfan_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_message_unsubscribe","full_table_name":"wp_bwfan_message_unsubscribe","description":"Stores bwfan message unsubscribe data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_task_claim","full_table_name":"wp_bwfan_task_claim","description":"Stores bwfan task claim data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_taskmeta","full_table_name":"wp_bwfan_taskmeta","description":"Stores bwfan taskmeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_tasks","full_table_name":"wp_bwfan_tasks","description":"Stores bwfan tasks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_templates","full_table_name":"wp_bwfan_templates","description":"Stores bwfan templates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_terms","full_table_name":"wp_bwfan_terms","description":"Stores bwfan terms data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bwfan_wcs_subscriber","full_table_name":"wp_bwfan_wcs_subscriber","description":"Stores bwfan wcs subscriber data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders","full_table_name":"wp_wc_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wc_orders_meta","full_table_name":"wp_wc_orders_meta","description":"Stores additional metadata (key-value pairs) for wc orders records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wfacp_stats","full_table_name":"wp_wfacp_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wfco_report_views","full_table_name":"wp_wfco_report_views","description":"Stores wfco report views data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wfob_stats","full_table_name":"wp_wfob_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wfocu_event","full_table_name":"wp_wfocu_event","description":"Stores wfocu event data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"wfocu_session","full_table_name":"wp_wfocu_session","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":43}