wp_acquis_leads
StaticStores acquis leads data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| full_name | varchar(191) | NO |
| varchar(191) | NO | |
| file_id | BIGINT(20) UNSIGNED | NO |
| ip_address | VARCHAR(45) | NO |
| user_agent | VARCHAR(500) | NO |
| device | VARCHAR(20) | NO |
| browser | VARCHAR(50) | NO |
| os | VARCHAR(50) | NO |
| country | VARCHAR(100) | NO |
| region | VARCHAR(100) | NO |
| city | VARCHAR(100) | NO |
| visit_count | INT(11) UNSIGNED | NO |
| last_seen_at | DATETIME | YES |
| deal_value | DECIMAL(12,2) | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_acquis_leads ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, full_name varchar(191) NOT NULL, email varchar(191) NOT NULL, file_id BIGINT(20) UNSIGNED NOT NULL, ip_address VARCHAR(45) NOT NULL DEFAULT '', user_agent VARCHAR(500) NOT NULL DEFAULT '', device VARCHAR(20) NOT NULL DEFAULT '', browser VARCHAR(50) NOT NULL DEFAULT '', os VARCHAR(50) NOT NULL DEFAULT '', country VARCHAR(100) NOT NULL DEFAULT '', region VARCHAR(100) NOT NULL DEFAULT '', city VARCHAR(100) NOT NULL DEFAULT '', visit_count INT(11) UNSIGNED NOT NULL DEFAULT 1, last_seen_at DATETIME DEFAULT NULL, deal_value DECIMAL(12,2) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY email (email), KEY file_id (file_id), KEY created_at (created_at), KEY country (country) ) $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_leads`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AcquisitionSuite