{"slug":"cheerful-give","name":"Cheerful Give","description":"Cheerful Give is the joyful donation plugin with 0% platform fees, for good causes of every kind. Beautiful giving, right on your WordPress site.","author":"Cheerful Give","active_installs":0,"version":"1.26.2","wp_org_url":"https://wordpress.org/plugins/cheerful-give/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cheerful_gift_audit_log","full_table_name":"wp_cheerful_gift_audit_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"cheerful_gift_campaigns","full_table_name":"wp_cheerful_gift_campaigns","description":"Stores cheerful gift campaigns data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"goal_amount","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"deadline","type":"date","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"preset_amounts","type":"longtext","nullable":true,"primary_key":false},{"name":"preset_labels","type":"longtext","nullable":true,"primary_key":false},{"name":"preset_popular","type":"tinyint unsigned","nullable":false,"primary_key":false},{"name":"preset_amounts_monthly","type":"longtext","nullable":true,"primary_key":false},{"name":"preset_labels_monthly","type":"longtext","nullable":true,"primary_key":false},{"name":"preset_popular_monthly","type":"tinyint unsigned","nullable":false,"primary_key":false},{"name":"show_fees_checkbox","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_feed_checkbox","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_privacy_checkbox","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"show_terms_checkbox","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"paid","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"campaign_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"donor_first_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"donor_last_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"donor_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"donor_city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"amount","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"gift_amount","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount_charged","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"platform_fee","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"stripe_fee","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"fee_estimated","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"net_amount","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"frequency","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fees_covered","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"gift_aid","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"gift_aid_first_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"gift_aid_last_name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"gift_aid_address1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"gift_aid_address2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"gift_aid_city","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"gift_aid_postcode","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"show_in_feed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"mailing_list","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"livemode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"gdpr_consent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"privacy_consent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"terms_consent","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"stripe_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"stripe_customer_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_subscription_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_balance_txn_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_payout_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"card_brand","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"card_last4","type":"varchar(4)","nullable":false,"primary_key":false},{"name":"cancellation_reason","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"refunded_amount","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"tip_refunded","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"refunded_at","type":"datetime","nullable":true,"primary_key":false},{"name":"dispute_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"dispute_reason","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"disputed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"anonymised","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"supporter_message","type":"text","nullable":true,"primary_key":false},{"name":"supporter_avatar","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_login","type":"varchar(120)","nullable":false,"primary_key":false},{"name":"action","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"detail","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_cheerful_gift_campaigns ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL DEFAULT '', slug varchar(200) NOT NULL DEFAULT '', goal_amount bigint(20) unsigned DEFAULT NULL, deadline date DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'active', preset_amounts longtext DEFAULT NULL, preset_labels longtext DEFAULT NULL, preset_popular tinyint unsigned NOT NULL DEFAULT 1, preset_amounts_monthly longtext DEFAULT NULL, preset_labels_monthly longtext DEFAULT NULL, preset_popular_monthly tinyint unsigned NOT NULL DEFAULT 1, show_fees_checkbox tinyint(1) NOT NULL DEFAULT 1, show_feed_checkbox tinyint(1) NOT NULL DEFAULT 0, show_privacy_checkbox tinyint(1) NOT NULL DEFAULT 1, show_terms_checkbox tinyint(1) NOT NULL DEFAULT 1, paid tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset_collate;\"; $donations = \"CREATE TABLE wp_cheerful_gift_donations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, campaign_id bigint(20) unsigned NOT NULL DEFAULT 1, donor_first_name varchar(100) NOT NULL DEFAULT '', donor_last_name varchar(100) NOT NULL DEFAULT '', donor_email varchar(255) NOT NULL DEFAULT '', donor_city varchar(100) NOT NULL DEFAULT '', amount bigint(20) unsigned NOT NULL DEFAULT 0, gift_amount bigint(20) unsigned NOT NULL DEFAULT 0, amount_charged bigint(20) unsigned NOT NULL DEFAULT 0, platform_fee bigint(20) unsigned NOT NULL DEFAULT 0, stripe_fee bigint(20) unsigned NOT NULL DEFAULT 0, fee_estimated tinyint(1) NOT NULL DEFAULT 0, net_amount bigint(20) unsigned NOT NULL DEFAULT 0, frequency varchar(20) NOT NULL DEFAULT 'one-off', fees_covered tinyint(1) NOT NULL DEFAULT 0, gift_aid tinyint(1) NOT NULL DEFAULT 0, gift_aid_first_name varchar(100) NOT NULL DEFAULT '', gift_aid_last_name varchar(100) NOT NULL DEFAULT '', gift_aid_address1 varchar(255) NOT NULL DEFAULT '', gift_aid_address2 varchar(255) NOT NULL DEFAULT '', gift_aid_city varchar(100) NOT NULL DEFAULT '', gift_aid_postcode varchar(20) NOT NULL DEFAULT '', show_in_feed tinyint(1) NOT NULL DEFAULT 1, mailing_list tinyint(1) NOT NULL DEFAULT 0, livemode tinyint(1) NOT NULL DEFAULT 1, gdpr_consent tinyint(1) NOT NULL DEFAULT 0, privacy_consent tinyint(1) NOT NULL DEFAULT 0, terms_consent tinyint(1) NOT NULL DEFAULT 0, stripe_id varchar(255) DEFAULT NULL, stripe_customer_id varchar(255) NOT NULL DEFAULT '', stripe_subscription_id varchar(255) NOT NULL DEFAULT '', stripe_balance_txn_id varchar(255) NOT NULL DEFAULT '', stripe_payout_id varchar(255) NOT NULL DEFAULT '', card_brand varchar(20) NOT NULL DEFAULT '', card_last4 varchar(4) NOT NULL DEFAULT '', cancellation_reason varchar(255) NOT NULL DEFAULT '', refunded_amount bigint(20) unsigned NOT NULL DEFAULT 0, tip_refunded bigint(20) unsigned NOT NULL DEFAULT 0, refunded_at datetime DEFAULT NULL, dispute_status varchar(20) NOT NULL DEFAULT '', dispute_reason varchar(64) NOT NULL DEFAULT '', disputed_at datetime DEFAULT NULL, status varchar(50) NOT NULL DEFAULT 'pending', anonymised tinyint(1) NOT NULL DEFAULT 0, supporter_message text NULL, supporter_avatar bigint(20) unsigned NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY campaign_id (campaign_id), KEY donor_email (donor_email), KEY status (status), KEY created_at (created_at), UNIQUE KEY stripe_id (stripe_id), KEY stripe_subscription_id (stripe_subscription_id), KEY stripe_balance_txn_id (stripe_balance_txn_id) ) $charset_collate;\"; $audit = \"CREATE TABLE wp_cheerful_gift_audit_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL DEFAULT 0, user_login varchar(120) NOT NULL DEFAULT '', action varchar(60) NOT NULL DEFAULT '', detail varchar(255) NOT NULL DEFAULT '', ip varchar(45) NOT NULL DEFAULT '', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY action (action), KEY created_at (created_at) ) $charset_collate;\"; dbDelta( $campaigns );"},{"table_name":"cheerful_gift_donations","full_table_name":"wp_cheerful_gift_donations","description":"Stores cheerful gift donations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":3}