wp_cartright_recoveries
StaticStores cartright recoveries data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| cart_id | BIGINT UNSIGNED | NO |
| order_id | BIGINT UNSIGNED | NO |
| amount_cents | INT UNSIGNED | NO |
| order_status | VARCHAR(20) | NO |
| token_valid | TINYINT(1) | NO |
| recovered_at | INT UNSIGNED | NO |
CREATE TABLE Statement
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;");
Safe to delete?
If you have uninstalled Cartright for WooCommerce, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_cartright_recoveries`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Cartright for WooCommerce