wp_jbusinessdirectory_categories
StaticStores jbusinessdirectory categories data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| parent_id | int | NO |
| lft | int | NO |
| rgt | int | NO |
| level | int UNSIGNED | NO |
| type | tinyint(1) | NO |
| name | varchar(100) | YES |
| alias | varchar(100) | YES |
| description | text | YES |
| published | tinyint | NO |
| imageLocation | varchar(250) | YES |
| markerLocation | varchar(250) | YES |
| color | varchar(10) | YES |
| icon | varchar(50) | YES |
| path | varchar(255) | YES |
| clickCount | int | NO |
| meta_title | varchar(255) | YES |
| meta_description | text | YES |
| meta_keywords | varchar(255) | YES |
| iconImgLocation | varchar(250) | YES |
| keywords | varchar(250) | YES |
| user_as_container | tinyint(1) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_categories` ( `id` int NOT NULL AUTO_INCREMENT, `parent_id` int NOT NULL DEFAULT '0', `lft` int NOT NULL DEFAULT '0', `rgt` int NOT NULL DEFAULT '0', `level` int UNSIGNED NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '1', `name` varchar(100) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `description` text, `published` tinyint NOT NULL DEFAULT '1', `imageLocation` varchar(250) DEFAULT NULL, `markerLocation` varchar(250) DEFAULT NULL, `color` varchar(10) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `clickCount` int NOT NULL DEFAULT '0', `meta_title` varchar(255) DEFAULT NULL, `meta_description` text, `meta_keywords` varchar(255) DEFAULT NULL, `iconImgLocation` varchar(250) DEFAULT NULL, `keywords` varchar(250) DEFAULT NULL, `user_as_container` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_alias` (`alias`), KEY `idx_parent` (`parent_id`), KEY `idx_name` (`name`), KEY `idx_state` (`published`), KEY `idx_type` (`type`), KEY `idx_lft` (`lft`), KEY `idx_rgt` (`rgt`), KEY `idx_level` (`level`) ) 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_categories`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress