{"slug":"supportflow-chatbot-documentation-builder","name":"SupportFlow – Chatbot & Documentation Builder","description":"Build a modern customer support center on WordPress with a dual-mode AI/human Chatbot and a complete dynamic Gutenberg-based Knowledge Base.","author":"wpbranddigital","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/supportflow-chatbot-documentation-builder/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aivb_conversations","full_table_name":"wp_aivb_conversations","description":"Stores aivb conversations data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"user_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"user_email","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"mode","type":"ENUM('ai','human')","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('open','closed','pending')","nullable":false,"primary_key":false},{"name":"last_message","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"conversation_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"sender","type":"ENUM('user','ai','admin')","nullable":false,"primary_key":false},{"name":"message","type":"TEXT","nullable":false,"primary_key":false},{"name":"is_read","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_aivb_conversations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(64) NOT NULL, user_name VARCHAR(100) NOT NULL DEFAULT '', user_email VARCHAR(200) NOT NULL DEFAULT '', mode ENUM('ai','human') NOT NULL DEFAULT 'ai', status ENUM('open','closed','pending') NOT NULL DEFAULT 'open', last_message DATETIME NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY session_id (session_id), KEY user_email (user_email), KEY status (status) ) $charset;\"; // Messages table $sql_msg = \"CREATE TABLE IF NOT EXISTS wp_aivb_messages ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, conversation_id BIGINT UNSIGNED NOT NULL, sender ENUM('user','ai','admin') NOT NULL, message TEXT NOT NULL, is_read TINYINT(1) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY conversation_id (conversation_id), KEY is_read (is_read) ) $charset;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql_conv );"},{"table_name":"aivb_messages","full_table_name":"wp_aivb_messages","description":"Stores aivb messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":2}