wp_dbcomw_rules
StaticStores dbcomw rules data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| name | varchar(255) | NO |
| rule_group | varchar(50) | NO |
| status | tinyint(1) | YES |
| priority | int(11) | YES |
| stop_further_rules | tinyint(1) | YES |
| discount_type | varchar(80) | NO |
| discount_data | longtext | NO |
| filter_data | longtext | YES |
| condition_data | longtext | YES |
| bxgy_data | longtext | YES |
| usage_limit_per_rule | int(11) | YES |
| usage_limit_per_user | int(11) | YES |
| usage_count | bigint(20) unsigned | YES |
| start_date | datetime | YES |
| end_date | datetime | YES |
| created_by | bigint(20) unsigned | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
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;" );
Safe to delete?
If you have uninstalled Cart Offer Manager for WooCommerce, 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_dbcomw_rules`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Cart Offer Manager for WooCommerce