wp_classpilot_pack_credits
StaticStores classpilot pack credits data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| customer_id | bigint(20) unsigned | NO |
| pack_id | bigint(20) unsigned | NO |
| credits_total | smallint unsigned | NO |
| credits_remaining | smallint unsigned | NO |
| stripe_session_id | varchar(200) | NO |
| purchased_at | datetime | NO |
| expires_at | datetime | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_classpilot_pack_credits ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, customer_id bigint(20) unsigned NOT NULL, pack_id bigint(20) unsigned NOT NULL, credits_total smallint unsigned NOT NULL DEFAULT 0, credits_remaining smallint unsigned NOT NULL DEFAULT 0, stripe_session_id varchar(200) NOT NULL DEFAULT '', purchased_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, expires_at datetime NOT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY customer_pack (customer_id, pack_id), KEY stripe_session_id (stripe_session_id), KEY expires_at (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_pack_credits`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ClassPilot Booking