wp_ec_offer
StaticStores ec offer data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑offer_id | int(11) | NO |
| offer_name | varchar(255) | NO |
| offer_label | varchar(255) | NO |
| offer_description | text | YES |
| offer_status | varchar(20) | NO |
| trigger_type | varchar(20) | NO |
| action_type | varchar(40) | NO |
| action_config | longtext | YES |
| start_date | datetime | YES |
| end_date | datetime | YES |
| schedule_config | longtext | YES |
| is_exclusive | tinyint(1) | NO |
| combine_item_discounts | tinyint(1) | NO |
| combine_cart_discounts | tinyint(1) | NO |
| combine_shipping_discounts | tinyint(1) | NO |
| priority | int(11) | NO |
| apply_limit | int(11) | NO |
| max_discount_amount | float(15,3) | NO |
| min_item_price_floor | float(15,3) | NO |
| max_redemptions | int(11) | NO |
| times_redeemed | int(11) | NO |
| max_redemptions_per_customer | int(11) | NO |
| max_redemptions_per_day | int(11) | NO |
| applies_to_subscriptions | tinyint(1) | NO |
| applies_to_sale_items | tinyint(1) | NO |
| discount_base | varchar(20) | NO |
| include_modifier_prices | tinyint(1) | NO |
| display_config | longtext | YES |
| legacy_promocode_id | varchar($max_index_length) | NO |
| legacy_promotion_id | int(11) | NO |
| modified_date | timestamp | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS ec_offer ( offer_id int(11) NOT NULL AUTO_INCREMENT, offer_name varchar(255) NOT NULL DEFAULT '', offer_label varchar(255) NOT NULL DEFAULT '', offer_description text, offer_status varchar(20) NOT NULL DEFAULT 'draft', trigger_type varchar(20) NOT NULL DEFAULT 'code', action_type varchar(40) NOT NULL DEFAULT 'item_discount', action_config longtext, start_date datetime DEFAULT NULL, end_date datetime DEFAULT NULL, schedule_config longtext, is_exclusive tinyint(1) NOT NULL DEFAULT '0', combine_item_discounts tinyint(1) NOT NULL DEFAULT '0', combine_cart_discounts tinyint(1) NOT NULL DEFAULT '0', combine_shipping_discounts tinyint(1) NOT NULL DEFAULT '1', priority int(11) NOT NULL DEFAULT '10', apply_limit int(11) NOT NULL DEFAULT '0', max_discount_amount float(15,3) NOT NULL DEFAULT '0.000', min_item_price_floor float(15,3) NOT NULL DEFAULT '0.000', max_redemptions int(11) NOT NULL DEFAULT '0', times_redeemed int(11) NOT NULL DEFAULT '0', max_redemptions_per_customer int(11) NOT NULL DEFAULT '0', max_redemptions_per_day int(11) NOT NULL DEFAULT '0', applies_to_subscriptions tinyint(1) NOT NULL DEFAULT '0', applies_to_sale_items tinyint(1) NOT NULL DEFAULT '1', discount_base varchar(20) NOT NULL DEFAULT 'unit_price', include_modifier_prices tinyint(1) NOT NULL DEFAULT '0', display_config longtext, legacy_promocode_id varchar($max_index_length) NOT NULL DEFAULT '', legacy_promotion_id int(11) NOT NULL DEFAULT '0', created_date $offer_created_date, modified_date timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (offer_id), UNIQUE KEY offer_offer_id (offer_id), KEY offer_status_trigger (offer_status,trigger_type), KEY offer_dates (start_date,end_date), KEY offer_legacy_promotion (legacy_promotion_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`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP EasyCart: Shopping Cart and eCommerce Store