{"slug":"givasso","name":"Givasso","description":"Donation forms for French nonprofits. HelloAsso & Stripe integration, donor management, campaign tracking. Free.","author":"otmaaan91","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/givasso/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"givasso_campaigns","full_table_name":"wp_givasso_campaigns","description":"Stores givasso campaigns data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"goal_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"currency","type":"CHAR(3)","nullable":false,"primary_key":false},{"name":"start_date","type":"DATE","nullable":true,"primary_key":false},{"name":"end_date","type":"DATE","nullable":true,"primary_key":false},{"name":"status","type":"ENUM('draft','active','ended','archived')","nullable":false,"primary_key":false},{"name":"featured_image","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_givasso_campaigns ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, goal_amount DECIMAL(10,2) DEFAULT NULL, currency CHAR(3) NOT NULL DEFAULT 'EUR', start_date DATE DEFAULT NULL, end_date DATE DEFAULT NULL, status ENUM('draft','active','ended','archived') NOT NULL DEFAULT 'draft', featured_image BIGINT UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_slug (slug), KEY idx_status (status) ) $charset;\" );"},{"table_name":"givasso_donations","full_table_name":"wp_givasso_donations","description":"Stores givasso donations data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"donor_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"campaign_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"currency","type":"CHAR(3)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending','completed','failed','refunded','cancelled')","nullable":false,"primary_key":false},{"name":"gateway","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"gateway_transaction_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"gateway_refund_ref","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"is_recurring","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"frequency","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"receipt_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"donor_message","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_givasso_donations ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, donor_id BIGINT UNSIGNED NOT NULL, campaign_id BIGINT UNSIGNED DEFAULT NULL, amount DECIMAL(10,2) NOT NULL, currency CHAR(3) NOT NULL DEFAULT 'EUR', status ENUM('pending','completed','failed','refunded','cancelled') NOT NULL DEFAULT 'pending', gateway VARCHAR(50) NOT NULL DEFAULT 'stripe', gateway_transaction_id VARCHAR(255) DEFAULT NULL, gateway_refund_ref VARCHAR(255) DEFAULT NULL, is_recurring TINYINT(1) NOT NULL DEFAULT 0, frequency VARCHAR(20) DEFAULT NULL, receipt_id BIGINT UNSIGNED DEFAULT NULL, donor_message TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_donor (donor_id), KEY idx_status (status), KEY idx_created (created_at), KEY idx_refund_ref (gateway_refund_ref) ) $charset;\" );"},{"table_name":"givasso_donors","full_table_name":"wp_givasso_donors","description":"Stores givasso donors data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"email","type":"VARCHAR(254)","nullable":false,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"company","type":"VARCHAR(150)","nullable":true,"primary_key":false},{"name":"address_line1","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"address_line2","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"postal_code","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"city","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"country","type":"CHAR(2)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_givasso_donors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, email VARCHAR(254) NOT NULL, first_name VARCHAR(100) NOT NULL DEFAULT '', last_name VARCHAR(100) NOT NULL DEFAULT '', company VARCHAR(150) DEFAULT NULL, address_line1 VARCHAR(255) DEFAULT NULL, address_line2 VARCHAR(255) DEFAULT NULL, postal_code VARCHAR(10) DEFAULT NULL, city VARCHAR(100) DEFAULT NULL, country CHAR(2) NOT NULL DEFAULT 'FR', phone VARCHAR(30) DEFAULT NULL, wp_user_id BIGINT UNSIGNED DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_email (email), KEY idx_wp_user (wp_user_id) ) $charset;\" );"},{"table_name":"givasso_receipts","full_table_name":"wp_givasso_receipts","description":"Stores givasso receipts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"donation_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"receipt_number","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"fiscal_year","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('issued','cancelled','replaced')","nullable":false,"primary_key":false},{"name":"replaces_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"pdf_path","type":"VARCHAR(512)","nullable":true,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"issued_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancel_reason","type":"VARCHAR(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_givasso_receipts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, donation_id BIGINT UNSIGNED NOT NULL, receipt_number VARCHAR(20) NOT NULL, fiscal_year SMALLINT NOT NULL, status ENUM('issued','cancelled','replaced') NOT NULL DEFAULT 'issued', replaces_id BIGINT UNSIGNED DEFAULT NULL, pdf_path VARCHAR(512) DEFAULT NULL, sent_at DATETIME DEFAULT NULL, issued_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, cancelled_at DATETIME DEFAULT NULL, cancel_reason VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY uq_receipt_number (receipt_number), KEY idx_donation (donation_id), KEY idx_fiscal_year (fiscal_year) ) $charset;\" );"},{"table_name":"givasso_subscriptions","full_table_name":"wp_givasso_subscriptions","description":"Stores givasso subscriptions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"donor_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"stripe_subscription_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"stripe_customer_id","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"amount","type":"DECIMAL(10,2)","nullable":false,"primary_key":false},{"name":"currency","type":"CHAR(3)","nullable":false,"primary_key":false},{"name":"frequency","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('active','cancelled','past_due','unpaid')","nullable":false,"primary_key":false},{"name":"next_payment_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"cancelled_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_givasso_subscriptions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, donor_id BIGINT UNSIGNED NOT NULL, stripe_subscription_id VARCHAR(255) NOT NULL, stripe_customer_id VARCHAR(255) NOT NULL, amount DECIMAL(10,2) NOT NULL, currency CHAR(3) NOT NULL DEFAULT 'EUR', frequency VARCHAR(20) NOT NULL, status ENUM('active','cancelled','past_due','unpaid') NOT NULL DEFAULT 'active', next_payment_at DATETIME DEFAULT NULL, cancelled_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY uq_stripe_sub (stripe_subscription_id), KEY idx_donor (donor_id), KEY idx_status (status) ) $charset;\" );"}],"table_count":5}