wp_clearfund_ledger
StaticStores clearfund ledger data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| event | varchar(40) | NO |
| entity_type | varchar(20) | NO |
| entity_id | bigint(20) unsigned | NO |
| actor_id | bigint(20) unsigned | NO |
| payload | longtext | NO |
| created_at | datetime | NO |
| prev_hash | char(64) | NO |
| hash | char(64) | NO |
CREATE TABLE Statement
CREATE TABLE wp_clearfund_ledger ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event` varchar(40) NOT NULL DEFAULT '', `entity_type` varchar(20) NOT NULL DEFAULT '', `entity_id` bigint(20) unsigned NOT NULL DEFAULT 0, `actor_id` bigint(20) unsigned NOT NULL DEFAULT 0, `payload` longtext NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `prev_hash` char(64) NOT NULL DEFAULT '', `hash` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `entity` (`entity_type`, `entity_id`), KEY `event` (`event`) ) $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_ledger`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClearFund