{"table_name":"kcm_instructors","full_table_name":"wp_kcm_instructors","description":"Stores kcm instructors data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"full_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"phone","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"specialization","type":"text","nullable":true,"primary_key":false},{"name":"bio","type":"text","nullable":true,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"class_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"instructor_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"assigned_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"martial-arts-club-manager","name":"Martial Arts Club Manager","active_installs":0,"version":"1.0.346","wp_org_url":"https://wordpress.org/plugins/martial-arts-club-manager/"}}