wp_audit_trail
StaticStores audit trail data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| operation | varchar(40) | NO |
| user_id | int(11) | NO |
| ip | int(11) unsigned | NO |
| happened_at | datetime | NO |
| item_id | int(11) | YES |
| data | longtext | YES |
| title | varchar(100) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_audit_trail`( `id` int(11) NOT NULL auto_increment, `operation` varchar(40) NOT NULL default '', `user_id` int(11) NOT NULL, `ip` int(11) unsigned NOT NULL default '0', `happened_at` datetime NOT NULL, `item_id` int(11) default NULL, `data` longtext, `title` varchar(100) default NULL, PRIMARY KEY ( `id`) )");
Safe to delete?
If you have uninstalled Audit Trail, 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_audit_trail`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.