wp_jbusinessdirectory_company_offers
StaticStores jbusinessdirectory company offers data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| companyId | int | NO |
| currencyId | int | NO |
| subject | varchar(110) | YES |
| description | text | YES |
| meta_title | varchar(100) | YES |
| meta_description | text | YES |
| meta_keywords | text | YES |
| price | decimal(12,2) | YES |
| specialPrice | decimal(12,2) | YES |
| price_base | decimal(12,2) | YES |
| price_base_unit | varchar(45) | YES |
| special_price_base | decimal(12,2) | YES |
| special_price_base_unit | varchar(45) | YES |
| total_coupons | int | NO |
| startDate | date | YES |
| endDate | date | YES |
| state | tinyint(1) | NO |
| approved | tinyint(1) | NO |
| offerOfTheDay | tinyint(1) | NO |
| viewCount | int | YES |
| alias | varchar(100) | YES |
| address | varchar(100) | YES |
| street_number | varchar(100) | YES |
| city | varchar(45) | YES |
| short_description | varchar(255) | YES |
| county | varchar(45) | YES |
| province | varchar(60) | YES |
| area | varchar(60) | YES |
| publish_start_date | date | YES |
| publish_end_date | date | YES |
| view_type | tinyint | NO |
| url | varchar(145) | YES |
| article_id | int | YES |
| latitude | varchar(45) | YES |
| longitude | varchar(45) | YES |
| featured | tinyint(1) | NO |
| created | timestamp | NO |
| show_time | tinyint(1) | YES |
| publish_start_time | time | YES |
| publish_end_time | time | YES |
| expiration_email_date | datetime | YES |
| main_subcategory | int | YES |
| enable_offer_selling | tinyint(1) | YES |
| min_purchase | int | YES |
| max_purchase | int | YES |
| quantity | int | YES |
| user_id | int | YES |
| postalCode | varchar(55) | YES |
| type | tinyint(1) | NO |
| countryId | int | YES |
| price_text | varchar(100) | YES |
| offer_type | int | YES |
| time_zone | varchar(15) | YES |
| item_type | tinyint(1) | NO |
| notify_offer_quantity | int | YES |
| use_stock_price | tinyint(1) | YES |
| contact_email | varchar(100) | YES |
| add_to_price_list | tinyint(1) | YES |
| review_score | decimal(2,1) | YES |
| packages | varchar(75) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_company_offers` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int NOT NULL, `currencyId` int NOT NULL, `subject` varchar(110) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` decimal(12,2) DEFAULT NULL, `specialPrice` decimal(12,2) DEFAULT NULL, `price_base` decimal(12,2) DEFAULT NULL, `price_base_unit` varchar(45) DEFAULT NULL, `special_price_base` decimal(12,2) DEFAULT NULL, `special_price_base_unit` varchar(45) DEFAULT NULL, `total_coupons` int NOT NULL DEFAULT '0', `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `approved` tinyint(1) NOT NULL DEFAULT '0', `offerOfTheDay` tinyint(1) NOT NULL DEFAULT '0', `viewCount` int DEFAULT '0', `alias` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `short_description` varchar(255) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `publish_start_date` date DEFAULT NULL, `publish_end_date` date DEFAULT NULL, `view_type` tinyint NOT NULL DEFAULT '1', `url` varchar(145) DEFAULT NULL, `article_id` int DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `show_time` tinyint(1) DEFAULT '0', `publish_start_time` time DEFAULT NULL, `publish_end_time` time DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `enable_offer_selling` tinyint(1) DEFAULT '1', `min_purchase` int DEFAULT NULL, `max_purchase` int DEFAULT NULL, `quantity` int DEFAULT NULL, `user_id` int DEFAULT NULL, `postalCode` varchar(55) DEFAULT NULL, `type` tinyint(1) NOT NULL DEFAULT '1', `countryId` int DEFAULT NULL, `price_text` varchar(100) DEFAULT NULL, `offer_type` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `item_type` tinyint(1) NOT NULL DEFAULT '1', `notify_offer_quantity` int DEFAULT NULL, `use_stock_price` tinyint(1) DEFAULT NULL, `contact_email` varchar(100) DEFAULT NULL, `add_to_price_list` tinyint(1) DEFAULT '0', `review_score` decimal(2,1) DEFAULT '0.0', `packages` varchar(75) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_company` (`companyId`), KEY `idx_country` (`countryId`), KEY `idx_approved` (`approved`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_latitude` (`latitude`), KEY `idx_longitude` (`longitude`), KEY `idx_price` (`price`), KEY `idx_specialPrice` (`specialPrice`), KEY `idx_subject` (`subject`), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_area` (`area`), KEY `idx_province` (`province`), KEY `idx_short_description` (`short_description`(100)), KEY `idx_address` (`address`), KEY `idx_user_id` (`user_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_search` (`state`,`endDate`,`startDate`,`publish_end_date`,`publish_start_date`), KEY `idx_publish_time` (`publish_start_time`,`publish_end_time`), KEY `idx_offer_type` (`offer_type`), KEY `idx_packages` (`packages`) ) 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_offers`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress