wp_clearfund_allocations
StaticStores clearfund allocations data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| give_donation_id | bigint(20) unsigned | NO |
| source | varchar(20) | NO |
| source_ref | bigint(20) unsigned | NO |
| category_id | bigint(20) unsigned | NO |
| amount | decimal(10,2) | NO |
| date | datetime | NO |
| donor_name | varchar(100) | NO |
| donor_email | varchar(100) | NO |
| note | varchar(255) | NO |
| deleted | tinyint(1) | NO |
| deleted_by | bigint(20) unsigned | NO |
| deleted_at | datetime | YES |
| notify_impact | tinyint(1) | NO |
CREATE TABLE Statement
CREATE TABLE wp_clearfund_allocations ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `give_donation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `source` varchar(20) NOT NULL DEFAULT 'manual', `source_ref` bigint(20) unsigned NOT NULL DEFAULT 0, `category_id` bigint(20) unsigned NOT NULL, `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `donor_name` varchar(100) NOT NULL DEFAULT '', `donor_email` varchar(100) NOT NULL DEFAULT '', `note` varchar(255) NOT NULL DEFAULT '', `deleted` tinyint(1) NOT NULL DEFAULT 0, `deleted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `deleted_at` datetime DEFAULT NULL, `notify_impact` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `give_donation_id` (`give_donation_id`), KEY `source_ref` (`source`, `source_ref`), KEY `deleted` (`deleted`), KEY `cat_date` (`category_id`, `date`), 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_allocations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClearFund