{"table_name":"apbd_wps_chatbot_history","full_table_name":"wp_apbd_wps_chatbot_history","description":"Stores apbd wps chatbot history data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_apbd_wps_chatbot_history` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` int NOT NULL DEFAULT '0',\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Session ID for grouping conversations',\\n  `guest_identifier` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL COMMENT 'Hashed guest identifier',\\n  `query` text COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'textarea',\\n  `docs_ids` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `is_stored_content` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y' COMMENT 'Whether AI response was stored',\\n  `feedback` char(1) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N' COMMENT 'drop(H=Happy,N=Neutral,U=Unhappy)',\\n  `conv_hash` char(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`id`),\\n  KEY `idx_session_id` (`session_id`),\\n  KEY `idx_user_id` (`user_id`),\\n  KEY `idx_guest_identifier` (`guest_identifier`),\\n  KEY `idx_created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"support-genix-lite","name":"Support Genix – Helpdesk, AI Chatbot, Knowledge Base & Customer Support Ticketing System","active_installs":1000,"version":"1.4.44","wp_org_url":"https://wordpress.org/plugins/support-genix-lite/"}}