wp_jbusinessdirectory_company_events
StaticStores jbusinessdirectory company events data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int | NO |
| company_id | int | YES |
| name | varchar(110) | YES |
| alias | varchar(100) | YES |
| short_description | varchar(245) | YES |
| description | text | YES |
| meta_title | varchar(100) | YES |
| meta_description | text | YES |
| meta_keywords | text | YES |
| price | varchar(100) | YES |
| type | int | YES |
| start_date | date | YES |
| start_time | time | YES |
| end_date | date | YES |
| end_time | time | YES |
| address | varchar(100) | YES |
| street_number | varchar(100) | YES |
| city | varchar(45) | YES |
| county | varchar(45) | YES |
| province | varchar(60) | YES |
| area | varchar(60) | YES |
| location | varchar(45) | YES |
| latitude | varchar(45) | YES |
| longitude | varchar(45) | YES |
| featured | tinyint(1) | NO |
| created | timestamp | NO |
| view_count | int | NO |
| approved | tinyint(1) | NO |
| state | tinyint(1) | YES |
| recurring_id | int | YES |
| contact_phone | varchar(20) | YES |
| contact_email | varchar(60) | YES |
| doors_open_time | time | YES |
| booking_open_date | date | YES |
| booking_close_date | date | YES |
| booking_open_time | time | YES |
| booking_close_time | time | YES |
| show_start_time | tinyint(1) | NO |
| show_end_time | tinyint(1) | NO |
| show_end_date | tinyint(1) | NO |
| show_doors_open_time | tinyint(1) | NO |
| currency_id | int | NO |
| total_tickets | int | YES |
| expiration_email_date | datetime | YES |
| main_subcategory | int | YES |
| user_id | int | YES |
| enable_subscription | tinyint(1) | NO |
| postalCode | varchar(55) | YES |
| countryId | int | YES |
| time_zone | varchar(15) | YES |
| recurring_info | varchar(255) | YES |
| attendance_mode | tinyint | YES |
| attendance_url | varchar(245) | YES |
| min_age | tinyint | YES |
| max_age | tinyint | YES |
| ticket_url | varchar(255) | YES |
| cover_image | varchar(255) | YES |
CREATE TABLE Statement
CREATE TABLE `wp_jbusinessdirectory_company_events` ( `id` int NOT NULL AUTO_INCREMENT, `company_id` int DEFAULT NULL, `name` varchar(110) DEFAULT NULL, `alias` varchar(100) DEFAULT NULL, `short_description` varchar(245) DEFAULT NULL, `description` text, `meta_title` varchar(100) DEFAULT NULL, `meta_description` text, `meta_keywords` text, `price` varchar(100) DEFAULT NULL, `type` int DEFAULT NULL, `start_date` date DEFAULT NULL, `start_time` time DEFAULT NULL, `end_date` date DEFAULT NULL, `end_time` time DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `street_number` varchar(100) DEFAULT NULL, `city` varchar(45) DEFAULT NULL, `county` varchar(45) DEFAULT NULL, `province` varchar(60) DEFAULT NULL, `area` varchar(60) DEFAULT NULL, `location` varchar(45) DEFAULT NULL, `latitude` varchar(45) DEFAULT NULL, `longitude` varchar(45) DEFAULT NULL, `featured` tinyint(1) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `view_count` int NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '0', `state` tinyint(1) DEFAULT NULL, `recurring_id` int DEFAULT NULL, `contact_phone` varchar(20) DEFAULT NULL, `contact_email` varchar(60) DEFAULT NULL, `doors_open_time` time DEFAULT NULL, `booking_open_date` date DEFAULT NULL, `booking_close_date` date DEFAULT NULL, `booking_open_time` time DEFAULT NULL, `booking_close_time` time DEFAULT NULL, `show_start_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_time` tinyint(1) NOT NULL DEFAULT '0', `show_end_date` tinyint(1) NOT NULL DEFAULT '0', `show_doors_open_time` tinyint(1) NOT NULL DEFAULT '0', `currency_id` int NOT NULL DEFAULT '0', `total_tickets` int DEFAULT NULL, `expiration_email_date` datetime DEFAULT NULL, `main_subcategory` int DEFAULT NULL, `user_id` int DEFAULT NULL, `enable_subscription` tinyint(1) NOT NULL DEFAULT '0', `postalCode` varchar(55) DEFAULT NULL, `countryId` int DEFAULT NULL, `time_zone` varchar(15) DEFAULT NULL, `recurring_info` varchar(255) DEFAULT NULL, `attendance_mode` tinyint DEFAULT NULL, `attendance_url` varchar(245) DEFAULT NULL, `min_age` tinyint DEFAULT NULL, `max_age` tinyint DEFAULT NULL, `ticket_url` varchar(255) DEFAULT NULL, `cover_image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company` (`company_id`), KEY `idx_name` (`name`), KEY `idx_alias` (`alias`), KEY `idx_countryId` (`countryId`), KEY `idx_created` (`created`), KEY `idx_recurring_id` (`recurring_id`), KEY `idx_expiration_email_date` (`expiration_email_date`), KEY `idx_user_id` (`user_id`), KEY `idx_search` (`start_date`,`end_time`,`end_date`,`state`,`approved`,`start_time`), KEY `idx_type` (`type`), KEY `idx_featured` (`featured`), KEY `idx_currency` (`currency_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_company_events`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP-BusinessDirectory – Business directory plugin for WordPress