wp_bcog_promotions
StaticStores bcog promotions data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| name | VARCHAR(255) | NO |
| status | VARCHAR(20) | NO |
| type | VARCHAR(50) | NO |
| priority | INT | NO |
| conditions | LONGTEXT | NO |
| rewards | LONGTEXT | NO |
| settings | LONGTEXT | NO |
| starts_at | DATETIME | YES |
| ends_at | DATETIME | YES |
| usage_count | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| created_by | BIGINT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE wp_bcog_promotions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'draft', type VARCHAR(50) NOT NULL, priority INT NOT NULL DEFAULT 10, conditions LONGTEXT NOT NULL, rewards LONGTEXT NOT NULL, settings LONGTEXT NOT NULL, starts_at DATETIME NULL DEFAULT NULL, ends_at DATETIME NULL DEFAULT NULL, usage_count BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, created_by BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY status_priority (status, priority), KEY starts_ends (starts_at, ends_at) ) 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_promotions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ByticsLab Conditional Offers for WooCommerce