{"table_name":"clearfund_allocations","full_table_name":"wp_clearfund_allocations","description":"Stores clearfund allocations data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_clearfund_allocations ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `give_donation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `source` varchar(20) NOT NULL DEFAULT 'manual', `source_ref` bigint(20) unsigned NOT NULL DEFAULT 0, `category_id` bigint(20) unsigned NOT NULL, `amount` decimal(10,2) NOT NULL DEFAULT 0.00, `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `donor_name` varchar(100) NOT NULL DEFAULT '', `donor_email` varchar(100) NOT NULL DEFAULT '', `note` varchar(255) NOT NULL DEFAULT '', `deleted` tinyint(1) NOT NULL DEFAULT 0, `deleted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `deleted_at` datetime DEFAULT NULL, `notify_impact` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `give_donation_id` (`give_donation_id`), KEY `source_ref` (`source`, `source_ref`), KEY `deleted` (`deleted`), KEY `cat_date` (`category_id`, `date`), KEY `donor_email` (`donor_email`) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"give_donation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"source_ref","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"date","type":"datetime","nullable":false,"primary_key":false},{"name":"donor_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"donor_email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"note","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"deleted_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"notify_impact","type":"tinyint(1)","nullable":false,"primary_key":false}],"plugin":{"slug":"clearfund","name":"ClearFund","active_installs":0,"version":"1.27.0","wp_org_url":"https://wordpress.org/plugins/clearfund/"}}