wp_contacts
StaticStores contacts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| contact_id | BIGINT | NO |
| order_key | VARCHAR(255) | NO |
| payment_type | VARCHAR(255) | NO |
| payment_status | VARCHAR(255) | NO |
| date | DATETIME | NO |
| check_date | DATETIME | NO |
| ip | VARCHAR(255) | NO |
| order_parent | BIGINT | NO |
| source | VARCHAR(255) | NO |
| product_id | BIGINT | NO |
| customer_id | BIGINT | NO |
| coupon | VARCHAR(255) | NO |
| tax | FLOAT | NO |
| licence_key | VARCHAR(255) | NO |
| licence_to | VARCHAR(255) | NO |
| order_type | VARCHAR(255) | YES |
| connected_id | BIGINT | NO |
CREATE TABLE Statement
CREATE TABLE `contacts` ( `contact_id` BIGINT NOT NULL , `order_key` VARCHAR(255) NOT NULL , `payment_type` VARCHAR(255) NOT NULL , `payment_status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL , `check_date` DATETIME NOT NULL , `ip` VARCHAR(255) NOT NULL , `order_parent` BIGINT NOT NULL , `source` VARCHAR(255) NOT NULL , `product_id` BIGINT NOT NULL , `customer_id` BIGINT NOT NULL , `coupon` VARCHAR(255) NOT NULL , `tax` FLOAT NOT NULL , `licence_key` VARCHAR(255) NOT NULL , `licence_to` VARCHAR(255) NOT NULL , `order_type` VARCHAR(255) , `connected_id` BIGINT NOT NULL , PRIMARY KEY (`contact_id`), KEY `fkIdx_159` (`product_id`), CONSTRAINT `products_to_contacts` FOREIGN KEY `fkIdx_159` (`product_id`) REFERENCES `products` (`product_id`), KEY `fkIdx_163` (`customer_id`), CONSTRAINT `customers_to_contacts` FOREIGN KEY `fkIdx_163` (`customer_id`) REFERENCES `customers` (`customer_id`) );
Safe to delete?
If you have uninstalled Email Reminders, 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_contacts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Email Reminders