{"slug":"audit-trail","name":"Audit Trail","description":"Audit Trail is a plugin to keep track of what is going on inside your blog by monitoring administration functions.","author":"John Godley","active_installs":10000,"version":"1.3","wp_org_url":"https://wordpress.org/plugins/audit-trail/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"audit_trail","full_table_name":"wp_audit_trail","description":"Stores audit trail data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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`) )\");"}],"table_count":1}