wp_clearfund_expenses
StaticStores clearfund expenses data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| category_id | bigint(20) unsigned | NO |
| amount_local | decimal(12,2) | NO |
| currency | varchar(3) | NO |
| amount_usd | decimal(10,2) | NO |
| exchange_rate | decimal(12,6) | NO |
| description | text | NO |
| vendor | varchar(150) | NO |
| receipt_url | varchar(500) | NO |
| action_photo_url | varchar(500) | NO |
| reference_id | varchar(50) | NO |
| submitted_by | bigint(20) unsigned | NO |
| submitted_at | datetime | NO |
| approved | tinyint(1) | NO |
| approved_by | bigint(20) unsigned | NO |
| approved_at | datetime | YES |
| rejected | tinyint(1) | NO |
| rejection_note | text | YES |
| deleted | tinyint(1) | NO |
| deleted_by | bigint(20) unsigned | NO |
| deleted_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_clearfund_expenses ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `amount_local` decimal(12,2) NOT NULL DEFAULT 0.00, `currency` varchar(3) NOT NULL DEFAULT 'USD', `amount_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `exchange_rate` decimal(12,6) NOT NULL DEFAULT 1.000000, `description` text NOT NULL, `vendor` varchar(150) NOT NULL DEFAULT '', `receipt_url` varchar(500) NOT NULL DEFAULT '', `action_photo_url` varchar(500) NOT NULL DEFAULT '', `reference_id` varchar(50) NOT NULL DEFAULT '', `submitted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `submitted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved` tinyint(1) NOT NULL DEFAULT 0, `approved_by` bigint(20) unsigned NOT NULL DEFAULT 0, `approved_at` datetime DEFAULT NULL, `rejected` tinyint(1) NOT NULL DEFAULT 0, `rejection_note` text, `deleted` tinyint(1) NOT NULL DEFAULT 0, `deleted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `approved` (`approved`), KEY `deleted` (`deleted`), KEY `cat_submitted` (`category_id`, `submitted_at`) ) $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_expenses`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClearFund