wp_jbusinessdirectory_request_quote
StaticStores jbusinessdirectory request quote data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| additional_information | varchar(255) | YES |
| summary | text | YES |
| status | int | YES |
| creationDate | timestamp | YES |
| user_id | int | YES |
| category_id | int | NO |
| company_id | int | NO |
| title | varchar(255) | YES |
| location | varchar(255) | YES |
| latitude | varchar(50) | YES |
| longitude | varchar(50) | YES |
| quote_date_time | datetime | YES |
| province | varchar(65) | YES |
| district | varchar(65) | YES |
| neighborhood | varchar(65) | YES |
| timeframe | varchar(65) | YES |
| phone | varchar(45) | YES |
| created | timestamp | NO |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_request_quote` ( `id` int NOT NULL AUTO_INCREMENT, `additional_information` varchar(255) DEFAULT NULL, `summary` text, `status` int DEFAULT NULL, `creationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int DEFAULT NULL, `category_id` int NOT NULL, `company_id` int NOT NULL DEFAULT '0', `title` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `latitude` varchar(50) DEFAULT NULL, `longitude` varchar(50) DEFAULT NULL, `quote_date_time` datetime DEFAULT NULL, `province` varchar(65) DEFAULT NULL, `district` varchar(65) DEFAULT NULL, `neighborhood` varchar(65) DEFAULT NULL, `timeframe` varchar(65) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_user` (`user_id`), KEY `idx_category` (`category_id`) ) 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_request_quote`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress