wp_bitgfzc_zoho_crm_log_details
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| form_id | bigint(20) | NO |
| integration_id | bigint(20) | YES |
| api_type | varchar(255) | YES |
| response_type | varchar(50) | YES |
| response_obj | LONGTEXT | YES |
| created_at | DATETIME | NO |
| category | varchar(50) | NO |
| integration_name | varchar(255) | YES |
| integration_type | varchar(50) | NO |
| integration_details | longtext | YES |
| form_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| status | tinyint(1) | YES |
| 1 | published | YES |
| 2 | trashed | YES |
| updated_at | datetime | YES |
| form_id | bigint(20) unsigned | YES |
| user_ip | int(11) unsigned | YES |
| status | tinyint(1) | YES |
| 1 | published | YES |
| 2 | trashed | YES |
| updated_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_bitgfzc_zoho_crm_log_details` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) NOT NULL, `integration_id` bigint(20) DEFAULT NULL, `api_type` varchar(255) DEFAULT NULL, `response_type` varchar(50) DEFAULT NULL, `response_obj` LONGTEXT DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (`id`), KEY `integration_id` (`integration_id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitgfzc_integration` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(50) NOT NULL, `integration_name` varchar(255) DEFAULT NULL, `integration_type` varchar(50) NOT NULL, `integration_details` longtext DEFAULT NULL, `form_id` bigint(20) unsigned DEFAULT NULL, /* form_id = 0 means all/app */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;", "CREATE TABLE IF NOT EXISTS `wp_bitgfzc_gclid` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `form_id` bigint(20) unsigned DEFAULT NULL, /* form_id = 0 means all/app */ `user_id` bigint(20) unsigned DEFAULT NULL, `user_ip` int(11) unsigned DEFAULT NULL, `status` tinyint(1) DEFAULT 1,/* 0 disabled, 1 published, 2 trashed */ `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) $collate;" );
Safe to delete?
If you have uninstalled Integration of Zoho CRM and Gravity Forms, 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_bitgfzc_zoho_crm_log_details`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Integration of Zoho CRM and Gravity Forms