wp_jbusinessdirectory_company_offer_pictures

Static

Stores jbusinessdirectory company offer pictures data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idintNO
offerIdintNO
picture_infovarchar(255)YES
picture_pathvarchar(255)YES
picture_enabletinyint(1)NO
picture_titlevarchar(255)YES

CREATE TABLE Statement

CREATE TABLE `wp_jbusinessdirectory_company_offer_pictures` ( `id` int NOT NULL AUTO_INCREMENT, `offerId` int NOT NULL DEFAULT '0', `picture_info` varchar(255) DEFAULT NULL, `picture_path` varchar(255) DEFAULT NULL, `picture_enable` tinyint(1) NOT NULL DEFAULT '1', `picture_title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_offer` (`offerId`), KEY `idx_status` (`picture_enable`) ) ENGINE

Safe to delete?

If you have uninstalled WP-BusinessDirectory – Business directory plugin for WordPress, 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_jbusinessdirectory_company_offer_pictures`;

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

Other tables from WP-BusinessDirectory – Business directory plugin for WordPress