wp_aime_modules
StaticStores aime modules data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| module_id | varchar(50) | NO |
| is_active | tinyint(1) | NO |
| settings | longtext | YES |
| activated_at | datetime | YES |
| updated_at | datetime | YES |
| module_id | varchar(50) | YES |
| level | varchar(20) | NO |
| message | text | NO |
| context | longtext | YES |
| created_at | datetime | NO |
| connection_id | varchar(64) | NO |
| connection_name | varchar(191) | NO |
| provider | varchar(50) | NO |
| model | varchar(191) | NO |
| task | varchar(50) | NO |
| prompt_tokens | bigint(20) unsigned | NO |
| completion_tokens | bigint(20) unsigned | NO |
| success | tinyint(1) | NO |
| created_at | datetime | NO |
| type | varchar(50) | NO |
| payload | longtext | YES |
| status | varchar(20) | NO |
| attempts | tinyint(3) unsigned | NO |
| result | longtext | YES |
| error | text | YES |
| created_at | datetime | NO |
| started_at | datetime | YES |
| completed_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_aime_modules ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, module_id varchar(50) NOT NULL, is_active tinyint(1) NOT NULL DEFAULT 1, settings longtext, activated_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idx_module_id (module_id) ) {$charset_collate};"; // Activity log. $tables[] = "CREATE TABLE wp_aime_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, module_id varchar(50) DEFAULT 'core', level varchar(20) NOT NULL DEFAULT 'info', message text NOT NULL, context longtext, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_module (module_id), KEY idx_level (level), KEY idx_created (created_at) ) {$charset_collate};"; // AI usage log (token accounting per generation call). $tables[] = "CREATE TABLE wp_aime_ai_usage ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, connection_id varchar(64) NOT NULL DEFAULT '', connection_name varchar(191) NOT NULL DEFAULT '', provider varchar(50) NOT NULL DEFAULT '', model varchar(191) NOT NULL DEFAULT '', task varchar(50) NOT NULL DEFAULT 'text', prompt_tokens bigint(20) unsigned NOT NULL DEFAULT 0, completion_tokens bigint(20) unsigned NOT NULL DEFAULT 0, success tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_created (created_at), KEY idx_connection (connection_id) ) {$charset_collate};"; // Background AI job queue. $tables[] = "CREATE TABLE wp_aime_ai_jobs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, type varchar(50) NOT NULL, payload longtext, status varchar(20) NOT NULL DEFAULT 'pending', attempts tinyint(3) unsigned NOT NULL DEFAULT 0, result longtext, error text, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, started_at datetime DEFAULT NULL, completed_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY idx_status (status), KEY idx_created (created_at) ) {$charset_collate};"; foreach ( $tables as $sql ) { dbDelta( $sql );Safe to delete?
If you have uninstalled AI Marketing Expert — AI Email Marketing, AI Content Generator, SEO Analyzer, AI Workflow Automation, Social Media & Ai 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_aime_modules`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI Marketing Expert — AI Email Marketing, AI Content Generator, SEO Analyzer, AI Workflow Automation, Social Media & Ai Chatbot