{"table_name":"ec_abandoned_cart","full_table_name":"wp_ec_abandoned_cart","description":"Stores ec abandoned cart data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_abandoned_cart ( abandoned_cart_id int(11) NOT NULL AUTO_INCREMENT, session_id varchar(191) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', user_id int(11) NOT NULL DEFAULT '0', phone varchar(64) NOT NULL DEFAULT '', status varchar(20) NOT NULL DEFAULT 'active', stage varchar(20) NOT NULL DEFAULT 'cart', items_json longtext, item_count int(11) NOT NULL DEFAULT '0', subtotal decimal(12,2) NOT NULL DEFAULT '0.00', currency varchar(8) NOT NULL DEFAULT '', coupon_code varchar(64) NOT NULL DEFAULT '', shipping_country varchar(8) NOT NULL DEFAULT '', locale varchar(16) NOT NULL DEFAULT '', card_error varchar(255) NOT NULL DEFAULT '', first_seen datetime DEFAULT NULL, last_activity datetime DEFAULT NULL, abandoned_at datetime DEFAULT NULL, recovered_at datetime DEFAULT NULL, recovered_order_id int(11) NOT NULL DEFAULT '0', recovered_total decimal(12,2) NOT NULL DEFAULT '0.00', sequence_step int(11) NOT NULL DEFAULT '0', next_send_at datetime DEFAULT NULL, offer_code_id int(11) NOT NULL DEFAULT '0', offer_code varchar(64) NOT NULL DEFAULT '', offer_code_expires datetime DEFAULT NULL, admin_notes text, PRIMARY KEY (abandoned_cart_id), UNIQUE KEY session_id (session_id), KEY status_next (status, next_send_at), KEY email (email(100)), KEY last_activity (last_activity), KEY first_seen (first_seen) ) $collate;\" );","columns":[{"name":"abandoned_cart_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"session_id","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"stage","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"items_json","type":"longtext","nullable":true,"primary_key":false},{"name":"item_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"coupon_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"shipping_country","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"locale","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"card_error","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_seen","type":"datetime","nullable":true,"primary_key":false},{"name":"last_activity","type":"datetime","nullable":true,"primary_key":false},{"name":"abandoned_at","type":"datetime","nullable":true,"primary_key":false},{"name":"recovered_at","type":"datetime","nullable":true,"primary_key":false},{"name":"recovered_order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"recovered_total","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"sequence_step","type":"int(11)","nullable":false,"primary_key":false},{"name":"next_send_at","type":"datetime","nullable":true,"primary_key":false},{"name":"offer_code_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"offer_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"offer_code_expires","type":"datetime","nullable":true,"primary_key":false},{"name":"admin_notes","type":"text","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/"}}