{"slug":"ai-workflow-automation-lite","name":"AI Workflow Automation","description":"Build AI agents, chatbots, and content workflows in WordPress with a visual, no-code builder. Free with your own API key.","author":"massiveshift","active_installs":70,"version":"2.0.9","wp_org_url":"https://wordpress.org/plugins/ai-workflow-automation-lite/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"ai_workflows_","full_table_name":"wp_ai_workflows_","description":"Stores ai workflows  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_agent_audit","full_table_name":"wp_ai_workflows_agent_audit","description":"Stores ai workflows agent audit data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ai_workflows_assistant_messages","full_table_name":"wp_ai_workflows_assistant_messages","description":"Stores ai workflows assistant messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_assistant_sessions","full_table_name":"wp_ai_workflows_assistant_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_chat_memory","full_table_name":"wp_ai_workflows_chat_memory","description":"Stores ai workflows chat memory data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_chat_messages","full_table_name":"wp_ai_workflows_chat_messages","description":"Stores ai workflows chat messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_chat_sessions","full_table_name":"wp_ai_workflows_chat_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_cost_settings","full_table_name":"wp_ai_workflows_cost_settings","description":"Stores ai workflows cost settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_cost_settings ( id BIGINT(20) NOT NULL AUTO_INCREMENT, provider VARCHAR(50) NOT NULL, model VARCHAR(255) NOT NULL, input_cost DECIMAL(10,6) NOT NULL, output_cost DECIMAL(10,6) NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY provider_model (provider, model) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_node_costs' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_node_costs ( id BIGINT(20) NOT NULL AUTO_INCREMENT, execution_id BIGINT(20) NOT NULL, node_id VARCHAR(255) NOT NULL, model VARCHAR(255) NOT NULL, provider VARCHAR(50) NOT NULL, prompt_tokens INT UNSIGNED DEFAULT 0, completion_tokens INT UNSIGNED DEFAULT 0, cost DECIMAL(10,6) DEFAULT 0.00, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY execution_node (execution_id, node_id), KEY model_idx (model), KEY provider_idx (provider) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_executions' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_executions ( id mediumint(9) NOT NULL AUTO_INCREMENT, workflow_id varchar(255) NOT NULL, workflow_name varchar(255) NOT NULL, status varchar(20) NOT NULL, input_data longtext, output_data longtext, current_node varchar(255), error_message text, total_cost DECIMAL(10,6) DEFAULT 0.00, cost_details JSON DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, scheduled_at datetime, PRIMARY KEY (id) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_assistant_messages' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_assistant_messages ( message_id bigint(20) NOT NULL AUTO_INCREMENT, session_id varchar(36) NOT NULL, role varchar(20) NOT NULL, content longtext NOT NULL, node_context text DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (message_id), KEY session_id (session_id), KEY message_ordering (session_id, created_at) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_assistant_sessions' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_assistant_sessions ( session_id varchar(36) NOT NULL, workflow_id varchar(255) NOT NULL, workflow_context longtext, selected_node varchar(255) DEFAULT NULL, mode varchar(20) NOT NULL DEFAULT 'chat', created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (session_id), KEY workflow_id (workflow_id), KEY mode (mode) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_vector_stores' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_vector_stores ( id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, is_default TINYINT(1) DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_vector_files' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_vector_files ( id VARCHAR(255) NOT NULL, store_id VARCHAR(255) NOT NULL, filename VARCHAR(255) NOT NULL, mime_type VARCHAR(100), size BIGINT, status VARCHAR(20) DEFAULT 'pending', url TEXT, local_path TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY store_id (store_id) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_license_security' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_license_security ( id BIGINT(20) NOT NULL AUTO_INCREMENT, check_time DATETIME NOT NULL, check_type VARCHAR(50) NOT NULL, ip_address VARCHAR(100) NOT NULL, result VARCHAR(20) NOT NULL, license_key_fragment VARCHAR(32), site_hash VARCHAR(64) NOT NULL, http_filter_status TINYINT(1) DEFAULT 0, details TEXT, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY check_time (check_time), KEY result (result), KEY site_hash (site_hash) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_workflow_data' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_workflow_data ( id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'active', data LONGTEXT NOT NULL, created_by VARCHAR(255), created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY name (name), KEY status (status), KEY created_at (created_at), KEY updated_at (updated_at) ) {$wpdb->get_charset_collate()};\", 'wp_ai_workflows_mcp_servers' => \" CREATE TABLE IF NOT EXISTS wp_wp_ai_workflows_mcp_servers ( id mediumint(9) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, name varchar(255) NOT NULL, description text, config longtext NOT NULL, discovered_tools longtext, is_active boolean DEFAULT 1, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY name (name), KEY is_active (is_active), KEY created_at (created_at) ) {$wpdb->get_charset_collate()};\", ]; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');"},{"table_name":"ai_workflows_executions","full_table_name":"wp_ai_workflows_executions","description":"Stores ai workflows executions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_handoff_sessions","full_table_name":"wp_ai_workflows_handoff_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"ai_workflows_human_tasks","full_table_name":"wp_ai_workflows_human_tasks","description":"Stores ai workflows human tasks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_knowledge_bases","full_table_name":"wp_ai_workflows_knowledge_bases","description":"Stores ai workflows knowledge bases data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_license_security","full_table_name":"wp_ai_workflows_license_security","description":"Stores ai workflows license security data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_mcp_servers","full_table_name":"wp_ai_workflows_mcp_servers","description":"Stores ai workflows mcp servers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_node_costs","full_table_name":"wp_ai_workflows_node_costs","description":"Stores ai workflows node costs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_outputs","full_table_name":"wp_ai_workflows_outputs","description":"Stores ai workflows outputs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_sheet_states","full_table_name":"wp_ai_workflows_sheet_states","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_shortcode_outputs","full_table_name":"wp_ai_workflows_shortcode_outputs","description":"Stores ai workflows shortcode outputs data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_site_steps","full_table_name":"wp_ai_workflows_site_steps","description":"Stores ai workflows site steps data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_templates","full_table_name":"wp_ai_workflows_templates","description":"Stores ai workflows templates data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_vector_files","full_table_name":"wp_ai_workflows_vector_files","description":"Stores ai workflows vector files data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_vector_stores","full_table_name":"wp_ai_workflows_vector_stores","description":"Stores ai workflows vector stores data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ai_workflows_workflow_data","full_table_name":"wp_ai_workflows_workflow_data","description":"Stores ai workflows workflow data data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":23}