{"slug":"clearfund","name":"ClearFund","description":"Show donors exactly where their money goes. Per-category donation pools, receipt-backed expense tracking, and a public transparency dashboard.","author":"ClearFund","active_installs":0,"version":"1.27.0","wp_org_url":"https://wordpress.org/plugins/clearfund/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"clearfund_allocations","full_table_name":"wp_clearfund_allocations","description":"Stores clearfund allocations data created by this plugin.","detection_method":"static","confidence":"high","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}],"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;\" );"},{"table_name":"clearfund_categories","full_table_name":"wp_clearfund_categories","description":"Stores clearfund categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"icon","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"color","type":"varchar(7)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"goal_usd","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"goal_deadline","type":"date","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"high_priority","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priority_note","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_categories ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `slug` varchar(100) NOT NULL DEFAULT '', `icon` varchar(50) NOT NULL DEFAULT '', `color` varchar(7) NOT NULL DEFAULT '#4A90D9', `description` text, `goal_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `goal_deadline` date DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `active` tinyint(1) NOT NULL DEFAULT 1, `high_priority` tinyint(1) NOT NULL DEFAULT 0, `priority_note` varchar(255) NOT NULL DEFAULT '', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`) ) $charset;\" );"},{"table_name":"clearfund_donor_impact_sent","full_table_name":"wp_clearfund_donor_impact_sent","description":"Stores clearfund donor impact sent data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"expense_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"donation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount_cents","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"donor_email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_donor_impact_sent ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `expense_id` bigint(20) unsigned NOT NULL DEFAULT 0, `donation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `amount_cents` bigint(20) NOT NULL DEFAULT 0, `donor_email` varchar(100) NOT NULL DEFAULT '', `sent_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slice` (`expense_id`, `donation_id`), KEY `donor_email` (`donor_email`) ) $charset;\" );"},{"table_name":"clearfund_email_optouts","full_table_name":"wp_clearfund_email_optouts","description":"Stores clearfund email optouts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_email_optouts ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(100) NOT NULL DEFAULT '', `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) $charset;\" );"},{"table_name":"clearfund_expenses","full_table_name":"wp_clearfund_expenses","description":"Stores clearfund expenses data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount_local","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"amount_usd","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"exchange_rate","type":"decimal(12,6)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"vendor","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"receipt_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"action_photo_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"reference_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"submitted_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"submitted_at","type":"datetime","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"approved_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"approved_at","type":"datetime","nullable":true,"primary_key":false},{"name":"rejected","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"rejection_note","type":"text","nullable":true,"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}],"create_sql":"CREATE TABLE wp_clearfund_expenses ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `amount_local` decimal(12,2) NOT NULL DEFAULT 0.00, `currency` varchar(3) NOT NULL DEFAULT 'USD', `amount_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `exchange_rate` decimal(12,6) NOT NULL DEFAULT 1.000000, `description` text NOT NULL, `vendor` varchar(150) NOT NULL DEFAULT '', `receipt_url` varchar(500) NOT NULL DEFAULT '', `action_photo_url` varchar(500) NOT NULL DEFAULT '', `reference_id` varchar(50) NOT NULL DEFAULT '', `submitted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `submitted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved` tinyint(1) NOT NULL DEFAULT 0, `approved_by` bigint(20) unsigned NOT NULL DEFAULT 0, `approved_at` datetime DEFAULT NULL, `rejected` tinyint(1) NOT NULL DEFAULT 0, `rejection_note` text, `deleted` tinyint(1) NOT NULL DEFAULT 0, `deleted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `approved` (`approved`), KEY `deleted` (`deleted`), KEY `cat_submitted` (`category_id`, `submitted_at`) ) $charset;\" );"},{"table_name":"clearfund_ledger","full_table_name":"wp_clearfund_ledger","description":"Stores clearfund ledger data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"event","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"entity_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"entity_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"actor_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"payload","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"prev_hash","type":"char(64)","nullable":false,"primary_key":false},{"name":"hash","type":"char(64)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_ledger ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event` varchar(40) NOT NULL DEFAULT '', `entity_type` varchar(20) NOT NULL DEFAULT '', `entity_id` bigint(20) unsigned NOT NULL DEFAULT 0, `actor_id` bigint(20) unsigned NOT NULL DEFAULT 0, `payload` longtext NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `prev_hash` char(64) NOT NULL DEFAULT '', `hash` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `entity` (`entity_type`, `entity_id`), KEY `event` (`event`) ) $charset;\" );"},{"table_name":"clearfund_pool_history","full_table_name":"wp_clearfund_pool_history","description":"Stores clearfund pool history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"balance_usd","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"snapshot_date","type":"date","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_pool_history ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `balance_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `snapshot_date` date NOT NULL, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `snapshot_date` (`snapshot_date`) ) $charset;\" );"},{"table_name":"clearfund_settings","full_table_name":"wp_clearfund_settings","description":"Stores clearfund settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"option_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"option_value","type":"longtext","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_clearfund_settings ( `option_name` varchar(100) NOT NULL, `option_value` longtext NOT NULL, PRIMARY KEY (`option_name`) ) $charset;\" );"}],"table_count":8}