wp_a1ai_system_prompts
StaticStores a1ai system prompts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(9) | NO |
| chatbot_id | mediumint(9) | NO |
| prompt_name | varchar(255) | NO |
| prompt_content | longtext | NO |
| is_active | tinyint(1) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| chatbot_id | mediumint(9) | NO |
| instruction_name | varchar(255) | NO |
| instruction_content | longtext | NO |
| instruction_type | varchar(50) | NO |
| priority | int(11) | NO |
| is_active | tinyint(1) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| chatbot_id | mediumint(9) | NO |
| business_name | varchar(255) | YES |
| tagline | text | YES |
| business_type | varchar(100) | YES |
| services | longtext | YES |
| products | longtext | YES |
| hours | longtext | YES |
| address | text | YES |
| phone | varchar(50) | YES |
| varchar(255) | YES | |
| website | varchar(255) | YES |
| policies | longtext | YES |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
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);Safe to delete?
If you have uninstalled A1AI Chatbot, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_a1ai_system_prompts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from A1AI Chatbot