wp_lavo_bulk_edit_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| batch_id | varchar(36) | NO |
| user_id | bigint(20) UNSIGNED | NO |
| product_id | bigint(20) UNSIGNED | NO |
| field_name | varchar(100) | NO |
| old_value | longtext | YES |
| new_value | longtext | YES |
| reverted | tinyint(1) | NO |
| created_at | datetime | NO |
| attribute_name | varchar(200) | NO |
| attribute_value | varchar(200) | NO |
| batch_id | varchar(64) | NO |
| job_type | varchar(20) | NO |
| user_id | bigint(20) UNSIGNED | NO |
| status | varchar(20) | NO |
| total | int(11) UNSIGNED | NO |
| processed | int(11) UNSIGNED | NO |
| created_at | datetime | NO |
| completed_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_lavo_bulk_edit_log ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, batch_id varchar(36) NOT NULL, user_id bigint(20) UNSIGNED NOT NULL, product_id bigint(20) UNSIGNED NOT NULL, field_name varchar(100) NOT NULL, old_value longtext DEFAULT NULL, new_value longtext DEFAULT NULL, reverted tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL, PRIMARY KEY (id), KEY batch_id (batch_id), KEY product_id (product_id), KEY created_at (created_at) ) $charset;"; // Custom attribute lookup — flat index of non-taxonomy attribute values // so we can filter by custom attribute without serialised-meta LIKE hacks. $attr_lookup = "CREATE TABLE wp_lavo_custom_attr_lookup ( product_id bigint(20) UNSIGNED NOT NULL, attribute_name varchar(200) NOT NULL, attribute_value varchar(200) NOT NULL, PRIMARY KEY (product_id, attribute_name(100), attribute_value(100)), KEY attr_name_value (attribute_name(100), attribute_value(100)) ) $charset;"; // Job tracking — persists async bulk-edit job state so large operations // survive page refreshes and the progress bar can reconnect. $jobs = "CREATE TABLE wp_lavo_bulk_edit_jobs ( job_id varchar(36) NOT NULL, batch_id varchar(64) NOT NULL DEFAULT '', job_type varchar(20) NOT NULL DEFAULT 'bulk_update', user_id bigint(20) UNSIGNED NOT NULL, status varchar(20) NOT NULL DEFAULT 'queued', total int(11) UNSIGNED NOT NULL DEFAULT 0, processed int(11) UNSIGNED NOT NULL DEFAULT 0, created_at datetime NOT NULL, completed_at datetime DEFAULT NULL, PRIMARY KEY (job_id), KEY user_id (user_id), KEY status (status) ) $charset;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $audit_log );
Safe to delete?
If you have uninstalled Lavo Bulk Edit for 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_lavo_bulk_edit_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Lavo Bulk Edit for WooCommerce