{"slug":"bluebot-ai-powered-chatbot","name":"BlueBot – AI Powered Chatbot","description":"BlueBot is an AI chatbot plugin for WordPress that uses OpenAI API to improve user interaction on your site.","author":"Salil Agarwal","active_installs":10,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/bluebot-ai-powered-chatbot/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bccbai_chatbot_api_logs","full_table_name":"wp_bccbai_chatbot_api_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bccbai_chatbot_api_logs` (\\n  `id` mediumint NOT NULL AUTO_INCREMENT,\\n  `function_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `request` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `response` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `response_text` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `tokens_used` int NOT NULL,\\n  `model` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `temperature` float NOT NULL,\\n  `n` int NOT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bccbai_chatbot_conversations","full_table_name":"wp_bccbai_chatbot_conversations","description":"Stores bccbai chatbot conversations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bccbai_chatbot_conversations` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `conversation_id` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `user_id` bigint unsigned DEFAULT NULL,\\n  `user_email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `user_data` text COLLATE utf8mb4_unicode_520_ci,\\n  `conversation` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `conversation_summary` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime NOT NULL,\\n  `updated_at` datetime NOT NULL,\\n  `last_email_sent` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `conversation_id` (`conversation_id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `user_email` (`user_email`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}