wp_ai_workflows_cost_settings

Column Definitions

CREATE TABLE Statement

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');

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_ai_workflows_cost_settings`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from AI Workflow Automation