wp_bcog_usage_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| promotion_id | BIGINT UNSIGNED | NO |
| order_id | BIGINT UNSIGNED | YES |
| customer_id | BIGINT UNSIGNED | YES |
| customer_hash | VARCHAR(64) | YES |
| reward_snapshot | LONGTEXT | YES |
| used_at | DATETIME | NO |
| released_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_bcog_usage_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NULL DEFAULT NULL, customer_id BIGINT UNSIGNED NULL DEFAULT NULL, customer_hash VARCHAR(64) NULL DEFAULT NULL, reward_snapshot LONGTEXT NULL, used_at DATETIME NOT NULL, released_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_usage_unique (promotion_id, order_id), KEY promotion_customer (promotion_id, customer_id), KEY promotion_customer_hash (promotion_id, customer_hash), KEY order_id (order_id) ) ENGINE
Safe to delete?
If you have uninstalled ByticsLab Conditional Offers 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_bcog_usage_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ByticsLab Conditional Offers for WooCommerce