wp_givasso_receipts
StaticStores givasso receipts data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| donation_id | BIGINT UNSIGNED | NO |
| receipt_number | VARCHAR(20) | NO |
| fiscal_year | SMALLINT | NO |
| status | ENUM('issued','cancelled','replaced') | NO |
| replaces_id | BIGINT UNSIGNED | YES |
| pdf_path | VARCHAR(512) | YES |
| sent_at | DATETIME | YES |
| issued_at | DATETIME | NO |
| cancelled_at | DATETIME | YES |
| cancel_reason | VARCHAR(255) | YES |
CREATE TABLE Statement
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;" );Safe to delete?
If you have uninstalled Givasso, 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_givasso_receipts`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Givasso