wp_bit_wc_zoho_books_integration
StaticStores bit wc zoho books integration data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) unsigned | NO |
| integration_details | TEXT | YES |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
| order_id | BIGINT(20) unsigned | NO |
| api_type | VARCHAR(20) | YES |
| response_type | VARCHAR(20) | YES |
| response_obj | TEXT | YES |
| generated_at | VARCHAR(20) | YES |
| created_at | DATETIME | YES |
CREATE TABLE Statement
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);Safe to delete?
If you have uninstalled Integration of Zoho Books and WooCommerce, 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_bit_wc_zoho_books_integration`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Integration of Zoho Books and WooCommerce