wp_clearfund_donor_impact_sent
StaticStores clearfund donor impact sent data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| expense_id | bigint(20) unsigned | NO |
| donation_id | bigint(20) unsigned | NO |
| amount_cents | bigint(20) | NO |
| donor_email | varchar(100) | NO |
| sent_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_clearfund_donor_impact_sent ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `expense_id` bigint(20) unsigned NOT NULL DEFAULT 0, `donation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `amount_cents` bigint(20) NOT NULL DEFAULT 0, `donor_email` varchar(100) NOT NULL DEFAULT '', `sent_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slice` (`expense_id`, `donation_id`), KEY `donor_email` (`donor_email`) ) $charset;" );
Safe to delete?
If you have uninstalled ClearFund, 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_clearfund_donor_impact_sent`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClearFund