wp_classpilot_locations

Static

Stores classpilot locations data created by this plugin.

Column Definitions

ColumnTypeNullable
🔑idbigint(20) unsignedNO
namevarchar(200)NO
addresstextNO
descriptionlongtextNO
arrival_instructionstextNO
gallery_image_idstextYES
activetinyint(1)NO

CREATE TABLE Statement

CREATE TABLE wp_classpilot_locations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(200) NOT NULL DEFAULT '', address text NOT NULL, description longtext NOT NULL, arrival_instructions text NOT NULL, gallery_image_ids text, active tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (id) ) {$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_locations`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from ClassPilot Booking