{"slug":"recover-abandoned-cart-for-woocommerce","name":"Recover Abandoned Cart for WooCommerce","description":"Professional solution for Recover Abandoned Carts","author":"azexo","active_installs":0,"version":"1.27.1","wp_org_url":"https://wordpress.org/plugins/recover-abandoned-cart-for-woocommerce/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"azm_woo_abandoned_carts","full_table_name":"wp_azm_woo_abandoned_carts","description":"Stores azm woo abandoned carts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"abandoned_timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"recovered_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"order_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"cart_contents","type":"text","nullable":false,"primary_key":false},{"name":"cart_total","type":"decimal(10,2) unsigned","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_azm_woo_abandoned_carts ( visitor_id varchar(32) NOT NULL, abandoned_timestamp int(11) unsigned NOT NULL, recovered_timestamp int(11) unsigned, order_id int(11) unsigned, user_id int(11) unsigned, cart_contents text NOT NULL, cart_total decimal(10,2) unsigned, status varchar(20), PRIMARY KEY abandoned_cart (visitor_id, abandoned_timestamp), KEY user (user_id) ) $collate;\");"},{"table_name":"azm_woo_abandoned_carts_rules","full_table_name":"wp_azm_woo_abandoned_carts_rules","description":"Stores azm woo abandoned carts rules data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"visitor_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"abandoned_timestamp","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"rule_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"sent_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"open_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"click_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false},{"name":"unsubscribe_timestamp","type":"int(11) unsigned","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_azm_woo_abandoned_carts_rules ( visitor_id varchar(32) NOT NULL, abandoned_timestamp int(11) unsigned NOT NULL, rule_id int(11) NOT NULL, status varchar(11), sent_timestamp int(11) unsigned, open_timestamp int(11) unsigned, click_timestamp int(11) unsigned, unsubscribe_timestamp int(11) unsigned, PRIMARY KEY abandoned_cart_rule (visitor_id, abandoned_timestamp, rule_id), KEY rule (rule_id) ) $collate;\");"}],"table_count":2}