{"table_name":"growfund_donations","full_table_name":"wp_growfund_donations","description":"Stores growfund donations data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"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","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/"}}