{"table_name":"bitgfzc_zoho_crm_log_details","full_table_name":"wp_bitgfzc_zoho_crm_log_details","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"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;\" );","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"form_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"integration_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"api_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"response_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"response_obj","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"integration_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"integration_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"integration_details","type":"longtext","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"published","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"user_ip","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"1","type":"published","nullable":true,"primary_key":false},{"name":"2","type":"trashed","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"integration-of-zoho-crm-and-gravity-forms","name":"Integration of Zoho CRM and Gravity Forms","active_installs":10,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/integration-of-zoho-crm-and-gravity-forms/"}}