wp_growfund_donations

Live

Stores 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