{"slug":"bstd-wc-zcrm","name":"Inventory Connector for Zoho and WooCommerce","description":"Inventory Connector for Zoho and WooCommerce integration is another well crafted wordpress plugin which enables the integration between wc and zoho in …","author":"boostedcrm","active_installs":10,"version":"1.0","wp_org_url":"https://wordpress.org/plugins/bstd-wc-zcrm/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bc_inventory_connector","full_table_name":"wp_bc_inventory_connector","description":"Stores bc inventory connector data created by this plugin.","detection_method":"both","confidence":"high","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"integration_details","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT(20) unsigned","nullable":false,"primary_key":false},{"name":"api_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_obj","type":"TEXT","nullable":true,"primary_key":false},{"name":"generated_at","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_bc_inventory_connector` (\\n  `id` int unsigned NOT NULL AUTO_INCREMENT,\\n  `integration_details` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"bc_inventory_connector_log","full_table_name":"wp_bc_inventory_connector_log","description":"A logging table that records activity, events, or audit history.","detection_method":"both","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_bc_inventory_connector_log` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `api_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `response_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `response_obj` text COLLATE utf8mb4_unicode_520_ci,\\n  `generated_at` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":2}