wp_jbusinessdirectory_company_claim

Static

Stores jbusinessdirectory company claim data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idintNO
companyIdintYES
firstNamevarchar(55)YES
lastNamevarchar(55)YES
functionvarchar(45)YES
phonevarchar(45)YES
emailvarchar(65)YES
statusintNO

CREATE TABLE Statement

CREATE TABLE `wp_jbusinessdirectory_company_claim` ( `id` int NOT NULL AUTO_INCREMENT, `companyId` int DEFAULT NULL, `firstName` varchar(55) DEFAULT NULL, `lastName` varchar(55) DEFAULT NULL, `function` varchar(45) DEFAULT NULL, `phone` varchar(45) DEFAULT NULL, `email` varchar(65) DEFAULT NULL, `status` int NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_companyId` (`companyId`), KEY `idx_status` (`status`) ) 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_claim`;

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

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