wp_ec_offer_target
StaticStores ec offer target data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑offer_target_id | int(11) | NO |
| offer_id | int(11) | NO |
| target_side | varchar(10) | NO |
| target_mode | varchar(10) | NO |
| entity_type | varchar(20) | NO |
| entity_id | int(11) | NO |
| optionitem_id_1 | int(11) | NO |
| optionitem_id_2 | int(11) | NO |
| optionitem_id_3 | int(11) | NO |
| optionitem_id_4 | int(11) | NO |
| optionitem_id_5 | int(11) | NO |
| entity_config | longtext | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_offer_target ( offer_target_id int(11) NOT NULL AUTO_INCREMENT, offer_id int(11) NOT NULL DEFAULT '0', target_side varchar(10) NOT NULL DEFAULT 'both', target_mode varchar(10) NOT NULL DEFAULT 'include', entity_type varchar(20) NOT NULL DEFAULT 'all', entity_id int(11) NOT NULL DEFAULT '0', optionitem_id_1 int(11) NOT NULL DEFAULT '0', optionitem_id_2 int(11) NOT NULL DEFAULT '0', optionitem_id_3 int(11) NOT NULL DEFAULT '0', optionitem_id_4 int(11) NOT NULL DEFAULT '0', optionitem_id_5 int(11) NOT NULL DEFAULT '0', entity_config longtext, PRIMARY KEY (offer_target_id), KEY offer_target_offer_id (offer_id), KEY offer_target_entity (entity_type,entity_id) ) $collate;" );
Safe to delete?
If you have uninstalled WP EasyCart: Shopping Cart and eCommerce Store, 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_ec_offer_target`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store