{"slug":"integration-of-zoho-crm-and-gravity-forms","name":"Integration of Zoho CRM and Gravity Forms","description":"Visit plugin's website","author":"formsintegrations","active_installs":10,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/integration-of-zoho-crm-and-gravity-forms/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bitgfzc_gclid","full_table_name":"wp_bitgfzc_gclid","description":"Stores bitgfzc gclid data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"bitgfzc_integration","full_table_name":"wp_bitgfzc_integration","description":"Stores bitgfzc integration data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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;\" );"}],"table_count":3}