{"table_name":"growfund_pledges","full_table_name":"wp_growfund_pledges","description":"Stores growfund pledges data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"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","columns":[],"plugin":{"slug":"growfund","name":"Growfund – Ultimate Donation & Crowdfunding Solution","active_installs":80,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/growfund/"}}