{"table_name":"audit_trail","full_table_name":"wp_audit_trail","description":"Stores audit trail data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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`) )\");","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"operation","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"ip","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"happened_at","type":"datetime","nullable":false,"primary_key":false},{"name":"item_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"data","type":"longtext","nullable":true,"primary_key":false},{"name":"title","type":"varchar(100)","nullable":true,"primary_key":false}],"plugin":{"slug":"audit-trail","name":"Audit Trail","active_installs":10000,"version":"1.3","wp_org_url":"https://wordpress.org/plugins/audit-trail/"}}