{"table_name":"cartright_recoveries","full_table_name":"wp_cartright_recoveries","description":"Stores cartright recoveries data created by this plugin.","detection_method":"static","confidence":"medium","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;\");","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}],"plugin":{"slug":"cartright","name":"Cartright for WooCommerce","active_installs":0,"version":"0.1.1","wp_org_url":"https://wordpress.org/plugins/cartright/"}}