{"table_name":"ec_user_activity","full_table_name":"wp_ec_user_activity","description":"Stores ec user activity data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_user_activity ( activity_id bigint(20) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL DEFAULT '0', activity_type varchar(50) NOT NULL DEFAULT '', activity_date datetime DEFAULT NULL, object_type varchar(50) NOT NULL DEFAULT '', object_id bigint(20) NOT NULL DEFAULT '0', meta text, actor_type varchar(20) NOT NULL DEFAULT '', actor_id bigint(20) NOT NULL DEFAULT '0', ip_address varchar(45) NOT NULL DEFAULT '', PRIMARY KEY (activity_id), KEY user_activity_user_date (user_id,activity_date), KEY user_activity_type (activity_type) ) $collate;\" );","columns":[{"name":"activity_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"activity_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"activity_date","type":"datetime","nullable":true,"primary_key":false},{"name":"object_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"object_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta","type":"text","nullable":true,"primary_key":false},{"name":"actor_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"actor_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","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/"}}