-- 在appointment表的period字段上创建索引
CREATE INDEX idx_appointment_period ON appointment(period);

-- 在feedback表的date字段上创建索引
CREATE INDEX idx_feedback_date ON feedback(date);

-- 在invoice表的date字段上创建索引
CREATE INDEX idx_invoice_date ON invoice(date);

-- 在training_record表的record_id字段上创建索引
CREATE INDEX idx_training_record_record_id ON training_record(record_id);

-- 在booking_slot表的start_time和end_time字段上创建复合索引
CREATE INDEX idx_booking_slot_start_end_time ON booking_slot(start_time, end_time);

-- 在account表的status字段上创建索引
CREATE INDEX idx_account_status ON account(status);

-- 在student表的name字段上创建索引
CREATE INDEX idx_student_name ON student(name);

-- 在coach表的name字段上创建索引
CREATE INDEX idx_coach_name ON coach(name);

-- 在venue表的name字段上创建索引
CREATE INDEX idx_venue_name ON venue(name);

-- 在personal_info表的email字段上创建唯一索引
CREATE UNIQUE INDEX idx_personal_info_email ON personal_info(email);
-- 添加新学员的存储过程