{"table_name":"ec_order_log","full_table_name":"wp_ec_order_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE ec_order_log ( order_log_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', order_log_key varchar(100) NOT NULL DEFAULT '', order_log_timestamp timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (order_log_id), UNIQUE KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_order_log_meta ( order_log_meta_id int(11) NOT NULL AUTO_INCREMENT, order_log_id int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', order_log_meta_key varchar(100) NOT NULL DEFAULT '', order_log_meta_value text, PRIMARY KEY (order_log_meta_id), UNIQUE KEY order_log_meta_id (order_log_meta_id), KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate;\" );","columns":[{"name":"order_log_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_timestamp","type":"timestamp","nullable":true,"primary_key":false},{"name":"order_log_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_meta_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_meta_value","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"Shopping Cart & eCommerce Store","active_installs":4000,"version":"5.9.1","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}