wp_jbusinessdirectory_company_locations
StaticStores jbusinessdirectory company locations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| name | varchar(80) | YES |
| company_id | int | YES |
| street_number | varchar(100) | YES |
| address | varchar(100) | YES |
| city | varchar(60) | YES |
| county | varchar(60) | YES |
| postalCode | varchar(45) | YES |
| countryId | int | YES |
| activity_radius | decimal(10,2) | YES |
| latitude | varchar(45) | YES |
| longitude | varchar(45) | YES |
| phone | varchar(45) | YES |
| province | varchar(60) | YES |
| area | varchar(60) | YES |
| identifier | varchar(255) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_company_locations` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(80) DEFAULT NULL, `company_id` int DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `city` varchar(60) DEFAULT NULL, `county` varchar(60) DEFAULT NULL, `postalCode` varchar(45) DEFAULT NULL, `countryId` int DEFAULT NULL, `activity_radius` decimal(10,2) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `identifier` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_country` (`countryId`), KEY `idx_company` (`company_id`), KEY `idx_identifier` (`identifier`), KEY `idx_city` (`city`), KEY `idx_county` (`county`), KEY `idx_province` (`province`), KEY `idx_area` (`area`) ) 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_locations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress