{"table_name":"ec_offer","full_table_name":"wp_ec_offer","description":"Stores ec offer data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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;\" );","columns":[{"name":"offer_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"offer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"offer_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"offer_description","type":"text","nullable":true,"primary_key":false},{"name":"offer_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"trigger_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"action_type","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"action_config","type":"longtext","nullable":true,"primary_key":false},{"name":"start_date","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"schedule_config","type":"longtext","nullable":true,"primary_key":false},{"name":"is_exclusive","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"combine_item_discounts","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"combine_cart_discounts","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"combine_shipping_discounts","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":false,"primary_key":false},{"name":"apply_limit","type":"int(11)","nullable":false,"primary_key":false},{"name":"max_discount_amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"min_item_price_floor","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"max_redemptions","type":"int(11)","nullable":false,"primary_key":false},{"name":"times_redeemed","type":"int(11)","nullable":false,"primary_key":false},{"name":"max_redemptions_per_customer","type":"int(11)","nullable":false,"primary_key":false},{"name":"max_redemptions_per_day","type":"int(11)","nullable":false,"primary_key":false},{"name":"applies_to_subscriptions","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"applies_to_sale_items","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"discount_base","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"include_modifier_prices","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"display_config","type":"longtext","nullable":true,"primary_key":false},{"name":"legacy_promocode_id","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"legacy_promotion_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"modified_date","type":"timestamp","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}