wp_givasso_donors
StaticStores givasso donors data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| VARCHAR(254) | NO | |
| first_name | VARCHAR(100) | NO |
| last_name | VARCHAR(100) | NO |
| company | VARCHAR(150) | YES |
| address_line1 | VARCHAR(255) | YES |
| address_line2 | VARCHAR(255) | YES |
| postal_code | VARCHAR(10) | YES |
| city | VARCHAR(100) | YES |
| country | CHAR(2) | NO |
| phone | VARCHAR(30) | YES |
| wp_user_id | BIGINT UNSIGNED | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
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;" );
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_donors`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Givasso