wp_bslco_offers

Static

Stores bslco offers data created by this plugin.

Column Definitions

Column	Type	Nullable
🔑id	bigint(20)	NO
user_id	bigint(20)	NO
product_id	bigint(20)	NO
offer_price	decimal(10,2)	NO
offer_type	varchar(20)	NO
quantity	int(11)	NO
shipping_charge	decimal(10,2)	NO
created_at	datetime	NO
expires_at	datetime	NO
status	varchar(20)	NO
order_id	bigint(20)	YES
user_id	bigint(20)	NO
product_id	bigint(20)	NO
sender_type	varchar(20)	NO
message	text	NO
offer_id	bigint(20)	NO
offer_ids	text	YES
created_at	datetime	NO

CREATE TABLE Statement

CREATE TABLE wp_bslco_offers ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, offer_price decimal(10,2) NOT NULL, offer_type varchar(20) DEFAULT 'automatic' NOT NULL, quantity int(11) DEFAULT 1 NOT NULL, shipping_charge decimal(10,2) DEFAULT 0.00 NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, expires_at datetime NOT NULL, status varchar(20) DEFAULT 'active' NOT NULL, order_id bigint(20) DEFAULT 0, PRIMARY KEY (id), KEY user_id (user_id), KEY product_id (product_id) ) {$charset_collate};"; $sql2 = "CREATE TABLE wp_bslco_messages ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, product_id bigint(20) NOT NULL, sender_type varchar(20) DEFAULT 'customer' NOT NULL, message text NOT NULL, offer_id bigint(20) DEFAULT 0 NOT NULL, offer_ids text NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY product_id (product_id) ) {$charset_collate};"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql1 );

Safe to delete?

If you have uninstalled Like and Custom Offer 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_bslco_offers`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Like and Custom Offer for WooCommerce

wp_bslco_messages