wp_cheerful_gift_campaigns
StaticStores cheerful gift campaigns data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| title | varchar(255) | NO |
| slug | varchar(200) | NO |
| goal_amount | bigint(20) unsigned | YES |
| deadline | date | YES |
| status | varchar(20) | NO |
| preset_amounts | longtext | YES |
| preset_labels | longtext | YES |
| preset_popular | tinyint unsigned | NO |
| preset_amounts_monthly | longtext | YES |
| preset_labels_monthly | longtext | YES |
| preset_popular_monthly | tinyint unsigned | NO |
| show_fees_checkbox | tinyint(1) | NO |
| show_feed_checkbox | tinyint(1) | NO |
| show_privacy_checkbox | tinyint(1) | NO |
| show_terms_checkbox | tinyint(1) | NO |
| paid | tinyint(1) | NO |
| created_at | datetime | NO |
| campaign_id | bigint(20) unsigned | NO |
| donor_first_name | varchar(100) | NO |
| donor_last_name | varchar(100) | NO |
| donor_email | varchar(255) | NO |
| donor_city | varchar(100) | NO |
| amount | bigint(20) unsigned | NO |
| gift_amount | bigint(20) unsigned | NO |
| amount_charged | bigint(20) unsigned | NO |
| platform_fee | bigint(20) unsigned | NO |
| stripe_fee | bigint(20) unsigned | NO |
| fee_estimated | tinyint(1) | NO |
| net_amount | bigint(20) unsigned | NO |
| frequency | varchar(20) | NO |
| fees_covered | tinyint(1) | NO |
| gift_aid | tinyint(1) | NO |
| gift_aid_first_name | varchar(100) | NO |
| gift_aid_last_name | varchar(100) | NO |
| gift_aid_address1 | varchar(255) | NO |
| gift_aid_address2 | varchar(255) | NO |
| gift_aid_city | varchar(100) | NO |
| gift_aid_postcode | varchar(20) | NO |
| show_in_feed | tinyint(1) | NO |
| mailing_list | tinyint(1) | NO |
| livemode | tinyint(1) | NO |
| gdpr_consent | tinyint(1) | NO |
| privacy_consent | tinyint(1) | NO |
| terms_consent | tinyint(1) | NO |
| stripe_id | varchar(255) | YES |
| stripe_customer_id | varchar(255) | NO |
| stripe_subscription_id | varchar(255) | NO |
| stripe_balance_txn_id | varchar(255) | NO |
| stripe_payout_id | varchar(255) | NO |
| card_brand | varchar(20) | NO |
| card_last4 | varchar(4) | NO |
| cancellation_reason | varchar(255) | NO |
| refunded_amount | bigint(20) unsigned | NO |
| tip_refunded | bigint(20) unsigned | NO |
| refunded_at | datetime | YES |
| dispute_status | varchar(20) | NO |
| dispute_reason | varchar(64) | NO |
| disputed_at | datetime | YES |
| status | varchar(50) | NO |
| anonymised | tinyint(1) | NO |
| supporter_message | text | YES |
| supporter_avatar | bigint(20) unsigned | NO |
| created_at | datetime | NO |
| user_id | bigint(20) unsigned | NO |
| user_login | varchar(120) | NO |
| action | varchar(60) | NO |
| detail | varchar(255) | NO |
| ip | varchar(45) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
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 );
Safe to delete?
If you have uninstalled Cheerful Give, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_cheerful_gift_campaigns`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Cheerful Give