{"table_name":"ec_checkout_event","full_table_name":"wp_ec_checkout_event","description":"Stores ec checkout event data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_checkout_event ( event_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, created_at datetime DEFAULT NULL, event_type varchar(20) NOT NULL DEFAULT '', reason varchar(40) NOT NULL DEFAULT '', place varchar(20) NOT NULL DEFAULT '', gateway varchar(40) NOT NULL DEFAULT '', session_key varchar(24) NOT NULL DEFAULT '', ip_key varchar(24) NOT NULL DEFAULT '', email_key varchar(24) NOT NULL DEFAULT '', card_key varchar(24) NOT NULL DEFAULT '', ip_display varchar(48) NOT NULL DEFAULT '', email_display varchar(100) NOT NULL DEFAULT '', card_display varchar(40) NOT NULL DEFAULT '', user_id int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', amount float(15,3) NOT NULL DEFAULT '0.000', ref varchar(100) NOT NULL DEFAULT '', detail varchar(255) NOT NULL DEFAULT '', in_attack tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (event_id), KEY created_at (created_at), KEY event_type (event_type,created_at), KEY session_key (session_key,created_at), KEY ip_key (ip_key,created_at), KEY email_key (email_key,created_at), KEY card_key (card_key,created_at), KEY ref (ref) ) $collate;\"; $wpdb->query( $sql );","columns":[{"name":"event_id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"event_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"place","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"gateway","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"session_key","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"ip_key","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"email_key","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"card_key","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"ip_display","type":"varchar(48)","nullable":false,"primary_key":false},{"name":"email_display","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"card_display","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"ref","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"detail","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"in_attack","type":"tinyint(1)","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/"}}