{"slug":"donorcore-donations","name":"DonorCore – Donations for WooCommerce","description":"Professional donation management for WooCommerce with campaigns, donor analytics, automated emails, and PDF receipts.","author":"Lalit RajPurohit","active_installs":0,"version":"1.3.1","wp_org_url":"https://wordpress.org/plugins/donorcore-donations/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"donorcore_donation_logs","full_table_name":"wp_donorcore_donation_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"campaign_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"donor_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"amount","type":"DECIMAL(18,2)","nullable":false,"primary_key":false},{"name":"currency","type":"CHAR(3)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"gateway","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_donorcore_donation_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT(20) UNSIGNED NOT NULL, campaign_id BIGINT(20) UNSIGNED DEFAULT 0, donor_id BIGINT(20) UNSIGNED DEFAULT 0, amount DECIMAL(18,2) NOT NULL, currency CHAR(3) NOT NULL DEFAULT 'USD', type VARCHAR(20) NOT NULL DEFAULT 'one-time', gateway VARCHAR(50) NOT NULL DEFAULT 'unknown', created_at DATETIME NOT NULL, PRIMARY KEY (id), KEY order_id (order_id), KEY campaign_id (campaign_id), KEY donor_id (donor_id), KEY type (type), KEY created_at (created_at) ) $charset_collate;\"; dbDelta( $sql_logs );"},{"table_name":"donorcore_donor_analytics","full_table_name":"wp_donorcore_donor_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"donor_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"donor_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"total_lifetime_value","type":"DECIMAL(18,2)","nullable":false,"primary_key":false},{"name":"donation_count","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"last_donation_date","type":"DATETIME","nullable":true,"primary_key":false},{"name":"first_donation_date","type":"DATETIME","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_donorcore_donor_analytics ( donor_email VARCHAR(100) NOT NULL, donor_id BIGINT(20) UNSIGNED DEFAULT 0, total_lifetime_value DECIMAL(18,2) NOT NULL DEFAULT 0, donation_count INT UNSIGNED NOT NULL DEFAULT 0, last_donation_date DATETIME DEFAULT NULL, first_donation_date DATETIME DEFAULT NULL, PRIMARY KEY (donor_email), KEY donor_id (donor_id), KEY total_lifetime_value (total_lifetime_value) ) $charset_collate;\"; dbDelta( $sql_analytics );"},{"table_name":"donorcore_security_log","full_table_name":"wp_donorcore_security_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"event_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"reason","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"user_agent","type":"text","nullable":true,"primary_key":false},{"name":"metadata","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_donorcore_security_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_type varchar(50) NOT NULL, reason varchar(100) NOT NULL, ip_address varchar(45) NOT NULL, user_agent text, metadata longtext, created_at datetime NOT NULL, PRIMARY KEY (id), KEY event_type (event_type), KEY ip_address (ip_address), KEY created_at (created_at) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"}],"table_count":3}