wp_growfund_donations
LiveStores growfund donations data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_growfund_donations` (\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 `fund_id` bigint unsigned NOT NULL,\n `user_id` bigint unsigned DEFAULT NULL,\n `email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `amount` int unsigned NOT NULL,\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 `tribute_type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_salutation` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_to` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_notification_type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_notification_recipient_name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_notification_recipient_phone` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_notification_recipient_email` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n `tribute_notification_recipient_address` text COLLATE utf8mb4_unicode_520_ci,\n `notes` text COLLATE utf8mb4_unicode_520_ci,\n `status` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\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_anonymous` tinyint NOT NULL DEFAULT '0',\n `is_manual` tinyint NOT NULL DEFAULT '0',\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_donations_unique_uid` (`uid`),\n KEY `campaign_id` (`campaign_id`),\n KEY `fund_id` (`fund_id`),\n KEY `user_id` (`user_id`),\n CONSTRAINT `wp_growfund_donations_ibfk_1` FOREIGN KEY (`campaign_id`) REFERENCES `wp_posts` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `wp_growfund_donations_ibfk_2` FOREIGN KEY (`fund_id`) REFERENCES `wp_growfund_funds` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,\n CONSTRAINT `wp_growfund_donations_ibfk_3` 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_donations`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Growfund – Ultimate Donation & Crowdfunding Solution