wp_jbusinessdirectory_attributes
StaticStores jbusinessdirectory attributes data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| name | varchar(255) | YES |
| code | varchar(100) | YES |
| type | int | YES |
| status | int | YES |
| is_mandatory | int | NO |
| show_in_filter | tinyint(1) | NO |
| only_for_admin | tinyint(1) | NO |
| show_in_front | tinyint(1) | NO |
| show_on_search | tinyint(1) | NO |
| show_icon | tinyint(1) | NO |
| show_name | tinyint(1) | NO |
| color | varchar(10) | YES |
| group | varchar(255) | YES |
| ordering | tinyint | NO |
| attribute_type | tinyint(1) | NO |
| show_in_list_view | tinyint(1) | NO |
| use_attribute_for_selling | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_attributes` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `code` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `status` int DEFAULT NULL, `is_mandatory` int NOT NULL DEFAULT '0', `show_in_filter` tinyint(1) NOT NULL DEFAULT '1', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `show_in_front` tinyint(1) NOT NULL DEFAULT '0', `show_on_search` tinyint(1) NOT NULL DEFAULT '0', `show_icon` tinyint(1) NOT NULL DEFAULT '0', `show_name` tinyint(1) NOT NULL DEFAULT '1', `color` varchar(10) DEFAULT NULL, `group` varchar(255) DEFAULT NULL, `ordering` tinyint NOT NULL DEFAULT '0', `attribute_type` tinyint(1) NOT NULL DEFAULT '1', `show_in_list_view` tinyint(1) NOT NULL DEFAULT '0', `use_attribute_for_selling` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_type` (`type`), KEY `idx_attribute_type` (`attribute_type`) ) 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_attributes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress