{"slug":"ai-marketing-expert","name":"AI Marketing Expert — AI Email Marketing, Content Generator, SEO Analyzer, Social Media & Chatbot","description":"All-in-one AI marketing plugin: email campaigns, content generation, SEO analyzer, social media scheduling, and AI chatbot — in one dashboard.","author":"Noor Alam","active_installs":20,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/ai-marketing-expert/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"aime_content_articles","full_table_name":"wp_aime_content_articles","description":"Stores aime content articles data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aime_content_brand_voices","full_table_name":"wp_aime_content_brand_voices","description":"Stores aime content brand voices data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aime_content_presets","full_table_name":"wp_aime_content_presets","description":"Stores aime content presets data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aime_log","full_table_name":"wp_aime_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"aime_modules","full_table_name":"wp_aime_modules","description":"Stores aime modules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"module_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"settings","type":"longtext","nullable":true,"primary_key":false},{"name":"activated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"module_id","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"level","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":false,"primary_key":false},{"name":"context","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"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};\"; foreach ( $tables as $sql ) { dbDelta( $sql );"}],"table_count":5}