{"slug":"a1ai-chatbot","name":"A1AI Chatbot","description":"AI-powered chatbot solution for WordPress powered by OpenAI's language models.","author":"A1Ai Digital","active_installs":0,"version":"1.5.6","wp_org_url":"https://wordpress.org/plugins/a1ai-chatbot/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"a1ai_adjustments","full_table_name":"wp_a1ai_adjustments","description":"Stores a1ai adjustments data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"a1ai_chatbots","full_table_name":"wp_a1ai_chatbots","description":"Stores a1ai chatbots data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"a1ai_custom_instructions","full_table_name":"wp_a1ai_custom_instructions","description":"Stores a1ai custom instructions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"a1ai_system_prompts","full_table_name":"wp_a1ai_system_prompts","description":"Stores a1ai system prompts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"chatbot_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"prompt_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"prompt_content","type":"longtext","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"chatbot_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"instruction_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"instruction_content","type":"longtext","nullable":false,"primary_key":false},{"name":"instruction_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"chatbot_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"business_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"tagline","type":"text","nullable":true,"primary_key":false},{"name":"business_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"services","type":"longtext","nullable":true,"primary_key":false},{"name":"products","type":"longtext","nullable":true,"primary_key":false},{"name":"hours","type":"longtext","nullable":true,"primary_key":false},{"name":"address","type":"text","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"website","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"policies","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_a1ai_system_prompts ( id mediumint(9) NOT NULL AUTO_INCREMENT, chatbot_id mediumint(9) NOT NULL, prompt_name varchar(255) NOT NULL, prompt_content longtext NOT NULL, is_active tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY chatbot_id (chatbot_id) ) $charset_collate;\"; // Custom instructions table $sql[] = \"CREATE TABLE wp_a1ai_custom_instructions ( id mediumint(9) NOT NULL AUTO_INCREMENT, chatbot_id mediumint(9) NOT NULL, instruction_name varchar(255) NOT NULL, instruction_content longtext NOT NULL, instruction_type varchar(50) NOT NULL DEFAULT 'general', priority int(11) NOT NULL DEFAULT 0, is_active tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY chatbot_id (chatbot_id) ) $charset_collate;\"; // Business information table $sql[] = \"CREATE TABLE {$this->tables['business_info']} ( id mediumint(9) NOT NULL AUTO_INCREMENT, chatbot_id mediumint(9) NOT NULL, business_name varchar(255) DEFAULT NULL, tagline text DEFAULT NULL, business_type varchar(100) DEFAULT NULL, services longtext DEFAULT NULL, products longtext DEFAULT NULL, hours longtext DEFAULT NULL, address text DEFAULT NULL, phone varchar(50) DEFAULT NULL, email varchar(255) DEFAULT NULL, website varchar(255) DEFAULT NULL, policies longtext DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY chatbot_id (chatbot_id), UNIQUE KEY chatbot_business_info (chatbot_id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; // Execute each query separately to better handle errors $success = true; foreach ($sql as $query) { $result = dbDelta($query);"}],"table_count":4}