wp_bcog_usage_reservations
StaticStores bcog usage reservations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| promotion_id | BIGINT UNSIGNED | NO |
| reservation_key | CHAR(64) | NO |
| scope | VARCHAR(20) | NO |
| subject_hash | VARCHAR(64) | NO |
| bucket_start | DATETIME | NO |
| status | VARCHAR(20) | NO |
| order_id | BIGINT UNSIGNED | YES |
| reserved_at | DATETIME | NO |
| expires_at | DATETIME | NO |
| confirmed_at | DATETIME | YES |
| released_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_bcog_usage_reservations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, reservation_key CHAR(64) NOT NULL, scope VARCHAR(20) NOT NULL, subject_hash VARCHAR(64) NOT NULL, bucket_start DATETIME NOT NULL, status VARCHAR(20) NOT NULL, order_id BIGINT UNSIGNED NULL DEFAULT NULL, reserved_at DATETIME NOT NULL, expires_at DATETIME NOT NULL, confirmed_at DATETIME NULL DEFAULT NULL, released_at DATETIME NULL DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_reservation_key (reservation_key), KEY promo_scope_subject_bucket_status (promotion_id, scope, subject_hash, bucket_start, status), KEY status_expires (status, expires_at), 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_reservations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ByticsLab Conditional Offers for WooCommerce