wp_jbusinessdirectory_order_packages
StaticStores order records and related transaction data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| order_id | int | NO |
| name | varchar(145) | YES |
| description | varchar(200) | 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 |
| ordering | tinyint | NO |
| time_unit | varchar(10) | NO |
| time_amount | mediumint | NO |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_order_packages` ( `id` int NOT NULL AUTO_INCREMENT, `order_id` int NOT NULL, `name` varchar(145) DEFAULT NULL, `description` varchar(200) DEFAULT NULL, `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', `ordering` tinyint NOT NULL DEFAULT '0', `time_unit` varchar(10) NOT NULL DEFAULT 'D', `time_amount` mediumint NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_price` (`price`), KEY `idx_order` (`order_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_order_packages`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress