{"table_name":"ec_email_log","full_table_name":"wp_ec_email_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_email_log ( log_id int(11) NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT NULL, email_type varchar(40) NOT NULL DEFAULT '', order_id int(11) NOT NULL DEFAULT '0', to_email varchar(255) NOT NULL DEFAULT '', subject varchar(255) NOT NULL DEFAULT '', transport varchar(30) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT '', error_text text, attempts int(11) NOT NULL DEFAULT '1', queue_id int(11) NOT NULL DEFAULT '0', body_hash varchar(40) NOT NULL DEFAULT '', PRIMARY KEY (log_id), KEY created_at (created_at), KEY order_id (order_id), KEY status (status), KEY to_email (to_email(100)) ) $collate;\" );","columns":[{"name":"log_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"email_type","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"to_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subject","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"transport","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"error_text","type":"text","nullable":true,"primary_key":false},{"name":"attempts","type":"int(11)","nullable":false,"primary_key":false},{"name":"queue_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"body_hash","type":"varchar(40)","nullable":false,"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/"}}