wp_growfund_pledges

Live

Stores 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