wp_kcm_instructors
StaticStores kcm instructors data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| full_name | varchar(255) | NO |
| varchar(255) | YES | |
| phone | varchar(50) | YES |
| specialization | text | YES |
| bio | text | YES |
| is_active | tinyint(1) | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
| class_id | bigint(20) UNSIGNED | NO |
| instructor_id | bigint(20) UNSIGNED | NO |
| assigned_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_kcm_instructors ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, full_name varchar(255) NOT NULL, email varchar(255) DEFAULT NULL, phone varchar(50) DEFAULT NULL, specialization text DEFAULT NULL, bio text DEFAULT NULL, is_active tinyint(1) NOT NULL DEFAULT 1, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY is_active (is_active) ) $macm_charset_collate;"; // Create class_instructors junction table. $macm_sql_class_instructors = "CREATE TABLE wp_kcm_class_instructors ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, class_id bigint(20) UNSIGNED NOT NULL, instructor_id bigint(20) UNSIGNED NOT NULL, assigned_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY class_instructor (class_id, instructor_id), KEY class_id (class_id), KEY instructor_id (instructor_id) ) $macm_charset_collate;"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; echo '<h2>Adding Instructors Tables</h2>'; // Create instructors table. echo '<p>Creating kcm_instructors table...</p>'; dbDelta( $macm_sql_instructors );
Safe to delete?
If you have uninstalled Martial Arts Club Manager, 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_kcm_instructors`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Martial Arts Club Manager