wp_mailnest_clicks
StaticStores mailnest clicks data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| campaign_id | BIGINT(20) UNSIGNED | NO |
| subscriber_id | BIGINT(20) UNSIGNED | NO |
| original_url | TEXT | NO |
| clicked_at | DATETIME | YES |
| ip_address | VARCHAR(45) | YES |
CREATE TABLE Statement
CREATE TABLE wp_mailnest_clicks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, campaign_id BIGINT(20) UNSIGNED NOT NULL, subscriber_id BIGINT(20) UNSIGNED NOT NULL, original_url TEXT NOT NULL, clicked_at DATETIME DEFAULT CURRENT_TIMESTAMP, ip_address VARCHAR(45) DEFAULT NULL, PRIMARY KEY (id), KEY campaign_sub (campaign_id, subscriber_id) ) $charset;" );
Safe to delete?
If you have uninstalled MailNest, 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_mailnest_clicks`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from MailNest