wp_jbusinessdirectory_packages
StaticStores jbusinessdirectory packages data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| name | varchar(145) | YES |
| description | text | YES |
| show_features | tinyint(1) | YES |
| show_buttons | tinyint(1) | YES |
| price_description | text | YES |
| expiration_type | tinyint(1) | YES |
| price | decimal(12,2) | YES |
| trial_price | decimal(12,2) | YES |
| trial_days | smallint | NO |
| trial_period_unit | varchar(10) | NO |
| trial_period_amount | smallint | YES |
| recurrence_count | tinyint | YES |
| special_price | decimal(12,2) | YES |
| special_from_date | date | YES |
| special_to_date | date | YES |
| days | smallint | NO |
| status | tinyint(1) | NO |
| ordering | tinyint | NO |
| time_unit | varchar(10) | NO |
| time_amount | mediumint | NO |
| show_price_per_month | tinyint(1) | NO |
| max_pictures | smallint | NO |
| max_videos | smallint | NO |
| max_attachments | smallint | NO |
| max_categories | smallint | NO |
| popular | tinyint(1) | NO |
| max_offers | smallint | NO |
| offer_count_type | tinyint(1) | NO |
| max_events | smallint | NO |
| only_for_admin | tinyint(1) | NO |
| package_usergroup | varchar(255) | YES |
| bg_color | varchar(45) | YES |
| text_color | varchar(45) | YES |
| border_color | varchar(45) | YES |
| show_disable_features | tinyint(1) | YES |
| max_quote_replies | int | NO |
| renewal_price | decimal(12,2) | YES |
| max_zipcodes | smallint | NO |
| package_type | tinyint(1) | YES |
| max_trips | smallint | NO |
| max_locations | smallint | NO |
| max_description_length | smallint | YES |
| max_sounds | smallint | NO |
| max_projects | smallint | YES |
| max_activity_cities | smallint | YES |
| max_activity_regions | smallint | YES |
| max_activity_countries | smallint | YES |
| require_review | tinyint | YES |
| fixed_end_date | date | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_packages` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(145) DEFAULT NULL, `description` text, `show_features` tinyint(1) DEFAULT '1', `show_buttons` tinyint(1) DEFAULT '1', `price_description` text, `expiration_type` tinyint(1) DEFAULT NULL, `price` decimal(12,2) DEFAULT NULL, `trial_price` decimal(12,2) DEFAULT NULL, `trial_days` smallint NOT NULL DEFAULT '0', `trial_period_unit` varchar(10) NOT NULL DEFAULT 'D', `trial_period_amount` smallint DEFAULT NULL, `recurrence_count` tinyint DEFAULT NULL, `special_price` decimal(12,2) DEFAULT NULL, `special_from_date` date DEFAULT NULL, `special_to_date` date DEFAULT NULL, `days` smallint NOT NULL DEFAULT '1', `status` tinyint(1) NOT NULL DEFAULT '0', `ordering` tinyint NOT NULL DEFAULT '0', `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', `show_price_per_month` tinyint(1) NOT NULL DEFAULT '0', `max_pictures` smallint NOT NULL DEFAULT '15', `max_videos` smallint NOT NULL DEFAULT '5', `max_attachments` smallint NOT NULL DEFAULT '5', `max_categories` smallint NOT NULL DEFAULT '10', `popular` tinyint(1) NOT NULL DEFAULT '0', `max_offers` smallint NOT NULL DEFAULT '0', `offer_count_type` tinyint(1) NOT NULL DEFAULT '0', `max_events` smallint NOT NULL DEFAULT '0', `only_for_admin` tinyint(1) NOT NULL DEFAULT '0', `package_usergroup` varchar(255) DEFAULT '1', `bg_color` varchar(45) DEFAULT NULL, `text_color` varchar(45) DEFAULT NULL, `border_color` varchar(45) DEFAULT NULL, `show_disable_features` tinyint(1) DEFAULT '1', `max_quote_replies` int NOT NULL DEFAULT '5', `renewal_price` decimal(12,2) DEFAULT NULL, `max_zipcodes` smallint NOT NULL DEFAULT '0', `package_type` tinyint(1) DEFAULT '1', `max_trips` smallint NOT NULL DEFAULT '0', `max_locations` smallint NOT NULL DEFAULT '0', `max_description_length` smallint DEFAULT '1200', `max_sounds` smallint NOT NULL DEFAULT '5', `max_projects` smallint DEFAULT '5', `max_activity_cities` smallint DEFAULT '0', `max_activity_regions` smallint DEFAULT '0', `max_activity_countries` smallint DEFAULT '0', `require_review` tinyint DEFAULT '0', `fixed_end_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_package_usergroup` (`package_usergroup`), KEY `idx_status` (`status`), KEY `idx_price` (`price`), KEY `idx_expiration_type` (`expiration_type`), KEY `idx_only_for_admin` (`only_for_admin`) ) 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_packages`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress