{"table_name":"dbcomw_rules","full_table_name":"wp_dbcomw_rules","description":"Stores dbcomw rules data created by this plugin.","detection_method":"static","confidence":"medium","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;\" );","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}],"plugin":{"slug":"debyendu-cart-offer-manager-woocommerce","name":"Cart Offer Manager for WooCommerce","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/debyendu-cart-offer-manager-woocommerce/"}}