{"slug":"axiachat-ai","name":"AxiaChat AI – Free AI Chatbot (Answers Customers Automatically)","description":"The best AI Chatbot for WordPress. Like having ChatGPT trained on your content — turn your site into a 24/7 sales & support machine.","author":"Esteban","active_installs":2000,"version":"4.1.10","wp_org_url":"https://wordpress.org/plugins/axiachat-ai/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aichat_appointment_slots","full_table_name":"wp_aichat_appointment_slots","description":"Stores aichat appointment slots data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_appointment_slots` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `day_of_week` tinyint NOT NULL,\\n  `start_time` time NOT NULL,\\n  `end_time` time NOT NULL,\\n  `slot_duration` int DEFAULT '30',\\n  `max_bookings` int DEFAULT '1',\\n  `is_active` tinyint(1) DEFAULT '1',\\n  `service` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `day_of_week` (`day_of_week`),\\n  KEY `is_active` (`is_active`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_appointments","full_table_name":"wp_aichat_appointments","description":"Stores aichat appointments data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_appointments` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `booking_code` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_email` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_phone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `service` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `staff` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `appointment_date` date NOT NULL,\\n  `start_time` time NOT NULL,\\n  `end_time` time NOT NULL,\\n  `timezone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'Europe/Madrid',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `notes` text COLLATE utf8mb4_unicode_520_ci,\\n  `source` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'chat',\\n  `bot_slug` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `session_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `external_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `external_source` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `reminder_sent` tinyint(1) DEFAULT '0',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `booking_code` (`booking_code`),\\n  KEY `appointment_date` (`appointment_date`),\\n  KEY `status` (`status`),\\n  KEY `customer_email` (`customer_email`),\\n  KEY `external_id` (`external_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_bots","full_table_name":"wp_aichat_bots","description":"Stores aichat bots data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_bots` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `slug` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `type` enum('text','voice_text') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'text',\\n  `instructions` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `provider` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'openai',\\n  `model` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'gpt-4o',\\n  `temperature` decimal(3,2) NOT NULL DEFAULT '0.70',\\n  `max_tokens` int NOT NULL DEFAULT '2048',\\n  `reasoning` enum('off','fast','accurate') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'off',\\n  `verbosity` enum('low','medium','high') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'medium',\\n  `context_mode` enum('embeddings','page','none') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'embeddings',\\n  `context_id` bigint unsigned DEFAULT NULL,\\n  `input_max_length` int NOT NULL DEFAULT '512',\\n  `max_messages` int NOT NULL DEFAULT '20',\\n  `context_max_length` int NOT NULL DEFAULT '6000',\\n  `context_limit` int NOT NULL DEFAULT '5',\\n  `history_persistence` tinyint(1) NOT NULL DEFAULT '1',\\n  `tools_json` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `ui_color` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '#1a73e8',\\n  `ui_position` enum('br','bl','tr','tl') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'br',\\n  `ui_avatar_enabled` tinyint(1) NOT NULL DEFAULT '0',\\n  `ui_avatar_key` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ui_icon_url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ui_start_sentence` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ui_role` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'AI Agent Specialist',\\n  `ui_placeholder` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Write your question...',\\n  `ui_button_send` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Send',\\n  `ui_width` int NOT NULL DEFAULT '380',\\n  `ui_height` int NOT NULL DEFAULT '380',\\n  `ui_closable` tinyint(1) NOT NULL DEFAULT '1',\\n  `ui_minimizable` tinyint(1) NOT NULL DEFAULT '1',\\n  `ui_draggable` tinyint(1) NOT NULL DEFAULT '1',\\n  `ui_minimized_default` tinyint(1) NOT NULL DEFAULT '0',\\n  `ui_superminimized_default` tinyint(1) NOT NULL DEFAULT '0',\\n  `ui_avatar_bubble` tinyint(1) NOT NULL DEFAULT '1',\\n  `ui_css_force` tinyint(1) NOT NULL DEFAULT '0',\\n  `is_active` tinyint(1) NOT NULL DEFAULT '1',\\n  `created_at` datetime NOT NULL,\\n  `updated_at` datetime NOT NULL,\\n  `ui_suggestions_enabled` tinyint(1) NOT NULL DEFAULT '0',\\n  `ui_suggestions_count` int NOT NULL DEFAULT '3',\\n  `ui_suggestions_bg` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '#f1f3f4',\\n  `ui_suggestions_text` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '#1a73e8',\\n  `wa_enabled` tinyint(1) NOT NULL DEFAULT '0',\\n  `wa_phone` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `wa_message` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `wa_tooltip` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `wa_schedule` text COLLATE utf8mb4_unicode_520_ci,\\n  `wa_outside_mode` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'none',\\n  `wa_outside_label` varchar(120) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `wa_trigger_mode` enum('always','time','messages') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'always',\\n  `wa_trigger_value` int NOT NULL DEFAULT '0',\\n  `wa_icon_color` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '#25D366',\\n  `wa_icon_bg` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '#ffffff',\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `slug` (`slug`),\\n  KEY `provider` (`provider`),\\n  KEY `context_id` (`context_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_bots_meta","full_table_name":"wp_aichat_bots_meta","description":"Stores additional metadata (key-value pairs) for aichat bots records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_chunks","full_table_name":"wp_aichat_chunks","description":"Stores aichat chunks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_chunks` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `id_context` bigint unsigned DEFAULT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `chunk_index` int NOT NULL DEFAULT '0',\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `title` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `content` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `embedding` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `tokens` int DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` timestamp NULL DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `uniq_post_ctx_chunk` (`post_id`,`id_context`,`chunk_index`),\\n  KEY `idx_context` (`id_context`),\\n  KEY `idx_post_context` (`post_id`,`id_context`),\\n  CONSTRAINT `wp_aichat_chunks_ibfk_1` FOREIGN KEY (`id_context`) REFERENCES `wp_aichat_contexts` (`id`) ON DELETE SET NULL\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_contexts","full_table_name":"wp_aichat_contexts","description":"Stores aichat contexts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_contexts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `context_type` enum('local','remoto') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'local',\\n  `remote_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\\n  `remote_api_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `remote_endpoint` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `embedding_provider` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `processing_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `processing_progress` int DEFAULT '0',\\n  `items_to_process` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `autosync` tinyint(1) NOT NULL DEFAULT '0',\\n  `autosync_mode` enum('updates','updates_and_new') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'updates',\\n  `autosync_post_types` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `autosync_last_scan` datetime DEFAULT NULL,\\n  `indexing_options` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_conversations","full_table_name":"wp_aichat_conversations","description":"Stores aichat conversations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_conversations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned DEFAULT '0',\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `bot_slug` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `model` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `provider` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `page_id` bigint unsigned DEFAULT '0',\\n  `ip_address` varbinary(16) DEFAULT NULL,\\n  `message` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `response` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `prompt_tokens` int unsigned DEFAULT NULL,\\n  `completion_tokens` int unsigned DEFAULT NULL,\\n  `total_tokens` int unsigned DEFAULT NULL,\\n  `cost_micros` bigint DEFAULT NULL,\\n  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `idx_session_bot` (`session_id`,`bot_slug`,`id`),\\n  KEY `idx_user` (`user_id`),\\n  KEY `idx_page` (`page_id`),\\n  KEY `idx_model` (`model`),\\n  KEY `idx_created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_custom_webhooks","full_table_name":"wp_aichat_custom_webhooks","description":"Stores aichat custom webhooks data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_gdpr_contacts","full_table_name":"wp_aichat_gdpr_contacts","description":"Stores aichat gdpr contacts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_gdpr_contacts` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `email` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `nombre` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `telefono` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `bot_slug` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `email` (`email`),\\n  KEY `bot_slug` (`bot_slug`),\\n  KEY `created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_lead_lists","full_table_name":"wp_aichat_lead_lists","description":"Stores aichat lead lists data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_leads","full_table_name":"wp_aichat_leads","description":"Stores aichat leads data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_livechat_messages","full_table_name":"wp_aichat_livechat_messages","description":"Stores aichat livechat messages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_livechat_sessions","full_table_name":"wp_aichat_livechat_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aichat_macros","full_table_name":"wp_aichat_macros","description":"Stores aichat macros data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_macros` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci,\\n  `source` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'local',\\n  `source_ref` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `tools_json` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `enabled` tinyint(1) NOT NULL DEFAULT '1',\\n  `created_at` datetime NOT NULL,\\n  `updated_at` datetime NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `name` (`name`),\\n  KEY `source` (`source`),\\n  KEY `enabled` (`enabled`)\\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_tool_calls","full_table_name":"wp_aichat_tool_calls","description":"Stores aichat tool calls data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_tool_calls` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `request_uuid` char(36) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `conversation_id` bigint unsigned DEFAULT NULL,\\n  `session_id` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `bot_slug` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `round` smallint unsigned NOT NULL DEFAULT '1',\\n  `call_id` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `tool_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `arguments_json` mediumtext COLLATE utf8mb4_unicode_520_ci,\\n  `output_excerpt` mediumtext COLLATE utf8mb4_unicode_520_ci,\\n  `duration_ms` int unsigned DEFAULT NULL,\\n  `error_code` varchar(64) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` datetime NOT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `bot_slug` (`bot_slug`),\\n  KEY `conversation_id` (`conversation_id`),\\n  KEY `request_uuid` (`request_uuid`),\\n  KEY `call_id` (`call_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_tool_states","full_table_name":"wp_aichat_tool_states","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_tool_states` (\\n  `response_id` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `state_data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`response_id`),\\n  KEY `idx_created` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_tools","full_table_name":"wp_aichat_tools","description":"Stores aichat tools data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_tools` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `type` enum('local','mcp','external') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'local',\\n  `source_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `label` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `description` text COLLATE utf8mb4_unicode_520_ci,\\n  `definition_json` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `enabled` tinyint(1) NOT NULL DEFAULT '1',\\n  `created_at` datetime NOT NULL,\\n  `updated_at` datetime NOT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `unique_tool` (`type`,`source_id`,`name`),\\n  KEY `type` (`type`),\\n  KEY `source_id` (`source_id`),\\n  KEY `enabled` (`enabled`),\\n  KEY `name` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"aichat_usage_daily","full_table_name":"wp_aichat_usage_daily","description":"Stores aichat usage daily data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_aichat_usage_daily` (\\n  `date` date NOT NULL,\\n  `provider` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'openai',\\n  `model` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `prompt_tokens` bigint unsigned NOT NULL DEFAULT '0',\\n  `completion_tokens` bigint unsigned NOT NULL DEFAULT '0',\\n  `total_tokens` bigint unsigned NOT NULL DEFAULT '0',\\n  `cost_micros` bigint unsigned NOT NULL DEFAULT '0',\\n  `conversations` bigint unsigned NOT NULL DEFAULT '0',\\n  PRIMARY KEY (`date`,`provider`,`model`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":18}