{"table_name":"donorcore_donor_analytics","full_table_name":"wp_donorcore_donor_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","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 );","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}],"plugin":{"slug":"donorcore-donations","name":"DonorCore – Donations for WooCommerce","active_installs":0,"version":"1.3.1","wp_org_url":"https://wordpress.org/plugins/donorcore-donations/"}}