{"slug":"integration-of-zoho-books-and-wc","name":"Integration of Zoho Books and WooCommerce","description":"Integration of Zoho Books and WooCommerce is another well crafted wordpress plugin which enables the integration between wc and zoho books.","author":"formsintegrations","active_installs":60,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/integration-of-zoho-books-and-wc/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"bit_wc_zoho_books_integration","full_table_name":"wp_bit_wc_zoho_books_integration","description":"Stores bit wc zoho books integration data created by this plugin.","detection_method":"static","confidence":"medium","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 IF NOT EXISTS `wp_bit_wc_zoho_books_integration` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `integration_details` TEXT DEFAULT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) $collate;\", \"CREATE TABLE IF NOT EXISTS `wp_bit_wc_zoho_books_log` ( `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` BIGINT(20) unsigned NOT NULL, `api_type` VARCHAR(20) DEFAULT NULL, `response_type` VARCHAR(20) DEFAULT NULL, `response_obj` TEXT DEFAULT NULL, `generated_at` VARCHAR(20) DEFAULT NULL, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) $collate;\" ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($table_schema as $table) { dbDelta($table);"},{"table_name":"bit_wc_zoho_books_log","full_table_name":"wp_bit_wc_zoho_books_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":2}