wp_jbusinessdirectory_company_announcements

Static

Stores jbusinessdirectory company announcements data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idintNO
call_to_actionintNO
company_idintNO
titlevarchar(255)YES
descriptionvarchar(255)YES
iconvarchar(50)YES
button_textvarchar(255)YES
button_linkvarchar(255)YES
statustinyintYES
expiration_datedateYES

CREATE TABLE Statement

CREATE TABLE `wp_jbusinessdirectory_company_announcements` ( `id` int NOT NULL AUTO_INCREMENT, `call_to_action` int NOT NULL, `company_id` int NOT NULL, `title` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `icon` varchar(50) DEFAULT NULL, `button_text` varchar(255) DEFAULT NULL, `button_link` varchar(255) DEFAULT NULL, `status` tinyint DEFAULT '1', `expiration_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_company_id` (`company_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_announcements`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from WP-BusinessDirectory – Business directory plugin for WordPress