{"table_name":"ec_inventory_log","full_table_name":"wp_ec_inventory_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_inventory_log ( log_id bigint(20) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT '0', optionitemquantity_id int(11) NOT NULL DEFAULT '0', location_id int(11) NOT NULL DEFAULT '0', delta int(11) NOT NULL DEFAULT '0', new_quantity int(11) NOT NULL DEFAULT '0', reason varchar(40) NOT NULL DEFAULT '', source varchar(40) NOT NULL DEFAULT '', note text NULL, user_id bigint(20) NOT NULL DEFAULT '0', created timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (log_id), KEY product_id (product_id), KEY optionitemquantity_id (optionitemquantity_id), KEY created (created) ) $collate;\" );","columns":[{"name":"log_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitemquantity_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"delta","type":"int(11)","nullable":false,"primary_key":false},{"name":"new_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"note","type":"text","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"created","type":"timestamp","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}