{"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","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');","columns":[{"name":"id","type":"BIGINT(20)","nullable":false,"primary_key":true},{"name":"provider","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"model","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"input_cost","type":"DECIMAL(10,6)","nullable":false,"primary_key":false},{"name":"output_cost","type":"DECIMAL(10,6)","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"execution_id","type":"BIGINT(20)","nullable":false,"primary_key":false},{"name":"node_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"model","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"provider","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"prompt_tokens","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"completion_tokens","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"cost","type":"DECIMAL(10,6)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"workflow_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"workflow_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"input_data","type":"longtext","nullable":true,"primary_key":false},{"name":"output_data","type":"longtext","nullable":true,"primary_key":false},{"name":"current_node","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"total_cost","type":"DECIMAL(10,6)","nullable":true,"primary_key":false},{"name":"cost_details","type":"JSON","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"scheduled_at","type":"datetime","nullable":true,"primary_key":false},{"name":"session_id","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"role","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"node_context","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"workflow_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"workflow_context","type":"longtext","nullable":true,"primary_key":false},{"name":"selected_node","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"mode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"is_default","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"store_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"filename","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"mime_type","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"size","type":"BIGINT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"local_path","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"result","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"license_key_fragment","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"site_hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"http_filter_status","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"details","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"data","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"created_by","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"config","type":"longtext","nullable":false,"primary_key":false},{"name":"discovered_tools","type":"longtext","nullable":true,"primary_key":false},{"name":"is_active","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"ai-workflow-automation-lite","name":"AI Workflow Automation","active_installs":100,"version":"1.4.2","wp_org_url":"https://wordpress.org/plugins/ai-workflow-automation-lite/"}}