{"slug":"cartright","name":"Cartright for WooCommerce","description":"Session-verified abandoned-cart recovery for WooCommerce. Counts genuine human carts, reports revenue reconciled to real orders, sends via your SMTP.","author":"famosmedia","active_installs":0,"version":"0.1.1","wp_org_url":"https://wordpress.org/plugins/cartright/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cartright_carts","full_table_name":"wp_cartright_carts","description":"Stores cartright carts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"product_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"score","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"recoverable","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"reasons","type":"TEXT","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"abandoned_at","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"steps_sent","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"recovered","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"opted_out","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"updated","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cartright_carts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(191) NOT NULL, product_id BIGINT UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL, score SMALLINT NOT NULL, recoverable TINYINT(1) NOT NULL DEFAULT 0, reasons TEXT NULL, email VARCHAR(191) NULL, abandoned_at INT UNSIGNED NOT NULL, steps_sent TINYINT UNSIGNED NOT NULL DEFAULT 0, recovered TINYINT(1) NOT NULL DEFAULT 0, opted_out TINYINT(1) NOT NULL DEFAULT 0, updated INT UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY session_id (session_id), KEY status (status) ) $charset;\");"},{"table_name":"cartright_recoveries","full_table_name":"wp_cartright_recoveries","description":"Stores cartright recoveries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"cart_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"amount_cents","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"order_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"token_valid","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"recovered_at","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cartright_recoveries ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, cart_id BIGINT UNSIGNED NOT NULL, order_id BIGINT UNSIGNED NOT NULL, amount_cents INT UNSIGNED NOT NULL, order_status VARCHAR(20) NOT NULL, token_valid TINYINT(1) NOT NULL DEFAULT 0, recovered_at INT UNSIGNED NOT NULL, PRIMARY KEY (id), UNIQUE KEY order_id (order_id), KEY cart_id (cart_id) ) $charset;\");"},{"table_name":"cartright_signals","full_table_name":"wp_cartright_signals","description":"Stores cartright signals data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"session_id","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"first_seen","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"pageview","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"interaction","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"token_valid","type":"TINYINT(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cartright_signals ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, session_id VARCHAR(191) NOT NULL, first_seen INT UNSIGNED NOT NULL, pageview TINYINT(1) NOT NULL DEFAULT 0, interaction TINYINT(1) NOT NULL DEFAULT 0, token_valid TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY session_id (session_id) ) $charset;\");"}],"table_count":3}