{"slug":"debyendu-cart-offer-manager-woocommerce","name":"Cart Offer Manager for WooCommerce","description":"Enterprise dynamic discount rules and cart offer manager engine for WooCommerce.","author":"debyendubhunia","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/debyendu-cart-offer-manager-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"dbcomw_cache","full_table_name":"wp_dbcomw_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"medium","columns":[{"name":"cache_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"cache_value","type":"longtext","nullable":true,"primary_key":false},{"name":"cache_group","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_cache ( cache_key varchar(255) NOT NULL, cache_value longtext, cache_group varchar(100) DEFAULT 'default', expires_at datetime DEFAULT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (cache_key), KEY idx_expires_at (expires_at) ) $charset;\" );"},{"table_name":"dbcomw_rule_applications","full_table_name":"wp_dbcomw_rule_applications","description":"Stores dbcomw rule applications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"rule_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"original_subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"applied_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_rule_applications ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, rule_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, user_id bigint(20) unsigned DEFAULT 0, discount_amount decimal(12,2) NOT NULL DEFAULT 0.00, original_subtotal decimal(12,2) NOT NULL DEFAULT 0.00, applied_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_rule_id (rule_id), KEY idx_order_id (order_id), KEY idx_user_id (user_id) ) $charset;\" );"},{"table_name":"dbcomw_rules","full_table_name":"wp_dbcomw_rules","description":"Stores dbcomw rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rule_group","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"priority","type":"int(11)","nullable":true,"primary_key":false},{"name":"stop_further_rules","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"discount_type","type":"varchar(80)","nullable":false,"primary_key":false},{"name":"discount_data","type":"longtext","nullable":false,"primary_key":false},{"name":"filter_data","type":"longtext","nullable":true,"primary_key":false},{"name":"condition_data","type":"longtext","nullable":true,"primary_key":false},{"name":"bxgy_data","type":"longtext","nullable":true,"primary_key":false},{"name":"usage_limit_per_rule","type":"int(11)","nullable":true,"primary_key":false},{"name":"usage_limit_per_user","type":"int(11)","nullable":true,"primary_key":false},{"name":"usage_count","type":"bigint(20) unsigned","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":"created_by","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_rules ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, rule_group varchar(50) NOT NULL DEFAULT 'cart', status tinyint(1) DEFAULT 1, priority int(11) DEFAULT 10, stop_further_rules tinyint(1) DEFAULT 0, discount_type varchar(80) NOT NULL, discount_data longtext NOT NULL, filter_data longtext, condition_data longtext, bxgy_data longtext, usage_limit_per_rule int(11) DEFAULT NULL, usage_limit_per_user int(11) DEFAULT NULL, usage_count bigint(20) unsigned DEFAULT 0, start_date datetime DEFAULT NULL, end_date datetime DEFAULT NULL, created_by bigint(20) unsigned DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_status_priority (status, priority), KEY idx_group_status (rule_group, status), KEY idx_active_dates (status, start_date, end_date) ) $charset;\" );"},{"table_name":"dbcomw_segments","full_table_name":"wp_dbcomw_segments","description":"Stores dbcomw segments data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rules","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_segments ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, rules longtext NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\" );"},{"table_name":"dbcomw_user_rule_tracking","full_table_name":"wp_dbcomw_user_rule_tracking","description":"Stores dbcomw user rule tracking data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"rule_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"usage_count","type":"int(10) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_user_rule_tracking ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, rule_id bigint(20) unsigned NOT NULL, user_id bigint(20) unsigned NOT NULL, usage_count int(10) unsigned DEFAULT 1, PRIMARY KEY (id), UNIQUE KEY idx_rule_user (rule_id, user_id) ) $charset;\" );"}],"table_count":5}