wp_dbcomw_rule_applications
StaticStores dbcomw rule applications data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| rule_id | bigint(20) unsigned | NO |
| order_id | bigint(20) unsigned | NO |
| user_id | bigint(20) unsigned | YES |
| discount_amount | decimal(12,2) | NO |
| original_subtotal | decimal(12,2) | NO |
| applied_at | datetime | YES |
CREATE TABLE Statement
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;" );
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_rule_applications`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Cart Offer Manager for WooCommerce