{"table_name":"amazon_stock_log","full_table_name":"wp_amazon_stock_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_amazon_stock_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `timestamp` datetime DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `sku` varchar(32) DEFAULT NULL, `old_stock` int(11) DEFAULT NULL, `new_stock` int(11) DEFAULT NULL, `caller` varchar(64) DEFAULT NULL, `method` varchar(128) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `backtrace` text, PRIMARY KEY (`id`) ) DEFAULT CHARSET","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"timestamp","type":"datetime","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"sku","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"old_stock","type":"int(11)","nullable":true,"primary_key":false},{"name":"new_stock","type":"int(11)","nullable":true,"primary_key":false},{"name":"caller","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"method","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"backtrace","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-lister-for-amazon","name":"WP-Lister Lite for Amazon","active_installs":800,"version":"2.9.1","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-amazon/"}}