wp_growfund_pledges
LiveStores growfund pledges data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_growfund_pledges` (\n `ID` bigint unsigned NOT NULL AUTO_INCREMENT,\n `uid` varchar(40) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `campaign_id` bigint unsigned NOT NULL,\n `user_id` bigint unsigned DEFAULT NULL,\n `email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `pledge_option` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n `reward_id` bigint DEFAULT NULL,\n `amount` int unsigned NOT NULL DEFAULT '0',\n `bonus_support_amount` int unsigned NOT NULL DEFAULT '0',\n `shipping_cost` int unsigned NOT NULL DEFAULT '0',\n `recovery_fee` int unsigned NOT NULL DEFAULT '0',\n `processing_fee` int unsigned NOT NULL DEFAULT '0',\n `should_deduct_fee_recovery` tinyint NOT NULL DEFAULT '0',\n `notes` text COLLATE utf8mb4_unicode_520_ci,\n `transaction_id` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_engine` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `payment_method` text COLLATE utf8mb4_unicode_520_ci,\n `payment_status` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `is_manual` tinyint NOT NULL DEFAULT '0',\n `reward_info` text COLLATE utf8mb4_unicode_520_ci,\n `user_info` text COLLATE utf8mb4_unicode_520_ci,\n `created_at` datetime NOT NULL,\n `created_by` bigint unsigned NOT NULL,\n `updated_at` datetime DEFAULT NULL,\n `updated_by` bigint unsigned DEFAULT NULL,\n PRIMARY KEY (`ID`),\n UNIQUE KEY `wp_growfund_pledges_unique_uid` (`uid`),\n KEY `campaign_id` (`campaign_id`),\n KEY `user_id` (`user_id`),\n CONSTRAINT `wp_growfund_pledges_ibfk_1` FOREIGN KEY (`campaign_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `wp_growfund_pledges_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `wp_users` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Safe to delete?
If you have uninstalled Growfund – Ultimate Donation & Crowdfunding Solution, 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_growfund_pledges`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Growfund – Ultimate Donation & Crowdfunding Solution