{"slug":"bit-integrations","name":"Bit integrations – Form Integration, Webhook, Spreadsheets, CRM, LMS & Email Automation","description":"Contact Form, Google Sheet, MailChimp, Brevo, Webhook, Zoho CRM Automation and Integration plugin that Connect 350+ platforms","author":"Bit Apps","active_installs":20000,"version":"2.9.0","wp_org_url":"https://wordpress.org/plugins/bit-integrations/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"affiliate_wp_affiliates","full_table_name":"wp_affiliate_wp_affiliates","description":"Stores affiliate wp affiliates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bp_groups","full_table_name":"wp_bp_groups","description":"Stores bp groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"bp_xprofile_fields","full_table_name":"wp_bp_xprofile_fields","description":"Stores bp xprofile fields data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"btcbi_auth","full_table_name":"wp_btcbi_auth","description":"Stores btcbi auth data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"btcbi_flow","full_table_name":"wp_btcbi_flow","description":"Stores btcbi flow data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"btcbi_log","full_table_name":"wp_btcbi_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"flow_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"job_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"api_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"response_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"response_obj","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"triggered_entity","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"triggered_entity_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"enabled","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"action_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tokenDetails","type":"longtext","nullable":true,"primary_key":false},{"name":"userInfo","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_btcbi_log` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `flow_id` bigint(20) DEFAULT NULL, `job_id` bigint(20) DEFAULT NULL, `api_type` varchar(255) DEFAULT NULL, `response_type` varchar(50) DEFAULT NULL, `response_obj` LONGTEXT DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `flow_id` (`flow_id`) ) {$collate};\", \"CREATE TABLE IF NOT EXISTS `wp_btcbi_flow` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `triggered_entity` varchar(50) NOT NULL, `triggered_entity_id` varchar(100) DEFAULT NULL, /* form_id = 0 means all/app */ `flow_details` longtext DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 enabled, 2 trashed */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) {$collate};\", \"CREATE TABLE IF NOT EXISTS `wp_btcbi_auth` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `action_name` varchar(255) DEFAULT NULL, `tokenDetails` longtext DEFAULT NULL, `userInfo` longtext DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) {$collate};\" ]; include_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($table_schema as $table) { dbDelta($table);"},{"table_name":"pro_quiz_statistic","full_table_name":"wp_pro_quiz_statistic","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"pro_quiz_statistic_ref","full_table_name":"wp_pro_quiz_statistic_ref","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":8}