wp_acquis_email_logs
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| lead_id | BIGINT(20) UNSIGNED | NO |
| varchar(191) | NO | |
| subject | VARCHAR(500) | NO |
| status | VARCHAR(20) | NO |
| provider | VARCHAR(50) | NO |
| error_msg | TEXT | YES |
| opened_at | DATETIME | YES |
| click_count | INT(11) UNSIGNED | NO |
| last_clicked_at | DATETIME | YES |
| sequence_id | BIGINT(20) UNSIGNED | NO |
| sequence_step | BIGINT(20) UNSIGNED | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_acquis_email_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT(20) UNSIGNED NOT NULL, email varchar(191) NOT NULL, subject VARCHAR(500) NOT NULL DEFAULT '', status VARCHAR(20) NOT NULL DEFAULT 'queued', provider VARCHAR(50) NOT NULL DEFAULT 'wp_mail', error_msg TEXT, opened_at DATETIME DEFAULT NULL, click_count INT(11) UNSIGNED NOT NULL DEFAULT 0, last_clicked_at DATETIME DEFAULT NULL, sequence_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, sequence_step BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY lead_id (lead_id), KEY status (status), KEY created_at (created_at) ) $c;" );
Safe to delete?
If you have uninstalled AcquisitionSuite, 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_acquis_email_logs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AcquisitionSuite