wp_classpilot_bookings
StaticStores classpilot bookings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| session_id | bigint(20) unsigned | NO |
| customer_id | bigint(20) unsigned | NO |
| status | varchar(20) | NO |
| payment_mode | varchar(20) | NO |
| stripe_session_id | varchar(200) | NO |
| pack_credit_id | bigint(20) unsigned | NO |
| attendance_status | varchar(20) | NO |
| idempotency_key | varchar(100) | NO |
| note | text | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_classpilot_bookings ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, session_id bigint(20) unsigned NOT NULL, customer_id bigint(20) unsigned NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', payment_mode varchar(20) NOT NULL DEFAULT 'stripe', stripe_session_id varchar(200) NOT NULL DEFAULT '', checkout_expires_at datetime NULL DEFAULT NULL, pack_credit_id bigint(20) unsigned NOT NULL DEFAULT 0, attendance_status varchar(20) NOT NULL DEFAULT 'unknown', idempotency_key varchar(100) NOT NULL DEFAULT '', note text NOT 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 idempotency (idempotency_key), KEY session_id (session_id), KEY customer_id (customer_id), KEY status (status), KEY pending_expiry (status, checkout_expires_at) ) {$charset};" );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_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClassPilot Booking