{"slug":"bit-assist","name":"Chat Widget: Floating Customer Support Button for 30+ Channels, Supporting SMS, Calls, and Chat – Bit Assist","description":"Floating sticky chat button for WhatsApp Chat, Facebook Messenger, Telegram, Instagram, SMS, Call, Discord chat, TikTok, Line & 30+ channels","author":"Bit Apps","active_installs":10000,"version":"1.8.1","wp_org_url":"https://wordpress.org/plugins/bit-assist/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bit_assist_analytics","full_table_name":"wp_bit_assist_analytics","description":"Stores analytics or statistics data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bit_assist_analytics` (\\n  `widget_id` bigint unsigned NOT NULL,\\n  `channel_id` bigint unsigned DEFAULT NULL,\\n  `is_clicked` tinyint NOT NULL DEFAULT '0',\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  KEY `widget_id` (`widget_id`),\\n  KEY `channel_id` (`channel_id`),\\n  CONSTRAINT `wp_bit_assist_analytics_ibfk_1` FOREIGN KEY (`widget_id`) REFERENCES `wp_bit_assist_widgets` (`id`) ON DELETE CASCADE,\\n  CONSTRAINT `wp_bit_assist_analytics_ibfk_2` FOREIGN KEY (`channel_id`) REFERENCES `wp_bit_assist_widget_channels` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bit_assist_responses","full_table_name":"wp_bit_assist_responses","description":"Stores bit assist responses data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bit_assist_responses` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `widget_channel_id` bigint unsigned NOT NULL,\\n  `response` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `widget_channel_id` (`widget_channel_id`),\\n  CONSTRAINT `wp_bit_assist_responses_ibfk_1` FOREIGN KEY (`widget_channel_id`) REFERENCES `wp_bit_assist_widget_channels` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bit_assist_widget_channels","full_table_name":"wp_bit_assist_widget_channels","description":"Stores bit assist widget channels data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bit_assist_widget_channels` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `widget_id` bigint unsigned NOT NULL,\\n  `channel_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `config` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `sequence` int DEFAULT NULL,\\n  `status` tinyint(1) NOT NULL DEFAULT '1',\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `widget_id` (`widget_id`),\\n  CONSTRAINT `wp_bit_assist_widget_channels_ibfk_1` FOREIGN KEY (`widget_id`) REFERENCES `wp_bit_assist_widgets` (`id`) ON DELETE CASCADE\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bit_assist_widgets","full_table_name":"wp_bit_assist_widgets","description":"Stores bit assist widgets data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bit_assist_widgets` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `styles` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `domains` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `business_hours` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `timezone` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `exclude_pages` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `initial_delay` int NOT NULL DEFAULT '0',\\n  `page_scroll` int NOT NULL DEFAULT '0',\\n  `widget_behavior` tinyint NOT NULL DEFAULT '1',\\n  `custom_css` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `call_to_action` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `store_responses` tinyint(1) NOT NULL DEFAULT '1',\\n  `delete_responses` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `integrations` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `status` tinyint(1) NOT NULL DEFAULT '1',\\n  `active` tinyint(1) NOT NULL DEFAULT '0',\\n  `hide_credit` tinyint(1) NOT NULL DEFAULT '0',\\n  `created_at` timestamp NULL DEFAULT NULL,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":4}