wp_classpilot_customers
StaticStores classpilot customers data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| wp_user_id | bigint(20) unsigned | YES |
| display_name | varchar(200) | NO |
| varchar(200) | NO | |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_classpilot_customers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, wp_user_id bigint(20) unsigned DEFAULT NULL, display_name varchar(200) NOT NULL DEFAULT '', email varchar(200) NOT NULL DEFAULT '', 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 wp_user_id (wp_user_id), KEY email (email) ) {$charset_collate};" );Safe to delete?
If you have uninstalled ClassPilot Booking, 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_classpilot_customers`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClassPilot Booking