wp_bcog_promotion_index
StaticStores bcog promotion index data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| promotion_id | BIGINT UNSIGNED | NO |
| object_id | BIGINT UNSIGNED | YES |
| lookup_key | VARCHAR(191) | NO |
| role | VARCHAR(20) | NO |
CREATE TABLE Statement
CREATE TABLE wp_bcog_promotion_index ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, promotion_id BIGINT UNSIGNED NOT NULL, index_type VARCHAR(20) NOT NULL, object_id BIGINT UNSIGNED NULL DEFAULT NULL, lookup_key VARCHAR(191) NOT NULL, role VARCHAR(20) NOT NULL, PRIMARY KEY (id), UNIQUE KEY bcog_idx_unique (promotion_id, lookup_key, role), KEY index_type_object_role (index_type, object_id, role), KEY lookup_key_role (lookup_key, role), KEY promotion_id (promotion_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_promotion_index`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ByticsLab Conditional Offers for WooCommerce