wp_jbusinessdirectory_discounts
StaticStores jbusinessdirectory discounts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| name | char(255) | YES |
| start_date | date | NO |
| end_date | date | NO |
| value | decimal(6,2) | NO |
| percent | tinyint(1) | NO |
| price_type | tinyint(1) | NO |
| package_ids | varchar(255) | YES |
| code | varchar(50) | NO |
| state | tinyint(1) | NO |
| uses_per_coupon | int | YES |
| coupon_used | int | NO |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_discounts` ( `id` int NOT NULL AUTO_INCREMENT, `name` char(255) DEFAULT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `value` decimal(6,2) NOT NULL DEFAULT '0.00', `percent` tinyint(1) NOT NULL DEFAULT '0', `price_type` tinyint(1) NOT NULL DEFAULT '1', `package_ids` varchar(255) DEFAULT NULL, `code` varchar(50) NOT NULL DEFAULT '0', `state` tinyint(1) NOT NULL DEFAULT '1', `uses_per_coupon` int DEFAULT NULL, `coupon_used` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_code` (`code`), KEY `idx_state` (`state`), KEY `idx_date` (`end_date`,`start_date`) ) 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_discounts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress