wp_classpilot_sessions
StaticStores session data for tracking user or visitor state.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| class_id | bigint(20) unsigned | NO |
| starts_at | datetime | NO |
| ends_at | datetime | NO |
| capacity | smallint unsigned | NO |
| seats_booked | smallint unsigned | NO |
| instructor_id | bigint(20) unsigned | NO |
| status | varchar(20) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_classpilot_sessions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, class_id bigint(20) unsigned NOT NULL, starts_at datetime NOT NULL, ends_at datetime NOT NULL, capacity smallint unsigned NOT NULL DEFAULT 10, seats_booked smallint unsigned NOT NULL DEFAULT 0, instructor_id bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(20) NOT NULL DEFAULT 'scheduled', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY class_starts (class_id, starts_at), KEY status (status) ) {$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_sessions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClassPilot Booking