wp_clearfund_categories
StaticStores clearfund categories data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| name | varchar(100) | NO |
| slug | varchar(100) | NO |
| icon | varchar(50) | NO |
| color | varchar(7) | NO |
| description | text | YES |
| goal_usd | decimal(10,2) | NO |
| goal_deadline | date | YES |
| sort_order | int(11) | NO |
| active | tinyint(1) | NO |
| high_priority | tinyint(1) | NO |
| priority_note | varchar(255) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_clearfund_categories ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `slug` varchar(100) NOT NULL DEFAULT '', `icon` varchar(50) NOT NULL DEFAULT '', `color` varchar(7) NOT NULL DEFAULT '#4A90D9', `description` text, `goal_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `goal_deadline` date DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `high_priority` tinyint(1) NOT NULL DEFAULT 0, `priority_note` varchar(255) NOT NULL DEFAULT '', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`) ) $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_categories`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClearFund